SaaS CMS has officially launched! Learn more now.

High load on database




I have been monitoring our episerver site and noticed that one query in particular creates high IO and heavy load on the CPU.

The Query in question is:

Select CONVERT(NVARCHAR(40), pkID) AS pkID, Name, CONVERT(INT,Enabled) AS Enabled, LastExec, LastStatus, LastText, NextExec,[DatePart], Interval, MethodName, CONVERT(INT,fStatic) AS fStatic, TypeName, AssemblyName, InstanceData, IsRunning, CurrentStatusMessage, DateDiff(second,LastPing,GetDate()) as SecondsAfterLastPing
FROM tblScheduledItem

We have both a test environment and a production environment, but one should think that the test-environment should be less loaded but in this case it is the test-environment which takes most cpu-time from the database.

It would be great to know how to, atleast, execute this query less often to ease up on the server.

Thank you


Feb 15, 2012 8:42

Is it possible that adjusting the different jobs (the ones you can see in admin mode, under planned jobs) that run automatically in Episerver to not run as often as they do by default would help?





May 02, 2012 13:10
This thread is locked and should be used for reference only. Please use the Episerver CMS 7 and earlier versions forum to open new discussions.
* You are NOT allowed to include any hyperlinks in the post because your account hasn't associated to your company. User profile should be updated.