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 |
|
wooody_1245
Starting Member
1 Post |
 Posted - 2008-05-14 : 16:33:36
|
| I've got a stored procedure that feeds a Crystal Report that is sometimes very slow and sometimes very fast. When I run the stored procedure using Query Analyzer, it only takes about 10 seconds to return 7 to 10 thousand records. When I run the Crystal Report, it takes about 5 minutes to get the same data.I know it sounds like a problem with Crystal Reports but I don't think it is. When I use SQL Profiler I can see where Crystal calls the stored procedure but it takes 5 minutes to complete. I've tried making an exact copy of the stored procedure with a different name and it runs perfect, sometimes. Other times it will take 5 minutes to complete. Sometimes the original stored procedure will run very quickly too. Anytime either stored procedure is slow, I can use SQL Profiler to verify when the SQL Server started and finished the query. It's always proportional to what I see with Crystal.I'm getting really bummed out by this. Any ideas? |
|
|
cat_jesus
Aged Yak Warrior
547 Posts |
Posted - 2008-05-14 : 16:36:46
|
| network issues?Crystal is a pig?An infinite universe is the ultimate cartesian product. |
 |
|
|
jason7655
Starting Member
24 Posts |
Posted - 2008-05-15 : 11:38:50
|
| couple ideas.1. make sure crystal is patched up. We ran into similar issues.2. make sure that the crystal report is cleaning up after itself (it's supposed to but we've read it's good practice to go ahead and do it.)3. have you tried to monitor to see if there's a lock or some resource being tied up when the slow down is happening? Is anything else going on that could be contributing. Generally, I've found that our stuff can run slow at a given time if certain things are happening at the same time...and sometimes that is hard to tell. |
|
|
|
|
|
|
Slow Stored Procedure (sometimes)