Yesterday, I wrote about some advice that I received at the pre-con titled “Demystifying Database Administration Best Practices” which was presented by Microsoft Certified Masters Robert Davis (twitter|blog) and Argenis Fernandez (twitter|blog) from SQL Saturday #132 in Pensacola, Florida. Here are some more gems:
- Instant File Initialization is critical for performance, read more from Kimberly L. Tripp (twitter|blog).
- If you do not have Instant File Initialization enabled, then when you need to autogrow your database, it will have to zero out the file which may timeout the active query. However, the transaction log will always need to be zeroed out during an autogrow. These scenarios remind us to properly size our database during the planning stages.
- Page file sizing does not need to be one and a half times the amount of memory. Your SQL Server shouldn’t be paging, otherwise review your memory settings.
Continue reading on SQLGator.com.