Skip to main content

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.

Comments

Popular posts from this blog

Why Driven Testing Important for every Software Tester

Context driven testing, Tester have to set their own path to complete their testing objectives, Test product, test documentation and test deliverable. The meaning of context-driven testing is project capture application of skill and opinion. Tester start testing with context driven testing it is very easy to understand and test application, therefore testing is a human activity that involves a great deal of skill to do well. The context-driven software testing methodological analysis indicates for continuous and creative valuation of testing opportunities. A tester always wants to do testing with context driven testing. It’s a very good practice to hands of explore and able to be proud of that work.   Why we need context driven testing- Context driven methodology like as agile process. Agile methodology generally depends on all-inclusive of unit tests. But in context driven testing, tester have to knowledge on unit testing as well testers will change, In context driven te...

Want to know about Mobile Application Testing? Came to right place

What is Mobile Application Testing ? Mobile Application Testing is a phenomenon of testing functionality, usability and consistency of application software designed for mobiles. It is done in two ways: Automated and Manually. When you buy a new mobile, various applications came pre-installed and some you install as per your need from mobile software distribution platforms such as Google Play, Nokia Store etc. In the recent years, mobile devices had shown a rapid growth rate .  Factors that give an open challenge to Mobile application Testing : 1. Mobile devices models : Different models have different hardware configurations, input methods (some are QWERTY, some are touch while others are normal). 2. Several different operating systems (OS) : Market  is full of availability of different operating  systems  (   Android , IOS, BREW, BREWMP, Symbian,   Windows Phone , and   BlackBerry   (RIM)).Each operating system is unique in ...

SELENIUM TESTING: SELENIUM IDE (& its installation)

In our previous post of selenium testing, we discussed selenium testing briefly. But it was just an introduction about that. And the selenium is much wider in its own. In today’s article, we are going to discuss the selenium, IDE Tool. What is Selenium IDE?? In selenium testing, selenium IDE (Selenium Integrated Development Environment) is a simple tool present in selenium suite Selenium IDE has an inbuilt record and playback functionality that allow us to create tests very quickly, easily and efficiently. Selenium IDE is very easy to install and use. As selenium IDE is a Firefox plugin, it aims to support Firefox browser only. Therefore, we can execute our created test scripts on Firefox only. Selenium IDE supports auto complete mode which allows the user to: * Enter commands more quickly *Restricts the user to enter invalid commands. The most impressive thing about the Selenium IDE in selenium testing that the user need not to have any prior knowledge of pr...