Tag Archive for DBA

pass plan cache whisperer

PASS Summit Session Follow-up: The Plan Cache Whisperer

I’ve wrapped up my session at my first session at this year’s PASS Summit.  My session this Thursday was The Plan Cache Whisperer: Performance Tuning SQL Server [DBA-313]. The session appears to have gone really well and the content has been uploaded to the PASS Summit for download.  To provide access to the materials now, the slide deck…

checklist

May 2015 – SQL Server Monthly Maintenance Checklist

It’s time for a monthly reminder to review you SQL Server environment.  Hopefully over the last few months of this post not being published you’ve still been going through and performing your monthly SQL Server environment checklists. As with anything, just because it appears to be running well, doesn’t mean that there isn’t an unknown…

checklist

July 2014 – SQL Server Monthly Maintenance Checklist

It’s been a few months since I’ve updated my SQL Server monthly maintenance checklist.  Even though it hasn’t been updated, hopefully people have been continuing to look at their environments and performing the needed monthly maintenance activities. Doing this is important because if you don’t know where you are today, or last month, its hard…