Sandip's Programming Zen

An attempt to share tech/coding experiences

SQL Performance and Recovery Model

leave a comment »

Recently I had a case where an application which was working fine suddenly started slowing down and apparently there were no code changes made. After checking around at Database properties found that Recovery Model was set to “Full”. In fact it was not needed according to the backup policy as only full backup was scheduled, not at the level of transaction log.

Setting the Recovery Model to “Simple” solved the problem and application was back on acceptable performance.

Check this link to know more about Recovery Model :
http://msdn.microsoft.com/en-us/library/aa173531.aspx

Advertisements

Written by Sandip

February 18, 2009 at 12:58 pm

Posted in MS SQL

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: