Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ferrethouse
Constraint Violating Yak Guru
352 Posts |
 Posted - 2012-06-01 : 11:59:54
|
| I need to delete several clients from our shared database. I will be disabling the website tonight in order to do this. It takes about an hour to delete a client but if I change the recovery mode of the database to simple first then it takes half the time. But If I do that and then change it back to full after then the transaction logs are out of sync and useless right? Suggestions? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
ferrethouse
Constraint Violating Yak Guru
352 Posts |
Posted - 2012-06-01 : 16:01:08
|
quote:
I don't understand why changing the recovery model speeds up performance. That doesn't make any sense. There must be something else going on here, such as severe IO issues.
It is deleting about 18 million records so I guess not having to commit to the tlogs means it is faster. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2012-06-01 : 16:41:53
|
quote:
Originally posted by ferrethouse
quote:
I don't understand why changing the recovery model speeds up performance. That doesn't make any sense. There must be something else going on here, such as severe IO issues.
It is deleting about 18 million records so I guess not having to commit to the tlogs means it is faster.
Nope. Transaction log is used regardless of recovery model. You've got something else happening here. Maybe autogrow problems and not often enough tlog backups?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
|
|
|
implications of temporarily changing DB mode?