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 |
|
pkern
Starting Member
2 Posts |
 Posted - 2010-06-15 : 07:33:43
|
| Hi Guys, I'm hoping someone can point me in the right direction with this one. I have a ssrs 2005 report that runs with a stored procedure. In my development environment it runs in 1/5 minutes and in my Production environment it takes 5 minutes. Report and SP are all the same. Can someone point me in the right direction to check for the problem. Any help would be greatly appreciated. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
pkern
Starting Member
2 Posts |
Posted - 2010-06-15 : 14:35:17
|
| As far as I can see, the stats are the same on both servers. I did notice after I ran a trace on prod, that it has a bunch of calls to a "EXEC DeadChunkPortion". The development environment doesn't have that. No difference in the data volumn. Execution plan looks the same. Any more suggestions would be very helpful as I struggle to find an answer |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Slow Report Performance