September 4, 2008 at 12:47 pm
Can anyone suggest a good tool to trend database growth for SQL 2k and SQL 2005
Thanks
September 4, 2008 at 12:57 pm
In a nutshell, this is how I do it ...
I have an admin database on all my servers, but I have one central admin database "a database that controls them all", that stores all my global information. On this central server, I have a simple control table with all my SQL server names stored inside of it. This is how I control all my DBA type processes and such ...
Anyways, I then run a simple vbscript I put together to connect to each of the servers in the control table and pull the database and log file size of each database on a daily basis. I dump this data into a normalized table structure.
I then use reporting services to show growth based on server, database and date range. I also report on alarming growth (thresholds created by a monthly average).
It's a very easy process and saves quite a bit of money vs. buying something fancy. Yet if you have the money to spend, I'd look into Redgate or Idera ... either one of them probably has a good tool for this.
September 4, 2008 at 1:00 pm
You can also use WMI counters per server and log locally or push to another server ... similar concept as above, and probably easier.
Check out [sys].[dm_os_performance_counters]
September 4, 2008 at 1:06 pm
Adam- thanks for the info. I'm not much of a developer so I may have to buy a tool.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply