- Web Load Testing SQLServer Monitoring

Web Load Testing SQL Server® monitoring

Real Time 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.

SQLServer Monitoring Counters

All these performance counters are available both while the web load test is running and in the results. On a typical SQLServer, 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.