SQL Server Monitoring

SQL Server monitors allow the user to monitor all the Windows machines and get specific counters from SQL Server.

NeoLoad uses PerfMon to get the standard Windows performance counters.

Features

• Preconfigured Monitoring: Each module ships pre-configured with the performance counters tailored to your system.
• Threshold Alerts: NeoLoad provides threshold values –derived from industry best practices- to raise the appropriate alerts.
• Agentless Monitoring: The design of our monitoring modules, based on industry standards, ensures non-intrusive remote monitoring.
• Real Time: The counter values and the threshold alerts are available as soon as the test is run.

Note: All the modules are included with the demo license.

Performance Counters

On a typical SQL Server, the main, basic counters are as follows:

• SQL Server\Buffer Management: Buffer cache hit ratio \%. Indicates how often SQL Server goes to the buffer, not the hard disk, to get data.
• SQL Server\Memory Manager: Total Server Memory (KB). If this reaches the level of the overall server memory, it means the server needs more RAM.
• SQL Server\general statistics: User connections. Number of users connected to the system.

Find Out More

• Why using NeoLoad monitoring modules?
• Monitoring modules list.
• Monitoring modules documentation.

Learn More

SQL Server is a trademark of Microsoft Corporation in U.S.A and other countries.