3 Discovery of the Microsoft SQL Server Target
The following topics are provided:
3.1 Discovering Targets
After successfully deploying the plug-in, follow these steps to add the plug-in target to Cloud Control for central monitoring and management:
- From the Setup menu, select Add Target and then Add Targets Manually as shown in Figure 3-1:
Figure 3-1 Add Targets Manually Menu
Figure 3-2 Add Microsoft SQL Server
3.2 Adding Targets with EMCLI
To add Microsoft SQL Server targets with EMCLI, use the add_target verb, as shown in Example 3-1.
You will need to specify the following options:
-
Target name:
*-name*It must begin with an alphabetic character contain only alphanumeric characters, multibyte characters, a space, -, _, ., :, /, (, ) and have a maximum length of 256 characters.
-
Target type:
*-type*Always use
"microsoft_sqlserver_database"(including the quotes). -
Host name:
*-host*Network name of the machine running the Management Agent that is collecting data for this target instance.
-
Target instance properties:
*-properties*Name-value pair list of properties for the target instance. The available property names are as follows.
SysUserName SysPassword DBUserName DBpassword Role dbBackupPath WinSecurityEnabled jdbcdriver url
-
Properties separator delimiter:
*-separator=properties*Specify a string delimiter to use between name-value pairs for the value of the -properties option. The default separator delimiter is ";".
-
Properties subseparator delimiter:
*-subseparator=properties*Specify a string delimiter to use between name and value in each name-value pair for the value of the -properties option. The default subseparator delimiter is ":". For the SQL Server plug-in, it is recommended that a plus "+" sign be used.
Example 3-1 Adding Microsoft SQL Server Targets Using EMCLI
emcli.bat add_target
-name=“SqlServerTarget"
-type="microsoft_sqlserver_database"
-host=“HostTargetName"
-properties="jdbcdriver+com.microsoft.sqlserver.jdbc.SQLServerDriver;
url+jdbc:sqlserver://SqlServerHost.domain.localnet:1433;
DBUserName+sa;DBpassword+password;
SysUserName+SqlServerHost.domain.localnet\Administrator;
SysPassword+password;WinSecurityEnabled+No;"
-subseparator=properties="+"
3.3 Verifying and Validating the Plug-in
After waiting a few minutes for the plug-in to start collecting data, use the following steps to verify and validate that Enterprise Manager is properly monitoring the plug-in target:
- Click the Microsoft SQL Server target link from the All Targets page. The Microsoft SQL Server home page appears as shown in Figure 3-3:
Figure 3-3 Microsoft SQL Server Target Home Page
- View the Database Page by selecting the Microsoft SQL Server drop down under the target name and selecting Database. The database page appears (Figure 3-4). The database page contains database specific performance and configuration metrics as well as backup and restore functionality. The database will be selected from a dropdown menu.
Figure 3-4 Microsoft SQL Server Database Page
- View the Performance Page by selecting the Microsoft SQL Server drop down under the target name and selecting Performance. The Performance page appears (Figure 3-5). The performance page contains convenient performance graphs built from collected metrics.
Figure 3-5 Microsoft SQL Server Performance Page
- View the Analysis Page by selecting the Microsoft SQL Server drop down under the target name and selecting Analysis. The Analysis page appears (Figure 3-6). The analysis page displayed SQL query and session information, as well as the "Kill Session" job button to quickly end any problematic sessions.
Figure 3-6 Microsoft SQL Server Analysis Page
- View the indexes page by selecting the Microsoft SQL Server drop down under the target name and selecting Indexes. The indexes page appears (Figure 3-7). The indexes page displays metric graphs and tables about the database indexes. It also includes a Missing Indexes table that recommends indexes to be created. Click Create Index to create an index.
Figure 3-7 Microsoft SQL Server Index Page
