January 14, 2013 at 2:56 am
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
January 14, 2013 at 2:59 am
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?
January 14, 2013 at 3:34 am
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
January 14, 2013 at 3:39 am
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.
January 14, 2013 at 4:15 am
thx bunches!!
January 14, 2013 at 3:20 pm
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) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply