DB Block Size

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » DB Block Size

DB Block Size

Rate Topic

Display Mode

Topic Options

Author

Message

Thinky Night

Posted Sunday, January 06, 2013 10:31 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, May 17, 2013 1:31 AM
Points: 123, Visits: 218

What is the recommended block size of operating system on dss systems?

Also what is the recommended block size of oltp systems?

Post #1403340

opc.three

Posted Sunday, January 13, 2013 1:57 PM

SSCertifiable

Group: General Forum Members
Last Login: Yesterday @ 8:27 PM
Points: 6,735, Visits: 11,788

Assuming you mean the allocation unit size defined when you format a Windows drive then it will depend on the workload but 64 KB is usually a good place to start.

Use SQLIO and test with your workload and underlying disk subsystem to find the optimal config.

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1406514

« Prev Topic | Next Topic »

Permissions