Forum Discussion

LeonLai's avatar
LeonLai
Regular Visitor
1 year ago
Solved

WriteCatalogExtendedContentChunkById

My Power BI Report Server is January 2024.

I have monitored the following syntax in SQL Server, which executes every hour and consumes a significant amount of resources, leading to a MemoryHigh condition on my Power BI Report Server.

However, upon checking the database, this stored procedure has always been present.

I am wondering why my Power BI Report Server keeps creating it incessantly.

How can I prevent Power BI Report Server from repeatedly executing this

 

```

CREATE PROCEDURE [dbo].[WriteCatalogExtendedContentChunkById] ID BIGINT
,@Chunk VARBINARY(max)
,@Offset INT
,@Length INT
AS
BEGIN
UPDATE [dbo].[CatalogItemExtendedContent]
SET [Content].WRITE(@Chunk, @Offset, @Length)
WHERE [Id] = ID
END

```

1 Reply