August 8, 2008 at 1:23 pm
Forgive me if this has been posted in the wrong forum section, don't really know where to post this one.
I hope someone can help, I am sure that I saw a reply to a posting here a few weeks ago that detailed a set of jobs and scripts to collect data from SQL 2005 management views and store them on a central server and then have the ability to run historical reports. I believe it is similar to the SQL Server DBA Dashboard produced by Greg Larsen http://www.sql-server-performance.com/software/review/dba_dashboard_p1.aspx but collects remotely and stores remotely.
If I remember rightly it is very similar in approach as the new SQL 2008 Performance Data Collector but collects 2005 instances. I may be going insane and have confused this with something else but I am sure I saw this post reply, if any one remembers it could you reply with the link I have searched high and low to no avail?
Andrew
August 8, 2008 at 1:59 pm
I think this is what you are looking for: http://www.codeplex.com/sqldmvstats/
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 8, 2008 at 3:11 pm
Jeffrey,
Thanks for the reply, I have looked at this, but I know this was not the link, this requires a DB be created on each monitored instance, I have 90 + production instances and don't want to go down that route if I can help it.
Andrew
August 8, 2008 at 5:16 pm
The only other tool I know about is the SQL Server Health and History tool from Microsoft. It can be downloaded from: http://www.microsoft.com/downloads/details.aspx?familyid=eedd10d6-75f7-4763-86de-d2347b8b5f89&displaylang=en
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply