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
Post a Comment