SQL-SERVER Database technology integration

ServicePilot database-sql-server

# MS SQL Server Instance


This package is designed to monitor performance of all or part of a MS SQL Server Instance (Overview and Databases) in term of transactions, locks and log/data files.


This package automatically configures the ServicePilot Agent in order to monitor a MS SQL Server Instance by using predefined SQL requests.

The statistics gathered in this way provide a Microsoft SQL Server Instance overview and Databases performance indicators.


  • Network Flows - It is is necessary to ensure network connectivity between ServicePilot and the monitored device. In case of a network infrastructure using a firewall, all the ports below must be opened:

    • TCP/1433 (Default) (Microsoft SQL): Between ServicePilot Agent and Microsoft SQL Server
    • UDP/1434 (SQL Server Browser service): Between ServicePilot Agent and Microsoft SQL Server. Note that if firewalls are being implemented then it is preferable to set a fixed port for Microsoft SQL database instance access that is on TCP/1433 by default.
    • If Windows domain authentication is being used then connectivity between the ServicePilot Agent and Windows Domain Controllers for authentication, time synchronization, group policy, etc.
  • Third Party Configuration

    • Created an SQL Server Authentication Login for the Microsoft SQL Server database instance or a Windows domain account used by the ServicePilot Agent
    • Created and associated a database User with read permissions in the databases monitored to the Login
    • Allowed IP remote access to the Microsoft SQL Server database instance and associated firewall rules
  • ServicePilot Requirements

    • ServicePilot Manager minimum version: 8.5
    • ServicePilot Agent Minimum version 8.5: installed and configured


Before adding a resource to monitor, make certain that all pre-requisites are in place and if a ServicePilot Agent is required, that it is communicating correctly with the ServicePilot Manager.

Add resource using Views Configuration web interface

  1. As an administrative user of ServicePilot, open the ServicePilot web interface.
  2. Navigate to Administration. The Configuration > Views web page will open.
  3. Click on the view in which to place the new resource in the Views hierarchy on the left of the interface. The View editor section will show the existing view contents.
  4. From the Packages list on the right of the interface, click and drag the database-sql-server package into the View editor and let go.
  5. The Resource properties dialog box will open to allow resource configuration.
  6. Click OK to close the Resource properties dialog box. Note that the dialog box will not close if required parameters are not set.
  7. Click Save to apply the new resource to ServicePilot configuration.

Key field notes

  1. In the Monitoring Policies tab, specify the policy or policies to apply to the resource

  2. Connection tab:

    1. Instance to monitor: Specify the database instance to monitor in the format Host\Instance or Host,Port
    2. Authentication Type: Select the authentication type (Windows or SQL) to be used by ServicePilot to connect to the SQL Server Database
    3. Database Login: Specify the username of the SQL Server Login Account
    4. Database Password: Specify the password of the SQL Server Login Account
  3. Monitoring Options tab:

    1. Polling Interval (sec): Specify the time interval (in seconds) at which ServicePilot will poll the Microsoft Database
  4. Filters tab:

    1. Databases Included Filter: Specify the Databases to be included in the monitoring, separated by | e.g. "Database1|Database*"
    2. Databases Excluded Filter: Specify the Databases to exclude from the monitoring, separated by | e.g. "Database1|Database*"

      Note: Each element of the Databases Filter list is a regular expression as defined by Like Operator (Visual Basic)

Note: Database Login and Password are only required for SQL type authentication


This package uses the master.sys.dm_os_performance_counters table from SQL Server.

How can we help you?

Or call us at +33 2 40 60 13 30