HOW-TO: Track and Report MOM (and Other SQL Database) Growth : Part 1
I put together a short article on collecting and reporting quick-and-dirty database usage trends for MOM and other SQL databases. http://www.it-jedi.net/how-to/dbstats/Track_Report_SQL_Growth_MOM.htm 6/05/06 - NOTE: I updated the script to deal with some whitespace issues. Get an updated copy of DB_SizeWatch HERE: http://www.momresources.org/momscripts/DBSizeWatch_Create.txt
Labels: MOM Reporting |
Comments on "HOW-TO: Track and Report MOM (and Other SQL Database) Growth : Part 1"
-
Mark said ... (7:07 AM) :
-
Anonymous said ... (9:24 AM) :
post a comment links to this postI have been down this road as well, whilst quietly muttering to myself..."why is this not a part of the sql management pack...?"
I also track the major tables in systemcenter reporting to try and correlate number of computers / events / managepacks to try and size my systemcenter db ...while evilly muttering "why isn't this in the mom management pack?"
I tried this script on my database and it works great, except for two things:
The @SQLstring dynamic query contains too much white space and can get truncated; this could simply be a function of the editor I used to create my copy of the script, but it's something to watch out for in any case. If this happens several of the fields in the table will show up as NULL since it just drops that parts of the query.
Secondly, the dynamic query didn't seem to work on moderately large databases--I have a 20GB database with 8GB free space, and the script reported negative free space for that DB. I changed the query to use "dpages" rather than "reserved" from the sysindexes table and all was well, it began reporting the free space accurately.. Not sure what other implications this might have though...
James Ervin
Chapel Hill, NC
james@unc.edu