I installed confluence with MSSQL server as the back end. I am seeing that confluence keeps on accessing the database constantly and relentlessly. Since it is a new database there is nothing to index that will run queries on the database non stop.
Here is one of the queries:
declare @p1 int
set @p1=1
exec sp_prepexec @p1 output,N'@P0 nvarchar(4000),@P1 int',N'select workitem0_.itemId as itemId1_8_, workitem0_.itemType as itemType2_8_, workitem0_.jobId as jobId3_8_, workitem0_.refId as refId4_8_, workitem0_.retryCount as retryCou5_8_, workitem0_.itemStatus as itemStat6_8_ from MIG_WORK_ITEM workitem0_ where workitem0_.itemType=@P0 order by workitem0_.itemId asc offset 0 rows fetch next @P1 rows only ',N'DATA_UPLOAD',2
select @p1
How do I slow it down?
Thanks!
