Excluding SQL Servers from monitoring

Using the /MSSQLServer/SQLServersExcludedFromDiscovery/ pconfig variable, you can exclude from monitoring one or more SQL Servers. This pconfig variable does not appear automatically. You must enter the pconfig variable manually. For instructions on how to add or modify pconfig variables, see Adding or modifying pconfig variables manually.

To exclude SQL Servers from monitoring

1. Determine the SQL Server or Windows service name of each SQL Server you want to exclude from monitoring. 

   Tip

   To determine the SQL Server name, use the following query: "SELECT @@SERVERNAME" To determine the Windows service name, use the following query: "SELECT @@SERVICENAME"

2. Enter the following pconfig variable followed by the names of the SQL Servers that you want to exclude from monitoring, with a vertical pipe (|) character separating the names of the SQL Servers.
    For example,
   /MSSQLServer/SQLServersExcludedFromDiscovery/ ABC\SQL8_TEST|MSSQLServer|MSSQL-SQL8DATA|ABC\SQL8_PROD
   
   The above example excludes the following SQL Servers:

• With the SQL Server name ABC\SQL8_TEST, and ABC\SQL8_PROD, where ABC is the host name.
• With the Windows service name MSSQLServer for SQL Server with a default instance name .