Monitoring of Sql Server & oracle database through APM

Did you receive an answer on this?  I am getting many requests to watch databases much better.  Tivoli does an adequate job, but now Orion must take over....  And do more, better, faster...

Hi,

I haven't received any appropriate solution for it. Can you please help me for the above listsed parameters monitoring through Solarwinds Suite

I am struggling with the Oracle side right now.  Not many resources available.  When I find something I'll update here...

So APM is not good tool for Oracle and SQl Server database monitoring? Please let me know the steps to create self monitor template in APM? Can I use Sql/Oracle query to monitor database through APM? Will it require readonly access of Database? 

Hello,

Tha admin guide has great walk throughs.  Have you tried these:

http://www.solarwinds.com/NetPerfMon/SolarWinds/images/ApplicationPerformanceMonitorAdministratorGuide.06.108.1.png

http://www.solarwinds.com/NetPerfMon/SolarWinds/OrionAPMAGCreatingNewTemplates.htm

http://www.solarwinds.com/NetPerfMon/SolarWinds/OrionAPMPHComponentTypesOracleQA.htm

Hello Jason,

I need help to elaborate the "6 canned templates for Sql server 2005-2008" and "Oracle database template" of APM.

Can you please help me in it?

Hi Nitin--

Thanks for your patience. I understand Sales has reached out to you and scheduled a call for Wednesday.

Also, to answer your recent post:

This Technical Reference provides you information on the canned (pre-defined) SQL templates. You get them with the latest version of APM.

This Templates Reference provides links to most of the APM's canned templates. Scroll down for the Oracle DB one.

HTH,

M

It may be best to open a support ticket.

http://www.solarwinds.com/support/ticket/

Just to clarify about what APM can monitor in terms of Oracle and SQL, APM has an Oracle template that monitors the following statistics: available free space, available continuous free space, buffer cache hit ratio, dictionary cache hit ratio, library cache hit ratio, available free memory, sort ratio (disk vs. free memory), and the number of users connected to the database through SQL Net.  APM also has four SQL templates: SQL Server (via SNMP), SQL Server Database 2005 and 2008, and SQL Server Query.  The documentation referenced earlier in this thread can give you additional detail on what you can monitor with those templates.

HTH,

Craig

Thanks Craig. Much appreciated you help in this.