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
|
Hello Rajni , thank you for this post , it was very helpfull.
ReplyDeleteI 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.