March 8, 2004 at 4:33 pm
Can someone point me to examples of database & file growth monitoring.
I specificially want to monitor a number of separate SQL servers 2000
I want to end up with statistics of any size changes on any of these databases over time. Is there a script to monitor the growth of databases.
Help is greatly appericated..
thanks
March 9, 2004 at 1:32 am
- you could just have an alert raised when a file grows (e.g. error 5005 might be logged). Then extract the info from sql-log or windows-eventlog.
- you can gather the info yourself with an application build for that purpose.
This is a nice exercise for a fulltime dba, to keep a feeling with the application-developent environment. Try to do it according to the rules your developers have to follow _and_ if you can follow guidelines, theories,.. to build a state of the art application. Start with a simple datamodel, that has adaptability as primary objective.
- if your company is willing to affort it, there are tools that do far more than just gather filesize-info. Quest software, Embarcadero, Veritas, ... all have software to monitor sqlserver etc.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
March 9, 2004 at 1:39 am
Vyas has some ideas on this published here
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
March 9, 2004 at 7:44 am
Jessie,
We have implimented a home grown solution. I think I got the idea and the original script from this web sight.
see: http://www.sqlservercentral.com/scripts/contributions/298.asp for ideas.
If this script only runs for one server, you could fire it in a SQL Server Agent job on each server on a scheduled basis, saving the results in a specific database & table. You could then have a script on a central control server that gathers all the information from the tables of the individual servers.
That's what we do to maintain a table on a central server that shows historic sizes of all databases on all servers.
Hope this helps.
March 9, 2004 at 2:26 pm
We use a free sproc from http://www.dbmaint.com that saves and compares file sizes. We have it scheduled to run every hour (we were trying to see how many databases were growing often - too many!). Mostly worked straight off the site but needed a bit of tweaking...
Steve
March 12, 2004 at 7:00 am
If I had to pick one thing I hated doing manually, this would be it. So I convinced our managers to buy us Embarcadero's DBArtisan Workbench, which has a component called Capacity Analyst that tracks growth at the database, filegroup, file, and object (table, index) level. Everything is automated and scheduled and it has nice trend graphs and reports too. I think they have a two week trial or something if you want to see if it'll give you what you want...
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply