|
DB-11
SQL-1 |
(@Arg1 bigint,@Arg2 bigint)SELECT 1, N'DB-11', p.plan_id, p.query_id, p.query_plan_hash, p.is_forced_plan, p.compatibility_level,
|
Karar bekliyor |
190 |
5.635.781 |
29.662,0 |
5.826.589 |
30.666,3 |
190.427,2 |
469.070 |
0 |
2 |
|
|
DB-11
SQL-1 |
(@incTest bit,@types1 nvarchar(4000),@sid int,@dbName nvarchar(4000),@tag nvarchar(4000),@model nvarchar(4000),@exact1 nvarchar(4000),@suffixes nvarch |
Aday |
93.673 |
5.186.683 |
55,4 |
5.414.289 |
57,8 |
177,4 |
15.355 |
0 |
3 |
|
|
DB-11
SQL-1 |
(@srv int,@dbName nvarchar(4000),@hash varbinary(8),@from datetime,@to datetime)SELECT (SELECT ServerName FROM DBA.ManagedServers WHERE ServerID = @sr10 plan, 49,4× |
Aday |
164.948 |
4.760.598 |
28,9 |
4.769.952 |
28,9 |
51,8 |
28.916 |
0 |
4 |
|
|
DB-12
SQL-1 |
INSERT INTO perf.Stg_QdsPlan (ServerID, DatabaseName, plan_id, query_id, query_plan_hash, is_forced_plan, compatibility_level, LastCompileUtc, LastExe |
Aday |
673 |
4.529.029 |
6.729,6 |
4.533.983 |
6.737,0 |
30.942,1 |
900 |
0 |
1 |
|
|
DB-11
SQL-1 |
INSERT INTO perf.Stg_QdsPlan (ServerID, DatabaseName, plan_id, query_id, query_plan_hash, is_forced_plan, compatibility_level, LastCompileUtc, LastExe |
Aday |
671 |
4.288.403 |
6.391,1 |
4.296.826 |
6.403,6 |
25.376,7 |
930 |
0 |
1 |
|
|
DB-11
SQL-1 |
(@srv int,@dbName nvarchar(4000),@hash varbinary(8),@from datetime,@to datetime)SELECT q.ObjectName, SUM(r.count_executions) AS Executions, SUM(r.avg_10 plan, 175,3× |
Aday |
164.946 |
3.619.308 |
21,9 |
3.624.803 |
22,0 |
155,8 |
21.105 |
0 |
4 |
|
|
DB-11
SQL-1 |
(@srv int,@dbName nvarchar(4000),@hash varbinary(8),@from datetime,@to datetime)SELECT p.plan_id AS PlanId, CAST(MAX(CAST(p.is_forced_plan AS int)) AS6 plan, 253,4× |
Aday |
164.948 |
3.169.380 |
19,2 |
3.175.367 |
19,3 |
366,3 |
21.164 |
0 |
3 |
|
|
DB-12
SQL-1 |
(@Arg1 bigint,@Arg2 bigint)SELECT 1, N'DB-12', p.plan_id, p.query_id, p.query_plan_hash, p.is_forced_plan, p.compatibility_level,
|
|
192 |
2.849.289 |
14.840,0 |
2.968.003 |
15.458,3 |
50.747,9 |
60.484 |
0 |
1 |
|
|
DB-11
SQL-1 |
(@condition nvarchar(4000),@incTest bit,@types1 nvarchar(4000),@sid int,@dbName nvarchar(4000),@tag nvarchar(4000),@top int)SELECT TOP (@top) c.ChunkI7 plan, 5,0× |
|
73.711 |
2.192.889 |
29,7 |
2.202.035 |
29,9 |
45,7 |
15.339 |
0 |
6 |
|
|
DB-11
SQL-1 |
(@incTest bit,@types1 nvarchar(4000),@sid int,@dbName nvarchar(4000),@tag nvarchar(4000),@model nvarchar(4000),@q vector(1024),@top int)SELECT TOP (@t7 plan, 4,3× |
|
85.682 |
2.162.583 |
25,2 |
2.166.617 |
25,3 |
41,4 |
9.398 |
0 |
5 |
|
|
DB-11
SQL-1 |
(@srv int,@dbName nvarchar(4000),@hash varbinary(8),@from datetime,@to datetime)SELECT (SELECT ServerName FROM DBA.ManagedServers WHERE ServerID = @sr2 plan, 86,6× |
|
45.193 |
1.684.047 |
37,3 |
1.687.488 |
37,3 |
51,4 |
37.138 |
0 |
3 |
|
|
DB-11
SQL-1 |
(@model nvarchar(4000),@own nvarchar(4000),@v vector(1024),@top int)SELECT TOP (@top) d.SourceRef, MIN(VECTOR_DISTANCE('cosine', c.Embedding, @v)) AS |
|
29.901 |
861.372 |
28,8 |
861.669 |
28,8 |
30,2 |
6.162 |
0 |
1 |
|
|
DB-1
SQL-1 |
INSERT #__o EXEC sp_executesql @__orig, @__def, @keys = @keys5 plan, 5,3× |
|
434 |
843.062 |
1.942,5 |
843.895 |
1.944,5 |
10.001,6 |
8.293 |
0 |
22 |
|
|
DB-11
SQL-1 |
(@incTest bit,@types1 nvarchar(4000),@sid int,@dbName nvarchar(4000),@tag nvarchar(4000),@model nvarchar(4000),@exact1 nvarchar(4000),@suffixes nvarch |
|
14.744 |
841.023 |
57,0 |
874.532 |
59,3 |
95,7 |
18.351 |
0 |
2 |
|
|
DB-1
SQL-1 |
SELECT COUNT_BIG(*) AS n FROM dbo.FxOrders a CROSS JOIN dbo.FxOrders b CROSS JOIN dbo.FxOrders c |
|
63 |
837.399 |
13.292,1 |
838.223 |
13.305,1 |
66.079,5 |
93 |
0 |
1 |
|
|
DB-11
SQL-1 |
(@incTest bit,@types1 nvarchar(4000),@sid int,@dbName nvarchar(4000),@tag nvarchar(4000),@model nvarchar(4000),@q vector(1024),@top int)WITH x AS (
2 plan, 2,8× |
|
13.406 |
810.635 |
60,5 |
811.781 |
60,6 |
54,4 |
25.836 |
0 |
2 |
|
|
DB-11
SQL-1 |
INSERT INTO perf.Stg_QdsPlanXml (ServerID, DatabaseName, plan_id, PlanXml) EXEC (@RemoteSql, @P1, @P2, @P3) AT [LOOPBACK] |
Aday |
243 |
805.356 |
3.314,2 |
841.835 |
3.464,3 |
38.261,8 |
13.724 |
0 |
1 |
|
|
DB-11
SQL-1 |
(@condition nvarchar(4000),@incTest bit,@types1 nvarchar(4000),@sid int,@dbName nvarchar(4000),@top int)SELECT TOP (@top) c.ChunkId, c.DocId, d.Source5 plan, 2,3× |
Aday |
15.479 |
740.203 |
47,8 |
742.290 |
48,0 |
74,8 |
41.409 |
0 |
4 |
|
|
DB-11
SQL-1 |
(@srv int,@dbName nvarchar(4000),@hash varbinary(8),@from datetime,@to datetime)SELECT StatDateUtc AS DayUtc, Executions, TotalCpuMs, TotalDurationMs,5 plan, 48,3× |
Aday |
211.706 |
696.532 |
3,3 |
697.280 |
3,3 |
5,9 |
466 |
0 |
4 |
|
|
DB-11
SQL-1 |
(@keys nvarchar(4000),@from datetime,@to datetime,@minExec bigint)SELECT k.ServerId, k.DatabaseName, k.Hash, COUNT(*) AS Plans, MAX(x.AvgDuration) / N4 plan, 27,5× |
Aday |
1.217 |
686.141 |
563,8 |
693.646 |
570,0 |
1.411,0 |
319.977 |
0 |
5 |
|
|
DB-11
SQL-1 |
WITH XMLNAMESPACES (DEFAULT 'http://schemas.microsoft.com/sqlserver/2004/07/showplan'),
pl AS (SELECT p.ServerID, p.DatabaseName, p.plan_id, CAST(DECO |
|
1 |
608.885 |
608.884,6 |
609.665 |
609.664,8 |
609.664,8 |
102.655.727 |
0 |
1 |
|
|
DB-12
SQL-1 |
INSERT @r EXEC rag.usp_EmbedQueue_Dequeue @BatchSize = @batchSize, @LeaseSeconds = @leaseSeconds, @MaxAttempts = @maxAttempts |
|
33.436 |
553.845 |
16,6 |
558.537 |
16,7 |
25,5 |
886 |
0 |
2 |
|
|
DB-11
SQL-1 |
(@keys nvarchar(4000),@from datetime,@to datetime)SELECT q.ServerID, q.DatabaseName, q.query_hash, q.StatDateUtc, SUM(q.TotalDurationMs) / NULLIF(SUM(3 plan, 1716,3× |
Aday |
777 |
485.742 |
625,2 |
495.342 |
637,5 |
2.435,1 |
821 |
0 |
4 |
|
|
DB-11
SQL-1 |
SELECT 1, N'DB-11', p.plan_id, p.query_plan FROM sys.query_store_plan AS p JOIN @ids AS x ON x.id = p.plan_id3 plan, 13,0× |
Aday |
171 |
438.883 |
2.566,6 |
496.016 |
2.900,7 |
25.685,7 |
6.482 |
0 |
3 |
|
|
DB-11
SQL-1 |
(@srv int,@dbName nvarchar(4000),@hash varbinary(8),@from datetime,@to datetime)SELECT p.plan_id AS PlanId, CAST(MAX(CAST(p.is_forced_plan AS int)) AS2 plan, 122,1× |
|
45.216 |
433.546 |
9,6 |
433.611 |
9,6 |
75,1 |
11.205 |
0 |
3 |
|
|
DB-11
SQL-1 |
(@incTest bit,@types1 nvarchar(4000),@sid int,@dbName nvarchar(4000),@model nvarchar(4000),@q vector(1024),@top int)SELECT TOP (@top) c.ChunkId, c.Doc5 plan, 11,1× |
|
15.666 |
431.977 |
27,6 |
433.494 |
27,7 |
37,5 |
12.737 |
0 |
4 |
|
|
DB-12
SQL-1 |
INSERT INTO perf.Stg_QdsPlanXml (ServerID, DatabaseName, plan_id, PlanXml) EXEC (@RemoteSql, @P1, @P2, @P3) AT [LOOPBACK] |
|
246 |
340.819 |
1.385,4 |
352.246 |
1.431,9 |
11.965,5 |
10.166 |
0 |
1 |
|
|
DB-11
SQL-1 |
(@srv int,@dbName nvarchar(4000),@track binary(8),@to datetime,@hash varbinary(8))SELECT @srv AS ServerID, @dbName AS DatabaseName, @hash AS QueryHash10 plan, 6,1× |
|
210.456 |
305.329 |
1,5 |
306.480 |
1,5 |
4,1 |
79 |
0 |
5 |
|
|
DB-12
SQL-1 · rag.usp_EmbedQueue_Dequeue |
(@MaxAttempts int,@BatchSize int,@LeaseSeconds int)WITH c AS (
SELECT TOP (@BatchSize) *
FROM rag.EmbedQueue WITH (READPAST, UPDLOCK, |
|
19.225 |
256.841 |
13,4 |
260.210 |
13,5 |
18,4 |
983 |
0 |
1 |
|
|
DB-11
SQL-1 |
(@WorstPlanId bigint,@ServerID int,@DatabaseName nvarchar(4000))SELECT CAST(DECOMPRESS(x.PlanXmlCompressed) AS nvarchar(max))
FROM perf.QdsPlan AS p |
|
319.881 |
229.982 |
0,7 |
232.363 |
0,7 |
7,7 |
25 |
0 |
1 |
|
|
DB-12
SQL-1 · rag.usp_EmbedQueue_Dequeue |
(@MaxAttempts int,@BatchSize int,@LeaseSeconds int)WITH c AS (
SELECT TOP (@BatchSize) *
FROM rag.EmbedQueue WITH (READPAST, UPDLOCK, |
|
11.355 |
217.946 |
19,2 |
218.869 |
19,3 |
24,9 |
701 |
0 |
1 |
|
|
DB-11
SQL-1 · rag.usp_ReviewQueue |
(@from datetime,@NowUtc datetime,@Top int)WITH items AS (
SELECT 'Analysis' AS Kind, a.RequestID AS RefId, a.TargetType, a.ServerID, a.Databas5 plan, 2463,2× |
Aday |
389 |
216.346 |
556,2 |
216.734 |
557,2 |
1.045,3 |
83.563 |
0 |
3 |
|
|
DB-11
SQL-1 · rag.usp_ObjectSearch |
(@name nvarchar(128),@schema nvarchar(128),@like nvarchar(520),@FromUtc datetime,@ToUtc datetime,@Top int)WITH o AS (
SELECT mo.ServerID, ms.S4 plan, 715,3× |
Aday |
537 |
187.768 |
349,7 |
188.199 |
350,5 |
1.179,3 |
77.892 |
0 |
3 |
|
|
DB-11
SQL-1 |
(@keys nvarchar(4000),@from datetime,@to datetime,@minExec bigint)SELECT k.ServerId, k.DatabaseName, k.Hash, COUNT(*) AS Plans, MAX(x.AvgDuration) / N12 plan, 340,7× |
|
935 |
185.510 |
198,4 |
186.620 |
199,6 |
336,7 |
4.690 |
0 |
4 |
|
|
DB-1
SQL-1 |
INSERT #__n EXEC sp_executesql @__new, @__def, @keys = @keys4 plan, 2,3× |
|
369 |
180.728 |
489,8 |
180.909 |
490,3 |
360,7 |
9.676 |
0 |
22 |
|
|
DB-1
SQL-1 |
SELECT COUNT_BIG(*) AS n FROM dbo.FxOrders a CROSS JOIN dbo.FxOrders b CROSS JOIN dbo.FxOrders c OPTION (MAXDOP 1) |
|
3 |
175.263 |
58.421,0 |
175.432 |
58.477,3 |
62.115,1 |
216 |
0 |
1 |
|
|
DB-11
SQL-1 |
INSERT @r EXEC rag.usp_EmbedQueue_Dequeue @BatchSize = @batchSize, @LeaseSeconds = @leaseSeconds, @MaxAttempts = @maxAttempts3 plan, 2,6× |
|
13.462 |
163.664 |
12,2 |
164.846 |
12,2 |
61,2 |
853 |
0 |
3 |
|
|
DB-11
SQL-1 |
(@srv int,@dbName nvarchar(4000),@planId bigint)SELECT CAST(DECOMPRESS(x.PlanXmlCompressed) AS nvarchar(max))
FROM perf.QdsPlan AS p JOIN perf.QdsPlan |
|
219.878 |
158.191 |
0,7 |
159.070 |
0,7 |
7,4 |
24 |
0 |
2 |
|
|
DB-11
SQL-1 · tSQLt.Private_CreateFakeOfTable |
(@OrigTableObjectId int,@SchemaName nvarchar(max),@TableName nvarchar(max),@Identity bit,@ComputedColumns bit,@Defaults bit,@cmd nvarchar(max))DECLARE3 plan, 18,7× |
|
57.534 |
140.727 |
2,4 |
140.805 |
2,4 |
28,7 |
250 |
0 |
3 |
|
|
DB-12
SQL-1 |
INSERT @r EXEC rag.usp_AnalysisRequest_Dequeue @LeaseSeconds = @leaseSeconds, @MaxAttempts = @maxAttempts |
|
165.004 |
122.802 |
0,7 |
123.902 |
0,8 |
2,5 |
33 |
0 |
2 |
|
|
DB-12
SQL-1 · rag.usp_PlanChange_Detect |
(@from datetime,@asOf datetime)WITH iv AS (
SELECT pr.ServerID, pr.DatabaseName, pr.query_id, pr.OldPlanId, pr.NewPlanId, rs.IntervalStar |
Aday |
25 |
121.020 |
4.840,8 |
126.363 |
5.054,5 |
26.785,5 |
6.306 |
0 |
2 |
|
|
DB-11
SQL-1 · rag.usp_PlanChange_Detect |
(@from datetime,@asOf datetime)WITH iv AS (
SELECT pr.ServerID, pr.DatabaseName, pr.query_id, pr.OldPlanId, pr.NewPlanId, rs.IntervalStar |
Aday |
401 |
120.520 |
300,5 |
130.363 |
325,1 |
21.862,0 |
405 |
0 |
25 |
|
|
DB-11
SQL-1 |
(@sourceType nvarchar(4000),@sourceRef nvarchar(4000),@model nvarchar(4000))SELECT d.DocId, d.SourceType, d.SourceRef, d.Title, d.ServerID AS ServerId |
|
34.681 |
119.826 |
3,5 |
119.893 |
3,5 |
3,6 |
104 |
0 |
2 |
|
|
DB-11
SQL-1 |
(@noStatus bit,@statuses2 nvarchar(4000),@statuses1 nvarchar(4000),@Confidence nvarchar(4000),@Direction nvarchar(4000),@Pattern nvarchar(4000),@Serve6 plan, 13,9× |
|
233 |
119.164 |
511,4 |
119.281 |
511,9 |
1.306,8 |
33.947 |
0 |
2 |
|
|
DB-11
SQL-1 |
(@sid int,@db nvarchar(4000),@names1 nvarchar(4000))SELECT object_id AS ObjectId, SchemaName, ObjectName, RTRIM(ObjectType) AS ObjectType
FROM perf.M2 plan, 4,8× |
Aday |
94.420 |
118.738 |
1,3 |
118.807 |
1,3 |
1,7 |
58 |
0 |
2 |
|
|
DB-11
SQL-1 |
(@p nvarchar(4000))SELECT SettingKey, SettingValue, IsSecret FROM DBA.AppSetting WHERE SettingKey LIKE @p ESCAPE '\' |
|
1.134.345 |
113.452 |
0,1 |
113.736 |
0,1 |
0,2 |
3 |
0 |
1 |
|
|
DB-12
SQL-1 |
(@sourceType nvarchar(4000),@sourceRef nvarchar(4000),@model nvarchar(4000))SELECT d.DocId, d.SourceType, d.SourceRef, d.Title, d.ServerID AS ServerId |
|
32.680 |
106.738 |
3,3 |
111.284 |
3,4 |
4,7 |
94 |
0 |
1 |
|
|
DB-11
SQL-1 |
(@ServerID int,@DatabaseName nvarchar(4000),@QueryHash varbinary(8),@first datetime,@last datetime)SELECT (SELECT ServerName FROM DBA.ManagedServers W |
|
307.896 |
99.349 |
0,3 |
99.509 |
0,3 |
2,5 |
61 |
0 |
2 |
|
|
DB-12
SQL-1 |
(@srv int,@dbName nvarchar(4000),@hash varbinary(8),@from datetime,@to datetime)SELECT p.plan_id AS PlanId, CAST(MAX(CAST(p.is_forced_plan AS int)) AS3 plan, 150,9× |
|
3.865 |
95.686 |
24,8 |
96.183 |
24,9 |
76,0 |
26.845 |
0 |
4 |
|
|
DB-10
SQL-1 |
SELECT 1, N'DB-10', i.object_id, i.index_id, ds.name, pf.name,
(SELECT c.name FROM sys.index_columns AS ic JOIN sys.columns AS c ON |
Karar bekliyor |
63 |
95.600 |
1.517,5 |
101.014 |
1.603,4 |
3.157,8 |
139.421 |
0 |
1 |
|