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 tohttp://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=19058 Please do not post multiple(duplicate) posts for same problem. Satya SKJ Microsoft SQL Server MVP Writer, Contributing Editor & Moderator http://www.SQL-Server-Performance.Com 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.