By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE OR ALTER FUNCTION dbo.WaitForMS
(
@Milliseconds smallint
)
RETURNS integer
WITH RETURNS NULL ON NULL INPUT
AS
BEGIN
DECLARE
@Start datetime2 =
SYSUTCDATETIME(),
@End datetime2 =
DATEADD
(
MILLISECOND,
@Milliseconds,
SYSUTCDATETIME()
);
DECLARE
@Context varchar(8000),
@ActualDelay integer,
@JSON nvarchar(max) =
N'{}',
@Now nvarchar(max) =
CONVERT
(
nvarchar(max),
SYSUTCDATETIME(),
126
);
SET @JSON =
JSON_MODIFY
(
@JSON,
SELECT
[Actual Delay ms] = dbo.WaitForMS(543),
[Details] = CONVERT(varchar(8000), SESSION_CONTEXT(N'dbo.WaitForMS'));
EXECUTE sys.sp_set_session_context
@key = N'dbo.WaitForMS',
@value = NULL;
| Actual Delay ms | Details |
|---|---|
| 547 | {"start_time":"2025-04-03T04:31:59.6563012","end_time":"2025-04-03T04:32:00.2031834","actual_delay_ms":547} |