select
DATEPART (HOUR,DATEADD(HOUR,3,wi.EndDate))
,count(1) 'Kayıt Sayısı'
from wflInstances i (nolock)
inner join wflWorkItems wi (nolock) on i.Id = wi.Instance and wi.EndDate
is not null and convert(varchar(10),(wi.EndDate),120)> CONVERT(varchar(10),getdate()-60 /*Son 60 güne ait */ ,120)
group by DATEPART (HOUR,DATEADD(HOUR,3,wi.EndDate)) order by [Kayıt Sayısı] desc
6 AYLIK SAAT BAZINDA YAPILAN İŞLEM ORTALAMASI | |
Saat | Yapılan İşlem Sayısı |
9 | 4295 |
11 | 3942 |
16 | 3771 |
14 | 3584 |
17 | 3465 |
13 | 3228 |
10 | 3016 |
15 | 2980 |
8 | 2629 |
12 | 2358 |
18 | 1335 |
19 | 1297 |
21 | 1226 |
0 | 1050 |
23 | 988 |
20 | 858 |
22 | 646 |
1 | 513 |
7 | 426 |
2 | 279 |
6 | 98 |
5 | 30 |
3 | 20 |