Performance Tuning - Category Archive
The following is a list of all entries from the Performance Tuning category.
How Do You Defragment Your SQL Server Indexes
Database Administration,Database Maintenance,Performance Tuning | August 18, 2010 | 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.
An Introduction to Data Compression in SQL Server 2008
Database Administration,Performance Tuning | March 8, 2010 | 5:57 pmThis is an excerpt from my free eBook, Brad’s Sure Guide to SQL Server 2008. There is one thing every DBA knows with certainty, and that is that databases grow with time. MDFs grow, backups grow, and it never stops. The more data we have, the more work SQL Server has to perform in order ...read more
Introduction to the SQL Server 2008 Resource Governor
Database Administration,Performance Tuning | January 4, 2010 | 4:05 pmThis is an excerpt from my free eBook, Brad’s Sure Guide to SQL Server 2008. I think most of us are familiar with this situation: a SQL Server database is the backend of an OLTP (Online Transaction Processing) application, but you are required to allow users to run any reports they want on the production ...read more
