Server Statistics | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Server Statistics

Can you give me scripts on how to get the following info? capacity metrics
-server hd capacity
-db total size / db free-space
-server hd size versus db size
-db growth rate
-db file location
-db transaction performance metrics
-sql server cpu utilization
-sql server memory utilization
-sql server network utilization
-sql server user connections
-db log growth
-db txns/sec
-db %log use —- Thanks in advance ——
Refer to
Please do not post multiple(duplicate) posts for same problem. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.