Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSRS 2008 R2 - SEGMENT table Expand / Collapse
Author
Message
Posted Sunday, April 07, 2013 4:10 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, January 09, 2014 2:21 PM
Points: 124, Visits: 293
Hello All,

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.

HELP!!


Thanks



Post #1439635
Posted Tuesday, April 09, 2013 8:20 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 5:31 AM
Points: 10,910, Visits: 12,548
AS far as what is, from http://sqlcat.com/sqlcat/b/technicalnotes/archive/2008/06/26/report-server-catalog-best-practices.aspx:

For SQL Server 2005 Reporting Services, many of the insertions are performed to the ChunkData, SnapshotData, and SessionData tables. But SQL Server 2008 in general does not write to these tables. They exist in the catalog to support the upgrade of pre-2008 catalog. SQL Server 2008 Reporting Services uses a new snapshot storage mechanism that shreds chunks across multiple rows in a table named Segment. For SQL Server 2008 Reporting Services, this table generally takes on the majority of transactions of the RSTempDB database.


So it stores the snapshots of reports.

I'm not sure how you'd clean it up, beyond changing the snapshot setting on the report server. If you go to http://[your server name here]/reports/pages/settings.aspx there is a property for how many snapshots to store in the report server per report. The default is unlimited, so changing this setting will reduce the size of the Segment table.




Jack Corbett

Applications Developer

Don't let the good be the enemy of the best. -- Paul Fleming

Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
How to Post Performance Problems
Crosstabs and Pivots or How to turn rows into columns Part 1
Crosstabs and Pivots or How to turn rows into columns Part 2
Post #1440357
Posted Wednesday, April 10, 2013 12:38 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Thursday, January 09, 2014 2:21 PM
Points: 124, Visits: 293
Thanks for the feedback, we'll investigate that option.

Thanjs again.



Post #1440667
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse