SQL Server Performance Monitoring through LoadRunner

Server Performance Monitoring through LoadRunner

SQL Server Monitoring

The SQL Server monitor shows the standard Windows resources on the SQL
server machine.
Note: To monitor an SQL server through a firewall, use TCP
This chapter includes:
➤ Setting up the Monitoring Environment 

➤ Adding a Machine to Monitor 

➤ Configuring the SQL Server Monitor 

➤ SQL Server Performance Counters Setting up the Monitoring Environment
➤ If you are using the SiteScope monitor engine, ensure that SiteScope has
been installed on a server. You can install SiteScope on the same machine as
the Controller, or on a dedicated server.
➤ To obtain data for this graph, you enable the SQL Server online monitor
(from the Controller) and select the measurements you want to display,
before running the scenario.

Adding a Machine to Monitor.
In order to monitor the SQL Server resources of a particular machine from
the Controller, you need to add the machine and the measurements that
you want to monitor.
To add a machine to the Controller
1 Click SQL Server in the graph tree, and drag it into the right pane of the Run
view.
2 Right-click the graph and select Add Measurements, or click anywhere on
graph and choose Monitors > Add Measurements. The SQL Server dialog
box opens.
3 By default, LoadRunner monitors SQL Server resources using the native
LoadRunner monitor engine.
If you want to monitor the SQL Server using a SiteScope monitor, click
Advanced.
In the Choose Monitor Engine dialog box, choose SiteScope, and click OK
to close the Monitor Engine dialog box.
4 In the Monitored Server Machines section, click Add. The Add Machine
dialog box opens.
➤ In the Monitored Machine Information section, enter the server name or
IP address of the machine you want to monitor. Select the platform on
which the machine runs.
➤ In the SiteScope Server Information section, enter the SiteScope machine
name, and port (default: 8888), and specify whether you are using a
Secure HTTP connection. If you are using a SiteScope account, fill in the
relevant account information.
Note: If you are adding a native LoadRunner monitor, the SiteScope
Server Information section does not appear.
Click OK to close the Add Machine dialog box.
5 Click Add in the Resource Measurements on: <machine> section of the SQL
Server dialog box
6 Continue with Configuring the SQL Server Monitor below.

Configuring the SQL Server Monitor

The configuration for this monitor differs slightly depending on whether
you are adding a SiteScope or native LoadRunner monitor.
Configuring the Native LoadRunner SQL Server Monitor
1 When you add a machine in the SQL Server dialog box, the default
measurements are displayed in the Resource Measurements on: <machine>
section.
Note: To change the default counters for the SQL Server monitor, see
“Changing a Monitor’s Default Counters” on page 395.
➤ To delete a measurement from the default list, select the measurement
and click Delete.
➤ To select additional measurements, click Add.
2 The MS SQL Server dialog box opens displaying the SQL Server resources.

 For each measurement select an object, counter, and instance, as described
in “Understanding the Add MS SQL Server Measurements Dialog Box” and then click Add.

 For a description of the available measurements, see “SQL Server
Performance Counters” .
3 When you have finished selecting the measurements to monitor, click
Close. The counters that you selected appear in the Resource Measurements
on: <machine> section of the SQL Server dialog box.
4 Click OK in the SQL Server dialog box to activate the monitor.
Note: Certain measurements or counters are especially useful for
determining server performance and isolating the cause of a bottleneck
during an initial stress test on the SQL Server. For more information about
these counters, see “Useful Counters for Stress Testing” on page 396.
Understanding the Add MS SQL Server Measurements
Dialog Box
The Add MS SQL Server Measurements dialog box lets you select additional
resources to monitor on the SQL Server.
➤ Object. Select the object being monitored on the specified machine.
➤ Counters/Measurements. Select a resource counter/measurement to
monitor. Select multiple counters using the CTRL key. For an explanation of
each counter/measurement, click Explain.
➤ Instances. If multiple instances of the selected counter/measurement are
running, select one or more instances to monitor for the selected
counter/measurement.
➤ Explain/Collapse. Displays/Collapses the Measurement Description box that
describes the selected counter/measurement.

Configuring the SiteScope SQL Server Monitor
1 The first time you add measurements you need to configure the remote
machine properties. When you click Add in the Resource Measurements on:
<machine> section of the SQL Server dialog box, a dialog box opens to
configure the remote machine as follows:
➤ If you are monitoring a machine on a UNIX platform, the Configuring
UNIX Remote Machine dialog box opens.
➤ If you are monitoring a machine on a Windows platform, the
Configuring NT Remote Machine dialog box opens.
Enter the remote machine’s configuration information, as described in
“Configuring the Remote Machine for SiteScope Monitors” on page 25, and
click OK.
2 The Configuring SQL Server Monitor dialog box opens. Verify the Server
and Update every properties, and click OK.
3 The Add MS SQL Server Measurements dialog box opens displaying the
available measurements and server properties.

For each measurement select an object, measurement, and instance, as
described in “Understanding the Add MS SQL Server Measurements Dialog
Box” on page , and then click Add.
For a description of the available measurements, see “SQL Server
Performance Counters” .

4 When you have finished selecting the measurements to monitor, click
Close. The measurements that you selected appear in the Resource
Measurements on: <machine> section of the SQL Server dialog box.
5 Click OK in the SQL Server dialog box to activate the monitor.