Any genius out there willing to help?

ups

Here it is!

01/08/2009 21:32:39,spid11s,Unknown,waiter id=processffffffffb285fc48 mode=U

requestType=wait

01/08/2009 21:32:39,spid11s,Unknown,waiter-list

01/08/2009 21:32:39,spid11s,Unknown,owner id=process351df18 mode=U

01/08/2009 21:32:39,spid11s,Unknown,owner-list

01/08/2009 21:32:39,spid11s,Unknown,pagelock fileid=1 pageid=243960 dbid=5 objectname=dbxxx.dbo.WebCustomer

id=lockffffffff8ac2dc00 mode=U associatedObjectId=72057594289848320

01/08/2009 21:32:39,spid11s,Unknown,waiter event=e_waitPipeGetRow type=consumer

id=processffffffffccc8ff18

01/08/2009 21:32:39,spid11s,Unknown,waiter-list

01/08/2009 21:32:39,spid11s,Unknown,owner event=e_waitNone type=producer id=processffffffffb285fc48

01/08/2009 21:32:39,spid11s,Unknown,owner...

Ok part 2 of problem.

I've been looking at the DBCC 1222 -1 logs and the pagelocks are happening on this table apparently waiting in queue for an update.

UPDATE XCustomer SET...

Superb! built the indexes on the tables responsible. nice! brought down site load speeds from 8s to 2s.

Mucho appreciate it.