Hi All,
I searched previous posts, but couldn't find solution to my current scenario.
We have about 80 SQL Server Instances on about 50 Boxes. Equal percentages of 2000 & 2005. Total of about 490 DBs
I need:
1: A way to identify the pattern of size increase [both TRN log and Data file] in each database over time. At the end of each month, I need to generate a Growth Graph [GG] of all the DBs for the Management to consider purchasing more space. I have a DB called "DBA" to store necessary information that I get, after performing calculations on the results from commands like "DBCC SQLPERF(LOGSPACE)" and "DBCC SHOWFILESTATS". This "DBA"-DB also has a bunch of tables that store information about location and login details of all the 490 DBs.
So I need to build a process that queries all the DB's, performs calculations and then inserts into a table in "DBA"-database. Since this process must talk to all the DBs, both SQL2000 & SQL2005, I am thinking of either a Windows Service Process or a VB exe file that runs from Scheduler.
Question: I need your suggestions or lessons learned from you guys, before I start this project.
2: Also, when log files comes close to full, an alert must be sent to a bunch of folks [e-mail, SMS, etc]. For SQL2005 I could use alerts, what about SQL2000. Ideally, I'd like to have one process do all of this, instead of having over 100 alerts.
Any suggestions are greatly appreciated,
_ub
I searched previous posts, but couldn't find solution to my current scenario.
We have about 80 SQL Server Instances on about 50 Boxes. Equal percentages of 2000 & 2005. Total of about 490 DBs
I need:
1: A way to identify the pattern of size increase [both TRN log and Data file] in each database over time. At the end of each month, I need to generate a Growth Graph [GG] of all the DBs for the Management to consider purchasing more space. I have a DB called "DBA" to store necessary information that I get, after performing calculations on the results from commands like "DBCC SQLPERF(LOGSPACE)" and "DBCC SHOWFILESTATS". This "DBA"-DB also has a bunch of tables that store information about location and login details of all the 490 DBs.
So I need to build a process that queries all the DB's, performs calculations and then inserts into a table in "DBA"-database. Since this process must talk to all the DBs, both SQL2000 & SQL2005, I am thinking of either a Windows Service Process or a VB exe file that runs from Scheduler.
Question: I need your suggestions or lessons learned from you guys, before I start this project.
2: Also, when log files comes close to full, an alert must be sent to a bunch of folks [e-mail, SMS, etc]. For SQL2005 I could use alerts, what about SQL2000. Ideally, I'd like to have one process do all of this, instead of having over 100 alerts.
Any suggestions are greatly appreciated,
_ub