This section describes the required configurations as well as the optional configurations available for the Solution Package for Microsoft SQL Server in the RTView Configuration Application. You must define the classpath to the SQL Server JDBC jar file and you must also define data source connections for each SQL Server that you want to monitor. 

Configuring Data Collection

Use the RTView Configuration Application to configure your data collection.

• Navigate to Solution Package Configuration > Microsoft SQL Server.

• On the CONNECTIONS tab, provide the correct full path to the directory containing the SQL Server JDBC jar file in the Classpath field.
• In the Connections region, click the  icon.

The Add Connection dialog displays.

• Specify the connection information and click SAVE where:

Connection Name: specify the name you want to use for the connection.

Database URL: Enter the complete URL for the SQL Server.

Username: The username is used when creating the connection to the SQL Server. 

Password: This password is used when creating the connection to the SQL Server. By default, the password entered is hidden. Click the  icon to view the password text.

The newly created connection displays in the Connections section.

• You can optionally modify the Poll Rates (query interval, in seconds) that will be used to collect the metric data for the DB Size (MssqlServerDatabaseSizes cache), Performance Counter (MssqlPerfCounters cache), Server Statistics (MssqlServerStats cache), Table Size (MssqlServerTableSizes cache), and Wait (MssqlWaitStats cache) caches by clicking on the DATA COLLECTION tab and entering the desired polling rate for each cache in the Poll Rates region.