test_RagQueue.test suresi dolmamis lease alinmaz

procedure

DB-11 · modified 10/11/2026 · Back to object search

Statements

1 statement · 164 executions · 0.0 s total

Query (query_hash)	Executions	Avg duration (ms)	Avg CPU (ms)	Avg reads	Share of duration
0x889AF3AB4CE239EF	164	0.1	0.1	0	100%

Dependencies

Direct references (sys.sql_expression_dependencies); dynamic SQL and deferred names may be missing.

same databaseother databaselinked server

Direction	Object	Type	Scope
uses	DBA.fn_Now	function	same database
uses	rag.AnalysisRequest	table	same database
uses	rag.usp_AnalysisRequest_Dequeue	procedure	same database
uses	tSQLt.AssertEquals	procedure	same database

Definition

CREATE   PROCEDURE test_RagQueue.[test suresi dolmamis lease alinmaz]
AS
BEGIN
    INSERT rag.AnalysisRequest (TargetType, RequestedBy, Status, LeaseUntilUtc, Attempt, CreatedUtc)
    VALUES ('Manual', N'test', 'Running', DATEADD(minute, 5, DBA.fn_Now()), 1, DBA.fn_Now());
    CREATE TABLE #got (RequestID bigint, TargetType varchar(10), ServerID int, DatabaseName sysname NULL, QueryHash binary(8) NULL,
                       ObjectName nvarchar(256) NULL, ManualSql nvarchar(max) NULL, ManualPlanXml nvarchar(max) NULL, RequestedBy nvarchar(128), Attempt int);
    INSERT #got EXEC rag.usp_AnalysisRequest_Dequeue @LeaseSeconds = 600, @MaxAttempts = 3;
    DECLARE @n int = (SELECT COUNT(*) FROM #got);
    EXEC tSQLt.AssertEquals 0, @n;
END;

Analyses of this object

Nothing here

No analyses for this object.