Setup a persistent database connection for OUE in SAM

How do we setup a persistent database connection in SAM? Our DBAs are not happy with how many connections SW is opening.

We have to check 96 data points in a database once a minute for two difference sites. 192 sessions a minute for 2 monitors is causing some aggravation. Is there a way to open one connection for all 96 checks or to keep one session open for multiple checks?

Find more posts tagged with

sam

OUE

solarwinds

Accepted answers

All comments

chad.every

I'm guessing you're referencing the SAM database user experience monitor (MSSQL/Oracle/etc)? If so, then unfortunately, there isn't a way to group all of these checks into a single call. It would be a feature request.

adam.beedell

Ask em to take your 96 checks and make them a stored proc that COUNTS the problems, then lists a summary

Run the stored proc in a SQL UX monitor, return count of problems and summary, set threshold on count

But like nah not really

adam.beedell

@wex
Or have em persist a table and update that table with the stored proc, then just read off the bads as before