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 |
|
sql2020
Yak Posting Veteran
54 Posts |
 Posted - 2010-07-20 : 05:49:12
|
| I run below store procedure in DEV and UAT environmentin UAT same proc executes in 6 secbut in DEV it executes in 42 sec.i checked execution plan it shows every thing same as UAT.How to resolve if any thing need to check pls tell me fastthis the procexec cgi_sp_Remedy_GetReportList @ERROR = 0, @REMEDY_LOGIN_ID = 'sql2020'sql2020 |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-07-20 : 05:53:24
|
i checked execution plan it shows every thing same as UAT.Then maybe your dev environment isn't that fast...
No, you're never too old to Yak'n'Roll if you're too young to die. |
 |
|
|
sql2020
Yak Posting Veteran
54 Posts |
Posted - 2010-07-20 : 06:17:30
|
| How to improve this performancesql2020 |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2010-07-20 : 07:27:19
|
Look at Gail's helpful output:http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/and take the time to work it out.Performance isn't a simple thing...
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
|
|
|
storeprocedure performace