Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Hard disk full Expand / Collapse
Author
Message
Posted Monday, January 14, 2013 2:56 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, January 14, 2013 4:15 AM
Points: 8, Visits: 9
A customer has a large SQLServer 2008 database, it increases size every day because it is basically a statistics database with data added every day. A web application uses it to display statistics. Nothing happening transaction-wise, the data are just read and interpreted.

Today everything runs slowly and there are errors - we found that the hard disk is full.

What are the steps best taken now?

I'm just a programmer and not much of a database admin, so I'm not sure what to do.

-Michael
Post #1406621
Posted Monday, January 14, 2013 2:59 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 2:20 AM
Points: 5,231, Visits: 5,106
Add more space - if possible
Purge data - to release space from inside the data files, will need to be done in small chunks due to it needing to log the purge for ACIDity reasons
Perform index and statistic maintenance - to ensure everything is optimal for the queries being performed


What is the recovery model of the database
SELECT recovery_model_desc FROM sys.databases WHERE name = 'databasename'

What is the backup strategy for the database? How often are full, differential, transaction log backups done?




Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1406623
Posted Monday, January 14, 2013 3:34 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, January 14, 2013 4:15 AM
Points: 8, Visits: 9
Recovery model says: SIMPLE :)

The backup command is

/SQL "Maintenance Plans\(databasename) Integrity und Backup" /SERVER (servername) /CHECKPOINTING OFF /SET "\Package\Subplan_1.Disable";false /REPORTING E

done once daily.

-mpe
Post #1406636
Posted Monday, January 14, 2013 3:39 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 2:20 AM
Points: 5,231, Visits: 5,106
Ok, so your in simple, thats ok just would dictate the way to go when purging.

So the options are

1 - Add more disk space
2 - Purge data and perform index and statistics maintenace
3 - Both of the above.




Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1406638
Posted Monday, January 14, 2013 4:15 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, January 14, 2013 4:15 AM
Points: 8, Visits: 9
thx bunches!!
Post #1406649
Posted Monday, January 14, 2013 3:20 PM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Today @ 9:24 AM
Points: 2,084, Visits: 3,130
If the log is on the same drive, don't purge any data until you've given the log more space!

If the log is out of space, and particularly if it getting errors about it, you must add log space first. If necessary, you can temporarily add another log file on a different drive. First you must get the log file in working shape, then and only then can you safely purge data.


SQL DBA,SQL Server MVP('07, '08, '09)

"While in these days of quiet desperation /
As I wander through the world in which I live /
I search everywhere for some new inspiration /
But it's more than cold reality can give /
If I need a cause for celebration /
Or a comfort I can use to ease my mind /
I rely on my imagination /
And I dream of an imaginary time" : the inimitable Mr. Billy Joel
Post #1406960
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse