Monthly Archives: July 2018

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

How to operate multiple objects in SSMS (F7)

While working on a service restoration, we had to resume data movement on 100+ random databases. Generating TSQL is the best option but UI will be very quick and reliable. Biggest challenge with SSMS UI will be to perform the … Continue reading

Posted in SQL, SQL Server, SSMS, Uncategorized | Tagged , , | 2 Comments