Last year I did some posts about maintaining larger SQL Server databases better. Since then I have had to answer some questions on the SQLHelp hashtag on Twitter about information which is in these posts.
So, I have decided to do this post as a quick recap about them to help others. Reading these posts will save some people having to post questions on the SQLHelp hashtag.
I have covered a lot of these topics during my Database Adventure session. Various parts have been covered whenever performance issues have been discussed during this session.
In fact, I still remember the look on some people’s faces at SQLBits this year. Because I discussed the potential issues if you keep the default settings with most well-known index maintenance solutions.
I cover that in the second post of this series, which the link is for below. With that in mind, I will get on with the recap below.
Maintaining your larger databases better Part 1
In the first in the series I covered a lot of things I have seen that cause problems. For example, overlapping maintenance windows and potential DBCC CheckDB issues. You can read that post in detail here.
Maintaining your larger databases better Part 2 – Indexes
In the second post of this series I cover items relating to indexes. For example, the index maintenance issue I discussed above. You can read that post in detail here.
Maintaining your larger databases better Part 3 – Recommended DMV’s
In the third post of the series I cover DMV’s that I recommend. For example, the sys.dm_database_index_physcial_stats DMV that I have used a lot over the years. You can read that post in detail here.
Maintaining your larger databases better Part 4 – Recommended FREE tools for the job
In the fourth post in the series I cover free tools that I recommend. For example, Glenn Berry’s diagnostic scripts and SentryOne Plan Explorer. You can read that post in detail here.
I hope these posts help you maintain your larger SQL Server databases better. If you have any questions or comments about these, you are more than welcome to contact me.
Like I said earlier, I do cover some of these topics during my Database Adventure session and I have submitted it to SQLBits again for next year.
You can currently vote on which sessions you want to see there. So, if interested in seeing my unique session feel free to vote for it here.