|
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, 50,1× |
Aday |
165.101 |
4.761.746 |
28,8 |
4.771.103 |
28,9 |
51,4 |
28.889 |
0 |
4 |
|
|
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,9× |
Aday |
165.099 |
3.636.469 |
22,0 |
3.641.983 |
22,1 |
159,2 |
21.191 |
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, 247,8× |
Aday |
165.101 |
3.184.228 |
19,3 |
3.190.224 |
19,3 |
366,3 |
21.251 |
0 |
3 |
|
|
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.ChunkI8 plan, 7,0× |
Aday |
73.828 |
2.195.085 |
29,7 |
2.204.245 |
29,9 |
45,7 |
15.319 |
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× |
Aday |
85.682 |
2.162.583 |
25,2 |
2.166.617 |
25,3 |
41,4 |
9.398 |
0 |
5 |
|
|
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 |
86 |
1.888.700 |
21.961,6 |
1.916.595 |
22.286,0 |
119.570,9 |
595.228 |
0 |
1 |
|
|
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 |
|
312 |
1.702.239 |
5.455,9 |
1.704.448 |
5.463,0 |
23.633,0 |
817 |
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 |
|
305 |
1.675.818 |
5.494,5 |
1.679.226 |
5.505,7 |
24.418,5 |
822 |
0 |
1 |
|
|
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,
|
|
88 |
1.376.588 |
15.643,0 |
1.415.322 |
16.083,2 |
47.919,4 |
65.893 |
0 |
1 |
|
|
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-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.752 |
841.471 |
57,0 |
874.985 |
59,3 |
93,8 |
18.352 |
0 |
2 |
|
|
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.523 |
813.257 |
60,1 |
814.436 |
60,2 |
54,4 |
25.680 |
0 |
2 |
|
|
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, 49,4× |
Aday |
172.946 |
691.465 |
4,0 |
692.205 |
4,0 |
5,9 |
566 |
0 |
3 |
|
|
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.Source3 plan, 22,4× |
|
12.261 |
635.443 |
51,8 |
636.256 |
51,9 |
47,2 |
45.719 |
0 |
4 |
|
|
DB-11
SQL-1 |
INSERT INTO perf.Stg_QdsPlanXml (ServerID, DatabaseName, plan_id, PlanXml) EXEC (@RemoteSql, @P1, @P2, @P3) AT [LOOPBACK] |
Aday |
97 |
633.606 |
6.532,0 |
654.370 |
6.746,1 |
38.261,8 |
20.081 |
0 |
1 |
|
|
DB-11
SQL-1 |
(@srv int,@dbName nvarchar(4000),@hash varbinary(8),@from datetime,@to datetime)SELECT (SELECT ServerName FROM DBA.ManagedServers WHERE ServerID = @sr |
|
7.833 |
400.931 |
51,2 |
402.416 |
51,4 |
51,4 |
50.958 |
0 |
1 |
|
|
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_id2 plan, 6,1× |
Aday |
79 |
378.617 |
4.792,6 |
405.047 |
5.127,2 |
25.685,7 |
7.505 |
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.Doc3 plan, 11,2× |
|
12.619 |
357.429 |
28,3 |
358.748 |
28,4 |
37,5 |
13.031 |
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, 114,4× |
Aday |
7.833 |
293.295 |
37,4 |
293.314 |
37,4 |
75,1 |
45.104 |
0 |
2 |
|
|
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 QueryHash8 plan, 6,1× |
|
172.943 |
261.132 |
1,5 |
262.080 |
1,5 |
4,1 |
84 |
0 |
4 |
|
|
DB-1
SQL-1 |
INSERT #__o EXEC sp_executesql @__orig, @__def, @keys = @keys5 plan, 6,1× |
|
186 |
260.985 |
1.403,1 |
261.306 |
1.404,9 |
10.001,4 |
4.686 |
0 |
8 |
|
|
DB-1
SQL-1 |
SELECT COUNT_BIG(*) AS n FROM dbo.FxOrders a CROSS JOIN dbo.FxOrders b CROSS JOIN dbo.FxOrders c |
|
26 |
259.557 |
9.983,0 |
259.873 |
9.995,1 |
10.006,2 |
85 |
0 |
1 |
|
|
DB-12
SQL-1 |
INSERT @r EXEC rag.usp_EmbedQueue_Dequeue @BatchSize = @batchSize, @LeaseSeconds = @leaseSeconds, @MaxAttempts = @maxAttempts |
|
15.449 |
225.699 |
14,6 |
228.426 |
14,8 |
22,7 |
1.025 |
0 |
2 |
|
|
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× |
|
1.004 |
201.304 |
200,5 |
202.415 |
201,6 |
327,7 |
4.816 |
0 |
4 |
|
|
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, |
|
14.668 |
198.305 |
13,5 |
200.899 |
13,7 |
18,4 |
1.003 |
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 |
|
266.036 |
196.922 |
0,7 |
199.151 |
0,7 |
7,7 |
26 |
0 |
1 |
|
|
DB-12
SQL-1 |
INSERT INTO perf.Stg_QdsPlanXml (ServerID, DatabaseName, plan_id, PlanXml) EXEC (@RemoteSql, @P1, @P2, @P3) AT [LOOPBACK] |
|
99 |
192.183 |
1.941,2 |
197.966 |
1.999,7 |
11.965,1 |
14.351 |
0 |
1 |
|
|
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 |
|
177.912 |
132.897 |
0,7 |
133.650 |
0,8 |
7,4 |
25 |
0 |
1 |
|
|
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,1× |
Aday |
84.858 |
116.333 |
1,4 |
116.400 |
1,4 |
1,7 |
59 |
0 |
2 |
|
|
DB-11
SQL-1 |
(@noStatus bit,@statuses2 nvarchar(4000),@statuses1 nvarchar(4000),@Confidence nvarchar(4000),@Direction nvarchar(4000),@Pattern nvarchar(4000),@Serve4 plan, 10,8× |
Aday |
117 |
112.644 |
962,8 |
112.740 |
963,6 |
1.326,4 |
46.080 |
0 |
2 |
|
|
DB-11
SQL-1 |
INSERT @r EXEC rag.usp_EmbedQueue_Dequeue @BatchSize = @batchSize, @LeaseSeconds = @leaseSeconds, @MaxAttempts = @maxAttempts2 plan, 2,6× |
|
9.312 |
98.321 |
10,6 |
99.174 |
10,7 |
61,2 |
867 |
0 |
3 |
|
|
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)) AS4 plan, 146,8× |
|
3.871 |
95.690 |
24,7 |
96.193 |
24,8 |
70,3 |
26.803 |
0 |
4 |
|
|
DB-11
SQL-1 · rag.usp_EmbedQueue_Dequeue |
(@BatchSize int,@LeaseSeconds int)WITH c AS (
SELECT TOP (@BatchSize) *
FROM rag.EmbedQueue WITH (READPAST, UPDLOCK, ROWLOCK)
4 plan, 36,6× |
|
9.343 |
93.492 |
10,0 |
94.319 |
10,1 |
25,5 |
859 |
0 |
4 |
|
|
DB-11
SQL-1 |
(@p nvarchar(4000))SELECT SettingKey, SettingValue, IsSecret FROM DBA.AppSetting WHERE SettingKey LIKE @p ESCAPE '\' |
|
919.004 |
92.215 |
0,1 |
92.443 |
0,1 |
0,2 |
3 |
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 |
|
266.140 |
87.404 |
0,3 |
87.555 |
0,3 |
2,4 |
61 |
0 |
2 |
|
|
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 |
|
23.190 |
81.408 |
3,5 |
81.469 |
3,5 |
3,6 |
107 |
0 |
1 |
|
|
DB-11
SQL-1 |
(@sid int,@db nvarchar(4000))SELECT MAX(LastSeenUtc), MIN(FirstSeenUtc) FROM perf.MetaObject WHERE ServerID = @sid AND DatabaseName = @db |
|
156.120 |
70.874 |
0,5 |
70.919 |
0,5 |
1,5 |
60 |
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 |
|
17.324 |
65.188 |
3,8 |
69.687 |
4,0 |
4,7 |
100 |
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.Databas3 plan, 2427,0× |
|
127 |
64.807 |
510,3 |
64.835 |
510,5 |
1.045,3 |
99.922 |
0 |
3 |
|
|
DB-12
SQL-1 |
(@srv int,@dbName nvarchar(4000),@hash varbinary(8),@from datetime,@to datetime)SELECT (SELECT ServerName FROM DBA.ManagedServers WHERE ServerID = @sr4 plan, 51,7× |
|
3.871 |
63.565 |
16,4 |
67.483 |
17,4 |
51,0 |
18.247 |
0 |
3 |
|
|
DB-12
SQL-1 |
INSERT @r EXEC rag.usp_AnalysisRequest_Dequeue @LeaseSeconds = @leaseSeconds, @MaxAttempts = @maxAttempts |
|
76.808 |
63.409 |
0,8 |
64.314 |
0,8 |
2,5 |
32 |
0 |
1 |
|
|
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 |
|
4 |
56.029 |
14.007,3 |
61.359 |
15.339,7 |
26.785,5 |
9.632 |
0 |
1 |
|
|
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 |
|
132 |
55.995 |
424,2 |
65.797 |
498,5 |
21.862,0 |
305 |
0 |
6 |
|
|
DB-11
SQL-1 · DBA.usp_Rollup_Day |
(@d datetime)INSERT perf.QueryDailyStats (StatDateUtc, ServerID, DatabaseName, query_hash, Source, ObjectName, SampleTextHash,
Executions, |
|
212 |
55.599 |
262,3 |
56.980 |
268,8 |
4.940,8 |
37.684 |
0 |
13 |
|
|
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_2 plan, 23,6× |
|
7.833 |
48.850 |
6,2 |
48.856 |
6,2 |
12,1 |
553 |
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, 17,6× |
|
21.319 |
48.384 |
2,3 |
48.440 |
2,3 |
13,0 |
246 |
0 |
3 |
|
|
DB-12
SQL-1 |
(@sourceType nvarchar(4000),@sourceRef nvarchar(4000),@version int)UPDATE rag.Document SET GeneratorVersion = @version
WHERE SourceType = @sourceType |
|
12.913 |
47.964 |
3,7 |
48.222 |
3,7 |
4,2 |
94 |
0 |
2 |
|
|
DB-11
SQL-1 |
(@incTest bit,@types1 nvarchar(4000),@sid int,@dbName nvarchar(4000),@tag nvarchar(4000),@model nvarchar(4000),@exact nvarchar(4000),@suffixes nvarcha |
|
607 |
47.935 |
79,0 |
50.654 |
83,5 |
409,5 |
8.907 |
0 |
3 |
|
|
DB-12
SQL-1 · DBA.usp_Pull_Qds |
(@ServerID int,@DatabaseName nvarchar(128),@Reset bit,@list nvarchar(max))SELECT @list = STRING_AGG(CAST(s.query_text_id AS nvarchar(max)), N',')
2 plan, 27,7× |
|
312 |
47.132 |
151,1 |
49.582 |
158,9 |
381,4 |
109.685 |
0 |
2 |
|