I have a developer that wants to write a query in SQL/Powershell that will present a number. He wants a graph in SW to display the results of the query over a period of time. The query is reporting back on a number of batch jobs waiting to be processed. They are wanting historical data of the number of jobs waiting to be processed over a period of time to tie it to an outages or issues.
Any insight on this?
You can do this in SAM using the SQL Server User Experience Monitor.
Create a new application monitor template.
Add component monitor and select sql server user experience monitor.
Select or add credentials and port number as required.
Enter the SQL query to Select Count from required table.
Add the sql server instance name if required.
SAM will then track the results of this over time and produce a nice chart of the historical statistic data.
