Find more about how we can help you tune your environment - click here!
Tuning Microsoft Sql Server 4 Quick steps
Sysadmins and Database Administrators priorities lie in maximizing server uptime and performance. These 4 steps to maintaining server uptime are often skipped by undertrained or overworked IT Staff. Go implement them now.
- Make sure your preventive maintenance, especially index maintenance, has been running. This balances internal index structures and smooths performance.
- Check the index recommendations coming out of the database engine tuning advisor (see my blog address below for code). Make sure that when you add them, you eliminate duplicates (There’s an entry for that as well). Storage is cheap for the additional indexes, extra io for table scans or badly constructed indexes is expensive.
- Identify and remove unused indexes. Storage is cheap, but it isn’t free. And it’s not useful to have the optimizer reviewing indexes it never uses. (See code in my blog, below)
- Identify and remove redundant indexes. Same reasons as number 3.
You’ll find all of this index maintenance has a dramatic effect on performance.
Still need help? Contact us today to get a free 1 hour environment review where we will show you how to do this, and a lot more
