Home Forums SQL Server 2005 SQL Server 2005 General Discussion SQL 2005 Perfmon Objects/Counters RE: SQL 2005 Perfmon Objects/Counters
Scalability Doug
SSCertifiable
Points: 5351
More actions
February 19, 2008 at 7:43 am
#779715
Kelly, some key counters and their significance...
processor queue length ( < 2 / processor )
disk queue length (<1000/spindle)
%disk time (obviously <100, the lower the better)
contect switches/sec (the lower the better)
Hope this helps,
Doug