Re: Disk space usage
- From: Jeff@xxxxxxxxxxxxxx
- Date: Wed, 22 Aug 2007 07:06:59 -0700
On Aug 22, 4:31 am, "luna" <lun...@xxxxxxxxxxx> wrote:
Whats the best practice for monitoring disk space and managing it
efficiently,
or what to look out for ?
(came in today to severe lack of diskspace - its a 700gig raid) (the data
folder is 279gig - also ive noticed a lot of LDF files
are bigger than the relevent MDF file)
cheers
It sounds like you have a few different things you need to configure.
To answer your initial question, you can use the performance monitor
to alert you when you're low on disk space. Run PERFMON, then use the
"Performance Logs and Alerts" Tab. The counter you'll want is
LogicalDisk/% Free Space. Perfmon doesn't allow you to send emails by
default, but you can use a simple command line mail program if you
need. The rest is fairly self explanatory.
Your log files sound like they've never been shrunk and have just been
growing for the life of the database. You have a couple options here
- At this point, you're probably best backing up the database itself
and running a Backup Log with NO_LOG statement to truncate the log.
If you need to save the transaction log for recovery purposes, then
you can specify a backup location and exclude the NO_LOG statement,
but you've got quite a space hog right now.
Afterwards, run a DBCC SHRINKFILE on the name of the log file and
specify a size, in megabytes, the reduce the actual physical size of
the log.
.
- Follow-Ups:
- Re: Disk space usage
- From: luna
- Re: Disk space usage
- References:
- Disk space usage
- From: luna
- Disk space usage
- Prev by Date: Change disk location without restarting services
- Next by Date: Script to Generate Create Table DDL
- Previous by thread: Disk space usage
- Next by thread: Re: Disk space usage
- Index(es):
Relevant Pages
|
