Sunday, February 17, 2013

1 Use OEM to monitor Microsoft SQL Server

 

  • Configure sshd service on Windows host
  • Install the Microsoft  SQL Server OMS plugin
  • Download the Windows Agent
  • Install Windows Agent
  • Add the Target

prerequisite

 

Configure sshd service on Windows host

Please refer here.

 

Install the Microsoft  SQL Server OMS Plugin

Setup –> Extensibility –> Self Update

image

Click Plugin

image

Click the Microsoft SQL Server plugin , If the plugin is not downloaded ( status: Available), click the download first . Once it is download, click the Apply

image

image

Select the Management Servers

image

image

image

image

image

 

image

 

Download the Windows Agent

  • From the 12c, the agent can not be  download separately from OTN. We have to download through the 12c either through the online or offline mode.
  • The easier way to get the agent download is setup the online mode.

 

Setup –> Extensibility –> Self Update

image

Click Agent software

image

Select Microsoft windows and click download

image

Click the Apply

image

 

Install Windows Agent

  • The Windows agent must be deploy on the Windows platform. The Agent use WMI to monitor the Windows, if the agent is on the Linux host, we would get the WMI error. “_OS_Type_Agent_DynamicProperty;Process invocation failure: java.io.IOException: Cannot run program "/u01/app/oracle/agent12cr2/core/12.1.0.2.0/bin/nmefwmi” . The nmwfwmi is the wmi monitor executable.

Setup –> Extensibility –> Self Update

image

image

 

image

Fill in the target host name

image

Fill in the host information. If the directory does not exist, it would be created

  • Installation Base Directory:  C:\OEM
  • Instance Directory: C:\OEM\agent_inst

image

Provide the host credential

image

image

Then, click deploy agent

image

After the agent is deploy, we can verify the agent status

C:\OEM\agent_inst\bin\emctl.bat status agent

image

image

Add the Target

Setup –> Add Target –> add Targets Manually

image

Select the agent on the windows

image

Click add manually

image

Fill in the information

Database Role: sysadmin

image

This is OEM bugs, test connection would always fail with below error: SKIP the test and add the target.

Test Connection failed: [_WinAuthDLLToLoadDynamicProp;DB Credentials are found missing. DB Credentials are required for SQL based connections, MSSQL_NumClusterNodes;Can't resolve a non-optional query descriptor property [dllFile] (dllFile), _Wbem_Remote_Determination_DynamicProperty;Can't resolve a non-optional query descriptor property [dllFile] (dllFile), _MSSQL_Instance_TestMetric_DynamicProperty;Can't resolve a non-optional query descriptor property [dllFile] (dllFile), _OS_Type_TargetHost_DynamicProperty;Can't resolve a non-optional query descriptor property [STDINWBEM_HOST] (ms_sqlserver_host), MSSQL_NumClusterNodes;Can't resolve a non-optional query descriptor property [dllFile] (dllFile)]

image

In the example above, I use the sql authentication. If I use windows authentication, I would get the “'C:\OEM\plugins\oracle.em.smss.agent.plugin_12.1.0.2.0\scripts\emx\microsoft_sqlserver_database..\..\..\..\dependencies\oracle.em.smss\jdbcdriver\sqljdbc_auth.dll' is found missing ” . We have to create the directory and download the sqljdbc_auth.dll from MSFT website then copy to that directory.  However, I still get the test connection fail error.

 

After the target installed. check the host agent status

emctl config agent listtargets

image

Target –> All Target –> Click the host pandawin

image

Target –> All Target –> Click the MSSQL

image

we can also see the instance information

image

 

Reference

1 comments:

  1. Its really a nice post, the content of this blog is really awesome and extraordinary.And also please Read link bvba Woodstone which provide information server monitoring & monitoring tools

    ReplyDelete

 

SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates