Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

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

Tags:

sql

sql-server

Yes, this is rather subjective, but I am doing research on that matter and am curious to see if others have come to the same conclusions that I have. So, I ask, if you could only monitor 10 SQL Server 2005 counters, what would they be?

like image 713
Mark Callison Avatar asked Jul 22 '09 21:07

Mark Callison


1 Answers

Are these SQL Server specific counters or SQL Server Machine Counters? If they are machine wide counters then I recommend these:

  • SQLServer: Memory Manager: Memory Grants Outstanding
  • SQLServer: General Statistics:Logins/Sec, Logouts/Sec, User Connections
  • Memory: Available Bytes
  • Memory: Pages/Sec
  • Paging File: % Usage
  • PhysicalDisk: Avg. Disk Queue Length
  • Processor: % Processor Time
like image 112
Jeff Widmer Avatar answered Nov 15 '22 09:11

Jeff Widmer