How to know do I have enough space on my database and how much I need to have?

Question

How to know do I have enough space on my database and how much I need to have?

Krasavita

SSC-Insane

Points: 23138
More actions
March 24, 2009 at 2:47 pm

#384201

How to know do I have enough space on my database and how much I need to have?

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Sam Greene SSCertifiable Points: 5252 More actions · Answer 1

If you are concerned about this, you need to start tracking the size of your database. You can then plot the growth on a graph and estimate the day you will run out of space.

You could set up a job to get this information from the system tables and then report of of this information.

I like this system.

http://www.sqlmag.com/Articles/ArticleID/95385/pg/3/3.html

Check out the other articles by this guy.

ShekharNaidu SSCrazy Points: 2092 More actions · Answer 2

The below might help you buddy.. 🙂

http://msdn.microsoft.com/en-us/library/ms187445.aspx

Shekhar.

Thanks ,

Shekhar