One of the key features of SQL Response v2 will be the ability to monitor a whole set of metrics in real-time across your enterprise from physical servers, SQL Servers, disks, network and so on.
There’s a huge amount of information that we can and will display in SQL Response v2, but we’d like to know what data matters most to you. Key metrics will be displayed graphically on the Overview pages, that show selected real-time information about your physical server or SQL Server; they will also be used to trigger relevant alerts.
Over the next few weeks, we’ll post lists of the counters that we think are most useful in a number of categories. To get the ball rolling, we’re going to start with memory counters.
Memory available for physical server
Amount of physical memory currently available to processes running on the computer (in MB)
Memory available for SQL server
Amount of physical memory currently available to SQL Server (in MB)
If memory is allocated to SQL Server then this equals Memory allocated to SQL Server – Total SQL Server Memory Used. If memory is not allocated to SQL Server then this value is the same as the memory available for the physical server.
Memory Paging / Sec
Rate at which pages are read from or written to disk (number of pages per second).
This counter is the sum of Pages Input / Sec and Pages Output / Sec.
Total SQL Server Memory Used
Amount of RAM the SQL Server service is currently using.
Includes the total of the buffers committed to the SQL Server BPool and OS buffers of the type “OS in Use”.
Target SQL Server Memory
Amount of RAM the SQL Server requires to operate efficiently, based on the number of buffers reserved by SQL Server when it is first started.
Buffer Cache Hit Ratio
How often SQL Server accesses the buffer rather than the hard disk to get data, as a percentage.
Buffer Manager Free Pages
The total number of free buffer pages in the free buffer list.
Buffer Manager Page life Expectancy
The number of seconds that a buffer page stays in the buffer before being written to disk.
Are these counters useful to you? Are there are any other memory counters that you look at, that we’ve not mentioned here? Let us know!
In Part two we’ll ask you to comment on the disk-based counters we’re looking to implement.