Does anyone know how I could get the data from a query on a table into a graph in APM? I have the query set up and it returns an "available", but I need to have the data the query results in graphed as the result. Any ideas?
APM v3.1
Thanks!!
Hello lytespd,I assume you use "SQL Server User Experience Monitor". If you enter a query that returns single numeric value, then this value is displayed in a statistics chart.
Example of such query can be: SELECT COUNT(OrderID) FROM Orders
Then your chart will show how number of orders in the table was changing during time.
For more info about monitor you can look at the documentation at: http://www.solarwinds.com/NetPerfMon/SolarWinds/OrionAPMPHComponentTypesSqlQA.htm