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 |
|
priyakara
Starting Member
3 Posts |
 Posted - 2008-01-07 : 19:53:44
|
| im using reporting services to genarate a report and its calling S.Procedure to get the results. When i ran this report from the report server, it took about 10 mins to generate it. but when i ran the same SP in query analyzer it took only 1 second. Reporting server is on different box and database on different ( separate boxes) when i check the performance monitor (in Database box) its gone high when the report is running(for about 10 mins) How can i optimized the same query for reporting ?Thanks.-----------------E! |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-07 : 22:31:10
|
| Trace it in profiler to find out what's going on. |
 |
|
|
|
|
|
SQL Reporting query