I have a query that obtains the detail data from the database. Then I have several other queries that interrogate the data which I then union for a complete set. This runs well and the results are between 15 - 30 rows of data. I then add another query with an outer join (50 rows in table) the query takes a huge performance hit - yet when I look on the server I don't see anything running - no cpu hit, and if I try for a pdf it never comes back and I still see no activity on the server. Any ideas on how I can determine what is going on and hopefully fix it.
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to troubleshoot RS 8 performance?
- Thread starter kbeck1
- Start date
- Status
Similar threads
- Locked
- Question