PRTG Manual: WMI Microsoft SQL Server 2005 Sensor

The WMI Microsoft SQL Server sensor monitors the performance of a Microsoft SQL server via Windows Management Instrumentation (WMI). It can show the number of user connections, and the number of logins and logouts per second; the number of full scans, page splits, and table lock escalations, per second; the buffer cache hit ratio in percent, and the number of database pages and stolen pages; the connection memory, optimizer memory, total server memory, target server memory, and SQL cache memory, in KB; the number of lock requests and deadlocks, per second, and the average wait time; and the number of batch requests, SQL compilations, and SQL re-compilations, per second. The channels actually available for a sensor depend on which performance counters you choose during setup.

Note: This sensor can only be added to a device (computer) running a Microsoft SQL database.

For this sensor type, Windows credentials must be defined for the device you want to use the sensor on.

For a general introduction to the technology behind WMI, please see Monitoring via WMI section.

Add Sensor

The Add Sensor dialog appears when adding a new sensor on a device manually. It only shows the setting fields that are imperative for creating the sensor. Therefore, you will not see all setting fields in this dialog. You can change all settings in the sensor's Settings tab later.

The following settings for this sensor differ in the 'Add Sensor' dialog in comparison to the sensor's settings page:

SQL Server Settings

MS SQL Server Instance

You see a list of all server instances available on the device. Display name and service name are provided as returned by the SQL server. Please choose one or more instances by adding a check mark in front of the respective line. For each instance one sensor will be created.

SQL Server Version

Enter the version of the SQL server. Usually, you can keep the default value.

SQL Counter Specific

SQL Performance Counters

You see a list of different performance counters which can be monitored for the instance(s) selected above. The sensors created for the server instances will all monitor the performance counter you select here. Choose from:

  • General Statistics: Read general performance counters. This will show the number of user connections, and the number of logins and logouts per second.
  • Access Methods: Read access method counters. This will show the number of full scans, page splits, and table lock escalations, per second.
  • Buffer Manager: Read buffer manager counters. This will show the buffer cache hit ratio in percent, and the number of database pages and stolen pages.
  • Memory Manager: Read memory manager counters. This will show the connection memory, optimizer memory, total server memory, target server memory, and SQL cache memory, in KB.
  • Locks: Read locks counters. This will show the number of lock requests and deadlocks, per second, and the average wait time.
  • SQL Statistics: Read SQL statistics. This will show the number of batch requests, SQL compilations, and SQL re-compilations, per second.

Depending on your selection, a sensor with the specified channels will be created. Note: In order to monitor several performance counters for an instance, please add the sensor several times.

Sensor Settings

On the sensor's details page, click on the Settings tab to change settings.

Note: If not set explicitly in a sensor's settings, it will connect to the IP Address or DNS Name defined in the settings of the parent device the sensor is created on.

Basic Sensor Settings

Sensor Name

Enter a meaningful name to identify the sensor. The name will be shown by default in the device tree and in all alarms.

Tags

Enter one or more tags, separated by space or comma. You can use tags to group sensors and use tag-filtered views later on. Tags are not case sensitive. We recommend using the default value. You can add additional tags to it, if you like. Other tags are automatically inherited from objects further up in the device tree. Those are not visible here.

Priority

Select a priority for the sensor. This setting determines where the sensor will be placed in sensor lists. Top priority will be at the top of a list. You can choose from one star (low priority) to five stars (top priority).

SQL Server Settings

Service

Shows the service monitored by this sensor. Once a sensor is created this value cannot be changed. It is shown for reference purposes only. If you need to change this, please add the sensor anew.

Name

Shows the name of the server instance monitored by this sensor. Once a sensor is created this value cannot be changed. It is shown for reference purposes only. If you need to change this, please add the sensor anew.

WMI Class Name

Select whether PRTG will select the name of the WMI class used for monitoring automatically. Choose between:

  • Automatic: Choose WMI class automatically. This is the recommended setting.
  • Manual: Manually enter a WMI class name. Use this if your server instance returns an error code in automatic mode.

WMI Class

This field is only shown if manual WMI class selection is enabled above. This setting is intended for experienced users only. Enter the WMI class name that will be used for monitoring your server instance.

Sensor Display

Primary Channel

Select a channel from the list to define it as the primary channel. In the device tree, the last value of the primary channel will always be displayed underneath the sensor's name. The available options depend on what channels are available for this sensor.

Chart Type

Define how different channels will be shown for this sensor.

  • Show channels independently (default): Show an own graph for each channel.
  • Stack channels on top of each other: Stack channels on top of each other to create a multi-channel graph. This will generate an easy-to-read graph which visualizes the different components of your total traffic. Note: This option cannot be used in combination with manual Vertical Axis Scaling (available in the Sensor Channels Settings settings).

Stack Unit

This setting is only available if stacked graphs are selected above. Choose a unit from the list. All channels with this unit will be stacked on top of each other. By default, you cannot exclude single channels from stacking, if they use the selected unit. However, there is an advanced procedure to do so.

Inherited Settings

By default, all following settings are inherited from objects higher in the hierarchy and should be changed there, if necessary. Often, best practice is to change them centrally in the Root group's settings. To change a setting for this object, disable inheritance by clicking on the check mark symbol in front of the respective setting name. You will then see the options described below.

Scanning Interval

Scanning Interval

The scanning interval determines the time the sensor waits between two scans. Select a scanning interval (seconds, minutes, or hours) from the list. You can change the available intervals in the system administration.

Schedules and Dependencies

Schedule

Select a schedule from the list. Schedules can be used to pause monitoring for a certain time span (days, hours) throughout the week. You can create new schedules and edit existing ones in the account settings. Note: Schedules are generally inherited. New schedules will be added to existing ones, so all schedules are active.

Dependency Type

Define a dependency type. Dependencies can be used to pause monitoring for an object depending on the status of another. You can choose between:

  • Use parent: Pause the current sensor if the device it is created on is in a Down status, or if it is paused by another dependency.
  • Select object: Pause the current sensor if the device it is created on is in an Down status, or if it is paused by another dependency. Additionally, pause the current sensor if a specific other object in the device tree is in a Down status, or if it is paused by another dependency. Select below.
  • Master object for parent: Make this sensor the master object for its parent device. The sensor will influence the behavior of the device it is created on: If the sensor is in a Down status, the device will be paused. For example, it is a good idea to make a Ping sensor the master object for its parent device to pause monitoring for all other sensors on the device in case the device cannot even be pinged. Additionally, the sensor will be paused if the parent group of its parent device is in a Down status, or if it is paused by another dependency.

Note: Testing your dependencies is easy! Simply choose Simulate Error Status from the context menu of an object that other objects depend on. A few seconds later all dependent objects should be paused.

Dependency

This field is only visible if the select object option is enabled above. Click on the reading-glass symbol and use the object selector to choose an object on which the current sensor will be dependent on.

Inherit Access Rights

User Group Access

Define which user group(s) will have access to the object you're editing. A table with user groups and right is shown; it contains all user groups from your setup. For each user group you can choose from the following access rights:

  • Inherited: Use the settings of the parent object.
  • None: Users in this group cannot see or edit the object. The object does not show up in lists and in the device tree. Exception: If a child object is visible to the user, the object is visible in the device tree, though not accessible.
  • Read: Users in this group can see the object and review its monitoring results.
  • Write: Users in this group can see the object, review its monitoring results, and edit the object's settings. They cannot edit access rights settings.
  • Full: Users in this group can see the object, review its monitoring results, edit the object's settings, and edit access rights settings.

You can create new user groups in the System Administration—User Groups settings. To automatically set all objects further down in the hierarchy to inherit this object's access rights, set a check mark for the Revert children's access rights to inherited option.

Channels

Click on the Channels tab to change display settings, spike filter, and limits. For detailed information, please see Sensor Channels Settings section.

Notifications

Click on the Notifications tab to change notification triggers. For detailed information, please see Sensor Notifications Settings section.

Others

For more general information about settings, please see Object Settings section.

Sensor Settings Overview

For information about sensor settings, please see the following sections:

Continue

Keywords:

Help
Need More Help?

Go to the Help Center.

Update Available Click here to install the lastest update
  FEEDBACK Click here to send feedback to Paessler