Pahalı sorgular0xA83E44DF4258304F
Demo modu

Sorgu 0xA83E44DF4258304F

SQL-1 · DB-11· test_LocalUsers.test basarili giris sayaci sifirlar ve son giris yazar · dönem 2026-09-13 → 2026-10-12 · 115 ç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

29.09.2026: 8 çalışma, ort. 0,1 ms30.09.2026: 43 çalışma, ort. 0,1 ms1.10.2026: 6 çalışma, ort. 0,1 ms2.10.2026: 11 çalışma, ort. 0,1 ms4.10.2026: 5 çalışma, ort. 0,2 ms5.10.2026: 26 çalışma, ort. 0,1 ms6.10.2026: 6 çalışma, ort. 0,1 ms7.10.2026: 6 çalışma, ort. 0,1 ms9.10.2026: 4 çalışma, ort. 0,1 ms max 43 çalışma max ort. süre 0,2 ms 29.09.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 82653
  2. 9.10.2026 17:00 yeni plan plan 81651
  3. 9.10.2026 14:00 yeni plan plan 79704
  4. 9.10.2026 14:00 yeni plan plan 80600
  5. 9.10.2026 13:00 yeni plan plan 78770
  6. 8.10.2026 19:00 yeni plan plan 77273
  7. 8.10.2026 18:00 yeni plan plan 76367
  8. 8.10.2026 17:00 yeni plan plan 75444
  9. 8.10.2026 16:00 yeni plan plan 73658
  10. 8.10.2026 16:00 yeni plan plan 74530
  11. 8.10.2026 14:00 yeni plan plan 72692
  12. 8.10.2026 12:00 yeni plan plan 70880
  13. 8.10.2026 12:00 yeni plan plan 71771
  14. 7.10.2026 20:00 yeni plan plan 66468
  15. 7.10.2026 20:00 yeni plan plan 67407
  16. 7.10.2026 20:00 yeni plan plan 68175
  17. 7.10.2026 20:00 yeni plan plan 69017
  18. 7.10.2026 20:00 yeni plan plan 69881
  19. 7.10.2026 13:00 yeni plan plan 65435
  20. 6.10.2026 00:00 yeni plan plan 64041
  21. 5.10.2026 23:00 yeni plan plan 63162
  22. 5.10.2026 22:00 yeni plan plan 60667
  23. 5.10.2026 22:00 yeni plan plan 61550
  24. 5.10.2026 22:00 yeni plan plan 62276
  25. 5.10.2026 21:00 yeni plan plan 58141
  26. 5.10.2026 21:00 yeni plan plan 58998
  27. 5.10.2026 21:00 yeni plan plan 59825
  28. 5.10.2026 20:00 yeni plan plan 57248
  29. 5.10.2026 18:00 yeni plan plan 56403
  30. 5.10.2026 17:00 yeni plan plan 54738
  31. 5.10.2026 17:00 yeni plan plan 55555
  32. 5.10.2026 13:00 yeni plan plan 53034
  33. 5.10.2026 13:00 yeni plan plan 53859
  34. 5.10.2026 12:00 yeni plan plan 49970
  35. 5.10.2026 12:00 yeni plan plan 50689
  36. 5.10.2026 12:00 yeni plan plan 51504
  37. 5.10.2026 12:00 yeni plan plan 52226
  38. 5.10.2026 10:00 yeni plan plan 47387
  39. 5.10.2026 10:00 yeni plan plan 48203
  40. 5.10.2026 10:00 yeni plan plan 49074
  41. 5.10.2026 09:00 yeni plan plan 43670
  42. 5.10.2026 09:00 yeni plan plan 44472
  43. 5.10.2026 09:00 yeni plan plan 45715
  44. 5.10.2026 09:00 yeni plan plan 46444
  45. 5.10.2026 02:00 yeni plan plan 42731
  46. 5.10.2026 00:00 yeni plan plan 41921
  47. 4.10.2026 22:00 yeni plan plan 41083
  48. 4.10.2026 13:00 yeni plan plan 38581
  49. 4.10.2026 13:00 yeni plan plan 39362
  50. 4.10.2026 13:00 yeni plan plan 40097
  51. 4.10.2026 08:00 yeni plan plan 37541
  52. 2.10.2026 17:00 yeni plan plan 35156
  53. 2.10.2026 17:00 yeni plan plan 35897
  54. 2.10.2026 17:00 yeni plan plan 36626
  55. 2.10.2026 16:00 yeni plan plan 34187
  56. 2.10.2026 02:00 yeni plan plan 33769
  57. 2.10.2026 01:00 yeni plan plan 33065
  58. 2.10.2026 00:00 yeni plan plan 31862
  59. 2.10.2026 00:00 yeni plan plan 32425
  60. 1.10.2026 21:00 yeni plan plan 31186
  61. 1.10.2026 20:00 yeni plan plan 29727
  62. 1.10.2026 20:00 yeni plan plan 30373
  63. 1.10.2026 19:00 yeni plan plan 27650
  64. 1.10.2026 19:00 yeni plan plan 28316
  65. 1.10.2026 19:00 yeni plan plan 28986
  66. 30.09.2026 22:00 yeni plan plan 23181
  67. 30.09.2026 22:00 yeni plan plan 23840
  68. 30.09.2026 22:00 yeni plan plan 24344
  69. 30.09.2026 22:00 yeni plan plan 24986
  70. 30.09.2026 22:00 yeni plan plan 25603
  71. 30.09.2026 22:00 yeni plan plan 26290
  72. 30.09.2026 22:00 yeni plan plan 26937
  73. 30.09.2026 21:00 yeni plan plan 20543
  74. 30.09.2026 21:00 yeni plan plan 21218
  75. 30.09.2026 21:00 yeni plan plan 21859
  76. 30.09.2026 21:00 yeni plan plan 22513
  77. 30.09.2026 20:00 yeni plan plan 19844
  78. 30.09.2026 19:00 yeni plan plan 19139
  79. 30.09.2026 15:00 yeni plan plan 17185
  80. 30.09.2026 15:00 yeni plan plan 17825
  81. 30.09.2026 15:00 yeni plan plan 18460
  82. 30.09.2026 11:00 yeni plan plan 14693
  83. 30.09.2026 11:00 yeni plan plan 15320
  84. 30.09.2026 11:00 yeni plan plan 15990
  85. 30.09.2026 11:00 yeni plan plan 16532
  86. 30.09.2026 10:00 yeni plan plan 12970
  87. 30.09.2026 10:00 yeni plan plan 13501
  88. 30.09.2026 10:00 yeni plan plan 14066
  89. 30.09.2026 07:00 yeni plan plan 12390
  90. 30.09.2026 06:00 yeni plan plan 10751
  91. 30.09.2026 06:00 yeni plan plan 11295
  92. 30.09.2026 06:00 yeni plan plan 11784
  93. 30.09.2026 05:00 yeni plan plan 10168
  94. 30.09.2026 00:00 yeni plan plan 9129
  95. 29.09.2026 21:00 yeni plan plan 8240
  96. 29.09.2026 21:00 yeni plan plan 8670
  97. 29.09.2026 20:00 yeni plan plan 7779
  98. 29.09.2026 18:00 yeni plan plan 7260

Günler

GünÇalışmaOrt. CPU msOrt. süre ms p95 msOrt. reads
2026-09-2980,10,1 0,13
2026-09-30430,10,1 0,13
2026-10-0160,10,1 0,13
2026-10-02110,10,1 0,13
2026-10-0450,20,2 0,43
2026-10-05260,10,1 0,13
2026-10-0660,10,1 0,13
2026-10-0760,10,1 0,13
2026-10-0940,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
1016810,10,13 30.09.2026 05:50 en iyi
4009710,10,13 4.10.2026 13:45
6316210,10,13 5.10.2026 23:04
1469310,10,13 30.09.2026 11:02
5303410,10,13 5.10.2026 13:20
1297010,10,13 30.09.2026 10:51
2318110,10,13 30.09.2026 22:15
777910,10,13 29.09.2026 20:13
6646810,10,13 7.10.2026 20:12
2765010,10,13 1.10.2026 19:13
3376910,10,13 2.10.2026 02:27
824010,10,13 29.09.2026 21:26
1129510,10,13 30.09.2026 06:58
1406610,10,13 30.09.2026 10:56
6817510,10,13 7.10.2026 20:50
6901710,10,13 7.10.2026 20:51
1846010,10,13 30.09.2026 15:51
1178420,10,13 30.09.2026 06:59
5222610,10,13 5.10.2026 12:59
2434420,10,13 30.09.2026 22:38
5068910,10,13 5.10.2026 12:33
867010,10,13 29.09.2026 21:50
2972710,10,13 1.10.2026 20:57
1532020,10,13 30.09.2026 11:15
5385910,10,13 5.10.2026 13:58
4571510,10,13 5.10.2026 09:48
2498610,10,13 30.09.2026 22:38
7365810,10,13 8.10.2026 16:34
1913910,10,13 30.09.2026 19:36
7544410,10,13 8.10.2026 17:17
5473810,10,13 5.10.2026 17:49
5814110,10,13 5.10.2026 21:02
5899810,10,13 5.10.2026 21:38
7453010,10,13 8.10.2026 16:38
1718510,10,13 30.09.2026 15:32
1239010,10,13 30.09.2026 07:00
5640310,10,13 5.10.2026 18:28
6155010,10,13 5.10.2026 22:56
3589710,10,13 2.10.2026 17:32
4644410,10,13 5.10.2026 09:49
2693710,10,13 30.09.2026 22:56
1075110,10,13 30.09.2026 06:32
4108310,10,13 4.10.2026 22:07
6543510,10,13 7.10.2026 13:55
3515610,10,13 2.10.2026 17:24
5150410,10,13 5.10.2026 12:58
7088010,10,13 8.10.2026 12:20
7177110,10,13 8.10.2026 12:37
2054310,10,13 30.09.2026 21:24
7877010,10,13 9.10.2026 13:15
4367010,10,13 5.10.2026 09:01
3418720,10,13 2.10.2026 16:25
3242510,10,13 2.10.2026 00:06
6988110,10,13 7.10.2026 20:53
2185910,10,13 30.09.2026 21:34
3306510,10,13 2.10.2026 01:09
3037310,10,13 1.10.2026 20:59
4820310,10,13 5.10.2026 10:03
6740710,10,13 7.10.2026 20:49
4738710,10,13 5.10.2026 10:00
8060010,10,13 9.10.2026 14:29
3754110,10,13 4.10.2026 08:55
3858110,10,13 4.10.2026 13:29
6066710,10,13 5.10.2026 22:04
3662630,10,13 2.10.2026 18:17
7269210,10,13 8.10.2026 14:01
1653210,10,13 30.09.2026 11:22
726050,10,13 29.09.2026 18:42
5982510,10,13 5.10.2026 21:41
7727310,10,13 8.10.2026 19:59
4447210,10,13 5.10.2026 09:09
2629010,10,13 30.09.2026 22:53
5724810,10,13 5.10.2026 20:19
3186210,10,13 2.10.2026 00:05
1599020,10,13 30.09.2026 11:20
4997010,10,13 5.10.2026 12:32
5555510,10,13 5.10.2026 17:58
2121810,10,13 30.09.2026 21:32
1984410,10,13 30.09.2026 20:43
8165110,10,13 9.10.2026 17:45
2384020,10,13 30.09.2026 22:19
7970410,10,13 9.10.2026 14:28
6404160,10,13 6.10.2026 05:50
2560310,10,13 30.09.2026 22:40
9129100,10,13 30.09.2026 05:43
6227610,10,13 5.10.2026 22:57
7636710,10,13 8.10.2026 18:57
3118610,10,13 1.10.2026 21:14
2251310,10,13 30.09.2026 21:37
2831610,10,13 1.10.2026 19:19
2898610,10,13 1.10.2026 19:31
1350110,10,13 30.09.2026 10:52
4273110,10,13 5.10.2026 02:59
4907410,10,13 5.10.2026 10:42
1782510,10,13 30.09.2026 15:42
4192110,30,33 5.10.2026 00:28
3936210,50,53 4.10.2026 13:31
8265310,70,73 9.10.2026 19:25 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 
(@ok bit)DECLARE @ok bit = (SELECT IIF(FailedCount = 0 AND LastLoginUtc IS NOT NULL, 1, 0) FROM DBA.LocalUser)

Bu sorgunun analizleri

Kayıt yok

Henüz analiz yok.