Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
 Posted - 2014-01-28 : 17:01:08
|
| Dear Experts,We have done some query optimization on UAT environment by changing in the indexes and also split the big query into small SP's.And lot of improvements in UAT server and SAT server environment.We moved the same query to the production server environment and there is huge difference in production and UAT boxes meaning PROD environment not improved at all as in UAT server.Could you please help me to identify what could be the reason behind this.SQL server environment are same in all 3 environment UAT,SAP and PRD of having SQL server 2008 R2 and same amount of memory.Any suggestion or link will be helpful.Thanks,Gangadhara MSSQL Developer and DBA |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-01-28 : 18:01:13
|
| Compare the execution plans and statistics.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
Posted - 2014-01-28 : 19:55:08
|
| but i can't get the execution plan and statistics from the PRODUCTION environment as i will be having read access. moreover on production job can't be run for addhoc and the schedule job will run it.Any other which i can do.Thanks,Gangadhara MSSQL Developer and DBA |
|
|
|
|
|
|
Query Optimization