I want to ask one general question like let's suppose I have a database and
the data file and transaction log for the database are located on a 9.1 GB
hard disk. Both files are configured for automatic file growth. The data
file occupies 7 GB of disk space. I want calculate when I will need to add
additional disk space.

Should I go with Configure System Monitor to log disk space utilization OR
Configure a SQL Server Agent job to execute the sp_spaceused stored
procedure each day and then to store the results of the procedure to a table
in the database

Thanks
NOOR

How big is your log file? You don't say, but if it is 500MB that only
leaves you 1.5GB. That is not a lot of room...I would probably order
another disk now. Then again, if you only add 20MB per day you have some
time.

--
Keith


"Noor" <noor (AT) ngsol (DOT) com> wrote

Basically I want to go with one option from the following two option

1) Configure System Monitor to log disk space utilization
2) Configure a SQL Server Agent job to execute the sp_spaceused stored
procedure each day and then to store the results of the procedure to a table
in the database

Thanks
NOOR

"Keith Kratochvil" <sqlguy.back2u (AT) comcast (DOT) net> wrote

You did not answer my question and you did not seem to have read my post.
Let me say it another way

Disk drives are cheap
Downtime due to a full drive can be expensive.
Buy a new drive.

Then again, only you know what your growth rate is. Perhaps it will take
many months or years to fill up the available space. Or perhaps it will
take days or weeks.

--
Keith


"Noor" <noor (AT) ngsol (DOT) com> wrote

Another thing to consider is the size your log file can
grow to if your database is particularly busy. As a rule
of thumb, on a busy database, I plan for 5-6 times the
data file for a log file and then put in a job to shrink
that log file down regularly.

Hi Noor,


I will go with 1st option... Second option will give only the database
size....

You can use the system monitor to log the hard disk utilization. Create an
alert in performance monitor with a threshhold limit , so as soon as
the space crosses the threshold an alert will be raised.

Thanks
Hari
MCDBA




"Noor" <noor (AT) ngsol (DOT) com> wrote

Thanks Hari..


Noor

"Hari Prasad" <hari_prasad_k (AT) hotmail (DOT) com> wrote