Bonjour,

J'ai le resultat de cette requête:

Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
select * from sys.dm_os_wait_stats WHERE wait_type NOT IN ('CLR_SEMAPHORE','LAZYWRITER_SLEEP','RESOURCE_QUEUE','SQLTRACE_BUFFER_FLUSH','WAITFOR', 'LOGMGR_QUEUE','CHECKPOINT_QUEUE',
'REQUEST_FOR_DEADLOCK_SEARCH','XE_TIMER_EVENT','BROKER_TO_FLUSH','BROKER_TASK_STOP','CLR_MANUAL_EVENT',
'CLR_AUTO_EVENT','DISPATCHER_QUEUE_SEMAPHORE', 'FT_IFTS_SCHEDULER_IDLE_WAIT',
'XE_DISPATCHER_WAIT', 'XE_DISPATCHER_JOIN', 'SQLTRACE_INCREMENTAL_FLUSH_SLEEP',
'ONDEMAND_TASK_QUEUE', 'BROKER_EVENTHANDLER')
and wait_type not like 'SLEEP%'
and wait_time_ms>0
Résultat:

Code : Sélectionner tout - Visualiser dans une fenêtre à part
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
wait_type	  		waiting_tasks_count		wait_time_ms	max_wait_time_ms	signal_wait_time_ms
LCK_M_SCH_M			804		139		4		83
LCK_M_S				4		11		5		0
LCK_M_X				47		15		0		3
LATCH_SH	1			3469		3350		5		1504
LATCH_EX				803		271		5		131
PAGELATCH_SH			744071		13526		10		11293
PAGELATCH_UP			297		26		3		12
PAGELATCH_EX			1772843		53044		9		42322
PAGEIOLATCH_SH			5126		8740		60		64
PAGEIOLATCH_UP			148073		139562		336		3433
PAGEIOLATCH_EX			132		378		21		0
IO_COMPLETION			877		504		22		6
ASYNC_IO_COMPLETION		1		35		35		0
ASYNC_NETWORK_IO			206947		41372		39		11972
CHKPT				1		715		715		0
OLEDB				9592		6		0		0
THREADPOOL			6		8		3		0
SOS_SCHEDULER_YIELD		17520042		344596		32		285868
SQLTRACE_FILE_BUFFER		600		2434		991		57
WRITELOG				428947		521839		354		28684
CMEMTHREAD			1271		72		1		39
CXPACKET				320		1254		170		51
MSQL_XP				63		366		133		0
LOGBUFFER			6		2		0		0
DAC_INIT				1		3		3		0
PREEMPTIVE_OS_GENERICOPS		15		514		260		0
PREEMPTIVE_OS_AUTHENTICATIONOPS	100017		69017		20		0
PREEMPTIVE_OS_DECRYPTMESSAGE	33316		1119		1		0
PREEMPTIVE_OS_DELETESECURITYCONTEXT	33308		3750		10	0
PREEMPTIVE_OS_AUTHORIZATIONOPS	33342		3731		3		0
PREEMPTIVE_OS_LOOKUPACCOUNTSID		26		30		12	0
PREEMPTIVE_OS_REVERTTOSELF		22		1		0	0
PREEMPTIVE_OS_COMOPS			1		505		505	0
PREEMPTIVE_OS_CRYPTOPS			2		718		370	0
PREEMPTIVE_OS_CRYPTACQUIRECONTEXT		33345		18049		6	0
PREEMPTIVE_OS_CRYPTIMPORTKEY		33317		3067		7	0
PREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICY	33294		19922		8	0
PREEMPTIVE_OS_NETVALIDATEPASSWORDPOLICYFREE	33294	2826		4	0
PREEMPTIVE_OS_DOMAINSERVICESOPS		1	179	179	0
PREEMPTIVE_OS_FILEOPS			90	286	37	0
PREEMPTIVE_OS_CREATEFILE			65	679	321	0
PREEMPTIVE_OS_DELETEFILE			27	19	1	0
PREEMPTIVE_FILESIZEGET			22	19	14	0
PREEMPTIVE_OS_GETDISKFREESPACE		6	2	0	0
PREEMPTIVE_OS_GETFILEATTRIBUTES		58	44	17	0
PREEMPTIVE_OS_SETFILEVALIDDATA		4	2	0	0
PREEMPTIVE_OS_WRITEFILEGATHER		12	41	19	0
PREEMPTIVE_OS_LIBRARYOPS	1		1124	1124	0
PREEMPTIVE_OS_GETPROCADDRESS		63	191	39	0
PREEMPTIVE_OS_LOADLIBRARY	3		171	93	0
PREEMPTIVE_OLEDBOPS			173826	21512	13	0
PREEMPTIVE_OS_PIPEOPS			1	261	261	0
PREEMPTIVE_OS_DISCONNECTNAMEDPIPE	29	2	0	0
PREEMPTIVE_OS_REPORTEVENT	51		46	13	0
PREEMPTIVE_OS_WAITFORSINGLEOBJECT	33309	3684	39	0
PREEMPTIVE_OS_QUERYREGISTRY		1386	1304	12	0
WRITE_COMPLETION	68			38	4	0
FT_IFTSHC_MUTEX				1	389	389	0
PERFORMANCE_COUNTERS_RWLOCK		17	16	13	14
SQLTRACE_FILE_WRITE_IO_COMPLETION		31	18	0	0
Alors je ne sais pas s'il ya des valeurs qui seraient anormalement très élevées ?

Merci.