SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Query Optimization
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

gangadhara.ms
Aged Yak Warrior

India
547 Posts

Posted - 01/28/2014 :  17:01:08  Show Profile  Reply with Quote
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 MS
SQL Developer and DBA

tkizer
Almighty SQL Goddess

USA
37316 Posts

Posted - 01/28/2014 :  18:01:13  Show Profile  Visit tkizer's Homepage  Reply with Quote
Compare the execution plans and statistics.

Tara Kizer
SQL Server MVP since 2007
http://weblogs.sqlteam.com/tarad/
Go to Top of Page

gangadhara.ms
Aged Yak Warrior

India
547 Posts

Posted - 01/28/2014 :  19:55:08  Show Profile  Reply with Quote
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 MS
SQL Developer and DBA
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000