Performance Tuning - Category Archive
The following is a list of all entries from the Performance Tuning category.
Most SQL Server DBAs Still Don’t Know About Instant File Initialization
Database Administration,Database Maintenance,Performance Tuning | September 20, 2010 | 8:53 amIn my most recent poll, I asked DBAs if they have turned on instant file initialization on their SQL Servers. I was a little surprised by the results. Just over half of the DBAs who responded to the poll said that they don’t know what instant file initialization is, and another 13% said that they ...read more
Checkout SQLServerIO.com for Useful Information on SQL Server Storage Systems
Database Administration,Hardware,Performance Tuning | August 18, 2010 | 4:45 pmAt the recent SQLSaturday #28 in Baton Rouge, LA, I had the opportunity to meet Wes Brown (Blog | Twitter), and attend his session on “Understanding Storage Systems and SQL Server”. I enjoyed his presentation and also discovered that Wes has a blog where he shares his deep knowledge of SQL Server I/O. If you ...read more
How Do You Defragment Your SQL Server Indexes
Database Administration,Database Maintenance,Performance Tuning | | 11:05 amI give a lot of presentations based on best practices, and in all of them I stress the importance of regularly rebuilding or reorganizing indexes. Both the REBUILD and the REORGANIZE options have their pros and cons, so I thought it would be interesting to do a poll to see which method(s) was preferred by ...read more
How to Performance Tune a VLDB on your Desktop
Database Administration,Performance Tuning | August 16, 2010 | 3:17 pmRecently, I wrote a review of Red Gate Software’s new SQL Virtual Restore software. SQL Virtual Restore allows you to quickly turn a compressed backup into a live, virtual database, with the advantage that the virtual database is substantially smaller than the original database, while at the same time acting identically to the production database.
Windows OS Power Saving Feature Directly Affects CPU Performance
Database Administration,Hardware,Performance Tuning | July 26, 2010 | 2:50 pmWhile I have always known that the Windows operating system Power Plan options affect a server’s performance, I had not realized how much until SQL Server MVP Glenn Berry (Blog | Twitter) suggested I try out my new Dell T610 test servers under the three available power savings plans: High Performance Balanced Power Saver
PAL 2.0 Beta Released
Database Administration,Free Stuff,News,Performance Tuning | July 2, 2010 | 4:25 pmBack in 2008, I wrote a blog post about version 1 of the Performance Analysis of Logs (PAL) tool. This free tool, available from pal.codeplex.com, has been enhanced, and Version 2.0, Beta 1.1, is currently available for download. I have just downloaded and installed it myself, although I haven’t had much chance to use it ...read more
What is the Ideal SQL Server Test Box?
Database Administration,Hardware,Performance Tuning | June 16, 2010 | 4:13 pmI’m thinking about setting up a SQL Server test box in my home office for doing some extensive, real-world SQL Server performance testing. So far, here is what I am thinking about getting: –Because I have limited space, the test box will need to be a tower. I will also be limited to one physical ...read more
Two Blog Series You Don’t Want to Miss
Database Administration,Indexing,Performance Tuning | May 28, 2010 | 1:52 pmBlogs are a great way to learn new things about SQL Server, and just in case you have missed them, I want to recommend the following two blog series that I feel every DBA should read.
