Experiencing high load on our sql server box when opening a top level node in backoffice. Anyone seen this before?Sql statement being executed a zillion times a minute resulting in a freeze in backoffice.
exec sp_executesql N'SELECT id, createDate, trashed, parentId, nodeObjectType, nodeUser, level, path, sortOrder, uniqueID, text FROM umbracoNode WHERE id = @id',N'@id int',@id=-1
Can only stop freeze by restarting sql server box, which is... hmm, not really a solution!
Lots of sql selects when opening a top level node after having copied from another top level node
Hi,
Experiencing high load on our sql server box when opening a top level node in backoffice. Anyone seen this before?Sql statement being executed a zillion times a minute resulting in a freeze in backoffice.
exec sp_executesql N'SELECT id, createDate, trashed, parentId, nodeObjectType, nodeUser, level, path, sortOrder, uniqueID, text FROM umbracoNode WHERE id = @id',N'@id int',@id=-1
Can only stop freeze by restarting sql server box, which is... hmm, not really a solution!
Anyone any clue?
Cheers,
Dirk
Found solution myself, seems one of my mntp datatypes was going into infinite loop trying to find a "start document" for the picker.
is working on a reply...