Anyone know where I can get documentation on what the various wait types shown in SQL 7 Enterprise Manager mean? I'm looking under current activity and see a waiting process with a wait type listed as LCK_M_IS and another with LCK_M_IX. I can't find a list of the valid wait types anywhere?
View 1 RepliesDoes anyone know how to prevent an exchange waittype?? Is it happening because of the memory config??
View 4 Replies View RelatedHi,
The column waittype of master..sysprocesses table contains binary numbers.
I am looking for their codes. I know that Microsoft has published these codes for SQL Server 7 (here: http://support.microsoft.com/default.aspx?scid=kb;EN-US;244455 ), but I need the codes of SQL Server 2000.
And yes, I've checked spt_values - they are not there.
Any help will be appreciated,
Thanks,
kukuk.
HiIn my server (MSSQL 2000 sp4) very often I see long time of executing querywith waittype=WRITELOGRecovery is set to SIMPLE and there is no autoShrink.Auto increment file size (log) is set to 10%What can be the reason of this problem?Marek
View 6 Replies View RelatedHi,I wonder if anyone can shed any light on the following as i just can'texplain it.A user is running an update on a 500m+ row table setting a columnvalue, computing its value from another column in the table. It's nowbeen running for 23hours.The server is Itanium 64, enterprise 2005, SAN based storage and itusually handles anything with this volume quite quickly, probablyabout 30 mins or so.There is nothing else running currently although overnight batches,backups etc have been running within the last 23 hours.In sysprocess it showing the following :-spid kpid blocked waittype waittimelastwaittype waitresource52 5236 0 0x0044 30PAGEIOLATCH_EX 6:13:1754732the process seems to stay in this waittype for a few secnds and thengoes to a 0x0000 and then back into this one again. I can see from theIO counter that IO is increasing and also looking at the current IO isee the following so presume the query is still working :-selectdatabase_id,file_id,io_stall,io_pending_ms_ticks,scheduler_addressfrom sys.dm_io_virtual_file_stats(NULL, NULL)t1,sys.dm_io_pending_io_requests as t2where t1.file_handle = t2.io_handlegives results :-613151115052100x0000000008624080I just can't explain why it is so slow when nothing else is ruuning.Anyone have any ideas on what i can check on?ThanksIan.
View 2 Replies View Related