Configuration parameters for the Database Server properties
In the Database Server Properties window, you can configure the Database Server properties, such as server name, database version, and home directory.
| Parameter name | Description | Mandatory field | Examples |
|---|---|---|---|
| Server Name | The name of the Microsoft SQL Server
instance that is to be monitored. Use MSSQLSERVER as the instance name for the default instance. The name must be short enough to fit within the total managed system name, which must be 2 - 32 characters in length. |
Yes | If the Microsoft SQL Server instance
that is monitored is the default Microsoft SQL Server
instance, enter MSSQLSERVER in this field. If the Microsoft SQL Server instance that is monitored is a named instance where the instance name is mysqlserver and the host name is popcorn, enter mysqlserver in this field. |
| Login | The Microsoft SQL Server user ID to be
used to connect to the Microsoft SQL Server. The user ID is required only when Windows Authentication parameter is set to False. Use only ASCII characters for the User ID. When you configure the
Microsoft SQL Server agent by specifying a login ID in the
Login field, the agent uses this login ID to connect to the Microsoft SQL Server.
Important: While configuring the agent if you select the Windows
Authentication check box and specify a login ID in the Login
field, the agent gives preference to the Windows
Authentication.
|
No | |
| Password | The password for the Microsoft SQL Server user ID. Password is required only when Windows Authentication parameter is set to False. Use only ASCII characters for the password. |
No | |
| Database Version | The version of SQL server instance. | Yes | The database versions for SQL server instance are as follows:
|
| Home Directory | The SQL server installation directory. | Yes | The default home directory path for the default Microsoft SQL Server 2005 instance is C:\Program
Files\Microsoft SQL Server\MSSQL. A named Microsoft SQL Server 2005 instance has a default home directory path in the format C:\Program Files\Microsoft SQL Server\MSSQL$instance_name, where instance_name is the Microsoft SQL Server instance name. |
| Error Log File | The fully qualified location and name of the SQL Server error log. | Yes | The default error log path for the default Microsoft SQL Server 2005 instance is C:\Program
Files\Microsoft SQL Server\MSSQL\LOG\ERRORLOG. A named Microsoft SQL Server 2005 instance has a default error log path in the format C:\Program Files\Microsoft SQL Server\MSSQL$instance_name\LOG\ERRORLOG, where instance_name is the Microsoft SQL Server instance name. |
| Windows Authentication |
Windows
Authentication is a Windows account with which the agent
services are configured, and is the default configuration option. If you select the Windows Authentication check box, Windows credentials are used for authentication. When the Microsoft SQL Server agent is configured with Windows Authentication,
either Local System account or This account is used by
the agent services to log on to the Microsoft SQL Server.
Remember: If you do not select the Windows Authentication check
box, you must specify values for the Login and
Password parameters. If you do not specify these parameters and click
OK in the Database Server Properties window, an error
message is displayed in a pop-up window and the agent configuration does not finish.
Important: If you configure the agent by selecting the Windows
Authentication check box and specifying a login ID in the Login
field, the agent gives preference to the Windows
Authentication.
|
No | |
| Support Long Lived Database Connections | Enables or disables long lived database connections. The following data sets
do not use long-lived database connections:
|
No | |
| Extended Parms | Disables capture of Table Detail and Database Detail attributes. | No | To disable the data collection for Table Details data set, enter koqtbld in the Extended Parms field. To disable the data collection for Database Details data set, enter koqdbd in the Extended Parms field. |
| Database | To select the databases for monitoring, specify a value for this parameter. To enable monitoring of all the databases that are available on the SQL server instance, select the Monitor All Databases check box in the Databases group area. Tip: The Monitor All Databases check box is selected by
default.
To enable or disable the monitoring of particular databases, clear the Monitor All Databases check box.
Use the text field to filter databases that you want to monitor. To specify database filter, you must first select a separator. A separator is a character that distinguishes a database name or database expression from the other database name or database expression. When you are selecting a separator, ensure that database names and database expression do not contain the character that you choose as a separator. You must not use the wildcard characters that are typically used in the T-SQL query (for example, %, _, [ ], ^, -) if they are used in the database names or database expression.When you are specifying database filter:
Note: Database expression is a valid expression that can be used in the LIKE part
of the T-SQL query. However, you cannot use the T-SQL ESCAPE
clause when you are specifying the database expression.
The following data sets are affected
by database filter:
|
No | Examples of filters: Case 1: % usage Example:
Case 2: _ usage Example:
Case 3: [] usage Example:
Case 4: [^] usage Example:
|
| Database (continued) | Remember:
|
Case 5: Wrong input Example:
Case 6: Default Example: Field left blank (No query is typed) Output: All the databases are filtered. Case 7: Mixed patterns Example:
Output: All the databases (of any length) whose names start with the characters m, n, o, p, q, r, s, t, followed by any character, with the character d in the third place are filtered. |
|
| Day(s) Frequency | Use this feature to define the frequency of collecting data of Table Detail attributes. The values can be from zero to 31. | No | |
| Weekly Frequency | Use this feature to specify a particular day for collecting data for Table Detail attributes. The values can be from zero to 7. | No | |
| Monthly Frequency | Use this feature to define the data collection of Table Detail attributes on a particular day of the month. The possible values are 1, 2, 3, and so on. | No | |
| Collection Start Time | The collection start time can be entered in HH:MM format. The possible values for hours are zero to 23. The default value is zero. The possible values for minutes are from zero to 59. The default value is zero. |
No | |
| Table Detail Continuous Collection | Use this feature for the continuous background collection of Table Detail
data. The Table Detail Continuous Collection check box is selected by default. |
No | |
| Interval Between Two Continuous Collection (in min.) | Specify the time for the interval between two collections in minutes. The
minimum interval time is 3 minutes. You can select the Interval Between Two Continuous Collection (in min.) check box or you can use Scheduling to specify continuous collection of the Table Detail data set. If you select the Interval Between Two Continuous Collection (in min.) check box, you must specify the time interval for collection. If you use Scheduling to specify the collection of the Table Detail data set, the minimum time interval is 1 day. The default interval between two continuous collections is 3 minutes. |
No |
- If day(s) frequency ≤ 7, the day(s) frequency settings are selected, and the weekly and monthly frequency settings are ignored.
- If day(s) frequency > 7, the weekly frequency settings are selected, and the day(s) and monthly frequency settings are ignored.