Forum Discussion

mikegrove's avatar
mikegrove
Regular Visitor
8 years ago

ReportServerTempDB.dbo.ContentCache

We upgraded our existing SSRS to PBIX by restoring our 2014 ReportServer and ReportServerTempDB on the new SQL 2017 instance and then installed Power BI server and shut down the SSRS server. Al the r...
errors in log
log
lynamc's avatar
lynamc
New Member
7 years ago

CREATE NONCLUSTERED INDEX [IX_ContentCache] ON [dbo].[ContentCache]
(
[CatalogItemID] ASC,
[ParamsHash] ASC,
[ContentType] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO

CREATE NONCLUSTERED INDEX [IX_ContentCache_ExpirationDate] ON [dbo].[ContentCache]
(
[ExpirationDate] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
GO