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 |
|
NewHampshire
Starting Member
14 Posts |
 Posted - 2009-01-26 : 11:38:06
|
| Hi there,I'm new to SSRS. One of my users has what seems to be a fairly basic report that is taking nearly two minutes to run. When I run the same query from SSMS, it takes less than a second. The databse engine tuning wizard returns no suggestions.What are some things I could check that would cause a report in SSRS to run so much slower than the underlying query?Thanks. |
|
|
kmarshba
Starting Member
24 Posts |
Posted - 2009-01-26 : 17:16:07
|
| 1. How is the report running the query? E.g. stored procedure, raw SQL query?2. Is the report doing anything with the data? I.e. is it calling any special libraries or poor performing functions, etc?3. Have you run a trace with SQL Profiler to watch what comes across the wire when they run the report?Kevin |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Performance Difference btw SSMS and SSRS