Pahalı sorgular0xD37C1E1150F15024
Demo modu

Sorgu 0xD37C1E1150F15024

SQL-1 · DB-11· test_LocalUsers.test basarili giris sayaci sifirlar ve son giris yazar · dönem 2026-09-13 → 2026-10-12 · 77 çalışma · Pahalı sorgulara dön

Ort. süre 0,2 ms
Ort. CPU 0,2 ms
Bekleme payı %0,2
Ort. mantıksal okuma 17
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,2 ms30.09.2026: 43 çalışma, ort. 0,2 ms1.10.2026: 6 çalışma, ort. 0,2 ms2.10.2026: 11 çalışma, ort. 0,2 ms4.10.2026: 5 çalışma, ort. 0,3 ms5.10.2026: 4 çalışma, ort. 0,3 ms max 43 çalışma max ort. süre 0,3 ms 29.09.2026 5.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. 5.10.2026 09:00 yeni plan plan 43669
  2. 5.10.2026 09:00 yeni plan plan 44471
  3. 5.10.2026 02:00 yeni plan plan 42730
  4. 5.10.2026 00:00 yeni plan plan 41920
  5. 4.10.2026 22:00 yeni plan plan 41082
  6. 4.10.2026 13:00 yeni plan plan 38580
  7. 4.10.2026 13:00 yeni plan plan 39361
  8. 4.10.2026 13:00 yeni plan plan 40096
  9. 4.10.2026 08:00 yeni plan plan 37540
  10. 2.10.2026 17:00 yeni plan plan 35155
  11. 2.10.2026 17:00 yeni plan plan 35896
  12. 2.10.2026 17:00 yeni plan plan 36625
  13. 2.10.2026 16:00 yeni plan plan 34186
  14. 2.10.2026 02:00 yeni plan plan 33768
  15. 2.10.2026 01:00 yeni plan plan 33064
  16. 2.10.2026 00:00 yeni plan plan 31861
  17. 2.10.2026 00:00 yeni plan plan 32424
  18. 1.10.2026 21:00 yeni plan plan 31185
  19. 1.10.2026 20:00 yeni plan plan 29726
  20. 1.10.2026 20:00 yeni plan plan 30372
  21. 1.10.2026 19:00 yeni plan plan 27649
  22. 1.10.2026 19:00 yeni plan plan 28315
  23. 1.10.2026 19:00 yeni plan plan 28985
  24. 30.09.2026 22:00 yeni plan plan 23180
  25. 30.09.2026 22:00 yeni plan plan 23839
  26. 30.09.2026 22:00 yeni plan plan 24343
  27. 30.09.2026 22:00 yeni plan plan 24985
  28. 30.09.2026 22:00 yeni plan plan 25602
  29. 30.09.2026 22:00 yeni plan plan 26289
  30. 30.09.2026 22:00 yeni plan plan 26936
  31. 30.09.2026 21:00 yeni plan plan 20542
  32. 30.09.2026 21:00 yeni plan plan 21217
  33. 30.09.2026 21:00 yeni plan plan 21858
  34. 30.09.2026 21:00 yeni plan plan 22512
  35. 30.09.2026 20:00 yeni plan plan 19843
  36. 30.09.2026 19:00 yeni plan plan 19138
  37. 30.09.2026 15:00 yeni plan plan 17184
  38. 30.09.2026 15:00 yeni plan plan 17824
  39. 30.09.2026 15:00 yeni plan plan 18459
  40. 30.09.2026 11:00 yeni plan plan 14692
  41. 30.09.2026 11:00 yeni plan plan 15319
  42. 30.09.2026 11:00 yeni plan plan 15989
  43. 30.09.2026 11:00 yeni plan plan 16531
  44. 30.09.2026 10:00 yeni plan plan 12969
  45. 30.09.2026 10:00 yeni plan plan 13500
  46. 30.09.2026 10:00 yeni plan plan 14065
  47. 30.09.2026 07:00 yeni plan plan 12389
  48. 30.09.2026 06:00 yeni plan plan 10750
  49. 30.09.2026 06:00 yeni plan plan 11294
  50. 30.09.2026 06:00 yeni plan plan 11783
  51. 30.09.2026 05:00 yeni plan plan 10167
  52. 30.09.2026 00:00 yeni plan plan 9128
  53. 29.09.2026 21:00 yeni plan plan 8239
  54. 29.09.2026 21:00 yeni plan plan 8669
  55. 29.09.2026 20:00 yeni plan plan 7778
  56. 29.09.2026 18:00 yeni plan plan 7259

Günler

GünÇalışmaOrt. CPU msOrt. süre ms p95 msOrt. reads
2026-09-2980,20,2 0,217
2026-09-30430,20,2 0,317
2026-10-0160,20,2 0,317
2026-10-02110,20,2 0,317
2026-10-0450,30,3 0,317
2026-10-0540,30,3 0,317

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
1016710,20,217 30.09.2026 05:50 en iyi
1350010,20,217 30.09.2026 10:52
1845910,20,217 30.09.2026 15:51
866910,20,217 29.09.2026 21:50
1238910,20,217 30.09.2026 07:00
2498510,20,217 30.09.2026 22:38
1129410,20,217 30.09.2026 06:58
1178320,20,217 30.09.2026 06:59
1718410,20,217 30.09.2026 15:32
2434320,20,217 30.09.2026 22:38
823910,20,217 29.09.2026 21:26
3376810,20,217 2.10.2026 02:27
3037210,20,217 1.10.2026 20:59
725950,20,217 29.09.2026 18:42
2251210,20,217 30.09.2026 21:37
3186110,20,217 2.10.2026 00:05
1469210,20,217 30.09.2026 11:02
1531920,20,217 30.09.2026 11:15
1598920,20,217 30.09.2026 11:20
2185810,20,217 30.09.2026 21:34
3118510,20,217 1.10.2026 21:14
2383920,20,217 30.09.2026 22:19
1406510,20,217 30.09.2026 10:56
4009610,20,217 4.10.2026 13:45
3418620,20,217 2.10.2026 16:25
2121710,20,217 30.09.2026 21:32
4366910,20,217 5.10.2026 09:01
1913810,20,217 30.09.2026 19:36
777810,20,217 29.09.2026 20:13
1782410,20,217 30.09.2026 15:42
3306410,20,217 2.10.2026 01:09
3754010,20,217 4.10.2026 08:55
2318010,20,217 30.09.2026 22:15
3589610,20,217 2.10.2026 17:32
1984310,20,217 30.09.2026 20:43
3662530,20,217 2.10.2026 18:17
1653110,20,217 30.09.2026 11:22
9128100,20,217 30.09.2026 05:43
2628910,20,217 30.09.2026 22:53
4108210,20,217 4.10.2026 22:07
2764910,20,217 1.10.2026 19:13
3515510,20,217 2.10.2026 17:24
2054210,20,217 30.09.2026 21:24
2560210,30,317 30.09.2026 22:40
3936110,30,317 4.10.2026 13:31
1075010,30,317 30.09.2026 06:32
4447110,30,317 5.10.2026 09:09
2831510,30,317 1.10.2026 19:19
4192010,30,317 5.10.2026 00:28
2972610,30,317 1.10.2026 20:57
2693610,30,317 30.09.2026 22:56
3242410,30,317 2.10.2026 00:06
4273010,30,317 5.10.2026 02:59
2898510,30,317 1.10.2026 19:31
1296910,40,317 30.09.2026 10:51
3858010,40,417 4.10.2026 13:29 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 
INSERT DBA.LocalUser (UserName, PasswordHash, CreatedBy, FailedCount) VALUES (N'ali', 'h', N'x', 2)

Bu sorgunun analizleri

Kayıt yok

Henüz analiz yok.