Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Mikael Axel Kleinwort 140 posts 484 karma points c-trib
    Dec 15, 2021 @ 13:12
    Mikael Axel Kleinwort
    0

    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:

    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
    
  • Mikael Axel Kleinwort 140 posts 484 karma points c-trib
    Dec 16, 2021 @ 07:54
    Mikael Axel Kleinwort
    0

    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.....

Please Sign in or register to post replies

Write your reply to:

Draft