The most recent content from our members.
One of our DBAs gave me a SQL query that I need to trigger an alert off of when any output is detected. I think there are a few ways handle this but wanted to ask here for some advice since I'm fairly new to SAM and don't know SQL very well. The query is below with an example of its output. To summarize - The DBAs would…
Hi all, I am trying to run a SQL Server User Experience Monitor on each database present on a DB host/instance. I can get the names of existing databases on each DB host/instance. Next I am trying to create a custom property (for application monitor template) in which I'll add the list of all DB names. Is is possible to…
I am wanting to run some custom SQL to return a single value for a data check. The SQL Server is being monitored via an Agent, with the agent initiating the communication. There is no direct connection. The Custom SQL works as expected, I've run this on the server. The Credentials are Windows Domain Credentials and work…
Hi, I have a custom SQL that I run on all the nodes on which SQL Server Db is installed. I use "SQL Server User Experience Monitor" component for this. The problem is we have multiple DB instances on each host/node. Some of these DB instances have multiple databases created on them. What we have done until now is that we…
Hi all, I want to run a monitoring component (SQL Server User Experience Monitor) twice. The result will be a number and I want to alert when the result of second run is different than the first run. Is there a way to do this from SAM? I can schedule the monitor to run every 10 minutes but can't think of a way to save and…
Hello, I've setup a SQL experience monitor that returns a statistic and a customized message with an alert that works well. However, I'd like to re-trigger the alert if the statistic data changes. For example, the statistic is currently 2, the alert email is sent, but then 10 minutes later the SQL query is execute again…
Hi All, I am new to Solarwinds and and I have a little query here, any help will be greatly appreciated! I have created a sql user experience monitor and wrote a query to capture the no of blocking sessions count. I am trying to create an Alert for the same where i want to have a description like " $Componentname has…
Hello, We are using this component to run simple queries against different databases(10). If i wanted to run the same Templates to run the same jobs on a test set of databases I could make a copy of all my Templates and manual change the SQL Server Instance and Initial Catalog fields however, is there a way to create a…
It looks like you're new here. Sign in or register to get started.