Tag Archives: Block size

Design considerations for SQL Server performance

While designing SQL Server for high performance following are the options to consider: 1. Block size to 64 KB (Defauly is 4 KB) Ref: * https://community.toadworld.com/platforms/sql-server/b/weblog/archive/2016/09/14/sql-server-storage-reading-block-size * https://blog.purestorage.com/what-is-sql-servers-io-block-size/ 2. Default Auto-Growth: change it to 1 GB 3. Validate MAXDOP Settings … Continue reading

Posted in Performance, SQL, Uncategorized | Tagged , , | Leave a comment