We are using SQL server 2008 R2 SSRS. The segment table in the SSRS database (Not SSRS Tempdb database) is extremely large. How does this table get populated and how can I tell what reports are consuming it. Can I truncate the table or delete some rows?
Any information is greatly appreciated.