I have a customer that needs to know if an item in a row in a SQL table is still pending. If they're pending after 30 minutes, then the process is stuck. Is there anything in either SAM or DPA that I can use to monitor this? Thank you!
You want the SQL Server User Experience Monitor
You will need to write the query to output the values correctly, but this can get it done.
http://www.solarwinds.com/documentation/helpLoader.aspx?lang=en&topic=OrionAPMPHComponentTypesSqlQA.htm
Thank you! I will give that a try. I'm not a SQL query guru but I'll try and figure it out.
yes, "SQL User Experience" component in SAM will definitely do the job. All you need is to ask your DB team to help you with script. It needs to have the following output:
____________________________________________
Case #1 - no issues
Statistic | Message-------------------------0 | No issues
Case #2 - one or more issues
Statistic | Message-------------------------3 | 3 pending rows detected
________________________________________________
Then all you need to do is to set your component threshold to more or equal 1
P.S.I can help you with SQL script as well if you give me table name and name of your columns where information is kept
Thank you! I was able to get a SQL query and then put it in the SQL Server User Experience component and it's working perfectly.
