Working with performance problems and query tuning can be a headache and take a lot of time. Most companies I have worked for have not done a good job with sharing experiences and dba to dba training. DBA’s can have a variety of experience and specialize in different aspects of SQL Server.
One of the best things that can be done is when working on a difficult problem is to save execution plans before and after the problem is fixed. This is a good practice to help train other database admins and even to keep for refreshers for yourself. So save your execution plans, your future self will thank you!
P.S.- We all know SSMS is terrible at viewing execution plans, do yourself a favor and download SQL Sentry Plan Explorer. Its FREE!!!!
SQL Sentry Plan Explorer Pro FREE!!!!!!
The post Save your execution plans! appeared first on VitaminDBA.
