DEFINITIONS

Definitions More Info.
Definition ID151
TitleSQL
CategoryMS_SCRIPT
DefinitionIdentifyAllocationContentionInTEMPDB
Definition DescriptionSELECT session_id AS SessionID, wait_duration_ms AS Wait_Time_In_Milliseconds, resource_description AS Type_of_Allocation_Contention FROM sys.dm_os_waiting_tasks WHERE wait_type LIKE 'PAGELATCH_%' AND (resource_description LIKE '2:%:1' OR resource_description LIKE '2:%:2' OR resource_description LIKE '2:%:3')
RecordBycunay
Record Date21-02-2012 12:23:42
Düzenle
Kopyala
Sil