Blocking in Reporting Services - What do these mean ?

Question

Blocking in Reporting Services - What do these mean ?

homebrew01

SSC Guru

Points: 55548
More actions
November 10, 2009 at 9:36 am

#213644

We've got some users reporting slow run times for their reports, and I see some blocking, but don't really understand what I'm seeing and am looking for help.
When looking at the processes running, I see this in the Process Details.
Blocker:
ReportServer.dbo.GetAllConfigurationInfo;1
ReportServer.dbo.WriteLockSession;1
Blocked:
ReportServer.dbo.GetSessionData;1
And if I look at SP_LOCK, the objects involved are:
"SnapshotData" and "Keys" tables in ReportServer Database
I'm not very familiar with RS objects & processes .... Any thoughts ?
Is there any RS specific maintenance I should be doing ?
TIA

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

AlexSQLForums SSChampion Points: 14277 More actions · Answer 1

homebrew01 (11/10/2009)
We've got some users reporting slow run times for their reports, and I see some blocking, but don't really understand what I'm seeing and am looking for help.
When looking at the processes running, I see this in the Process Details.
Blocker:
ReportServer.dbo.GetAllConfigurationInfo;1
ReportServer.dbo.WriteLockSession;1
Blocked:
ReportServer.dbo.GetSessionData;1
And if I look at SP_LOCK, the objects involved are:
"SnapshotData" and "Keys" tables in ReportServer Database
I'm not very familiar with RS objects & processes .... Any thoughts ?
Is there any RS specific maintenance I should be doing ?
TIA

You can cache the reports or create report snapshots using Report Manager

http://media.techtarget.com/digitalguide/images/Misc/reportmanager.JPG

Alex S

AlexSQLForums SSChampion Points: 14277 More actions · Answer 2

homebrew01 (11/10/2009)
We've got some users reporting slow run times for their reports, and I see some blocking, but don't really understand what I'm seeing and am looking for help.
When looking at the processes running, I see this in the Process Details.
Blocker:
ReportServer.dbo.GetAllConfigurationInfo;1
ReportServer.dbo.WriteLockSession;1
Blocked:
ReportServer.dbo.GetSessionData;1
And if I look at SP_LOCK, the objects involved are:
"SnapshotData" and "Keys" tables in ReportServer Database
I'm not very familiar with RS objects & processes .... Any thoughts ?
Is there any RS specific maintenance I should be doing ?
TIA

You can cache the reports or create report snapshots using Report Manager

http://media.techtarget.com/digitalguide/images/Misc/reportmanager.JPG

Alex S

AlexSQLForums SSChampion Points: 14277 More actions · Answer 3

homebrew01 (11/10/2009)
We've got some users reporting slow run times for their reports, and I see some blocking, but don't really understand what I'm seeing and am looking for help.
When looking at the processes running, I see this in the Process Details.
Blocker:
ReportServer.dbo.GetAllConfigurationInfo;1
ReportServer.dbo.WriteLockSession;1
Blocked:
ReportServer.dbo.GetSessionData;1
And if I look at SP_LOCK, the objects involved are:
"SnapshotData" and "Keys" tables in ReportServer Database
I'm not very familiar with RS objects & processes .... Any thoughts ?
Is there any RS specific maintenance I should be doing ?
TIA

You can cache the reports or create report snapshots using Report Manager

http://media.techtarget.com/digitalguide/images/Misc/reportmanager.JPG

Alex S

AlexSQLForums SSChampion Points: 14277 More actions · Answer 4

Moderator:

Please delete all the copies of the original reply.

I think i hit the server during maintenance.

Alex S