Monday, 10 November 2014

LoadRunner - Counters useful for monitoring Web & SQL server performance




While carrying out performance test execution, it's very important to monitor the underlying infrastructure to identify performance bottlenecks.
The following is a list of counters that are useful for monitoring Web server performance:  
 Object
 Counter
 Web Service
 Maximum Connections
 Web Service
 Bytes Total/sec
 Web Service
 Current NonAnonymous Users
 Web Service
 Current Connections
 Web Service
 Not Found Errors
 Active Server Pages
 Requests/sec
 Active Server Pages
 Errors/sec
 Active Server Pages
 Requests Rejected
 Active Server Pages
 Request Not Found
 Active Server Pages
 Memory Allocated
 Active Server Pages
 Requests Queued
 Active Server Pages
 Errors During Script Run Time
 Memory
 Page Faults/sec
 Server
 Total Bytes/sec
 Process
 Private Bytes/Inetinfo

The following is a list of counters that are useful for monitoring SQL Server performance:



 Object

 Counter

 SQLServer

 User Connections

 SQLServer

 Cache Hit Ratio

 SQLServer

 Net-Network Reads/sec

 SQLServer

 I/O-Lazy Writes/sec

 SQLServer-Locks

 Total Blocking Locks

 PhysicalDisk

 Disk Queue Length

The following is a list of counters that are useful for monitoring both Web and SQL server performance:


 Object

 Counter

 Processor

 % Total Processor Time

 PhysicalDisk

 % Disk Time

 Memory

 Available Bytes

 Memory

 Pool Nonpaged Bytes

 Memory

 Pages/sec

 Memory

 Committed Bytes

 System

 Total Interrupts/sec

 Object

 Threads

 Process

 Private Bytes:Total


1 comment:

  1. Hello Rajni , thank you for this post , it was very helpfull.
    I have a question to ask , since i'm a beginner in using loadrunner , i need to monito a MySQL server but i can't figure out how to do that using Loadrunner ( we can only monitor SQL server or Oracle ). So is there any usefull solution to do that properly without having to use Sitescope. And For MySQL , does it have the same counters to monitor as SQL server or are they different ?
    Thank you in advance.

    ReplyDelete