Can Anyone Help With Waittype 0x0044?

Dec 4, 2007

Hi,

I wonder if anyone can shed any light on the following as i just can't
explain it.

A user is running an update on a 500m+ row table setting a column
value, computing its value from another column in the table. It's now
been running for 23hours.

The server is Itanium 64, enterprise 2005, SAN based storage and it
usually handles anything with this volume quite quickly, probably
about 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 waittime
lastwaittype waitresource
52 5236 0 0x0044 30
PAGEIOLATCH_EX 6:13:1754732

the process seems to stay in this waittype for a few secnds and then
goes to a 0x0000 and then back into this one again. I can see from the
IO counter that IO is increasing and also looking at the current IO i
see the following so presume the query is still working :-

select
database_id,
file_id,
io_stall,
io_pending_ms_ticks,
scheduler_address
from sys.dm_io_virtual_file_stats(NULL, NULL)t1,
sys.dm_io_pending_io_requests as t2
where t1.file_handle = t2.io_handle

gives results :-

613151115052100x0000000008624080

I just can't explain why it is so slow when nothing else is ruuning.

Anyone have any ideas on what i can check on?

Thanks

Ian.

View 2 Replies


ADVERTISEMENT

Exchange WaitType

Nov 3, 2000

Does anyone know how to prevent an exchange waittype?? Is it happening because of the memory config??

View 4 Replies View Related

Waittype LCK_M_IS

Feb 19, 1999

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 Replies View Related

Sysprocesses.waittype

May 24, 2004

Hi,

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.

View 4 Replies View Related

Waittype=WRITELOG

Mar 17, 2006

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 Related







Copyrights 2005-15 www.BigResource.com, All rights reserved