Pahalı sorgular0x620B522768FA237D
Demo modu

Sorgu 0x620B522768FA237D

SQL-1 · DB-11· test_ModelExam.test yasam dongusu sayilari yazar · dönem 2026-09-13 → 2026-10-12 · 90 çalışma · Pahalı sorgulara dön

Ort. süre 0,1 ms
Ort. CPU 0,1 ms
Bekleme payı %0,3
Ort. mantıksal okuma 3
En büyük bellek izni –

Önceki dönemde çalışma yok; değişim hesaplanmadı.

Takip

Yeni

Bu sorgu henüz analiz edilmedi.

Bilinen sorgu, ertele:

Günlük trend

4.10.2026: 6 çalışma, ort. 0,1 ms5.10.2026: 52 çalışma, ort. 0,1 ms6.10.2026: 12 çalışma, ort. 0,1 ms7.10.2026: 12 çalışma, ort. 0,1 ms9.10.2026: 8 çalışma, ort. 0,1 ms max 52 çalışma max ort. süre 0,1 ms 4.10.2026 9.10.2026
Çalışma sayısı (sol ölçek)Ortalama süre (sağ ölçek)

Ne değişti, ne zaman

Dönemden 14 gün öncesinden itibaren: planlar, plan değişimleri, nesne tanımı, analizler, uygulanan öneriler.
  1. 9.10.2026 19:00 yeni plan plan 82915
  2. 9.10.2026 19:00 yeni plan plan 82925
  3. 9.10.2026 17:00 yeni plan plan 81914
  4. 9.10.2026 17:00 yeni plan plan 81915
  5. 9.10.2026 14:00 yeni plan plan 79961
  6. 9.10.2026 14:00 yeni plan plan 79964
  7. 9.10.2026 14:00 yeni plan plan 80875
  8. 9.10.2026 14:00 yeni plan plan 80878
  9. 9.10.2026 13:00 yeni plan plan 79020
  10. 9.10.2026 13:00 yeni plan plan 79035
  11. 8.10.2026 19:00 yeni plan plan 77538
  12. 8.10.2026 19:00 yeni plan plan 77545
  13. 8.10.2026 18:00 yeni plan plan 76619
  14. 8.10.2026 18:00 yeni plan plan 76624
  15. 8.10.2026 17:00 yeni plan plan 75700
  16. 8.10.2026 17:00 yeni plan plan 75703
  17. 8.10.2026 16:00 yeni plan plan 73915
  18. 8.10.2026 16:00 yeni plan plan 73930
  19. 8.10.2026 16:00 yeni plan plan 74780
  20. 8.10.2026 16:00 yeni plan plan 74802
  21. 8.10.2026 14:00 yeni plan plan 72932
  22. 8.10.2026 14:00 yeni plan plan 72943
  23. 8.10.2026 12:00 yeni plan plan 71141
  24. 8.10.2026 12:00 yeni plan plan 71149
  25. 8.10.2026 12:00 yeni plan plan 72017
  26. 8.10.2026 12:00 yeni plan plan 72035
  27. 7.10.2026 20:00 yeni plan plan 66719
  28. 7.10.2026 20:00 yeni plan plan 66722
  29. 7.10.2026 20:00 yeni plan plan 67671
  30. 7.10.2026 20:00 yeni plan plan 67682
  31. 7.10.2026 20:00 yeni plan plan 68406
  32. 7.10.2026 20:00 yeni plan plan 68420
  33. 7.10.2026 20:00 yeni plan plan 69256
  34. 7.10.2026 20:00 yeni plan plan 69276
  35. 7.10.2026 20:00 yeni plan plan 70144
  36. 7.10.2026 20:00 yeni plan plan 70147
  37. 7.10.2026 13:00 yeni plan plan 65696
  38. 7.10.2026 13:00 yeni plan plan 65699
  39. 6.10.2026 00:00 yeni plan plan 64271
  40. 6.10.2026 00:00 yeni plan plan 64293
  41. 5.10.2026 23:00 yeni plan plan 63398
  42. 5.10.2026 23:00 yeni plan plan 63418
  43. 5.10.2026 22:00 yeni plan plan 60899
  44. 5.10.2026 22:00 yeni plan plan 60902
  45. 5.10.2026 22:00 yeni plan plan 61802
  46. 5.10.2026 22:00 yeni plan plan 61809
  47. 5.10.2026 22:00 yeni plan plan 62508
  48. 5.10.2026 22:00 yeni plan plan 62511
  49. 5.10.2026 21:00 yeni plan plan 58382
  50. 5.10.2026 21:00 yeni plan plan 58392
  51. 5.10.2026 21:00 yeni plan plan 59255
  52. 5.10.2026 21:00 yeni plan plan 59260
  53. 5.10.2026 21:00 yeni plan plan 60069
  54. 5.10.2026 21:00 yeni plan plan 60072
  55. 5.10.2026 20:00 yeni plan plan 57487
  56. 5.10.2026 20:00 yeni plan plan 57494
  57. 5.10.2026 18:00 yeni plan plan 56643
  58. 5.10.2026 18:00 yeni plan plan 56654
  59. 5.10.2026 17:00 yeni plan plan 54978
  60. 5.10.2026 17:00 yeni plan plan 54994
  61. 5.10.2026 17:00 yeni plan plan 55803
  62. 5.10.2026 17:00 yeni plan plan 55812
  63. 5.10.2026 13:00 yeni plan plan 53281
  64. 5.10.2026 13:00 yeni plan plan 53284
  65. 5.10.2026 13:00 yeni plan plan 54102
  66. 5.10.2026 13:00 yeni plan plan 54111
  67. 5.10.2026 12:00 yeni plan plan 50228
  68. 5.10.2026 12:00 yeni plan plan 50237
  69. 5.10.2026 12:00 yeni plan plan 50911
  70. 5.10.2026 12:00 yeni plan plan 50928
  71. 5.10.2026 12:00 yeni plan plan 51755
  72. 5.10.2026 12:00 yeni plan plan 51765
  73. 5.10.2026 12:00 yeni plan plan 52446
  74. 5.10.2026 12:00 yeni plan plan 52466
  75. 5.10.2026 10:00 yeni plan plan 47634
  76. 5.10.2026 10:00 yeni plan plan 47655
  77. 5.10.2026 10:00 yeni plan plan 48435
  78. 5.10.2026 10:00 yeni plan plan 48440
  79. 5.10.2026 10:00 yeni plan plan 49328
  80. 5.10.2026 10:00 yeni plan plan 49329
  81. 5.10.2026 09:00 yeni plan plan 43931
  82. 5.10.2026 09:00 yeni plan plan 43933
  83. 5.10.2026 09:00 yeni plan plan 44717
  84. 5.10.2026 09:00 yeni plan plan 44720
  85. 5.10.2026 09:00 yeni plan plan 45985
  86. 5.10.2026 09:00 yeni plan plan 45987
  87. 5.10.2026 09:00 yeni plan plan 46658
  88. 5.10.2026 09:00 yeni plan plan 46676
  89. 5.10.2026 02:00 yeni plan plan 42975
  90. 5.10.2026 02:00 yeni plan plan 42982
  91. 5.10.2026 00:00 yeni plan plan 42167
  92. 5.10.2026 00:00 yeni plan plan 42173
  93. 4.10.2026 22:00 yeni plan plan 41324
  94. 4.10.2026 22:00 yeni plan plan 41344
  95. 4.10.2026 21:00 yeni plan plan 40468
  96. 4.10.2026 21:00 yeni plan plan 40476

Günler

GünÇalışmaOrt. CPU msOrt. süre ms p95 msOrt. reads
2026-10-0460,10,1 0,12
2026-10-05520,10,1 0,13
2026-10-06120,10,1 0,13
2026-10-07120,10,1 0,13
2026-10-0980,10,1 0,13

Planlar

QDS, dönem içinde; ham veri 14 gün saklanır
PlanÇalışmaOrt. süre msOrt. CPU ms Ort. readsSon çalışma
5838210,10,13 5.10.2026 21:02 en iyi
4393310,10,13 5.10.2026 09:01
4765510,10,13 5.10.2026 10:00
7661910,10,13 8.10.2026 18:57
4132410,10,13 4.10.2026 22:07
4763410,10,13 5.10.2026 10:00
7570010,10,13 8.10.2026 17:17
4598510,10,13 5.10.2026 09:48
4472010,10,13 5.10.2026 09:09
6006910,10,13 5.10.2026 21:41
5925510,10,13 5.10.2026 21:38
5839210,10,13 5.10.2026 21:02
8087510,10,13 9.10.2026 14:29
6925610,10,13 7.10.2026 20:51
7203510,10,13 8.10.2026 12:37
6768210,10,13 7.10.2026 20:49
5022810,10,13 5.10.2026 12:32
7014410,10,13 7.10.2026 20:53
5664310,10,13 5.10.2026 18:28
6339810,10,13 5.10.2026 23:04
4667610,10,13 5.10.2026 09:49
5411110,10,13 5.10.2026 13:58
8291510,10,13 9.10.2026 19:26
6767110,10,13 7.10.2026 20:49
7754510,10,13 8.10.2026 19:59
4665810,10,13 5.10.2026 09:49
7662410,10,13 8.10.2026 18:57
5328110,10,13 5.10.2026 13:20
7201710,10,13 8.10.2026 12:37
7114910,10,13 8.10.2026 12:20
7753810,10,13 8.10.2026 19:59
7478010,10,13 8.10.2026 16:38
7294310,10,13 8.10.2026 14:01
7293210,10,13 8.10.2026 14:01
7114110,10,13 8.10.2026 12:20
6090210,10,13 5.10.2026 22:04
5926010,10,13 5.10.2026 21:38
5665410,10,13 5.10.2026 18:28
6089910,10,13 5.10.2026 22:04
5410210,10,13 5.10.2026 13:58
4598710,10,13 5.10.2026 09:48
4047610,10,13 4.10.2026 21:16
7570310,10,13 8.10.2026 17:17
4932910,10,13 5.10.2026 10:42
4932810,10,13 5.10.2026 10:42
5176510,10,13 5.10.2026 12:59
4298210,10,13 5.10.2026 02:59
5244610,10,13 5.10.2026 12:59
6007210,10,13 5.10.2026 21:41
7996110,10,13 9.10.2026 14:28
5497810,10,13 5.10.2026 17:50
7902010,10,13 9.10.2026 13:15
7014710,10,13 7.10.2026 20:53
6842010,10,13 7.10.2026 20:50
8191510,10,13 9.10.2026 17:45
6671910,10,13 7.10.2026 20:12
5091110,10,13 5.10.2026 12:33
4046820,10,13 4.10.2026 21:16
4843510,10,13 5.10.2026 10:03
8292510,10,13 9.10.2026 19:26
4393110,10,13 5.10.2026 09:01
6840610,10,13 7.10.2026 20:50
5581210,10,13 5.10.2026 17:58
7391510,10,13 8.10.2026 16:34
4844010,10,13 5.10.2026 10:03
6429360,10,13 6.10.2026 05:50
7996410,10,13 9.10.2026 14:28
4216710,10,13 5.10.2026 00:28
6341810,10,13 5.10.2026 23:04
5092810,10,13 5.10.2026 12:33
6569610,10,13 7.10.2026 13:55
6672210,10,13 7.10.2026 20:12
5023710,10,13 5.10.2026 12:32
6927610,10,13 7.10.2026 20:51
5580310,10,13 5.10.2026 17:58
4134410,10,13 4.10.2026 22:07
6427160,10,13 6.10.2026 05:50
6180910,10,13 5.10.2026 22:56
5328410,10,13 5.10.2026 13:20
4471710,10,13 5.10.2026 09:09
6180210,10,13 5.10.2026 22:56
6251110,10,13 5.10.2026 22:57
4297510,10,13 5.10.2026 02:59
5499410,10,13 5.10.2026 17:50
7480210,10,13 8.10.2026 16:38
8191410,10,13 9.10.2026 17:45
5246610,10,13 5.10.2026 12:59
6250810,10,13 5.10.2026 22:57
5175510,10,13 5.10.2026 12:59
7903510,10,13 9.10.2026 13:15
7393010,10,13 8.10.2026 16:34
5749410,10,13 5.10.2026 20:19
6569910,10,13 7.10.2026 13:55
5748710,10,13 5.10.2026 20:19
8087810,10,13 9.10.2026 14:29
4217310,10,13 5.10.2026 00:28 en kötü

Davranış

Wait kategorileri (QDS)
–
Session'da görülen wait'ler
–
Başka oturumları bloklama
0
En büyük memory grant
–

Saat dağılımı

session yakalama
00:00 — 00001:00 — 002:00 — 003:00 — 00304:00 — 005:00 — 006:00 — 00607:00 — 008:00 — 009:00 — 00910:00 — 011:00 — 012:00 — 01213:00 — 014:00 — 015:00 — 01516:00 — 017:00 — 018:00 — 01819:00 — 020:00 — 021:00 — 02122:00 — 023:00 — 0

Sorgu metni

SQL
(@id bigint)UPDATE rag.ModelExamRun SET Status = 'Done' WHERE RunID = @id

Bu sorgunun analizleri

Kayıt yok

Henüz analiz yok.