Page History

To configure SQL Server monitors, do the following:

1. In the SQL Server (Basic Checks) monitor template, complete the monitor information fields.
   To learn about monitor information fields, see Monitor Identification.
2. Complete the following fields:
   
   • SQL Server Port
     The number of the port on which SQL Server is listening.
     SQL Server uses Static Port Allocation or Dynamic Port Allocation ports. For more information, see the Knowledge Base article“SQL Server Ports.”
   • Port Check (Optional)
     Select this option to open a socket connection that determines whether or not the database is listening on the defined port.
     You should perform a port check because SQL Server can communicate statically on a defined or default port, or communicate dynamically on a port assigned by the operating system.
   • Username
     The user name that is required to log into the SQL Server database.
   • Password
     The password that is required to log into the SQL Server database.
   • Instance
     The name of the SQL server instance to which you want to connect.
     You can install multiple versions of Microsoft SQL Server on one computer. When installing a new version of SQL Server or maintaining an existing installation, you can specify it as:
   
   
   1. • A default instance of SQL Server
        This instance is identified by the network name of the computer on which it is running.
   
   
   • • A named instance of SQL Server
       This instance is identified by the network name of the computer plus an instance name, in the format <computername>\<instancename>.
       Most applications must use SQL Server client components to connect to a named instance. However, you can use tools such as the SQL Server Client Network Utility, or SQL Server Configuration Manager (depending on your SQL Server version) to configure a server alias name that the client components can use to connect to a named instance.
       A computer can concurrently run any number of named instances of SQL Server. An instance name cannot exceed 16 characters.
   • Database
     The name of the SQL Server database that you want to monitor.
     up.time views each database along the path /<system>/<instance>/<database>.
     Each instance of SQL Server has four system databases – master, model, tempdb, and msdb – and one or more user databases. Depending on their permissions, users can access some or all of the databases in an instance.
     A connection to an instance is associated with a particular database on the server, called the current database. You can switch from one database to another using the Transact-SQL USE database_name statement.
     up.time gathers information from all of the databases in all instances on a system and aggregates this information in the metrics it returns to you. Unless you must identify a particular database on your system – for example, you have applied a name to the default instance – you should leave the Database field blank.

   • Script File
     Click the Script File checkbox and then enter the full path on the Monitoring Station to the script that this monitor will run against the database.

     Info
     If you configured your database to allow logins with a user name and password, and you specify the script file but no login information, the script will fail and an error message will appear on the Global Scan dashboard. The script will run if you have configured your database to allow logins without a user name and password.

   • Script
     Click the Script checkbox, then in the text box, type or copy the script that you want up.time to run against the database. Use this option if you do not have access to the file system on the Monitoring Station or if your script is short or will not regularly change.

   • Match
     The value to match the script results against, which can be either a string or a regular expression. For more information, see Comparison Methods. For example, you can enter the following in the Match text box:
     ^[OK]+
     Where:
     
     •  ^ means start the match at the beginning of the line.
     •  [OK] is the pattern to match.
     •  + is the pattern to match anywhere on the line.
       The value that your script returns can be a string that you can match to. If you match to the value you checked for, the status of the service monitor is OK. Otherwise, the status of the service monitor is Critical.
   • Response Time
     Enter the Warning and Critical Response Time thresholds. For more information, see Configuring Warning and Critical Thresholds.
3. Click the Save for Graphing checkbox to save the data for a metric to the DataStore, which can be used to generate a report or graph.
4. Complete the following settings:
   
   • Timing Settings (see Adding Monitor Timing Settings Information for more information)
   • Alert Settings (see Monitor Alert Settings for more information)
   • Monitoring Period settings (see Monitor Timing Settings for more information)
   • Alert Profile settings (see Alert Profiles for more information)
   • Action Profile settings (see Action Profiles for more information)
5. Click Finish.