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

USE [ReportServerTempDB]
GO
/****** Object: Table [dbo].[ContentCache] Script Date: 21/05/2019 12:07:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ContentCache](
[ContentCacheID] [bigint] IDENTITY(1,1) NOT NULL,
[CatalogItemID] [uniqueidentifier] NOT NULL,
[CreatedDate] [datetime] NOT NULL,
[ParamsHash] [int] NULL,
[EffectiveParams] [nvarchar](max) NULL,
[ContentType] [nvarchar](256) NULL,
[ExpirationDate] [datetime] NOT NULL,
[Version] [smallint] NULL,
[Content] [varbinary](max) NULL,
CONSTRAINT [PK_ContentCache] PRIMARY KEY NONCLUSTERED
(
[ContentCacheID] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO


USE [ReportServerTempDB]
GO

/****** Object: Index [IX_ExecutionCacheLastUsed] Script Date: 21/05/2019 12:09:14 ******/
CREATE NONCLUSTERED INDEX [IX_ExecutionCacheLastUsed] ON [dbo].[ExecutionCache]
(
[ReportID] ASC,
[AbsoluteExpiration] ASC,
[LastUsedTime] ASC,
[ExecutionCacheID] 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

 

  • 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