If you could only monitor 10 SQL Server 2005 counters, what would they be? -


Yes, this is not a subjective subject, but I am researching this matter and am eager to see if Other people have the same conclusion as I have, I ask, if you can only monitor 10 SQL Server 2005 counters, what will happen?

SQL server page life expectancy (prefer buffer cache hit ratio)

% of processor time P> SQL Server Agent Failure Jobs

SQL Server Lock Vets Average Waiting Time

Physical Disk Average Disc Sec / Write (prefer on line length, though both work is fine) / P>


Comments

Popular posts from this blog

c# - ListView onScroll event -

PHP - get image from byte array -

Linux Terminal Problem with Non-Canonical Terminal I/O app -