- Web Load Testing SQL Server 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.

SQL Server Monitoring Counters

All SQL Server performance counters are available both while the web load test is running and in the results. 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.

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