Duty Free!!

SQL Write-Ahead Overhead…

SQL Server on Compressed Filesystems.

Many of us know that the filesystem on which the SQL Datafiles exist shouldnt be Compressed. The main reason that every one knows – it takes more effort to get the IO operations completed. Added to that the Windows  OS doesnt entertain any async IO operations on a Compressed volume. This makes a huge difference when the application, most probably SQL Server, can give a better performance calling the async IO calls. 

More over here by Ken Henderson’s Why you shouldn’t compress SQL Server data and log files

Advertisements

January 20, 2009 - Posted by | SQL Server

No comments yet.

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: