In SQL Server Profiler, I see that for every Umbraco instance on the server, there are frequent sql calls being made all the time, like 20 calls per second on average, with no traffic coming into the site.
My question is: is this normal? Can this be changed / adjusted in some way.
Kind regards, Mikael
Here is an sql profiler trace of 1 second length for one site:
exec sp_reset_connection
go
exec sp_executesql N'SELECT TOP 100 *
FROM [umbracoCacheInstruction]
WHERE (([umbracoCacheInstruction].[id] > @0))
ORDER BY ([umbracoCacheInstruction].[id])',N'@0 int',@0=993
go
SELECT MAX(id) FROM umbracoCacheInstruction;
go
exec sp_executesql N'DELETE FROM umbracoCacheInstruction WHERE utcStamp < @0 AND id < @1',N'@0 datetime,@1 int',@0='2021-12-13 12:57:23.690',@1=993
go
exec sp_reset_connection
go
exec sp_executesql N'SELECT TOP 100 *
FROM [umbracoCacheInstruction]
WHERE (([umbracoCacheInstruction].[id] > @0))
ORDER BY ([umbracoCacheInstruction].[id])',N'@0 int',@0=993
go
exec sp_reset_connection
go
SET LOCK_TIMEOUT 5000;
go
exec sp_executesql N'UPDATE umbracoLock WITH (REPEATABLEREAD) SET value = (CASE WHEN (value=1) THEN -1 ELSE 1 END) WHERE id=@0',N'@0 int',@0=-331
go
SELECT [id] AS [Id], [address] AS [ServerAddress], [computerName] AS [ServerIdentity], [registeredDate] AS [DateRegistered], [lastNotifiedDate] AS [DateAccessed], [isActive] AS [IsActive], [isMaster] AS [IsMaster] FROM [umbracoServer] WHERE id > 0
go
exec sp_executesql N'UPDATE [umbracoServer] SET [address] = @0, [computerName] = @1, [registeredDate] = @2, [lastNotifiedDate] = @3, [isActive] = @4, [isMaster] = @5 WHERE [id] = @6',N'@0 nvarchar(4000),@1 nvarchar(4000),@2 datetime,@3 datetime,@4 int,@5 int,@6 int',@0=N'http://localhost/umbraco',@1=N'MIKAEL-IONOS//LM/W3SVC/2/ROOT',@2='2021-08-20 18:30:31.520',@3='2021-12-15 13:57:31.903',@4=1,@5=1,@6=2
go
exec sp_executesql N'UPDATE [umbracoServer] SET isActive=0, isMaster=0 WHERE lastNotifiedDate < @0',N'@0 datetime',@0='2021-12-15 13:55:31.903'
go
SELECT [id] AS [Id], [address] AS [ServerAddress], [computerName] AS [ServerIdentity], [registeredDate] AS [DateRegistered], [lastNotifiedDate] AS [DateAccessed], [isActive] AS [IsActive], [isMaster] AS [IsMaster] FROM [umbracoServer] WHERE id > 0
go
exec sp_reset_connection
go
exec sp_executesql N'SELECT TOP 100 *
FROM [umbracoCacheInstruction]
WHERE (([umbracoCacheInstruction].[id] > @0))
ORDER BY ([umbracoCacheInstruction].[id])',N'@0 int',@0=993
go
exec sp_reset_connection
go
exec sp_executesql N'SELECT TOP 100 *
FROM [umbracoCacheInstruction]
WHERE (([umbracoCacheInstruction].[id] > @0))
ORDER BY ([umbracoCacheInstruction].[id])',N'@0 int',@0=993
go
exec sp_reset_connection
go
exec sp_executesql N'SELECT TOP 100 *
FROM [umbracoCacheInstruction]
WHERE (([umbracoCacheInstruction].[id] > @0))
ORDER BY ([umbracoCacheInstruction].[id])',N'@0 int',@0=993
go
exec sp_reset_connection
go
exec sp_executesql N'SELECT TOP 100 *
FROM [umbracoCacheInstruction]
WHERE (([umbracoCacheInstruction].[id] > @0))
ORDER BY ([umbracoCacheInstruction].[id])',N'@0 int',@0=993
go
exec sp_reset_connection
go
exec sp_executesql N'SELECT TOP 100 *
FROM [umbracoCacheInstruction]
WHERE (([umbracoCacheInstruction].[id] > @0))
ORDER BY ([umbracoCacheInstruction].[id])',N'@0 int',@0=993
go
exec sp_reset_connection
go
exec sp_executesql N'SELECT TOP 100 *
FROM [umbracoCacheInstruction]
WHERE (([umbracoCacheInstruction].[id] > @0))
ORDER BY ([umbracoCacheInstruction].[id])',N'@0 int',@0=993
go
exec sp_reset_connection
go
exec sp_executesql N'SELECT TOP 100 *
FROM [umbracoCacheInstruction]
WHERE (([umbracoCacheInstruction].[id] > @0))
ORDER BY ([umbracoCacheInstruction].[id])',N'@0 int',@0=993
go
exec sp_reset_connection
go
exec sp_executesql N'SELECT TOP 100 *
FROM [umbracoCacheInstruction]
WHERE (([umbracoCacheInstruction].[id] > @0))
ORDER BY ([umbracoCacheInstruction].[id])',N'@0 int',@0=993
go
exec sp_reset_connection
go
exec sp_executesql N'SELECT TOP 100 *
FROM [umbracoCacheInstruction]
WHERE (([umbracoCacheInstruction].[id] > @0))
ORDER BY ([umbracoCacheInstruction].[id])',N'@0 int',@0=993
go
exec sp_reset_connection
go
exec sp_executesql N'SELECT COUNT(*)
FROM [umbracoContentSchedule]
WHERE ((([umbracoContentSchedule].[action] = @0) AND ([umbracoContentSchedule].[date] <= @1)))',N'@0 nvarchar(4000),@1 datetime',@0=N'Release',@1='2021-12-15 13:58:15.983'
go
exec sp_reset_connection
go
exec sp_executesql N'SELECT COUNT(*)
FROM [umbracoContentSchedule]
WHERE ((([umbracoContentSchedule].[action] = @0) AND ([umbracoContentSchedule].[date] <= @1)))',N'@0 nvarchar(4000),@1 datetime',@0=N'Expire',@1='2021-12-15 13:58:15.983'
go
exec sp_reset_connection
go
exec sp_executesql N'SELECT TOP 100 *
FROM [umbracoCacheInstruction]
WHERE (([umbracoCacheInstruction].[id] > @0))
ORDER BY ([umbracoCacheInstruction].[id])',N'@0 int',@0=993
go
exec sp_reset_connection
go
exec sp_executesql N'SELECT TOP 100 *
FROM [umbracoCacheInstruction]
WHERE (([umbracoCacheInstruction].[id] > @0))
ORDER BY ([umbracoCacheInstruction].[id])',N'@0 int',@0=993
go
SELECT MAX(id) FROM umbracoCacheInstruction;
go
exec sp_executesql N'DELETE FROM umbracoCacheInstruction WHERE utcStamp < @0 AND id < @1',N'@0 datetime,@1 int',@0='2021-12-13 12:58:23.847',@1=993
go
A lot of SQL calls on idle site
In SQL Server Profiler, I see that for every Umbraco instance on the server, there are frequent sql calls being made all the time, like 20 calls per second on average, with no traffic coming into the site.
My question is: is this normal? Can this be changed / adjusted in some way.
Kind regards, Mikael
Here is an sql profiler trace of 1 second length for one site:
Any idea anybody? Just knowing that this is normal would help me :-) although I would actually rather know it's not normal and should be fixed.....
is working on a reply...