I need to work on performance improvement project,most of the time i will not have access to box having performance issue but i can get all the details from that box like file placements on different disk drive,fragmentation details or anything like that.
In most cases i can get backup of DB as well so that i can restore it on another environment which is having same configuration as the production box.
My question - if we restore the DB in another DB will the execution plan cache,statistics,fragmentation details will get vary/changed.What are the all measure i should considered before we proceed further.
Also i somebody shares the full cycle of performance tuning of a DB or application will be helpful. It may be point of view of DBA or developer performance point of view.
The project is having only DB solution so lot of inserts/updates will happen. The environment is of 2008 r2.
Any projects which is having details for full performance tuning will be helpful.