nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

How to setup sql monitors?

FormerMember

SAM noob here,

I'm trying to set up a simple query to return a value (select count(*) from ent_flash_traffic_5min where create_date >= SYSDATE-15/1440). How do i go about creating a connection the database and what monitor template should I use?

Find more posts tagged with

Accepted answers

vinay.by

SQL Server User Experience Monitor

http://www.solarwinds.com/documentation/en/flarehelp/sam/default.htm#OrionAPMPHComponentTypesSqlQA.htm?Highlight=SQL%20Monitors

All comments

vinay.by

SQL Server User Experience Monitor

http://www.solarwinds.com/documentation/en/flarehelp/sam/default.htm#OrionAPMPHComponentTypesSqlQA.htm?Highlight=SQL%20Monitors

FormerMember

How do I setup a connection to my oracle database in SAM?

aLTeReGo

Adding an Oracle Database Server to SAM

HolyGuacamole

This document should answer everything you need to know about setting up Oracle User Experience Monitors in SAM

http://www.solarwinds.com/documentation/apm/docs/Configuring_and_Integrating_Oracle.pdf

FormerMember

Thanks for the information guys!!! I followed the to install the basic lite oracle client and on step 10 it has me shutdown everything. Everything stopped except for SolarWinds JMX Bridge. It's status says stopping but its been well over 15 minutes. I've tried start and stoping but the status doesn't change. Any ideas what i should try next?

aLTeReGo

I would recommend opening Task Manager on the Orion server and killing (ending task) on the "jsl.exe" process

jsl.exe.png

FormerMember

Thanks, that worked!

I think I'm almost there but I'm I have a question about part of the installation. Do these two additional components need to be install on the database or the server where SAM lives in?

SAM requires two additional components in order to monitor Oracle databases:

Oracle's Instant Client
SolarWinds Oracle Plug-in.

The steps below should result in a successfully tested and monitored database.

aLTeReGo

One of those ODBC drivers should be installed on the Orion server before you will be able to connect to an Oracle database server. You can use the SolarWinds Oracle Plug-in available in your Customer Portal, or download Oracle's Instant Client from Oracle's website.