Running out of space on E drive

Question

Running out of space on E drive

Krasavita

SSC-Insane

Points: 23138
More actions
September 21, 2009 at 8:31 am

#226458

I was told to check what is taking a lot of space on the drive where db live. We were ok until last week and now we get alert 10% left and that is production server.Can you please direct me,what should I do.Thank you

Viewing 15 posts - 1 through 15 (of 31 total)

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

Silverfox SSC-Insane Points: 23150 More actions · Answer 1

Krasavita (9/21/2009)
I was told to check what is taking a lot of space on the drive where db live. We were ok until last week and now we get alert 10% left and that is production server.Can you please direct me,what should I do.Thank you

Ok, you need to work out what is taking all the space, what is kept on the e drive. datafiles, log files, backups?.

Check to see if anyone has copied anything on the drive recently, you can also check to see if any log files (.ldf) are really big, compared to the corresponding database files (.mdf)

You can also check to see if you have a lot of backup files (.bak) on the drive

--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]

Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]

Krasavita SSC-Insane Points: 23138 More actions · Answer 2

I found .mdb file with 19,717,120 kb for today, what kind of file is that?

Sergey Vavinskiy SSCarpal Tunnel Points: 4469 More actions · Answer 3

Sergey Vavinskiy

SSCarpal Tunnel

Points: 4469

September 21, 2009 at 9:13 am

#1056304

It is MS ACCESS data file.

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 4

An MDB is an Access file. If it's an mdf/ndf/ldf, those are SQL Server files.

Krasavita SSC-Insane Points: 23138 More actions · Answer 5

What code can I run to see how much each db space is using space.

Thank you

Seth Lynch SSCrazy Points: 2975 More actions · Answer 6

This script runs against the database you are connected to. This will show the total size of a database file along with the available space left in the file. This is for all the files that make up the database including the log file.

SELECT name AS 'File Name' , physical_name AS 'Physical Name', size/128 AS 'Total Size in MB',

size/128.0 - CAST(FILEPROPERTY(name, 'SpaceUsed') AS int)/128.0 AS 'Available Space In MB'

FROM sys.database_files;

You will need to run it against each of your SQL databases - or loop through with a cursor.

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 7

You can also right click the databases in SSMS and view the space. That can be easier to understand.

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 8

Also be aware that a SQL file needs free space in it. It is not like a Word or Excel file in that it is the size of the data.

Sergey Vavinskiy SSCarpal Tunnel Points: 4469 More actions · Answer 9

If you want to see data file allocated space and the actual size of data separately as Steve mentioned, just Right click on a database->Reports->Standard Reports->Disk Usage

Krasavita SSC-Insane Points: 23138 More actions · Answer 10

I looked at my drive and I didn't find anything accept data files for our db,How can I find out if any of the db are growing very quickly.Thank you

Krasavita SSC-Insane Points: 23138 More actions · Answer 11

I put all of my db here, any suggestions, how can I clean up the drive?

Here is my system db:

master4

mastlog0

modeldev2

modellog0

MSDBData 1674

MSDBLog31

tempdev1544

templog68

Here is db:

DB11827

DB1_log16

Db23

db2_log0

db32

db3_log0

db474

db4_log0

db53

db50

db62

db6_log0

2

db72

db7_log0

db84669

db8_log313

db910

db9_log1

db1011

db10_log24

db1121

db11_log0

21

db1250

db12_log1

db1310

db13_log0

db14500

db14_log211

db1566

db15_log5

db150

db16394

db162

db1715

db17_log0

db1812081

db18_log516

db1976

db19_log5

db19_Log120

db20428

db20_log8

db21 3

db22_log0

db222

db22_log0

db2323

db23_log1

db24236

db24_log0

db252

db25_log0

db267

db261

db272

db27_log0

2

db2837

db28_log19

56

db298

db29_log7

db30732

db30_log837

db313

db31_log0

db322

db32_log0

2

db338

db330

db343

db340

db352

db35_log0

db362

db36_log0

db3755

db375

db3819258

db38_log1

db3910

db39_log0

db4010

db40_log0

db4110

db41_log1

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 12

There may not be anything to clean up. You might just be out of space. Data files grow over time as data is added, and most of these are not very big.

Krasavita SSC-Insane Points: 23138 More actions · Answer 13

Thank you, do you know the tool that I can compare the space growing for db.

Steve Jones - SSC Editor SSC Guru Points: 736270 More actions · Answer 14

There are tools like Quest's Spotlight (or Foglight) and maybe Patrol from BMC, that will monitor this.

The way I used to do it was track backup sizes from a script and then compare them over time. The backup is a good guess of your data size and can tell you how quickly it's growing.