Database Query: MS.SQL.Connection
The duration to connect to a database

Windows Service Name: SQLBrowser
Service description: SQL Server Browser
 

Windows Service Name: SQLSERVERAGENT
Service description: SQL Server Agent (MSSQLSERVER)
 

Windows Service Name: MSSQLSERVER
Service description: SQL Server (MSSQLSERVER)
 

Windows Service Name: MSSQLServerADHelper
Service description: SQL Server Active Directory Helper
 

WMI Class: Win32_PerfRawData_MSSQLSERVER_SQLServerGeneralStatistics
Property: UserConnections
Description: The number of connections (and users) using the SQL server. Keep in mind that one connection does not equal one user. A single user can have more than one connection, and a single connection can have more than one user.
 

WMI Class: Win32_PerfRawData_MSSQLSERVER_SQLServerBufferManager
Property: Buffercachehitratio and
Property: Buffercachehitratio_Base
Description: Buffer Cache Hit Ratio should be consistently greater than 90%. This indicates that the data cache supplied 90% of the requests for data. If this value is consistently lower, it is a very good indicator that more memory is needed by SQL Server.
 

WMI Class: Win32_PerfRawData_MSSQLSERVER_SQLServerAccessMethods
Property:PageSplitsPersec
Description: If page splits are high it means there is a need either to increase the fill factor of my indexes, or to rebuild the indexes more often.
 

WMI Class: Win32_PerfRawData_MSSQLSERVER_SQLServerBufferManager
Property: FreeBuffers
Description: When Free Buffers is low, this means that there is not enough memory to maintain a consistent amount of data cache.
 

WMI Class: Win32_Process.Handle="SQL process id"
Property: WorkingSetSize
Description: The process: Working Set Size shows the amount of memory that SQL Server is using. If the number is consistently lower than the amount SQL Server is configured to use by the MIN SERVER MEMORY and MAX SERVER MEMORY options, then SQL Server is configured for too much memory. Otherwise, you may need to increase RAM and MAX SERVER MEMORY.
 

WMI Class: Win32_PerfRawData_MSSQLSERVER_SQLServerMemoryManager
Property:TargetServerMemoryKB
Description: How much memory SQL Server wants. If this is the same as the SQLServer:Memory Manager:Total Server Memory (KB) counter, then SQL Server has all the memory that it wants.
 

WMI Class: Win32_PerfRawData_MSSQLSERVER_SQLServerMemoryManager
Property:TotalServerMemoryKB
Description: How much memory SQL Server actual is using. If this is the same as SQLServer:Memory Manager:Target Server Memory (KB), then SQL Server has all the memory that it wants. But if this is smaller, then SQL Server needs more available memory in order to run at its optimum performance.
 

WMI Class: SQL Server: Memory Manager
Property: Total Server Memory (KB)
Description: If Total Server Memory for SQL Server is consistently higher than the overall server memory, it indicates that there is not enough RAM.
 

WMI Class: Win32_PerfRawData_MSSQLSERVER_SQLServerLocks
Property: NumberofDeadlocksPersec
Description: Use the number of Deadlocks/sec counter on a regular basis to observe trends. If you discover deadlock problems, use the Profiler to "drill" down on the problem for a more detailed analysis.