November 26, 2002 08:26 PM

Avoiding the Red Zone

Follow this 2-step process for tracking disk usage
Rating: (0)
SQL Server Magazine
InstantDoc ID #26874
Have your customers or managers ever asked you how much their databases grew during the past year? Have you needed to plan how much disk capacity you'll need for the next year based on your database's average growth rate during the past 12 months? How long will your existing unallocated disk space last based on your current growth rate? To answer these kinds of database-growth questions or similar disk-space questions, you need some historical space-usage information about your databases. I've d...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Add a Comment

Its an very, very helpful article...

In conjunction with "EXEC master..xp_fixeddrives" you can have a completly track of your Databases and harddrives spaces.

Thanks Greg!!

Gerardo3/22/2007 5:10:48 PM


Very good!

LOUIS7/11/2006 12:03:41 PM


This article is a gem! The author was kind enough to revert to me during my implementation. Bravo Greg!

Patrick3/3/2003 10:57:15 PM


I'm unsuccessful in implementing this idea in my environment. I'm sure I'm probably doing something wrong, but when I try to run the jobs in Enterprise Manager, they just fail. Admittedly, I'm pretty new to manual jobs and osql syntax, but I don't see anything out of the ordinary. It isn't creating the output files as expected, and I can't see anything wrong. Anyone got any suggestions for implementing this in other environments?

Thanks,

Dave

Dave2/5/2003 3:58:55 PM


You must log on before posting a comment.

Are you a new visitor? Register Here