Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Any good/free utilities that provide database metrics
Message
 
General information
Forum:
Microsoft SQL Server
Category:
Database management
Miscellaneous
Thread ID:
01462081
Message ID:
01462275
Views:
57
>>Hi all -
>>
>>Looking to produce metrics for various databases that help (potentially) identify size, complexity, etc. of each database. Thinks like lines-of-code for stored procedures, number of tables, total number of rows, number of views, etc. You know? Some of the stuff that we can get from similar tools for Visual FoxPro and Visual Studio size that help us figure out how small/big an animal we're looking at.
>>
>>Anyone have any recommendations?
>>
>>TIA
>

This WiKi page may be helpful http://wiki.lessthandot.com/index.php/List_The_Count_Of_All_Objects_In_Your_SQL_Server_Database_Grouped_By_Type

and this one for lines of code

http://wiki.lessthandot.com/index.php/Get_a_rough_estimate_of_how_many_lines_of_code_you_have_in_your_SQL_Server_database
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform