ReportServer DB blocking !

Hi There

I have installed Reporting Services 2005 on a server, this uses a remote ReportServer Database on a Sql Server 2000 instance.

Everything has been working fine until a few days ago, i am picking up long blocking in the 2005 ReportServer database.

Up to 3-4 minutes.

The blocking is occuring on table locks on the "Keys" and "SnapshotData" tables in the report server database.

Now as a dba all i can see is the 2 spid's that are involved in the blocking, the spid that is blocking is at the time not doing anything, it is waititng while holding these locks.

I have a feeling this is due to long running reports, but iam not so sure because long running reports are a fact of life , i do not see how they should block other report user on ReportServer system tables ?

However how do i troubleshoot this? I dont know how to link these spids in sql server to reports being run , or to prove or disprove that his is due to long running reports ?

In other words how do i trouble shoot blocking in the reportserver database ?

Thanx

I've experienced the same problem. I contacted microsoft support regarding the issue, but they haven't found the solution.|||

Hi

Please keep me updated if you receive any feedback, i was going to open a case myself.

Thank You