Monthly Trending with SQL Monitor
To start off, I have purging setup on SQL Monitor to happen once every month. I am looking at creating a trending report for SQL Server and I was wondering if SQL Monitor already had something in place for this. I am basically looking for all of the data found in the Analysis page, but instead of having the day to day data in it, I would like to see the average for each month on a line graph. As an example, for one SQL Server/Instance I would have one plot point for each month in the year that would display the Average User Connections for the month. So over the course of the year you would have 12 plot points on a line graph that showed you the average User Connections each month for 12 months. I have looked around some and I have done some Googling, but I don't see where SQL Monitor can do this for me right out of the box. I have read that people have written their own SQL queries to pull the data out of the database to create their own trending reports, but I am looking to save some time as I would have to figure out the layout of the database. Does this make sense?
-Brandon J. Button