I am a .Net developer. I have a database upgrade coming up (from SQL Server 2005 to SQL Server 2012). The database team will be handling the migration. But I have seen forums posts saying that after migration, the queries are taking too long to execute even though amount of data and number of users are almost same. And one main reason is change in
execution plan between these servers. Reference: Performance problem after migration from SQL Server 2005 to 2012
So, I am considering possibility of storing the actual execution plans from my current production server itself. In Oracle, I could find a feature for baselining:-
In SQL Server, what is the usual practice for achieving this?
Note: I referred Creating a baseline for SQL Server, yet it doesn't say anything about baselining