Un-normall process handle count for report service
Is there a bug on SQL 2008 report services? I have report service configured on a windows 2008 server. None is using it, no third party call to it at all. But It's holding 2504 process handle there. Can anyone tell me what cause it?
Database is SQL 2008 enterprise edition 10.0.2804
Thanks
May 20th, 2011 10:52am
Hi LuZ,
I think it is a normal behavior, those handles may belong to different SSRS components. E.g. ReportingServicesEmailDeliveryProvider, ReportingServices.ProcessingCore, ReportingServicesFileShareDeliveryProvider, such and such.
You can download Handle.exe from Microsoft website and verify what the handles are. It can be found here:
http://download.sysinternals.com/Files/Handle.zip
Thanks.
Eileen
Free Windows Admin Tool Kit Click here and download it now
May 26th, 2011 10:30am