Groups | Blog | Home
all groups > sql server reporting services > august 2004 >

sql server reporting services : Reporting services web service performance and asp.net thread pool



Rahul Agarwal
8/31/2004 10:24:41 AM
Hi

What are the implications of a long running query/report on asp.net thread
pool, I understand that if I am using reporting webservices or any
webservices it uses one of the thread from asp.net thread pool and if that
thread is blocked for processing the long running report/query it can't
process any other requests, is that correct? How to improve the performance
or handle such situation?

Please advice?
Thanks
rahul



Jéjé
9/6/2004 10:16:00 PM
you can follow the number of threads through the performance monitor.
Actually IIS can support thousands of requests, so I don't see any "problem"
in reporting services

Also I think that RS use a lot of thread to process the report (I presume
that each SQL query run asynchronously)

so, what result do you except?
how many users are planned on your system?

"Rahul Agarwal" <agarwal_rahul@hotmail.com> a écrit dans le message de news:
ekIplDvjEHA.2360@TK2MSFTNGP10.phx.gbl...
[quoted text, click to view]

AddThis Social Bookmark Button