Sample Header Ad - 728x90

SSRS 2016 running slow with blocking

0 votes
0 answers
221 views
SSRS 2016 - Standard Default Settings. Work Horse for Reporting. Some large reports can run 5 hours+. Most reports cannot be optimized/tuned - 3rd party vendor. On occasion noticed procs "WriteLockSession,CreateChunkSegment,ReadChunkSegment" in multiple sessions with millions of reads and writes , and at times Blocking. Noticed these table have over 400k records: SegmentedChunk, ChunkSegmentMapping and Segment. Is there a standard process to clean up these tables (unused data) ,or check these tables for orphan records? Does 400k sound high (like a problem), have other SSRS instances with much lower counts. Restarted SSRS - no change. Shrink db - no change. Index optimization and update stats - regular maintenance.
Asked by jay (31 rep)
Dec 7, 2023, 04:02 PM
Last activity: Dec 7, 2023, 07:28 PM