Scroll to navigation

PMDAMSSQL(1) General Commands Manual PMDAMSSQL(1)


pmdamssql - Microsoft SQL Server database PMDA


pmdamssql is a Performance Co-Pilot (PCP) Performance Metrics Domain Agent (PMDA) which extracts live performance data from a running Microsoft SQL Server database server.


Firstly, pmdamssql requires installation of these support packages:

The primary Microsoft SQL Server database package.
Latest Microsoft SQL Server ODBC bindings.
General Python ODBC module with Microsoft SQL Server support enabled.

Next, pmdamssql reads an optional ini-style configuration file:


This file currently allows for two sections, one for configuring the library that connects to SQL server, the other for authenticating with SQL server.

[connection] section specifies values for the following settings (their default values are shown in parenthesis):

ODBC driver string.
SQL Server socket connection string.
Connection timeout setting, in seconds.

[authentication] section specifies values for the two supported modes of authentication with SQL Server.

The default is to use SQL Server authentication, which requires a username and password to be provided. These are the following configuration settings (their default values are shown in parenthesis):

Username to connect to the database.
Password to connect to the database.

The second option is Windows authentication mode, where logins are created in SQL Server that are not based on operating system user accounts.

Set to true to use Windows authentication when connecting to the database.

This is a Kerberos-style connection and credentials must be available before the PMDA is started (see kinit(1) for further details).


To install, the following must be done as root:

# cd $PCP_PMDAS_DIR/mssql
# ./Install

To uninstall, the following must be done as root:

# cd $PCP_PMDAS_DIR/mssql
# ./Remove

pmdamssql is launched by pmcd(1) and should never be executed directly. The Install and Remove scripts notify pmcd(1) when the agent is installed or removed.

pmdamssql will automatically attempt to reconnect to the SQL Server if its connection is lost - e.g. if the SQL Server service is restarted.


configuration file for the pmdamssql agent
installation script for the pmdamssql agent
undo installation script for the pmdamssql agent
default log file for messages from the pmdamssql agent

Note that the usual/default value for $PCP_PMDAS_DIR is /var/lib/pcp/pmdas and the default for $PCP_LOG_DIR is /var/log/pcp but these settings are platform dependent.


Environment variables with the prefix PCP_ are used to parameterize the file and directory names used by PCP. On each installation, the file /etc/pcp.conf contains the local values for these variables. The $PCP_CONF variable may be used to specify an alternative configuration file, as described in pcp.conf(5).


PCPIntro(1), kinit(1) and pmcd(1).

PCP Performance Co-Pilot