Help with long running Update query

Hi i was wondering if anyone could help with the following query.
Sometimes it takes 11 mins to run, sometimes it takes around 5 hours
and the it seems random as to when it happens.
Each table has around 1.4 million rows in and i have included a copy of
the sp_lock output showing that the table has an exclusive lock on and
nothing else seems to be using the same resources. It seems to be
hanging for hours with an exclusive lock on the main table and multiple
extent locks on the tempdb.
the query is :-
Update netviewplus.dbo.PSTN_BAS_RepeatReportDetails
set Fault_Count = RRF.Fault_Count
from netviewplus.dbo.PSTN_BAS_RepeatReportDetails as BAS
Inner Join netviewstaging.dbo.PSTN_PRO_RRFaultCount as RRF
ON BAS.Telephone_Number = RRF.Telephone_Number
I can't understand why its getting stuck on this simple update
statement. Running profiler against the server shows a few
transactionlog eventclass records produced every second for the spid.
Anyone have any ideas on what could be happening?
Thanks
Ian.
The locks from sp_lock for the spid are as follows :-
153200EXT1:181552 XGRANT
1531700DB SGRANT
153200EXT1:189816 XGRANT
153200EXT1:185616 XGRANT
153200EXT1:181560 XGRANT
153200EXT1:189808 XGRANT
153200EXT1:181536 XGRANT
153200EXT1:189800 XGRANT
153200EXT1:185600 XGRANT
153200EXT1:181544 XGRANT
153200EXT1:189792 XGRANT
153200EXT1:181520 XGRANT
153200EXT1:189784 XGRANT
153200EXT1:181528 XGRANT
153200EXT1:189776 XGRANT
153200EXT1:181504 XGRANT
153200EXT1:189768 XGRANT
153200EXT1:185632 XGRANT
153200EXT1:181512 XGRANT
153200EXT1:189760 XGRANT
153200EXT1:185640 XGRANT
153200EXT1:189752 XGRANT
153200EXT1:181616 XGRANT
153200EXT1:189744 XGRANT
153200EXT1:181624 XGRANT
153200EXT1:189736 XGRANT
153200EXT1:181600 XGRANT
153200EXT1:189728 XGRANT
153200EXT1:181608 XGRANT
153200EXT1:189720 XGRANT
153200EXT1:181584 XGRANT
153200EXT1:189712 XGRANT
153200EXT1:181592 XGRANT
153200EXT1:185720 XGRANT
153200EXT1:189704 XGRANT
153200EXT1:181568 XGRANT
153200EXT1:189696 XGRANT
153200EXT1:181576 XGRANT
153200EXT1:185752 XGRANT
153200EXT1:181664 XGRANT
153200EXT1:189928 XGRANT
153200EXT1:185728 XGRANT
153200EXT1:181672 XGRANT
153200EXT1:189920 XGRANT
153200EXT1:185736 XGRANT
153200EXT1:181648 XGRANT
153200EXT1:189912 XGRANT
153200EXT1:185776 XGRANT
153200EXT1:181656 XGRANT
153200EXT1:189904 XGRANT
153200EXT1:185784 XGRANT
153200EXT1:181632 XGRANT
153200EXT1:189896 XGRANT
153200EXT1:185760 XGRANT
153200EXT1:181640 XGRANT
153200EXT1:189888 XGRANT
153200EXT1:185768 XGRANT
153200EXT1:189880 XGRANT
153200EXT1:181744 XGRANT
153200EXT1:185808 XGRANT
153200EXT1:189872 XGRANT
153200EXT1:181752 XGRANT
153200EXT1:185816 XGRANT
153200EXT1:189864 XGRANT
153200EXT1:185792 XGRANT
153200EXT1:189856 XGRANT
153200EXT1:181736 XGRANT
153200EXT1:185800 XGRANT
153200EXT1:189848 XGRANT
153200EXT1:185840 XGRANT
153200EXT1:189840 XGRANT
153200EXT1:189832 XGRANT
153200EXT1:181696 XGRANT
153200EXT1:185824 XGRANT
153200EXT1:189824 XGRANT
153200EXT1:185832 XGRANT
153200EXT1:181296 XGRANT
153200EXT1:189560 XGRANT
153200EXT1:189552 XGRANT
153200EXT1:181280 XGRANT
153200EXT1:189544 XGRANT
153200EXT1:185344 XGRANT
153200EXT1:189944 XGRANT
153200EXT1:185744 XGRANT
153200EXT1:181688 XGRANT
153200EXT1:189936 XGRANT
153200EXT1:181680 XGRANT
153200EXT1:181288 XGRANT
153200EXT1:189536 XGRANT
153200EXT1:181264 XGRANT
153200EXT1:189528 XGRANT
153200EXT1:181272 XGRANT
153200EXT1:189520 XGRANT
153200EXT1:181248 XGRANT
153200EXT1:189512 XGRANT
153200EXT1:181256 XGRANT
153200EXT1:185424 XGRANT
153200EXT1:181368 XGRANT
153200EXT1:185432 XGRANT
1531200DB SGRANT
153200EXT1:182112 XGRANT
153200EXT1:190248 XGRANT
153200EXT1:182120 XGRANT
153200EXT1:190240 XGRANT
153200EXT1:186224 XGRANT
153200EXT1:182096 XGRANT
153200EXT1:190232 XGRANT
153200EXT1:186232 XGRANT
153200EXT1:182104 XGRANT
153200EXT1:190224 XGRANT
153200EXT1:186208 XGRANT
153200EXT1:190216 XGRANT
153200EXT1:186216 XGRANT
153200EXT1:190208 XGRANT
153200EXT1:186256 XGRANT
153200EXT1:190456 XGRANT
153200EXT1:182192 XGRANT
153200EXT1:190448 XGRANT
153200EXT1:182200 XGRANT
153200EXT1:186240 XGRANT
153200EXT1:190440 XGRANT
153200EXT1:182176 XGRANT
153200EXT1:186248 XGRANT
153200EXT1:190432 XGRANT
153200EXT1:182184 XGRANT
153200EXT1:186288 XGRANT
153200EXT1:190424 XGRANT
153200EXT1:182160 XGRANT
153200EXT1:186296 XGRANT
153200EXT1:190416 XGRANT
153200EXT1:182168 XGRANT
153200EXT1:190408 XGRANT
153200EXT1:182144 XGRANT
153200EXT1:190400 XGRANT
153200EXT1:182152 XGRANT
153200EXT1:182256 XGRANT
153200EXT1:190392 XGRANT
153200EXT1:182264 XGRANT
153200EXT1:190384 XGRANT
153200EXT1:186304 XGRANT
153200EXT1:182240 XGRANT
153200EXT1:190376 XGRANT
153200EXT1:186312 XGRANT
153200EXT1:182248 XGRANT
153200EXT1:190368 XGRANT
153200EXT1:182224 XGRANT
153200EXT1:190360 XGRANT
153200EXT1:182232 XGRANT
153200EXT1:190352 XGRANT
153200EXT1:182208 XGRANT
153200EXT1:190344 XGRANT
153200EXT1:182216 XGRANT
153200EXT1:190336 XGRANT
153200EXT1:190072 XGRANT
153200EXT1:181808 XGRANT
153200EXT1:185880 XGRANT
153200EXT1:190064 XGRANT
153200EXT1:181816 XGRANT
153200EXT1:185856 XGRANT
153200EXT1:185416 XGRANT
153200EXT1:181336 XGRANT
153200EXT1:181312 XGRANT
153200EXT1:189440 XGRANT
153200EXT1:181424 XGRANT
153200EXT1:189688 XGRANT
153200EXT1:181432 XGRANT
153200EXT1:189680 XGRANT
153200EXT1:181408 XGRANT
153200EXT1:189672 XGRANT
153200EXT1:185472 XGRANT
153200EXT1:181416 XGRANT
153200EXT1:189664 XGRANT
153200EXT1:181392 XGRANT
153200EXT1:189656 XGRANT
153200EXT1:181400 XGRANT
153200EXT1:189648 XGRANT
153200EXT1:181376 XGRANT
153200EXT1:189640 XGRANT
153200EXT1:181384 XGRANT
153200EXT1:189632 XGRANT
153200EXT1:189624 XGRANT
153200EXT1:181488 XGRANT
153200EXT1:185552 XGRANT
153200EXT1:189616 XGRANT
153200EXT1:181496 XGRANT
153200EXT1:185560 XGRANT
153200EXT1:189608 XGRANT
153200EXT1:181472 XGRANT
153200EXT1:189600 XGRANT
153200EXT1:181480 XGRANT
153200EXT1:181992 XGRANT
153200EXT1:190112 XGRANT
153200EXT1:181968 XGRANT
153200EXT1:190104 XGRANT
153200EXT1:186104 XGRANT
153200EXT1:181976 XGRANT
153200EXT1:190096 XGRANT
153200EXT1:186080 XGRANT
153200EXT1:181952 XGRANT
153200EXT1:190088 XGRANT
153200EXT1:186088 XGRANT
153200EXT1:181960 XGRANT
153200EXT1:190080 XGRANT
153200EXT1:180536 XGRANT
153200EXT1:188784 XGRANT
153200EXT1:184600 XGRANT
153200EXT1:180528 XGRANT
153200EXT1:188792 XGRANT
153200EXT1:184592 XGRANT
153200EXT1:180520 XGRANT
153200EXT1:188768 XGRANT
153200EXT1:184584 XGRANT
153200EXT1:180512 XGRANT
153200EXT1:188776 XGRANT
153200EXT1:184576 XGRANT
153200EXT1:180504 XGRANT
153200EXT1:188752 XGRANT
153200EXT1:180496 XGRANT
153200EXT1:188760 XGRANT
153200EXT1:184624 XGRANT
153200EXT1:180488 XGRANT
153200EXT1:188736 XGRANT
153200EXT1:184616 XGRANT
153200EXT1:180480 XGRANT
153200EXT1:188744 XGRANT
153200EXT1:184608 XGRANT
153200EXT1:188720 XGRANT
153200EXT1:180600 XGRANT
153200EXT1:192784 XGRANT
153200EXT1:184664 XGRANT
153200EXT1:188728 XGRANT
153200EXT1:180592 XGRANT
153200EXT1:188704 XGRANT
153200EXT1:180584 XGRANT
153200EXT1:192768 XGRANT
153200EXT1:188712 XGRANT
153200EXT1:180576 XGRANT
153200EXT1:192776 XGRANT
153200EXT1:188688 XGRANT
153200EXT1:180568 XGRANT
153200EXT1:184696 XGRANT
153200EXT1:188696 XGRANT
153200EXT1:180560 XGRANT
153200EXT1:184688 XGRANT
153200EXT1:188672 XGRANT
153200EXT1:180552 XGRANT
153200EXT1:184680 XGRANT
153200EXT1:188680 XGRANT
153200EXT1:180544 XGRANT
153200EXT1:184672 XGRANT
153200EXT1:180664 XGRANT
153200EXT1:184728 XGRANT
153200EXT1:180656 XGRANT
153200EXT1:184720 XGRANT
153200EXT1:180648 XGRANT
153200EXT1:184712 XGRANT
153200EXT1:180640 XGRANT
153200EXT1:184704 XGRANT
153200EXT1:180632 XGRANT
153200EXT1:188880 XGRANT
153200EXT1:184760 XGRANT
153200EXT1:180624 XGRANT
153200EXT1:184752 XGRANT
153200EXT1:180616 XGRANT
153200EXT1:184744 XGRANT
153200EXT1:180608 XGRANT
153200EXT1:184736 XGRANT
153200EXT1:180728 XGRANT
153200EXT1:188856 XGRANT
153200EXT1:180720 XGRANT
153200EXT1:184784 XGRANT
153200EXT1:180712 XGRANT
153200EXT1:184776 XGRANT
153200EXT1:188840 XGRANT
153200EXT1:180704 XGRANT
153200EXT1:184768 XGRANT
153200EXT1:180696 XGRANT
153200EXT1:184824 XGRANT
153200EXT1:188824 XGRANT
153200EXT1:180688 XGRANT
153200EXT1:180680 XGRANT
153200EXT1:188808 XGRANT
153200EXT1:180672 XGRANT
153200EXT1:188528 XGRANT
153200EXT1:184344 XGRANT
153200EXT1:188536 XGRANT
153200EXT1:184336 XGRANT
153200EXT1:188512 XGRANT
153200EXT1:184328 XGRANT
153200EXT1:188520 XGRANT
153200EXT1:184320 XGRANT
153200EXT1:188496 XGRANT
153200EXT1:184376 XGRANT
153200EXT1:188504 XGRANT
153200EXT1:184368 XGRANT
153200EXT1:188480 XGRANT
153200EXT1:184360 XGRANT
153200EXT1:188488 XGRANT
153200EXT1:184352 XGRANT
1531715625927550TAB XGRANT
153200EXT1:188464 XGRANT
153200EXT1:180344 XGRANT
153200EXT1:184408 XGRANT
153200EXT1:188472 XGRANT
153200EXT1:180336 XGRANT
153200EXT1:184400 XGRANT
153200EXT1:188448 XGRANT
153200EXT1:180328 XGRANT
153200EXT1:184392 XGRANT
153200EXT1:188456 XGRANT
153200EXT1:180320 XGRANT
153200EXT1:184384 XGRANT
153200EXT1:188432 XGRANT
153200EXT1:180312 XGRANT
153200EXT1:184440 XGRANT
153200EXT1:188440 XGRANT
153200EXT1:184432 XGRANT
153200EXT1:188416 XGRANT
153200EXT1:184424 XGRANT
153200EXT1:188424 XGRANT
153200EXT1:184416 XGRANT
153200EXT1:180408 XGRANT
153200EXT1:188656 XGRANT
153200EXT1:184472 XGRANT
153200EXT1:192720 XGRANT
153200EXT1:180400 XGRANT
153200EXT1:188664 XGRANT
153200EXT1:184464 XGRANT
153200EXT1:192728 XGRANT
153200EXT1:180392 XGRANT
153200EXT1:188640 XGRANT
153200EXT1:184456 XGRANT
153200EXT1:192704 XGRANT
153200EXT1:180384 XGRANT
153200EXT1:188648 XGRANT
153200EXT1:184448 XGRANT
153200EXT1:190288 XGRANT
153200EXT1:190280 XGRANT
153200EXT1:182016 XGRANT
153200EXT1:186152 XGRANT
153200EXT1:190272 XGRANT
153200EXT1:182128 XGRANT
153200EXT1:190264 XGRANT
153200EXT1:186200 XGRANT
153200EXT1:182136 XGRANT
153200EXT1:190256 XGRANT
153200EXT1:186056 XGRANT
153200EXT1:190056 XGRANT
153200EXT1:181792 XGRANT
153200EXT1:185864 XGRANT
153200EXT1:189280 XGRANT
153200EXT1:181032 XGRANT
153200EXT1:189288 XGRANT
153200EXT1:181024 XGRANT
153200EXT1:189264 XGRANT
153200EXT1:181016 XGRANT
153200EXT1:185136 XGRANT
153200EXT1:189272 XGRANT
153200EXT1:181008 XGRANT
153200EXT1:185128 XGRANT
153200EXT1:189248 XGRANT
153200EXT1:181000 XGRANT
153200EXT1:185120 XGRANT
153200EXT1:189256 XGRANT
153200EXT1:180992 XGRANT
153200EXT1:185176 XGRANT
153200EXT1:192712 XGRANT
153200EXT1:180376 XGRANT
153200EXT1:188624 XGRANT
153200EXT1:184504 XGRANT
153200EXT1:192752 XGRANT
153200EXT1:180368 XGRANT
153200EXT1:188632 XGRANT
153200EXT1:184496 XGRANT
153200EXT1:192760 XGRANT
153200EXT1:180360 XGRANT
153200EXT1:188608 XGRANT
153200EXT1:184488 XGRANT
153200EXT1:192736 XGRANT
153200EXT1:180352 XGRANT
153200EXT1:188616 XGRANT
153200EXT1:184480 XGRANT
153200EXT1:192744 XGRANT
153200EXT1:188592 XGRANT
153200EXT1:180472 XGRANT
153200EXT1:192656 XGRANT
153200EXT1:184536 XGRANT
153200EXT1:188600 XGRANT
153200EXT1:180464 XGRANT
153200EXT1:192664 XGRANT
153200EXT1:184528 XGRANT
153200EXT1:188576 XGRANT
153200EXT1:184520 XGRANT
153200EXT1:188584 XGRANT
153200EXT1:192648 XGRANT
153200EXT1:184512 XGRANT
153200EXT1:188560 XGRANT
153200EXT1:192688 XGRANT
153200EXT1:184568 XGRANT
153200EXT1:188568 XGRANT
153200EXT1:180432 XGRANT
153200EXT1:190048 XGRANT
153200EXT1:181800 XGRANT
153200EXT1:190040 XGRANT
153200EXT1:181776 XGRANT
153200EXT1:185912 XGRANT
153200EXT1:190032 XGRANT
153200EXT1:181784 XGRANT
153200EXT1:185888 XGRANT
153200EXT1:190024 XGRANT
153200EXT1:181760 XGRANT
153200EXT1:190016 XGRANT
153200EXT1:181768 XGRANT
153200EXT1:185936 XGRANT
153200EXT1:181872 XGRANT
153200EXT1:190008 XGRANT
153200EXT1:181880 XGRANT
153200EXT1:190000 XGRANT
153200EXT1:185920 XGRANT
153200EXT1:181856 XGRANT
153200EXT1:189992 XGRANT
153200EXT1:185928 XGRANT
153200EXT1:181864 XGRANT
153200EXT1:189984 XGRANT
153200EXT1:181840 XGRANT
153200EXT1:189976 XGRANT
153200EXT1:181848 XGRANT
153200EXT1:189968 XGRANT
153200EXT1:185952 XGRANT
153200EXT1:181824 XGRANT
153200EXT1:189960 XGRANT
153200EXT1:181832 XGRANT
153200EXT1:189952 XGRANT
153200EXT1:190200 XGRANT
153200EXT1:185544 XGRANT
153200EXT1:189592 XGRANT
153200EXT1:181456 XGRANT
153200EXT1:185584 XGRANT
153200EXT1:189584 XGRANT
153200EXT1:181464 XGRANT
153200EXT1:189576 XGRANT
153200EXT1:181440 XGRANT
153200EXT1:189568 XGRANT
153200EXT1:181448 XGRANT
153200EXT1:186128 XGRANT
153200EXT1:190328 XGRANT
153200EXT1:186136 XGRANT
153200EXT1:190320 XGRANT
153200EXT1:190312 XGRANT
153200EXT1:186120 XGRANT
153200EXT1:190304 XGRANT
153200EXT1:182056 XGRANT
153200EXT1:190296 XGRANT
153200EXT1:190192 XGRANT
153200EXT1:190184 XGRANT
153200EXT1:190176 XGRANT
153200EXT1:190168 XGRANT
153200EXT1:181904 XGRANT
153200EXT1:186040 XGRANT
153200EXT1:190160 XGRANT
153200EXT1:181912 XGRANT
153200EXT1:186016 XGRANT
153200EXT1:190152 XGRANT
153200EXT1:181888 XGRANT
153200EXT1:186024 XGRANT
153200EXT1:190144 XGRANT
153200EXT1:181896 XGRANT
153200EXT1:186064 XGRANT
153200EXT1:182000 XGRANT
153200EXT1:190136 XGRANT
153200EXT1:182008 XGRANT
153200EXT1:190128 XGRANT
153200EXT1:191768 XGRANT
153200EXT1:183632 XGRANT
153200EXT1:187760 XGRANT
153200EXT1:191760 XGRANT
153200EXT1:183640 XGRANT
153200EXT1:187768 XGRANT
153200EXT1:183712 XGRANT
153200EXT1:191976 XGRANT
153200EXT1:187776 XGRANT
153200EXT1:191968 XGRANT
153200EXT1:187784 XGRANT
153200EXT1:191992 XGRANT
153200EXT1:180832 XGRANT
153200EXT1:188968 XGRANT
153200EXT1:184952 XGRANT
153200EXT1:180824 XGRANT
153200EXT1:184944 XGRANT
153200EXT1:180816 XGRANT
153200EXT1:188952 XGRANT
153200EXT1:184936 XGRANT
153200EXT1:187792 XGRANT
153200EXT1:191984 XGRANT
153200EXT1:187800 XGRANT
153200EXT1:183680 XGRANT
153200EXT1:191944 XGRANT
153200EXT1:187808 XGRANT
153200EXT1:183688 XGRANT
153200EXT1:191936 XGRANT
153200EXT1:187816 XGRANT
153200EXT1:183696 XGRANT
153200EXT1:191960 XGRANT
153200EXT1:187824 XGRANT
153200EXT1:183704 XGRANT
153200EXT1:191952 XGRANT
153200EXT1:187832 XGRANT
153200EXT1:191912 XGRANT
153200EXT1:183776 XGRANT
153200EXT1:187840 XGRANT
153200EXT1:191904 XGRANT
153200EXT1:183784 XGRANT
153200EXT1:187848 XGRANT
153200EXT1:191928 XGRANT
153200EXT1:183792 XGRANT
153200EXT1:187856 XGRANT
153200EXT1:191920 XGRANT
153200EXT1:183800 XGRANT
153200EXT1:180808 XGRANT
153200EXT1:184928 XGRANT
153200EXT1:180800 XGRANT
153200EXT1:184984 XGRANT
153200EXT1:189168 XGRANT
153200EXT1:184976 XGRANT
153200EXT1:189176 XGRANT
153200EXT1:184968 XGRANT
153200EXT1:189152 XGRANT
153200EXT1:180904 XGRANT
153200EXT1:184960 XGRANT
153200EXT1:189160 XGRANT
153200EXT1:180896 XGRANT
153200EXT1:185016 XGRANT
153200EXT1:189136 XGRANT
153200EXT1:180888 XGRANT
153200EXT1:185008 XGRANT
153200EXT1:189144 XGRANT
153200EXT1:180880 XGRANT
153200EXT1:185000 XGRANT
153200EXT1:189120 XGRANT
153200EXT1:184992 XGRANT
153200EXT1:189128 XGRANT
153200EXT1:180864 XGRANT
153200EXT1:189008 XGRANT
153200EXT1:180760 XGRANT
153200EXT1:184880 XGRANT
153200EXT1:189016 XGRANT
153200EXT1:180752 XGRANT
153200EXT1:184872 XGRANT
153200EXT1:188992 XGRANT
153200EXT1:180744 XGRANT
153200EXT1:184864 XGRANT
153200EXT1:189000 XGRANT
153200EXT1:180736 XGRANT
153200EXT1:184920 XGRANT
153200EXT1:188976 XGRANT
153200EXT1:188984 XGRANT
153200EXT1:180840 XGRANT
153200EXT1:188960 XGRANT
153200EXT1:187456 XGRANT
153200EXT1:187464 XGRANT
153200EXT1:187472 XGRANT
153200EXT1:183416 XGRANT
153200EXT1:187480 XGRANT
153200EXT1:187488 XGRANT
153200EXT1:183368 XGRANT
153200EXT1:187496 XGRANT
153200EXT1:183376 XGRANT
153200EXT1:187504 XGRANT
153200EXT1:183384 XGRANT
153200EXT1:187512 XGRANT
153200EXT1:183456 XGRANT
153200EXT1:187520 XGRANT
153200EXT1:183464 XGRANT
153200EXT1:187528 XGRANT
153200EXT1:183472 XGRANT
153200EXT1:187536 XGRANT
153200EXT1:183480 XGRANT
153200EXT1:187544 XGRANT
153200EXT1:183424 XGRANT
153200EXT1:187552 XGRANT
153200EXT1:187560 XGRANT
1531219044783090TAB SGRANT
153200EXT1:187568 XGRANT
153200EXT1:187576 XGRANT
153200EXT1:183520 XGRANT
153200EXT1:187584 XGRANT
153200EXT1:183528 XGRANT
153200EXT1:187592 XGRANT
153200EXT1:191672 XGRANT
153200EXT1:183536 XGRANT
153200EXT1:187600 XGRANT
153200EXT1:183544 XGRANT
153200EXT1:187608 XGRANT
153200EXT1:183488 XGRANT
153200EXT1:187616 XGRANT
153200EXT1:183496 XGRANT
153200EXT1:187624 XGRANT
153200EXT1:183504 XGRANT
153200EXT1:187632 XGRANT
153200EXT1:183512 XGRANT
153200EXT1:187640 XGRANT
153200EXT1:188160 XGRANT
153200EXT1:184096 XGRANT
153200EXT1:188168 XGRANT
153200EXT1:184104 XGRANT
153200EXT1:188176 XGRANT
153200EXT1:184112 XGRANT
153200EXT1:188184 XGRANT
153200EXT1:184120 XGRANT
153200EXT1:188192 XGRANT
153200EXT1:184064 XGRANT
153200EXT1:188200 XGRANT
153200EXT1:184072 XGRANT
153200EXT1:188208 XGRANT
153200EXT1:184080 XGRANT
153200EXT1:188216 XGRANT
153200EXT1:184088 XGRANT
153200EXT1:188224 XGRANT
153200EXT1:184160 XGRANT
153200EXT1:192296 XGRANT
153200EXT1:188232 XGRANT
153200EXT1:184168 XGRANT
153200EXT1:192288 XGRANT
153200EXT1:188240 XGRANT
153200EXT1:184176 XGRANT
153200EXT1:192312 XGRANT
153200EXT1:188248 XGRANT
153200EXT1:184184 XGRANT
153200EXT1:192304 XGRANT
153200EXT1:188256 XGRANT
153200EXT1:184128 XGRANT
153200EXT1:192264 XGRANT
153200EXT1:181984 XGRANT
153200EXT1:190120 XGRANT
153200EXT1:181104 XGRANT
153200EXT1:189240 XGRANT
153200EXT1:181112 XGRANT
153200EXT1:189232 XGRANT
153200EXT1:192696 XGRANT
153200EXT1:184560 XGRANT
153200EXT1:188544 XGRANT
153200EXT1:180424 XGRANT
153200EXT1:192672 XGRANT
153200EXT1:184552 XGRANT
153200EXT1:188552 XGRANT
153200EXT1:180416 XGRANT
153200EXT1:192680 XGRANT
153200EXT1:184544 XGRANT
153200EXT1:185112 XGRANT
153200EXT1:189296 XGRANT
153200EXT1:189304 XGRANT
153200EXT1:181040 XGRANT
153200EXT1:189184 XGRANT
153200EXT1:189192 XGRANT
153200EXT1:185240 XGRANT
153200EXT1:189424 XGRANT
153200EXT1:181176 XGRANT
153200EXT1:185232 XGRANT
153200EXT1:181168 XGRANT
153200EXT1:185224 XGRANT
153200EXT1:189408 XGRANT
153200EXT1:181160 XGRANT
153200EXT1:181096 XGRANT
153200EXT1:189216 XGRANT
153200EXT1:181088 XGRANT
153200EXT1:189224 XGRANT
153200EXT1:181080 XGRANT
153200EXT1:189200 XGRANT
153200EXT1:181072 XGRANT
153200EXT1:189208 XGRANT
153200EXT1:181128 XGRANT
153200EXT1:189384 XGRANT
153200EXT1:181120 XGRANT
153200EXT1:185304 XGRANT
153200EXT1:181240 XGRANT
153200EXT1:185296 XGRANT
153200EXT1:181232 XGRANT
153200EXT1:189368 XGRANT
153200EXT1:185288 XGRANT
153200EXT1:181224 XGRANT
153200EXT1:189344 XGRANT
153200EXT1:185280 XGRANT
153200EXT1:181216 XGRANT
153200EXT1:185336 XGRANT
153200EXT1:181208 XGRANT
153200EXT1:189328 XGRANT
153200EXT1:185328 XGRANT
153200EXT1:181200 XGRANT
153200EXT1:189336 XGRANT
153200EXT1:185320 XGRANT
153200EXT1:181192 XGRANT
153200EXT1:189312 XGRANT
153200EXT1:185312 XGRANT
153200EXT1:181184 XGRANT
153200EXT1:189320 XGRANT
153200EXT1:184856 XGRANT
153200EXT1:189040 XGRANT
153200EXT1:180792 XGRANT
153200EXT1:184848 XGRANT
153200EXT1:189048 XGRANT
153200EXT1:180784 XGRANT
153200EXT1:184840 XGRANT
153200EXT1:189024 XGRANT
153200EXT1:180776 XGRANT
153200EXT1:184832 XGRANT
153200EXT1:189032 XGRANT
153200EXT1:180768 XGRANT
153200EXT1:185048 XGRANT
153200EXT1:180984 XGRANT
153200EXT1:189104 XGRANT
153200EXT1:185040 XGRANT
153200EXT1:180976 XGRANT
153200EXT1:189112 XGRANT
153200EXT1:185032 XGRANT
153200EXT1:180968 XGRANT
153200EXT1:189088 XGRANT
153200EXT1:185024 XGRANT
153200EXT1:180960 XGRANT
153200EXT1:189096 XGRANT
153200EXT1:180952 XGRANT
153200EXT1:189072 XGRANT
153200EXT1:185072 XGRANT
153200EXT1:180944 XGRANT
153200EXT1:189080 XGRANT
153200EXT1:185064 XGRANT
153200EXT1:180936 XGRANT
153200EXT1:189056 XGRANT
153200EXT1:185056 XGRANT
153200EXT1:189064 XGRANT
153200EXT1:183584 XGRANT
153200EXT1:191848 XGRANT
153200EXT1:187648 XGRANT
153200EXT1:183592 XGRANT
153200EXT1:191840 XGRANT
153200EXT1:187656 XGRANT
153200EXT1:183600 XGRANT
153200EXT1:191864 XGRANT
153200EXT1:187664 XGRANT
153200EXT1:183608 XGRANT
153200EXT1:191856 XGRANT
153200EXT1:187672 XGRANT
153200EXT1:183552 XGRANT
153200EXT1:191816 XGRANT
153200EXT1:187680 XGRANT
153200EXT1:183560 XGRANT
153200EXT1:191808 XGRANT
153200EXT1:187688 XGRANT
153200EXT1:183568 XGRANT
153200EXT1:191832 XGRANT
153200EXT1:187696 XGRANT
153200EXT1:183576 XGRANT
153200EXT1:191824 XGRANT
153200EXT1:187704 XGRANT
153200EXT1:191784 XGRANT
153200EXT1:183648 XGRANT
153200EXT1:187712 XGRANT
153200EXT1:191776 XGRANT
153200EXT1:183656 XGRANT
153200EXT1:187720 XGRANT
153200EXT1:191800 XGRANT
153200EXT1:183664 XGRANT
153200EXT1:187728 XGRANT
153200EXT1:191792 XGRANT
153200EXT1:183672 XGRANT
153200EXT1:187736 XGRANT
153200EXT1:191752 XGRANT
153200EXT1:183616 XGRANT
153200EXT1:187744 XGRANT
153200EXT1:191744 XGRANT
153200EXT1:183624 XGRANT
153200EXT1:187752 XGRANT
153200EXT1:186736 XGRANT
153200EXT1:190944 XGRANT
153200EXT1:190952 XGRANT
153200EXT1:182712 XGRANT
153200EXT1:190960 XGRANT
153200EXT1:186776 XGRANT
153200EXT1:182704 XGRANT
153200EXT1:190968 XGRANT
153200EXT1:182664 XGRANT
153200EXT1:190912 XGRANT
153200EXT1:186792 XGRANT
153200EXT1:182656 XGRANT
153200EXT1:190920 XGRANT
153200EXT1:186784 XGRANT
153200EXT1:190928 XGRANT
153200EXT1:186808 XGRANT
153200EXT1:190936 XGRANT
153200EXT1:186800 XGRANT
153200EXT1:190880 XGRANT
153200EXT1:190888 XGRANT
153200EXT1:190896 XGRANT
153200EXT1:182776 XGRANT
153200EXT1:190904 XGRANT
153200EXT1:190848 XGRANT
153200EXT1:186856 XGRANT
153200EXT1:190856 XGRANT
153200EXT1:186848 XGRANT
153200EXT1:190864 XGRANT
153200EXT1:182744 XGRANT
153200EXT1:186872 XGRANT
153200EXT1:190872 XGRANT
153200EXT1:182736 XGRANT
153200EXT1:186864 XGRANT
153200EXT1:182312 XGRANT
153200EXT1:190560 XGRANT
153200EXT1:182304 XGRANT
153200EXT1:190568 XGRANT
153200EXT1:182328 XGRANT
153200EXT1:190576 XGRANT
153200EXT1:186392 XGRANT
153200EXT1:182320 XGRANT
153200EXT1:190584 XGRANT
153200EXT1:182280 XGRANT
153200EXT1:190528 XGRANT
153200EXT1:182272 XGRANT
153200EXT1:190536 XGRANT
153200EXT1:182296 XGRANT
153200EXT1:190544 XGRANT
153200EXT1:186424 XGRANT
153200EXT1:182288 XGRANT
153200EXT1:190552 XGRANT
153200EXT1:190496 XGRANT
153200EXT1:182376 XGRANT
153200EXT1:186440 XGRANT
153200EXT1:190504 XGRANT
153200EXT1:182368 XGRANT
153200EXT1:186432 XGRANT
153200EXT1:190512 XGRANT
153200EXT1:182392 XGRANT
153200EXT1:186456 XGRANT
153200EXT1:190520 XGRANT
153200EXT1:182384 XGRANT
153200EXT1:186448 XGRANT
153200EXT1:190464 XGRANT
153200EXT1:182344 XGRANT
153200EXT1:186472 XGRANT
153200EXT1:190472 XGRANT
153200EXT1:182336 XGRANT
153200EXT1:186464 XGRANT
153200EXT1:190480 XGRANT
153200EXT1:182360 XGRANT
153200EXT1:186488 XGRANT
153200EXT1:190488 XGRANT
153200EXT1:182352 XGRANT
153200EXT1:186480 XGRANT
153200EXT1:182440 XGRANT
153200EXT1:190688 XGRANT
153200EXT1:186504 XGRANT
153200EXT1:182432 XGRANT
153200EXT1:190696 XGRANT
153200EXT1:182456 XGRANT
153200EXT1:190704 XGRANT
153200EXT1:182448 XGRANT
153200EXT1:190712 XGRANT
153200EXT1:182408 XGRANT
153200EXT1:190656 XGRANT
153200EXT1:182400 XGRANT
153200EXT1:190664 XGRANT
153200EXT1:186528 XGRANT
153200EXT1:182424 XGRANT
153200EXT1:190672 XGRANT
153200EXT1:182416 XGRANT
153200EXT1:190680 XGRANT
153200EXT1:190624 XGRANT
153200EXT1:182504 XGRANT
153200EXT1:190632 XGRANT
153200EXT1:182496 XGRANT
153200EXT1:186560 XGRANT
153200EXT1:190640 XGRANT
153200EXT1:182520 XGRANT
153200EXT1:186584 XGRANT
153200EXT1:190648 XGRANT
153200EXT1:182512 XGRANT
153200EXT1:186576 XGRANT
153200EXT1:190592 XGRANT
153200EXT1:182472 XGRANT
153200EXT1:186600 XGRANT
153200EXT1:190600 XGRANT
153200EXT1:182464 XGRANT
153200EXT1:190608 XGRANT
153200EXT1:182488 XGRANT
153200EXT1:186616 XGRANT
153200EXT1:190616 XGRANT
153200EXT1:182480 XGRANT
153200EXT1:186608 XGRANT
153200EXT1:187144 XGRANT
153200EXT1:191328 XGRANT
153200EXT1:183080 XGRANT
153200EXT1:187136 XGRANT
153200EXT1:191336 XGRANT
153200EXT1:183072 XGRANT
153200EXT1:187160 XGRANT
153200EXT1:191344 XGRANT
153200EXT1:183096 XGRANT
153200EXT1:187152 XGRANT
153200EXT1:191352 XGRANT
153200EXT1:183088 XGRANT
153200EXT1:187176 XGRANT
153200EXT1:191296 XGRANT
153200EXT1:183048 XGRANT
153200EXT1:187168 XGRANT
153200EXT1:191304 XGRANT
153200EXT1:183040 XGRANT
153200EXT1:187192 XGRANT
153200EXT1:191312 XGRANT
153200EXT1:183064 XGRANT
153200EXT1:187184 XGRANT
153200EXT1:191320 XGRANT
153200EXT1:183056 XGRANT
153200EXT1:187208 XGRANT
153200EXT1:183144 XGRANT
153200EXT1:191264 XGRANT
153200EXT1:187200 XGRANT
153200EXT1:183136 XGRANT
153200EXT1:191272 XGRANT
153200EXT1:187224 XGRANT
153200EXT1:183160 XGRANT
153200EXT1:191280 XGRANT
153200EXT1:187216 XGRANT
153200EXT1:183152 XGRANT
153200EXT1:191288 XGRANT
153200EXT1:187240 XGRANT
153200EXT1:183112 XGRANT
153200EXT1:191232 XGRANT
153200EXT1:187232 XGRANT
153200EXT1:183104 XGRANT
153200EXT1:191240 XGRANT
153200EXT1:187256 XGRANT
153200EXT1:183128 XGRANT
153200EXT1:191248 XGRANT
153200EXT1:187248 XGRANT
153200EXT1:183120 XGRANT
153200EXT1:191256 XGRANT
153200EXT1:187272 XGRANT
153200EXT1:183208 XGRANT
153200EXT1:187264 XGRANT
153200EXT1:183200 XGRANT
153200EXT1:187288 XGRANT
153200EXT1:191472 XGRANT
153200EXT1:183224 XGRANT
153200EXT1:192192 XGRANT
153200EXT1:183944 XGRANT
153200EXT1:188080 XGRANT
153200EXT1:192216 XGRANT
153200EXT1:183952 XGRANT
153200EXT1:188088 XGRANT
153200EXT1:192208 XGRANT
153200EXT1:183960 XGRANT
153200EXT1:188096 XGRANT
153200EXT1:184032 XGRANT
153200EXT1:192168 XGRANT
153200EXT1:188104 XGRANT
153200EXT1:184040 XGRANT
153200EXT1:192160 XGRANT
153200EXT1:188112 XGRANT
153200EXT1:184048 XGRANT
153200EXT1:192184 XGRANT
153200EXT1:188120 XGRANT
153200EXT1:184056 XGRANT
153200EXT1:192176 XGRANT
153200EXT1:188128 XGRANT
153200EXT1:192136 XGRANT
153200EXT1:188136 XGRANT
153200EXT1:184008 XGRANT
153200EXT1:192128 XGRANT
153200EXT1:188144 XGRANT
153200EXT1:184016 XGRANT
153200EXT1:192152 XGRANT
153200EXT1:188152 XGRANT
153200EXT1:184024 XGRANT
153200EXT1:192144 XGRANT
153200EXT1:182568 XGRANT
153200EXT1:190816 XGRANT
153200EXT1:186632 XGRANT
153200EXT1:190824 XGRANT
153200EXT1:186624 XGRANT
153200EXT1:182584 XGRANT
153200EXT1:190832 XGRANT
153200EXT1:186648 XGRANT
153200EXT1:182576 XGRANT
153200EXT1:190840 XGRANT
153200EXT1:186640 XGRANT
153200EXT1:190784 XGRANT
153200EXT1:187880 XGRANT
153200EXT1:191896 XGRANT
153200EXT1:183760 XGRANT
153200EXT1:187888 XGRANT
153200EXT1:191888 XGRANT
153200EXT1:183768 XGRANT
153200EXT1:187896 XGRANT
153200EXT1:183328 XGRANT
153200EXT1:187392 XGRANT
153200EXT1:187400 XGRANT
153200EXT1:187408 XGRANT
153200EXT1:183352 XGRANT
153200EXT1:187416 XGRANT
153200EXT1:187424 XGRANT
153200EXT1:183304 XGRANT
153200EXT1:187432 XGRANT
153200EXT1:187440 XGRANT
153200EXT1:183320 XGRANT
153200EXT1:187448 XGRANT
153200EXT1:188264 XGRANT
153200EXT1:184136 XGRANT
153200EXT1:192256 XGRANT
153200EXT1:188272 XGRANT
153200EXT1:184144 XGRANT
153200EXT1:192280 XGRANT
153200EXT1:188280 XGRANT
153200EXT1:184152 XGRANT
153200EXT1:192272 XGRANT
153200EXT1:188288 XGRANT
153200EXT1:184224 XGRANT
153200EXT1:192480 XGRANT
153200EXT1:184232 XGRANT
153200EXT1:184240 XGRANT
153200EXT1:184248 XGRANT
153200EXT1:184192 XGRANT
153200EXT1:188328 XGRANT
153200EXT1:184296 XGRANT
153200EXT1:188368 XGRANT
153200EXT1:184304 XGRANT
153200EXT1:188376 XGRANT
153200EXT1:184312 XGRANT
153200EXT1:188384 XGRANT
153200EXT1:184256 XGRANT
153200EXT1:188392 XGRANT
153200EXT1:184264 XGRANT
153200EXT1:188400 XGRANT
153200EXT1:184272 XGRANT
153200EXT1:188408 XGRANT
153200EXT1:184280 XGRANT
153200EXT1:187904 XGRANT
153200EXT1:192104 XGRANT
153200EXT1:183840 XGRANT
153200EXT1:187912 XGRANT
153200EXT1:192096 XGRANT
153200EXT1:183848 XGRANT
153200EXT1:187920 XGRANT
153200EXT1:192120 XGRANT
153200EXT1:183856 XGRANT
153200EXT1:187928 XGRANT
153200EXT1:192112 XGRANT
153200EXT1:183864 XGRANT
153200EXT1:187936 XGRANT
153200EXT1:192072 XGRANT
153200EXT1:183808 XGRANT
153200EXT1:187944 XGRANT
153200EXT1:192064 XGRANT
153200EXT1:183816 XGRANT
153200EXT1:187952 XGRANT
153200EXT1:192088 XGRANT
153200EXT1:183824 XGRANT
153200EXT1:187960 XGRANT
153200EXT1:192080 XGRANT
153200EXT1:183832 XGRANT
153200EXT1:187968 XGRANT
153200EXT1:183904 XGRANT
153200EXT1:192040 XGRANT
153200EXT1:187976 XGRANT
153200EXT1:192032 XGRANT
153200EXT1:187984 XGRANT
153200EXT1:192056 XGRANT
153200EXT1:187992 XGRANT
153200EXT1:192048 XGRANT
153200EXT1:188000 XGRANT
153200EXT1:183872 XGRANT
153200EXT1:192008 XGRANT
1531715625927551PAG1:25290761 IUGRANT
153200EXT1:188008 XGRANT
153200EXT1:183880 XGRANT
153200EXT1:192000 XGRANT
153200EXT1:188016 XGRANT
153200EXT1:183888 XGRANT
153200EXT1:192024 XGRANT
153200EXT1:188024 XGRANT
153200EXT1:183896 XGRANT
153200EXT1:192016 XGRANT
153200EXT1:188032 XGRANT
153200EXT1:192232 XGRANT
153200EXT1:183968 XGRANT
153200EXT1:188040 XGRANT
153200EXT1:192224 XGRANT
153200EXT1:188048 XGRANT
153200EXT1:192248 XGRANT
153200EXT1:188056 XGRANT
153200EXT1:192240 XGRANT
153200EXT1:188064 XGRANT
153200EXT1:192200 XGRANT
153200EXT1:188072 XGRANT
153200EXT1:187864 XGRANT
153200EXT1:191880 XGRANT
153200EXT1:187872 XGRANT
153200EXT1:191872 XGRANT
153200EXT1:183752 XGRANT
153200EXT1:189392 XGRANT
153200EXT1:184200 XGRANT
153200EXT1:188336 XGRANT
153200EXT1:184208 XGRANT
153200EXT1:188344 XGRANT
153200EXT1:186664 XGRANT
153200EXT1:190792 XGRANT
153200EXT1:186656 XGRANT
153200EXT1:190800 XGRANT
153200EXT1:182544 XGRANT
153200EXT1:190808 XGRANT
153200EXT1:186672 XGRANT
153200EXT1:190752 XGRANT
153200EXT1:182632 XGRANT
153200EXT1:186696 XGRANT
153200EXT1:190760 XGRANT
153200EXT1:186688 XGRANT
153200EXT1:190768 XGRANT
153200EXT1:186712 XGRANT
153200EXT1:190776 XGRANT
153200EXT1:182640 XGRANT
153200EXT1:186704 XGRANT
153200EXT1:190720 XGRANT
153200EXT1:186728 XGRANT
153200EXT1:190728 XGRANT
153200EXT1:186720 XGRANT
153200EXT1:190736 XGRANT
153200EXT1:182616 XGRANT
153200EXT1:190744 XGRANT
153200EXT1:182608 XGRANT
153200EXT1:187280 XGRANT
153200EXT1:184216 XGRANT
153200EXT1:188352 XGRANT
153200EXT1:184288 XGRANT
153200EXT1:188360 XGRANT
153200EXT1:183216 XGRANT
153200EXT1:187304 XGRANT
153200EXT1:183176 XGRANT
153200EXT1:187296 XGRANT
153200EXT1:183168 XGRANT
153200EXT1:187320 XGRANT
153200EXT1:183192 XGRANT
153200EXT1:187312 XGRANT
153200EXT1:183184 XGRANT
153200EXT1:187336 XGRANT
153200EXT1:183272 XGRANT
153200EXT1:187328 XGRANT
153200EXT1:183264 XGRANT
153200EXT1:187352 XGRANT
153200EXT1:187344 XGRANT
153200EXT1:183280 XGRANT
153200EXT1:187368 XGRANT
153200EXT1:191360 XGRANT
153200EXT1:187360 XGRANT
153200EXT1:191368 XGRANT
153200EXT1:187384 XGRANT
153200EXT1:187376 XGRANT
153200EXT1:183248 XGRANT
153200EXT1:186888 XGRANT
153200EXT1:191072 XGRANT
153200EXT1:182824 XGRANT
153200EXT1:186880 XGRANT
153200EXT1:191080 XGRANT
153200EXT1:186904 XGRANT
153200EXT1:191088 XGRANT
153200EXT1:186896 XGRANT
153200EXT1:191096 XGRANT
153200EXT1:186920 XGRANT
153200EXT1:191040 XGRANT
153200EXT1:182792 XGRANT
153200EXT1:186912 XGRANT
153200EXT1:191048 XGRANT
153200EXT1:182784 XGRANT
153200EXT1:186936 XGRANT
153200EXT1:191056 XGRANT
153200EXT1:186928 XGRANT
153200EXT1:191064 XGRANT
153200EXT1:182888 XGRANT
153200EXT1:191008 XGRANT
153200EXT1:182880 XGRANT
153200EXT1:191016 XGRANT
153200EXT1:182904 XGRANT
153200EXT1:191024 XGRANT
153200EXT1:182896 XGRANT
153200EXT1:191032 XGRANT
153200EXT1:182856 XGRANT
153200EXT1:190976 XGRANT
153200EXT1:190984 XGRANT
153200EXT1:182872 XGRANT
153200EXT1:190992 XGRANT
153200EXT1:182864 XGRANT
153200EXT1:191000 XGRANT
153200EXT1:191200 XGRANT
153200EXT1:182952 XGRANT
153200EXT1:191208 XGRANT
153200EXT1:182944 XGRANT
153200EXT1:191216 XGRANT
153200EXT1:182968 XGRANT
153200EXT1:191224 XGRANT
153200EXT1:182960 XGRANT
153200EXT1:187048 XGRANT
153200EXT1:191168 XGRANT
153200EXT1:182920 XGRANT
153200EXT1:187040 XGRANT
153200EXT1:191176 XGRANT
153200EXT1:182912 XGRANT
153200EXT1:187064 XGRANT
153200EXT1:191184 XGRANT
153200EXT1:182936 XGRANT
153200EXT1:187056 XGRANT
153200EXT1:191192 XGRANT
153200EXT1:182928 XGRANT
153200EXT1:187080 XGRANT
153200EXT1:183016 XGRANT
153200EXT1:191136 XGRANT
153200EXT1:187072 XGRANT
153200EXT1:183008 XGRANT
153200EXT1:191144 XGRANT
153200EXT1:187096 XGRANT
153200EXT1:183032 XGRANT
153200EXT1:191152 XGRANT
153200EXT1:187088 XGRANT
153200EXT1:183024 XGRANT
153200EXT1:191160 XGRANT
153200EXT1:187112 XGRANT
153200EXT1:182984 XGRANT
153200EXT1:191104 XGRANT
153200EXT1:187104 XGRANT
153200EXT1:182976 XGRANT
153200EXT1:191112 XGRANT
153200EXT1:187128 XGRANT
153200EXT1:183000 XGRANT
153200EXT1:191120 XGRANT
153200EXT1:187120 XGRANT
153200EXT1:182992 XGRANT
153200EXT1:191128 XGRANT
Hi
Don't you have a WHERE condition? Have you checked sp_lock system stored
procedures?
Did you update statistics on the both servers?
<ian.wrigglesworth@.openreach.co.uk> wrote in message
news:1162392567.098665.190840@.e3g2000cwe.googlegro ups.com...
> Hi i was wondering if anyone could help with the following query.
> Sometimes it takes 11 mins to run, sometimes it takes around 5 hours
> and the it seems random as to when it happens.
> Each table has around 1.4 million rows in and i have included a copy of
> the sp_lock output showing that the table has an exclusive lock on and
> nothing else seems to be using the same resources. It seems to be
> hanging for hours with an exclusive lock on the main table and multiple
> extent locks on the tempdb.
> the query is :-
> Update netviewplus.dbo.PSTN_BAS_RepeatReportDetails
> set Fault_Count = RRF.Fault_Count
> from netviewplus.dbo.PSTN_BAS_RepeatReportDetails as BAS
> Inner Join netviewstaging.dbo.PSTN_PRO_RRFaultCount as RRF
> ON BAS.Telephone_Number = RRF.Telephone_Number
> I can't understand why its getting stuck on this simple update
> statement. Running profiler against the server shows a few
> transactionlog eventclass records produced every second for the spid.
> Anyone have any ideas on what could be happening?
> Thanks
> Ian.
> The locks from sp_lock for the spid are as follows :-
> 153 2 0 0 EXT 1:181552 X GRANT
> 153 17 0 0 DB S GRANT
> 153 2 0 0 EXT 1:189816 X GRANT
> 153 2 0 0 EXT 1:185616 X GRANT
> 153 2 0 0 EXT 1:181560 X GRANT
> 153 2 0 0 EXT 1:189808 X GRANT
> 153 2 0 0 EXT 1:181536 X GRANT
> 153 2 0 0 EXT 1:189800 X GRANT
> 153 2 0 0 EXT 1:185600 X GRANT
> 153 2 0 0 EXT 1:181544 X GRANT
> 153 2 0 0 EXT 1:189792 X GRANT
> 153 2 0 0 EXT 1:181520 X GRANT
> 153 2 0 0 EXT 1:189784 X GRANT
> 153 2 0 0 EXT 1:181528 X GRANT
> 153 2 0 0 EXT 1:189776 X GRANT
> 153 2 0 0 EXT 1:181504 X GRANT
> 153 2 0 0 EXT 1:189768 X GRANT
> 153 2 0 0 EXT 1:185632 X GRANT
> 153 2 0 0 EXT 1:181512 X GRANT
> 153 2 0 0 EXT 1:189760 X GRANT
> 153 2 0 0 EXT 1:185640 X GRANT
> 153 2 0 0 EXT 1:189752 X GRANT
> 153 2 0 0 EXT 1:181616 X GRANT
> 153 2 0 0 EXT 1:189744 X GRANT
> 153 2 0 0 EXT 1:181624 X GRANT
> 153 2 0 0 EXT 1:189736 X GRANT
> 153 2 0 0 EXT 1:181600 X GRANT
> 153 2 0 0 EXT 1:189728 X GRANT
> 153 2 0 0 EXT 1:181608 X GRANT
> 153 2 0 0 EXT 1:189720 X GRANT
> 153 2 0 0 EXT 1:181584 X GRANT
> 153 2 0 0 EXT 1:189712 X GRANT
> 153 2 0 0 EXT 1:181592 X GRANT
> 153 2 0 0 EXT 1:185720 X GRANT
> 153 2 0 0 EXT 1:189704 X GRANT
> 153 2 0 0 EXT 1:181568 X GRANT
> 153 2 0 0 EXT 1:189696 X GRANT
> 153 2 0 0 EXT 1:181576 X GRANT
> 153 2 0 0 EXT 1:185752 X GRANT
> 153 2 0 0 EXT 1:181664 X GRANT
> 153 2 0 0 EXT 1:189928 X GRANT
> 153 2 0 0 EXT 1:185728 X GRANT
> 153 2 0 0 EXT 1:181672 X GRANT
> 153 2 0 0 EXT 1:189920 X GRANT
> 153 2 0 0 EXT 1:185736 X GRANT
> 153 2 0 0 EXT 1:181648 X GRANT
> 153 2 0 0 EXT 1:189912 X GRANT
> 153 2 0 0 EXT 1:185776 X GRANT
> 153 2 0 0 EXT 1:181656 X GRANT
> 153 2 0 0 EXT 1:189904 X GRANT
> 153 2 0 0 EXT 1:185784 X GRANT
> 153 2 0 0 EXT 1:181632 X GRANT
> 153 2 0 0 EXT 1:189896 X GRANT
> 153 2 0 0 EXT 1:185760 X GRANT
> 153 2 0 0 EXT 1:181640 X GRANT
> 153 2 0 0 EXT 1:189888 X GRANT
> 153 2 0 0 EXT 1:185768 X GRANT
> 153 2 0 0 EXT 1:189880 X GRANT
> 153 2 0 0 EXT 1:181744 X GRANT
> 153 2 0 0 EXT 1:185808 X GRANT
> 153 2 0 0 EXT 1:189872 X GRANT
> 153 2 0 0 EXT 1:181752 X GRANT
> 153 2 0 0 EXT 1:185816 X GRANT
> 153 2 0 0 EXT 1:189864 X GRANT
> 153 2 0 0 EXT 1:185792 X GRANT
> 153 2 0 0 EXT 1:189856 X GRANT
> 153 2 0 0 EXT 1:181736 X GRANT
> 153 2 0 0 EXT 1:185800 X GRANT
> 153 2 0 0 EXT 1:189848 X GRANT
> 153 2 0 0 EXT 1:185840 X GRANT
> 153 2 0 0 EXT 1:189840 X GRANT
> 153 2 0 0 EXT 1:189832 X GRANT
> 153 2 0 0 EXT 1:181696 X GRANT
> 153 2 0 0 EXT 1:185824 X GRANT
> 153 2 0 0 EXT 1:189824 X GRANT
> 153 2 0 0 EXT 1:185832 X GRANT
> 153 2 0 0 EXT 1:181296 X GRANT
> 153 2 0 0 EXT 1:189560 X GRANT
> 153 2 0 0 EXT 1:189552 X GRANT
> 153 2 0 0 EXT 1:181280 X GRANT
> 153 2 0 0 EXT 1:189544 X GRANT
> 153 2 0 0 EXT 1:185344 X GRANT
> 153 2 0 0 EXT 1:189944 X GRANT
> 153 2 0 0 EXT 1:185744 X GRANT
> 153 2 0 0 EXT 1:181688 X GRANT
> 153 2 0 0 EXT 1:189936 X GRANT
> 153 2 0 0 EXT 1:181680 X GRANT
> 153 2 0 0 EXT 1:181288 X GRANT
> 153 2 0 0 EXT 1:189536 X GRANT
> 153 2 0 0 EXT 1:181264 X GRANT
> 153 2 0 0 EXT 1:189528 X GRANT
> 153 2 0 0 EXT 1:181272 X GRANT
> 153 2 0 0 EXT 1:189520 X GRANT
> 153 2 0 0 EXT 1:181248 X GRANT
> 153 2 0 0 EXT 1:189512 X GRANT
> 153 2 0 0 EXT 1:181256 X GRANT
> 153 2 0 0 EXT 1:185424 X GRANT
> 153 2 0 0 EXT 1:181368 X GRANT
> 153 2 0 0 EXT 1:185432 X GRANT
> 153 12 0 0 DB S GRANT
> 153 2 0 0 EXT 1:182112 X GRANT
> 153 2 0 0 EXT 1:190248 X GRANT
> 153 2 0 0 EXT 1:182120 X GRANT
> 153 2 0 0 EXT 1:190240 X GRANT
> 153 2 0 0 EXT 1:186224 X GRANT
> 153 2 0 0 EXT 1:182096 X GRANT
> 153 2 0 0 EXT 1:190232 X GRANT
> 153 2 0 0 EXT 1:186232 X GRANT
> 153 2 0 0 EXT 1:182104 X GRANT
> 153 2 0 0 EXT 1:190224 X GRANT
> 153 2 0 0 EXT 1:186208 X GRANT
> 153 2 0 0 EXT 1:190216 X GRANT
> 153 2 0 0 EXT 1:186216 X GRANT
> 153 2 0 0 EXT 1:190208 X GRANT
> 153 2 0 0 EXT 1:186256 X GRANT
> 153 2 0 0 EXT 1:190456 X GRANT
> 153 2 0 0 EXT 1:182192 X GRANT
> 153 2 0 0 EXT 1:190448 X GRANT
> 153 2 0 0 EXT 1:182200 X GRANT
> 153 2 0 0 EXT 1:186240 X GRANT
> 153 2 0 0 EXT 1:190440 X GRANT
> 153 2 0 0 EXT 1:182176 X GRANT
> 153 2 0 0 EXT 1:186248 X GRANT
> 153 2 0 0 EXT 1:190432 X GRANT
> 153 2 0 0 EXT 1:182184 X GRANT
> 153 2 0 0 EXT 1:186288 X GRANT
> 153 2 0 0 EXT 1:190424 X GRANT
> 153 2 0 0 EXT 1:182160 X GRANT
> 153 2 0 0 EXT 1:186296 X GRANT
> 153 2 0 0 EXT 1:190416 X GRANT
> 153 2 0 0 EXT 1:182168 X GRANT
> 153 2 0 0 EXT 1:190408 X GRANT
> 153 2 0 0 EXT 1:182144 X GRANT
> 153 2 0 0 EXT 1:190400 X GRANT
> 153 2 0 0 EXT 1:182152 X GRANT
> 153 2 0 0 EXT 1:182256 X GRANT
> 153 2 0 0 EXT 1:190392 X GRANT
> 153 2 0 0 EXT 1:182264 X GRANT
> 153 2 0 0 EXT 1:190384 X GRANT
> 153 2 0 0 EXT 1:186304 X GRANT
> 153 2 0 0 EXT 1:182240 X GRANT
> 153 2 0 0 EXT 1:190376 X GRANT
> 153 2 0 0 EXT 1:186312 X GRANT
> 153 2 0 0 EXT 1:182248 X GRANT
> 153 2 0 0 EXT 1:190368 X GRANT
> 153 2 0 0 EXT 1:182224 X GRANT
> 153 2 0 0 EXT 1:190360 X GRANT
> 153 2 0 0 EXT 1:182232 X GRANT
> 153 2 0 0 EXT 1:190352 X GRANT
> 153 2 0 0 EXT 1:182208 X GRANT
> 153 2 0 0 EXT 1:190344 X GRANT
> 153 2 0 0 EXT 1:182216 X GRANT
> 153 2 0 0 EXT 1:190336 X GRANT
> 153 2 0 0 EXT 1:190072 X GRANT
> 153 2 0 0 EXT 1:181808 X GRANT
> 153 2 0 0 EXT 1:185880 X GRANT
> 153 2 0 0 EXT 1:190064 X GRANT
> 153 2 0 0 EXT 1:181816 X GRANT
> 153 2 0 0 EXT 1:185856 X GRANT
> 153 2 0 0 EXT 1:185416 X GRANT
> 153 2 0 0 EXT 1:181336 X GRANT
> 153 2 0 0 EXT 1:181312 X GRANT
> 153 2 0 0 EXT 1:189440 X GRANT
> 153 2 0 0 EXT 1:181424 X GRANT
> 153 2 0 0 EXT 1:189688 X GRANT
> 153 2 0 0 EXT 1:181432 X GRANT
> 153 2 0 0 EXT 1:189680 X GRANT
> 153 2 0 0 EXT 1:181408 X GRANT
> 153 2 0 0 EXT 1:189672 X GRANT
> 153 2 0 0 EXT 1:185472 X GRANT
> 153 2 0 0 EXT 1:181416 X GRANT
> 153 2 0 0 EXT 1:189664 X GRANT
> 153 2 0 0 EXT 1:181392 X GRANT
> 153 2 0 0 EXT 1:189656 X GRANT
> 153 2 0 0 EXT 1:181400 X GRANT
> 153 2 0 0 EXT 1:189648 X GRANT
> 153 2 0 0 EXT 1:181376 X GRANT
> 153 2 0 0 EXT 1:189640 X GRANT
> 153 2 0 0 EXT 1:181384 X GRANT
> 153 2 0 0 EXT 1:189632 X GRANT
> 153 2 0 0 EXT 1:189624 X GRANT
> 153 2 0 0 EXT 1:181488 X GRANT
> 153 2 0 0 EXT 1:185552 X GRANT
> 153 2 0 0 EXT 1:189616 X GRANT
> 153 2 0 0 EXT 1:181496 X GRANT
> 153 2 0 0 EXT 1:185560 X GRANT
> 153 2 0 0 EXT 1:189608 X GRANT
> 153 2 0 0 EXT 1:181472 X GRANT
> 153 2 0 0 EXT 1:189600 X GRANT
> 153 2 0 0 EXT 1:181480 X GRANT
> 153 2 0 0 EXT 1:181992 X GRANT
> 153 2 0 0 EXT 1:190112 X GRANT
> 153 2 0 0 EXT 1:181968 X GRANT
> 153 2 0 0 EXT 1:190104 X GRANT
> 153 2 0 0 EXT 1:186104 X GRANT
> 153 2 0 0 EXT 1:181976 X GRANT
> 153 2 0 0 EXT 1:190096 X GRANT
> 153 2 0 0 EXT 1:186080 X GRANT
> 153 2 0 0 EXT 1:181952 X GRANT
> 153 2 0 0 EXT 1:190088 X GRANT
> 153 2 0 0 EXT 1:186088 X GRANT
> 153 2 0 0 EXT 1:181960 X GRANT
> 153 2 0 0 EXT 1:190080 X GRANT
> 153 2 0 0 EXT 1:180536 X GRANT
> 153 2 0 0 EXT 1:188784 X GRANT
> 153 2 0 0 EXT 1:184600 X GRANT
> 153 2 0 0 EXT 1:180528 X GRANT
> 153 2 0 0 EXT 1:188792 X GRANT
> 153 2 0 0 EXT 1:184592 X GRANT
> 153 2 0 0 EXT 1:180520 X GRANT
> 153 2 0 0 EXT 1:188768 X GRANT
> 153 2 0 0 EXT 1:184584 X GRANT
> 153 2 0 0 EXT 1:180512 X GRANT
> 153 2 0 0 EXT 1:188776 X GRANT
> 153 2 0 0 EXT 1:184576 X GRANT
> 153 2 0 0 EXT 1:180504 X GRANT
> 153 2 0 0 EXT 1:188752 X GRANT
> 153 2 0 0 EXT 1:180496 X GRANT
> 153 2 0 0 EXT 1:188760 X GRANT
> 153 2 0 0 EXT 1:184624 X GRANT
> 153 2 0 0 EXT 1:180488 X GRANT
> 153 2 0 0 EXT 1:188736 X GRANT
> 153 2 0 0 EXT 1:184616 X GRANT
> 153 2 0 0 EXT 1:180480 X GRANT
> 153 2 0 0 EXT 1:188744 X GRANT
> 153 2 0 0 EXT 1:184608 X GRANT
> 153 2 0 0 EXT 1:188720 X GRANT
> 153 2 0 0 EXT 1:180600 X GRANT
> 153 2 0 0 EXT 1:192784 X GRANT
> 153 2 0 0 EXT 1:184664 X GRANT
> 153 2 0 0 EXT 1:188728 X GRANT
> 153 2 0 0 EXT 1:180592 X GRANT
> 153 2 0 0 EXT 1:188704 X GRANT
> 153 2 0 0 EXT 1:180584 X GRANT
> 153 2 0 0 EXT 1:192768 X GRANT
> 153 2 0 0 EXT 1:188712 X GRANT
> 153 2 0 0 EXT 1:180576 X GRANT
> 153 2 0 0 EXT 1:192776 X GRANT
> 153 2 0 0 EXT 1:188688 X GRANT
> 153 2 0 0 EXT 1:180568 X GRANT
> 153 2 0 0 EXT 1:184696 X GRANT
> 153 2 0 0 EXT 1:188696 X GRANT
> 153 2 0 0 EXT 1:180560 X GRANT
> 153 2 0 0 EXT 1:184688 X GRANT
> 153 2 0 0 EXT 1:188672 X GRANT
> 153 2 0 0 EXT 1:180552 X GRANT
> 153 2 0 0 EXT 1:184680 X GRANT
> 153 2 0 0 EXT 1:188680 X GRANT
> 153 2 0 0 EXT 1:180544 X GRANT
> 153 2 0 0 EXT 1:184672 X GRANT
> 153 2 0 0 EXT 1:180664 X GRANT
> 153 2 0 0 EXT 1:184728 X GRANT
> 153 2 0 0 EXT 1:180656 X GRANT
> 153 2 0 0 EXT 1:184720 X GRANT
> 153 2 0 0 EXT 1:180648 X GRANT
> 153 2 0 0 EXT 1:184712 X GRANT
> 153 2 0 0 EXT 1:180640 X GRANT
> 153 2 0 0 EXT 1:184704 X GRANT
> 153 2 0 0 EXT 1:180632 X GRANT
> 153 2 0 0 EXT 1:188880 X GRANT
> 153 2 0 0 EXT 1:184760 X GRANT
> 153 2 0 0 EXT 1:180624 X GRANT
> 153 2 0 0 EXT 1:184752 X GRANT
> 153 2 0 0 EXT 1:180616 X GRANT
> 153 2 0 0 EXT 1:184744 X GRANT
> 153 2 0 0 EXT 1:180608 X GRANT
> 153 2 0 0 EXT 1:184736 X GRANT
> 153 2 0 0 EXT 1:180728 X GRANT
> 153 2 0 0 EXT 1:188856 X GRANT
> 153 2 0 0 EXT 1:180720 X GRANT
> 153 2 0 0 EXT 1:184784 X GRANT
> 153 2 0 0 EXT 1:180712 X GRANT
> 153 2 0 0 EXT 1:184776 X GRANT
> 153 2 0 0 EXT 1:188840 X GRANT
> 153 2 0 0 EXT 1:180704 X GRANT
> 153 2 0 0 EXT 1:184768 X GRANT
> 153 2 0 0 EXT 1:180696 X GRANT
> 153 2 0 0 EXT 1:184824 X GRANT
> 153 2 0 0 EXT 1:188824 X GRANT
> 153 2 0 0 EXT 1:180688 X GRANT
> 153 2 0 0 EXT 1:180680 X GRANT
> 153 2 0 0 EXT 1:188808 X GRANT
> 153 2 0 0 EXT 1:180672 X GRANT
> 153 2 0 0 EXT 1:188528 X GRANT
> 153 2 0 0 EXT 1:184344 X GRANT
> 153 2 0 0 EXT 1:188536 X GRANT
> 153 2 0 0 EXT 1:184336 X GRANT
> 153 2 0 0 EXT 1:188512 X GRANT
> 153 2 0 0 EXT 1:184328 X GRANT
> 153 2 0 0 EXT 1:188520 X GRANT
> 153 2 0 0 EXT 1:184320 X GRANT
> 153 2 0 0 EXT 1:188496 X GRANT
> 153 2 0 0 EXT 1:184376 X GRANT
> 153 2 0 0 EXT 1:188504 X GRANT
> 153 2 0 0 EXT 1:184368 X GRANT
> 153 2 0 0 EXT 1:188480 X GRANT
> 153 2 0 0 EXT 1:184360 X GRANT
> 153 2 0 0 EXT 1:188488 X GRANT
> 153 2 0 0 EXT 1:184352 X GRANT
> 153 17 1562592755 0 TAB X GRANT
> 153 2 0 0 EXT 1:188464 X GRANT
> 153 2 0 0 EXT 1:180344 X GRANT
> 153 2 0 0 EXT 1:184408 X GRANT
> 153 2 0 0 EXT 1:188472 X GRANT
> 153 2 0 0 EXT 1:180336 X GRANT
> 153 2 0 0 EXT 1:184400 X GRANT
> 153 2 0 0 EXT 1:188448 X GRANT
> 153 2 0 0 EXT 1:180328 X GRANT
> 153 2 0 0 EXT 1:184392 X GRANT
> 153 2 0 0 EXT 1:188456 X GRANT
> 153 2 0 0 EXT 1:180320 X GRANT
> 153 2 0 0 EXT 1:184384 X GRANT
> 153 2 0 0 EXT 1:188432 X GRANT
> 153 2 0 0 EXT 1:180312 X GRANT
> 153 2 0 0 EXT 1:184440 X GRANT
> 153 2 0 0 EXT 1:188440 X GRANT
> 153 2 0 0 EXT 1:184432 X GRANT
> 153 2 0 0 EXT 1:188416 X GRANT
> 153 2 0 0 EXT 1:184424 X GRANT
> 153 2 0 0 EXT 1:188424 X GRANT
> 153 2 0 0 EXT 1:184416 X GRANT
> 153 2 0 0 EXT 1:180408 X GRANT
> 153 2 0 0 EXT 1:188656 X GRANT
> 153 2 0 0 EXT 1:184472 X GRANT
> 153 2 0 0 EXT 1:192720 X GRANT
> 153 2 0 0 EXT 1:180400 X GRANT
> 153 2 0 0 EXT 1:188664 X GRANT
> 153 2 0 0 EXT 1:184464 X GRANT
> 153 2 0 0 EXT 1:192728 X GRANT
> 153 2 0 0 EXT 1:180392 X GRANT
> 153 2 0 0 EXT 1:188640 X GRANT
> 153 2 0 0 EXT 1:184456 X GRANT
> 153 2 0 0 EXT 1:192704 X GRANT
> 153 2 0 0 EXT 1:180384 X GRANT
> 153 2 0 0 EXT 1:188648 X GRANT
> 153 2 0 0 EXT 1:184448 X GRANT
> 153 2 0 0 EXT 1:190288 X GRANT
> 153 2 0 0 EXT 1:190280 X GRANT
> 153 2 0 0 EXT 1:182016 X GRANT
> 153 2 0 0 EXT 1:186152 X GRANT
> 153 2 0 0 EXT 1:190272 X GRANT
> 153 2 0 0 EXT 1:182128 X GRANT
> 153 2 0 0 EXT 1:190264 X GRANT
> 153 2 0 0 EXT 1:186200 X GRANT
> 153 2 0 0 EXT 1:182136 X GRANT
> 153 2 0 0 EXT 1:190256 X GRANT
> 153 2 0 0 EXT 1:186056 X GRANT
> 153 2 0 0 EXT 1:190056 X GRANT
> 153 2 0 0 EXT 1:181792 X GRANT
> 153 2 0 0 EXT 1:185864 X GRANT
> 153 2 0 0 EXT 1:189280 X GRANT
> 153 2 0 0 EXT 1:181032 X GRANT
> 153 2 0 0 EXT 1:189288 X GRANT
> 153 2 0 0 EXT 1:181024 X GRANT
> 153 2 0 0 EXT 1:189264 X GRANT
> 153 2 0 0 EXT 1:181016 X GRANT
> 153 2 0 0 EXT 1:185136 X GRANT
> 153 2 0 0 EXT 1:189272 X GRANT
> 153 2 0 0 EXT 1:181008 X GRANT
> 153 2 0 0 EXT 1:185128 X GRANT
> 153 2 0 0 EXT 1:189248 X GRANT
> 153 2 0 0 EXT 1:181000 X GRANT
> 153 2 0 0 EXT 1:185120 X GRANT
> 153 2 0 0 EXT 1:189256 X GRANT
> 153 2 0 0 EXT 1:180992 X GRANT
> 153 2 0 0 EXT 1:185176 X GRANT
> 153 2 0 0 EXT 1:192712 X GRANT
> 153 2 0 0 EXT 1:180376 X GRANT
> 153 2 0 0 EXT 1:188624 X GRANT
> 153 2 0 0 EXT 1:184504 X GRANT
> 153 2 0 0 EXT 1:192752 X GRANT
> 153 2 0 0 EXT 1:180368 X GRANT
> 153 2 0 0 EXT 1:188632 X GRANT
> 153 2 0 0 EXT 1:184496 X GRANT
> 153 2 0 0 EXT 1:192760 X GRANT
> 153 2 0 0 EXT 1:180360 X GRANT
> 153 2 0 0 EXT 1:188608 X GRANT
> 153 2 0 0 EXT 1:184488 X GRANT
> 153 2 0 0 EXT 1:192736 X GRANT
> 153 2 0 0 EXT 1:180352 X GRANT
> 153 2 0 0 EXT 1:188616 X GRANT
> 153 2 0 0 EXT 1:184480 X GRANT
> 153 2 0 0 EXT 1:192744 X GRANT
> 153 2 0 0 EXT 1:188592 X GRANT
> 153 2 0 0 EXT 1:180472 X GRANT
> 153 2 0 0 EXT 1:192656 X GRANT
> 153 2 0 0 EXT 1:184536 X GRANT
> 153 2 0 0 EXT 1:188600 X GRANT
> 153 2 0 0 EXT 1:180464 X GRANT
> 153 2 0 0 EXT 1:192664 X GRANT
> 153 2 0 0 EXT 1:184528 X GRANT
> 153 2 0 0 EXT 1:188576 X GRANT
> 153 2 0 0 EXT 1:184520 X GRANT
> 153 2 0 0 EXT 1:188584 X GRANT
> 153 2 0 0 EXT 1:192648 X GRANT
> 153 2 0 0 EXT 1:184512 X GRANT
> 153 2 0 0 EXT 1:188560 X GRANT
> 153 2 0 0 EXT 1:192688 X GRANT
> 153 2 0 0 EXT 1:184568 X GRANT
> 153 2 0 0 EXT 1:188568 X GRANT
> 153 2 0 0 EXT 1:180432 X GRANT
> 153 2 0 0 EXT 1:190048 X GRANT
> 153 2 0 0 EXT 1:181800 X GRANT
> 153 2 0 0 EXT 1:190040 X GRANT
> 153 2 0 0 EXT 1:181776 X GRANT
> 153 2 0 0 EXT 1:185912 X GRANT
> 153 2 0 0 EXT 1:190032 X GRANT
> 153 2 0 0 EXT 1:181784 X GRANT
> 153 2 0 0 EXT 1:185888 X GRANT
> 153 2 0 0 EXT 1:190024 X GRANT
> 153 2 0 0 EXT 1:181760 X GRANT
> 153 2 0 0 EXT 1:190016 X GRANT
> 153 2 0 0 EXT 1:181768 X GRANT
> 153 2 0 0 EXT 1:185936 X GRANT
> 153 2 0 0 EXT 1:181872 X GRANT
> 153 2 0 0 EXT 1:190008 X GRANT
> 153 2 0 0 EXT 1:181880 X GRANT
> 153 2 0 0 EXT 1:190000 X GRANT
> 153 2 0 0 EXT 1:185920 X GRANT
> 153 2 0 0 EXT 1:181856 X GRANT
> 153 2 0 0 EXT 1:189992 X GRANT
> 153 2 0 0 EXT 1:185928 X GRANT
> 153 2 0 0 EXT 1:181864 X GRANT
> 153 2 0 0 EXT 1:189984 X GRANT
> 153 2 0 0 EXT 1:181840 X GRANT
> 153 2 0 0 EXT 1:189976 X GRANT
> 153 2 0 0 EXT 1:181848 X GRANT
> 153 2 0 0 EXT 1:189968 X GRANT
> 153 2 0 0 EXT 1:185952 X GRANT
> 153 2 0 0 EXT 1:181824 X GRANT
> 153 2 0 0 EXT 1:189960 X GRANT
> 153 2 0 0 EXT 1:181832 X GRANT
> 153 2 0 0 EXT 1:189952 X GRANT
> 153 2 0 0 EXT 1:190200 X GRANT
> 153 2 0 0 EXT 1:185544 X GRANT
> 153 2 0 0 EXT 1:189592 X GRANT
> 153 2 0 0 EXT 1:181456 X GRANT
> 153 2 0 0 EXT 1:185584 X GRANT
> 153 2 0 0 EXT 1:189584 X GRANT
> 153 2 0 0 EXT 1:181464 X GRANT
> 153 2 0 0 EXT 1:189576 X GRANT
> 153 2 0 0 EXT 1:181440 X GRANT
> 153 2 0 0 EXT 1:189568 X GRANT
> 153 2 0 0 EXT 1:181448 X GRANT
> 153 2 0 0 EXT 1:186128 X GRANT
> 153 2 0 0 EXT 1:190328 X GRANT
> 153 2 0 0 EXT 1:186136 X GRANT
> 153 2 0 0 EXT 1:190320 X GRANT
> 153 2 0 0 EXT 1:190312 X GRANT
> 153 2 0 0 EXT 1:186120 X GRANT
> 153 2 0 0 EXT 1:190304 X GRANT
> 153 2 0 0 EXT 1:182056 X GRANT
> 153 2 0 0 EXT 1:190296 X GRANT
> 153 2 0 0 EXT 1:190192 X GRANT
> 153 2 0 0 EXT 1:190184 X GRANT
> 153 2 0 0 EXT 1:190176 X GRANT
> 153 2 0 0 EXT 1:190168 X GRANT
> 153 2 0 0 EXT 1:181904 X GRANT
> 153 2 0 0 EXT 1:186040 X GRANT
> 153 2 0 0 EXT 1:190160 X GRANT
> 153 2 0 0 EXT 1:181912 X GRANT
> 153 2 0 0 EXT 1:186016 X GRANT
> 153 2 0 0 EXT 1:190152 X GRANT
> 153 2 0 0 EXT 1:181888 X GRANT
> 153 2 0 0 EXT 1:186024 X GRANT
> 153 2 0 0 EXT 1:190144 X GRANT
> 153 2 0 0 EXT 1:181896 X GRANT
> 153 2 0 0 EXT 1:186064 X GRANT
> 153 2 0 0 EXT 1:182000 X GRANT
> 153 2 0 0 EXT 1:190136 X GRANT
> 153 2 0 0 EXT 1:182008 X GRANT
> 153 2 0 0 EXT 1:190128 X GRANT
> 153 2 0 0 EXT 1:191768 X GRANT
> 153 2 0 0 EXT 1:183632 X GRANT
> 153 2 0 0 EXT 1:187760 X GRANT
> 153 2 0 0 EXT 1:191760 X GRANT
> 153 2 0 0 EXT 1:183640 X GRANT
> 153 2 0 0 EXT 1:187768 X GRANT
> 153 2 0 0 EXT 1:183712 X GRANT
> 153 2 0 0 EXT 1:191976 X GRANT
> 153 2 0 0 EXT 1:187776 X GRANT
> 153 2 0 0 EXT 1:191968 X GRANT
> 153 2 0 0 EXT 1:187784 X GRANT
> 153 2 0 0 EXT 1:191992 X GRANT
> 153 2 0 0 EXT 1:180832 X GRANT
> 153 2 0 0 EXT 1:188968 X GRANT
> 153 2 0 0 EXT 1:184952 X GRANT
> 153 2 0 0 EXT 1:180824 X GRANT
> 153 2 0 0 EXT 1:184944 X GRANT
> 153 2 0 0 EXT 1:180816 X GRANT
> 153 2 0 0 EXT 1:188952 X GRANT
> 153 2 0 0 EXT 1:184936 X GRANT
> 153 2 0 0 EXT 1:187792 X GRANT
> 153 2 0 0 EXT 1:191984 X GRANT
> 153 2 0 0 EXT 1:187800 X GRANT
> 153 2 0 0 EXT 1:183680 X GRANT
> 153 2 0 0 EXT 1:191944 X GRANT
> 153 2 0 0 EXT 1:187808 X GRANT
> 153 2 0 0 EXT 1:183688 X GRANT
> 153 2 0 0 EXT 1:191936 X GRANT
> 153 2 0 0 EXT 1:187816 X GRANT
> 153 2 0 0 EXT 1:183696 X GRANT
> 153 2 0 0 EXT 1:191960 X GRANT
> 153 2 0 0 EXT 1:187824 X GRANT
> 153 2 0 0 EXT 1:183704 X GRANT
> 153 2 0 0 EXT 1:191952 X GRANT
> 153 2 0 0 EXT 1:187832 X GRANT
> 153 2 0 0 EXT 1:191912 X GRANT
> 153 2 0 0 EXT 1:183776 X GRANT
> 153 2 0 0 EXT 1:187840 X GRANT
> 153 2 0 0 EXT 1:191904 X GRANT
> 153 2 0 0 EXT 1:183784 X GRANT
> 153 2 0 0 EXT 1:187848 X GRANT
> 153 2 0 0 EXT 1:191928 X GRANT
> 153 2 0 0 EXT 1:183792 X GRANT
> 153 2 0 0 EXT 1:187856 X GRANT
> 153 2 0 0 EXT 1:191920 X GRANT
> 153 2 0 0 EXT 1:183800 X GRANT
> 153 2 0 0 EXT 1:180808 X GRANT
> 153 2 0 0 EXT 1:184928 X GRANT
> 153 2 0 0 EXT 1:180800 X GRANT
> 153 2 0 0 EXT 1:184984 X GRANT
> 153 2 0 0 EXT 1:189168 X GRANT
> 153 2 0 0 EXT 1:184976 X GRANT
> 153 2 0 0 EXT 1:189176 X GRANT
> 153 2 0 0 EXT 1:184968 X GRANT
> 153 2 0 0 EXT 1:189152 X GRANT
> 153 2 0 0 EXT 1:180904 X GRANT
> 153 2 0 0 EXT 1:184960 X GRANT
> 153 2 0 0 EXT 1:189160 X GRANT
> 153 2 0 0 EXT 1:180896 X GRANT
> 153 2 0 0 EXT 1:185016 X GRANT
> 153 2 0 0 EXT 1:189136 X GRANT
> 153 2 0 0 EXT 1:180888 X GRANT
> 153 2 0 0 EXT 1:185008 X GRANT
> 153 2 0 0 EXT 1:189144 X GRANT
> 153 2 0 0 EXT 1:180880 X GRANT
> 153 2 0 0 EXT 1:185000 X GRANT
> 153 2 0 0 EXT 1:189120 X GRANT
> 153 2 0 0 EXT 1:184992 X GRANT
> 153 2 0 0 EXT 1:189128 X GRANT
> 153 2 0 0 EXT 1:180864 X GRANT
> 153 2 0 0 EXT 1:189008 X GRANT
> 153 2 0 0 EXT 1:180760 X GRANT
> 153 2 0 0 EXT 1:184880 X GRANT
> 153 2 0 0 EXT 1:189016 X GRANT
> 153 2 0 0 EXT 1:180752 X GRANT
> 153 2 0 0 EXT 1:184872 X GRANT
> 153 2 0 0 EXT 1:188992 X GRANT
> 153 2 0 0 EXT 1:180744 X GRANT
> 153 2 0 0 EXT 1:184864 X GRANT
> 153 2 0 0 EXT 1:189000 X GRANT
> 153 2 0 0 EXT 1:180736 X GRANT
> 153 2 0 0 EXT 1:184920 X GRANT
> 153 2 0 0 EXT 1:188976 X GRANT
> 153 2 0 0 EXT 1:188984 X GRANT
> 153 2 0 0 EXT 1:180840 X GRANT
> 153 2 0 0 EXT 1:188960 X GRANT
> 153 2 0 0 EXT 1:187456 X GRANT
> 153 2 0 0 EXT 1:187464 X GRANT
> 153 2 0 0 EXT 1:187472 X GRANT
> 153 2 0 0 EXT 1:183416 X GRANT
> 153 2 0 0 EXT 1:187480 X GRANT
> 153 2 0 0 EXT 1:187488 X GRANT
> 153 2 0 0 EXT 1:183368 X GRANT
> 153 2 0 0 EXT 1:187496 X GRANT
> 153 2 0 0 EXT 1:183376 X GRANT
> 153 2 0 0 EXT 1:187504 X GRANT
> 153 2 0 0 EXT 1:183384 X GRANT
> 153 2 0 0 EXT 1:187512 X GRANT
> 153 2 0 0 EXT 1:183456 X GRANT
> 153 2 0 0 EXT 1:187520 X GRANT
> 153 2 0 0 EXT 1:183464 X GRANT
> 153 2 0 0 EXT 1:187528 X GRANT
> 153 2 0 0 EXT 1:183472 X GRANT
> 153 2 0 0 EXT 1:187536 X GRANT
> 153 2 0 0 EXT 1:183480 X GRANT
> 153 2 0 0 EXT 1:187544 X GRANT
> 153 2 0 0 EXT 1:183424 X GRANT
> 153 2 0 0 EXT 1:187552 X GRANT
> 153 2 0 0 EXT 1:187560 X GRANT
> 153 12 1904478309 0 TAB S GRANT
> 153 2 0 0 EXT 1:187568 X GRANT
> 153 2 0 0 EXT 1:187576 X GRANT
> 153 2 0 0 EXT 1:183520 X GRANT
> 153 2 0 0 EXT 1:187584 X GRANT
> 153 2 0 0 EXT 1:183528 X GRANT
> 153 2 0 0 EXT 1:187592 X GRANT
> 153 2 0 0 EXT 1:191672 X GRANT
> 153 2 0 0 EXT 1:183536 X GRANT
> 153 2 0 0 EXT 1:187600 X GRANT
> 153 2 0 0 EXT 1:183544 X GRANT
> 153 2 0 0 EXT 1:187608 X GRANT
> 153 2 0 0 EXT 1:183488 X GRANT
> 153 2 0 0 EXT 1:187616 X GRANT
> 153 2 0 0 EXT 1:183496 X GRANT
> 153 2 0 0 EXT 1:187624 X GRANT
> 153 2 0 0 EXT 1:183504 X GRANT
> 153 2 0 0 EXT 1:187632 X GRANT
> 153 2 0 0 EXT 1:183512 X GRANT
> 153 2 0 0 EXT 1:187640 X GRANT
> 153 2 0 0 EXT 1:188160 X GRANT
> 153 2 0 0 EXT 1:184096 X GRANT
> 153 2 0 0 EXT 1:188168 X GRANT
> 153 2 0 0 EXT 1:184104 X GRANT
> 153 2 0 0 EXT 1:188176 X GRANT
> 153 2 0 0 EXT 1:184112 X GRANT
> 153 2 0 0 EXT 1:188184 X GRANT
> 153 2 0 0 EXT 1:184120 X GRANT
> 153 2 0 0 EXT 1:188192 X GRANT
> 153 2 0 0 EXT 1:184064 X GRANT
> 153 2 0 0 EXT 1:188200 X GRANT
> 153 2 0 0 EXT 1:184072 X GRANT
> 153 2 0 0 EXT 1:188208 X GRANT
> 153 2 0 0 EXT 1:184080 X GRANT
> 153 2 0 0 EXT 1:188216 X GRANT
> 153 2 0 0 EXT 1:184088 X GRANT
> 153 2 0 0 EXT 1:188224 X GRANT
> 153 2 0 0 EXT 1:184160 X GRANT
> 153 2 0 0 EXT 1:192296 X GRANT
> 153 2 0 0 EXT 1:188232 X GRANT
> 153 2 0 0 EXT 1:184168 X GRANT
> 153 2 0 0 EXT 1:192288 X GRANT
> 153 2 0 0 EXT 1:188240 X GRANT
> 153 2 0 0 EXT 1:184176 X GRANT
> 153 2 0 0 EXT 1:192312 X GRANT
> 153 2 0 0 EXT 1:188248 X GRANT
> 153 2 0 0 EXT 1:184184 X GRANT
> 153 2 0 0 EXT 1:192304 X GRANT
> 153 2 0 0 EXT 1:188256 X GRANT
> 153 2 0 0 EXT 1:184128 X GRANT
> 153 2 0 0 EXT 1:192264 X GRANT
> 153 2 0 0 EXT 1:181984 X GRANT
> 153 2 0 0 EXT 1:190120 X GRANT
> 153 2 0 0 EXT 1:181104 X GRANT
> 153 2 0 0 EXT 1:189240 X GRANT
> 153 2 0 0 EXT 1:181112 X GRANT
> 153 2 0 0 EXT 1:189232 X GRANT
> 153 2 0 0 EXT 1:192696 X GRANT
> 153 2 0 0 EXT 1:184560 X GRANT
> 153 2 0 0 EXT 1:188544 X GRANT
> 153 2 0 0 EXT 1:180424 X GRANT
> 153 2 0 0 EXT 1:192672 X GRANT
> 153 2 0 0 EXT 1:184552 X GRANT
> 153 2 0 0 EXT 1:188552 X GRANT
> 153 2 0 0 EXT 1:180416 X GRANT
> 153 2 0 0 EXT 1:192680 X GRANT
> 153 2 0 0 EXT 1:184544 X GRANT
> 153 2 0 0 EXT 1:185112 X GRANT
> 153 2 0 0 EXT 1:189296 X GRANT
> 153 2 0 0 EXT 1:189304 X GRANT
> 153 2 0 0 EXT 1:181040 X GRANT
> 153 2 0 0 EXT 1:189184 X GRANT
> 153 2 0 0 EXT 1:189192 X GRANT
> 153 2 0 0 EXT 1:185240 X GRANT
> 153 2 0 0 EXT 1:189424 X GRANT
> 153 2 0 0 EXT 1:181176 X GRANT
> 153 2 0 0 EXT 1:185232 X GRANT
> 153 2 0 0 EXT 1:181168 X GRANT
> 153 2 0 0 EXT 1:185224 X GRANT
> 153 2 0 0 EXT 1:189408 X GRANT
> 153 2 0 0 EXT 1:181160 X GRANT
> 153 2 0 0 EXT 1:181096 X GRANT
> 153 2 0 0 EXT 1:189216 X GRANT
> 153 2 0 0 EXT 1:181088 X GRANT
> 153 2 0 0 EXT 1:189224 X GRANT
> 153 2 0 0 EXT 1:181080 X GRANT
> 153 2 0 0 EXT 1:189200 X GRANT
> 153 2 0 0 EXT 1:181072 X GRANT
> 153 2 0 0 EXT 1:189208 X GRANT
> 153 2 0 0 EXT 1:181128 X GRANT
> 153 2 0 0 EXT 1:189384 X GRANT
> 153 2 0 0 EXT 1:181120 X GRANT
> 153 2 0 0 EXT 1:185304 X GRANT
> 153 2 0 0 EXT 1:181240 X GRANT
> 153 2 0 0 EXT 1:185296 X GRANT
> 153 2 0 0 EXT 1:181232 X GRANT
> 153 2 0 0 EXT 1:189368 X GRANT
> 153 2 0 0 EXT 1:185288 X GRANT
> 153 2 0 0 EXT 1:181224 X GRANT
> 153 2 0 0 EXT 1:189344 X GRANT
> 153 2 0 0 EXT 1:185280 X GRANT
> 153 2 0 0 EXT 1:181216 X GRANT
> 153 2 0 0 EXT 1:185336 X GRANT
> 153 2 0 0 EXT 1:181208 X GRANT
> 153 2 0 0 EXT 1:189328 X GRANT
> 153 2 0 0 EXT 1:185328 X GRANT
> 153 2 0 0 EXT 1:181200 X GRANT
> 153 2 0 0 EXT 1:189336 X GRANT
> 153 2 0 0 EXT 1:185320 X GRANT
> 153 2 0 0 EXT 1:181192 X GRANT
> 153 2 0 0 EXT 1:189312 X GRANT
> 153 2 0 0 EXT 1:185312 X GRANT
> 153 2 0 0 EXT 1:181184 X GRANT
> 153 2 0 0 EXT 1:189320 X GRANT
> 153 2 0 0 EXT 1:184856 X GRANT
> 153 2 0 0 EXT 1:189040 X GRANT
> 153 2 0 0 EXT 1:180792 X GRANT
> 153 2 0 0 EXT 1:184848 X GRANT
> 153 2 0 0 EXT 1:189048 X GRANT
> 153 2 0 0 EXT 1:180784 X GRANT
> 153 2 0 0 EXT 1:184840 X GRANT
> 153 2 0 0 EXT 1:189024 X GRANT
> 153 2 0 0 EXT 1:180776 X GRANT
> 153 2 0 0 EXT 1:184832 X GRANT
> 153 2 0 0 EXT 1:189032 X GRANT
> 153 2 0 0 EXT 1:180768 X GRANT
> 153 2 0 0 EXT 1:185048 X GRANT
> 153 2 0 0 EXT 1:180984 X GRANT
> 153 2 0 0 EXT 1:189104 X GRANT
> 153 2 0 0 EXT 1:185040 X GRANT
> 153 2 0 0 EXT 1:180976 X GRANT
> 153 2 0 0 EXT 1:189112 X GRANT
> 153 2 0 0 EXT 1:185032 X GRANT
> 153 2 0 0 EXT 1:180968 X GRANT
> 153 2 0 0 EXT 1:189088 X GRANT
> 153 2 0 0 EXT 1:185024 X GRANT
> 153 2 0 0 EXT 1:180960 X GRANT
> 153 2 0 0 EXT 1:189096 X GRANT
> 153 2 0 0 EXT 1:180952 X GRANT
> 153 2 0 0 EXT 1:189072 X GRANT
> 153 2 0 0 EXT 1:185072 X GRANT
> 153 2 0 0 EXT 1:180944 X GRANT
> 153 2 0 0 EXT 1:189080 X GRANT
> 153 2 0 0 EXT 1:185064 X GRANT
> 153 2 0 0 EXT 1:180936 X GRANT
> 153 2 0 0 EXT 1:189056 X GRANT
> 153 2 0 0 EXT 1:185056 X GRANT
> 153 2 0 0 EXT 1:189064 X GRANT
> 153 2 0 0 EXT 1:183584 X GRANT
> 153 2 0 0 EXT 1:191848 X GRANT
> 153 2 0 0 EXT 1:187648 X GRANT
> 153 2 0 0 EXT 1:183592 X GRANT
> 153 2 0 0 EXT 1:191840 X GRANT
> 153 2 0 0 EXT 1:187656 X GRANT
> 153 2 0 0 EXT 1:183600 X GRANT
> 153 2 0 0 EXT 1:191864 X GRANT
> 153 2 0 0 EXT 1:187664 X GRANT
> 153 2 0 0 EXT 1:183608 X GRANT
> 153 2 0 0 EXT 1:191856 X GRANT
> 153 2 0 0 EXT 1:187672 X GRANT
> 153 2 0 0 EXT 1:183552 X GRANT
> 153 2 0 0 EXT 1:191816 X GRANT
> 153 2 0 0 EXT 1:187680 X GRANT
> 153 2 0 0 EXT 1:183560 X GRANT
> 153 2 0 0 EXT 1:191808 X GRANT
> 153 2 0 0 EXT 1:187688 X GRANT
> 153 2 0 0 EXT 1:183568 X GRANT
> 153 2 0 0 EXT 1:191832 X GRANT
> 153 2 0 0 EXT 1:187696 X GRANT
> 153 2 0 0 EXT 1:183576 X GRANT
> 153 2 0 0 EXT 1:191824 X GRANT
> 153 2 0 0 EXT 1:187704 X GRANT
> 153 2 0 0 EXT 1:191784 X GRANT
> 153 2 0 0 EXT 1:183648 X GRANT
> 153 2 0 0 EXT 1:187712 X GRANT
> 153 2 0 0 EXT 1:191776 X GRANT
> 153 2 0 0 EXT 1:183656 X GRANT
> 153 2 0 0 EXT 1:187720 X GRANT
> 153 2 0 0 EXT 1:191800 X GRANT
> 153 2 0 0 EXT 1:183664 X GRANT
> 153 2 0 0 EXT 1:187728 X GRANT
> 153 2 0 0 EXT 1:191792 X GRANT
> 153 2 0 0 EXT 1:183672 X GRANT
> 153 2 0 0 EXT 1:187736 X GRANT
> 153 2 0 0 EXT 1:191752 X GRANT
> 153 2 0 0 EXT 1:183616 X GRANT
> 153 2 0 0 EXT 1:187744 X GRANT
> 153 2 0 0 EXT 1:191744 X GRANT
> 153 2 0 0 EXT 1:183624 X GRANT
> 153 2 0 0 EXT 1:187752 X GRANT
> 153 2 0 0 EXT 1:186736 X GRANT
> 153 2 0 0 EXT 1:190944 X GRANT
> 153 2 0 0 EXT 1:190952 X GRANT
> 153 2 0 0 EXT 1:182712 X GRANT
> 153 2 0 0 EXT 1:190960 X GRANT
> 153 2 0 0 EXT 1:186776 X GRANT
> 153 2 0 0 EXT 1:182704 X GRANT
> 153 2 0 0 EXT 1:190968 X GRANT
> 153 2 0 0 EXT 1:182664 X GRANT
> 153 2 0 0 EXT 1:190912 X GRANT
> 153 2 0 0 EXT 1:186792 X GRANT
> 153 2 0 0 EXT 1:182656 X GRANT
> 153 2 0 0 EXT 1:190920 X GRANT
> 153 2 0 0 EXT 1:186784 X GRANT
> 153 2 0 0 EXT 1:190928 X GRANT
> 153 2 0 0 EXT 1:186808 X GRANT
> 153 2 0 0 EXT 1:190936 X GRANT
> 153 2 0 0 EXT 1:186800 X GRANT
> 153 2 0 0 EXT 1:190880 X GRANT
> 153 2 0 0 EXT 1:190888 X GRANT
> 153 2 0 0 EXT 1:190896 X GRANT
> 153 2 0 0 EXT 1:182776 X GRANT
> 153 2 0 0 EXT 1:190904 X GRANT
> 153 2 0 0 EXT 1:190848 X GRANT
> 153 2 0 0 EXT 1:186856 X GRANT
> 153 2 0 0 EXT 1:190856 X GRANT
> 153 2 0 0 EXT 1:186848 X GRANT
> 153 2 0 0 EXT 1:190864 X GRANT
> 153 2 0 0 EXT 1:182744 X GRANT
> 153 2 0 0 EXT 1:186872 X GRANT
> 153 2 0 0 EXT 1:190872 X GRANT
> 153 2 0 0 EXT 1:182736 X GRANT
> 153 2 0 0 EXT 1:186864 X GRANT
> 153 2 0 0 EXT 1:182312 X GRANT
> 153 2 0 0 EXT 1:190560 X GRANT
> 153 2 0 0 EXT 1:182304 X GRANT
> 153 2 0 0 EXT 1:190568 X GRANT
> 153 2 0 0 EXT 1:182328 X GRANT
> 153 2 0 0 EXT 1:190576 X GRANT
> 153 2 0 0 EXT 1:186392 X GRANT
> 153 2 0 0 EXT 1:182320 X GRANT
> 153 2 0 0 EXT 1:190584 X GRANT
> 153 2 0 0 EXT 1:182280 X GRANT
> 153 2 0 0 EXT 1:190528 X GRANT
> 153 2 0 0 EXT 1:182272 X GRANT
> 153 2 0 0 EXT 1:190536 X GRANT
> 153 2 0 0 EXT 1:182296 X GRANT
> 153 2 0 0 EXT 1:190544 X GRANT
> 153 2 0 0 EXT 1:186424 X GRANT
> 153 2 0 0 EXT 1:182288 X GRANT
> 153 2 0 0 EXT 1:190552 X GRANT
> 153 2 0 0 EXT 1:190496 X GRANT
> 153 2 0 0 EXT 1:182376 X GRANT
> 153 2 0 0 EXT 1:186440 X GRANT
> 153 2 0 0 EXT 1:190504 X GRANT
> 153 2 0 0 EXT 1:182368 X GRANT
> 153 2 0 0 EXT 1:186432 X GRANT
> 153 2 0 0 EXT 1:190512 X GRANT
> 153 2 0 0 EXT 1:182392 X GRANT
> 153 2 0 0 EXT 1:186456 X GRANT
> 153 2 0 0 EXT 1:190520 X GRANT
> 153 2 0 0 EXT 1:182384 X GRANT
> 153 2 0 0 EXT 1:186448 X GRANT
> 153 2 0 0 EXT 1:190464 X GRANT
> 153 2 0 0 EXT 1:182344 X GRANT
> 153 2 0 0 EXT 1:186472 X GRANT
> 153 2 0 0 EXT 1:190472 X GRANT
> 153 2 0 0 EXT 1:182336 X GRANT
> 153 2 0 0 EXT 1:186464 X GRANT
> 153 2 0 0 EXT 1:190480 X GRANT
> 153 2 0 0 EXT 1:182360 X GRANT
> 153 2 0 0 EXT 1:186488 X GRANT
> 153 2 0 0 EXT 1:190488 X GRANT
> 153 2 0 0 EXT 1:182352 X GRANT
> 153 2 0 0 EXT 1:186480 X GRANT
> 153 2 0 0 EXT 1:182440 X GRANT
> 153 2 0 0 EXT 1:190688 X GRANT
> 153 2 0 0 EXT 1:186504 X GRANT
> 153 2 0 0 EXT 1:182432 X GRANT
> 153 2 0 0 EXT 1:190696 X GRANT
> 153 2 0 0 EXT 1:182456 X GRANT
> 153 2 0 0 EXT 1:190704 X GRANT
> 153 2 0 0 EXT 1:182448 X GRANT
> 153 2 0 0 EXT 1:190712 X GRANT
> 153 2 0 0 EXT 1:182408 X GRANT
> 153 2 0 0 EXT 1:190656 X GRANT
> 153 2 0 0 EXT 1:182400 X GRANT
> 153 2 0 0 EXT 1:190664 X GRANT
> 153 2 0 0 EXT 1:186528 X GRANT
> 153 2 0 0 EXT 1:182424 X GRANT
> 153 2 0 0 EXT 1:190672 X GRANT
> 153 2 0 0 EXT 1:182416 X GRANT
> 153 2 0 0 EXT 1:190680 X GRANT
> 153 2 0 0 EXT 1:190624 X GRANT
> 153 2 0 0 EXT 1:182504 X GRANT
> 153 2 0 0 EXT 1:190632 X GRANT
> 153 2 0 0 EXT 1:182496 X GRANT
> 153 2 0 0 EXT 1:186560 X GRANT
> 153 2 0 0 EXT 1:190640 X GRANT
> 153 2 0 0 EXT 1:182520 X GRANT
> 153 2 0 0 EXT 1:186584 X GRANT
> 153 2 0 0 EXT 1:190648 X GRANT
> 153 2 0 0 EXT 1:182512 X GRANT
> 153 2 0 0 EXT 1:186576 X GRANT
> 153 2 0 0 EXT 1:190592 X GRANT
> 153 2 0 0 EXT 1:182472 X GRANT
> 153 2 0 0 EXT 1:186600 X GRANT
> 153 2 0 0 EXT 1:190600 X GRANT
> 153 2 0 0 EXT 1:182464 X GRANT
> 153 2 0 0 EXT 1:190608 X GRANT
> 153 2 0 0 EXT 1:182488 X GRANT
> 153 2 0 0 EXT 1:186616 X GRANT
> 153 2 0 0 EXT 1:190616 X GRANT
> 153 2 0 0 EXT 1:182480 X GRANT
> 153 2 0 0 EXT 1:186608 X GRANT
> 153 2 0 0 EXT 1:187144 X GRANT
> 153 2 0 0 EXT 1:191328 X GRANT
> 153 2 0 0 EXT 1:183080 X GRANT
> 153 2 0 0 EXT 1:187136 X GRANT
> 153 2 0 0 EXT 1:191336 X GRANT
> 153 2 0 0 EXT 1:183072 X GRANT
> 153 2 0 0 EXT 1:187160 X GRANT
> 153 2 0 0 EXT 1:191344 X GRANT
> 153 2 0 0 EXT 1:183096 X GRANT
> 153 2 0 0 EXT 1:187152 X GRANT
> 153 2 0 0 EXT 1:191352 X GRANT
> 153 2 0 0 EXT 1:183088 X GRANT
> 153 2 0 0 EXT 1:187176 X GRANT
> 153 2 0 0 EXT 1:191296 X GRANT
> 153 2 0 0 EXT 1:183048 X GRANT
> 153 2 0 0 EXT 1:187168 X GRANT
> 153 2 0 0 EXT 1:191304 X GRANT
> 153 2 0 0 EXT 1:183040 X GRANT
> 153 2 0 0 EXT 1:187192 X GRANT
> 153 2 0 0 EXT 1:191312 X GRANT
> 153 2 0 0 EXT 1:183064 X GRANT
> 153 2 0 0 EXT 1:187184 X GRANT
> 153 2 0 0 EXT 1:191320 X GRANT
> 153 2 0 0 EXT 1:183056 X GRANT
> 153 2 0 0 EXT 1:187208 X GRANT
> 153 2 0 0 EXT 1:183144 X GRANT
> 153 2 0 0 EXT 1:191264 X GRANT
> 153 2 0 0 EXT 1:187200 X GRANT
> 153 2 0 0 EXT 1:183136 X GRANT
> 153 2 0 0 EXT 1:191272 X GRANT
> 153 2 0 0 EXT 1:187224 X GRANT
> 153 2 0 0 EXT 1:183160 X GRANT
> 153 2 0 0 EXT 1:191280 X GRANT
> 153 2 0 0 EXT 1:187216 X GRANT
> 153 2 0 0 EXT 1:183152 X GRANT
> 153 2 0 0 EXT 1:191288 X GRANT
> 153 2 0 0 EXT 1:187240 X GRANT
> 153 2 0 0 EXT 1:183112 X GRANT
> 153 2 0 0 EXT 1:191232 X GRANT
> 153 2 0 0 EXT 1:187232 X GRANT
> 153 2 0 0 EXT 1:183104 X GRANT
> 153 2 0 0 EXT 1:191240 X GRANT
> 153 2 0 0 EXT 1:187256 X GRANT
> 153 2 0 0 EXT 1:183128 X GRANT
> 153 2 0 0 EXT 1:191248 X GRANT
> 153 2 0 0 EXT 1:187248 X GRANT
> 153 2 0 0 EXT 1:183120 X GRANT
> 153 2 0 0 EXT 1:191256 X GRANT
> 153 2 0 0 EXT 1:187272 X GRANT
> 153 2 0 0 EXT 1:183208 X GRANT
> 153 2 0 0 EXT 1:187264 X GRANT
> 153 2 0 0 EXT 1:183200 X GRANT
> 153 2 0 0 EXT 1:187288 X GRANT
> 153 2 0 0 EXT 1:191472 X GRANT
> 153 2 0 0 EXT 1:183224 X GRANT
> 153 2 0 0 EXT 1:192192 X GRANT
> 153 2 0 0 EXT 1:183944 X GRANT
> 153 2 0 0 EXT 1:188080 X GRANT
> 153 2 0 0 EXT 1:192216 X GRANT
> 153 2 0 0 EXT 1:183952 X GRANT
> 153 2 0 0 EXT 1:188088 X GRANT
> 153 2 0 0 EXT 1:192208 X GRANT
> 153 2 0 0 EXT 1:183960 X GRANT
> 153 2 0 0 EXT 1:188096 X GRANT
> 153 2 0 0 EXT 1:184032 X GRANT
> 153 2 0 0 EXT 1:192168 X GRANT
> 153 2 0 0 EXT 1:188104 X GRANT
> 153 2 0 0 EXT 1:184040 X GRANT
> 153 2 0 0 EXT 1:192160 X GRANT
> 153 2 0 0 EXT 1:188112 X GRANT
> 153 2 0 0 EXT 1:184048 X GRANT
> 153 2 0 0 EXT 1:192184 X GRANT
> 153 2 0 0 EXT 1:188120 X GRANT
> 153 2 0 0 EXT 1:184056 X GRANT
> 153 2 0 0 EXT 1:192176 X GRANT
> 153 2 0 0 EXT 1:188128 X GRANT
> 153 2 0 0 EXT 1:192136 X GRANT
> 153 2 0 0 EXT 1:188136 X GRANT
> 153 2 0 0 EXT 1:184008 X GRANT
> 153 2 0 0 EXT 1:192128 X GRANT
> 153 2 0 0 EXT 1:188144 X GRANT
> 153 2 0 0 EXT 1:184016 X GRANT
> 153 2 0 0 EXT 1:192152 X GRANT
> 153 2 0 0 EXT 1:188152 X GRANT
> 153 2 0 0 EXT 1:184024 X GRANT
> 153 2 0 0 EXT 1:192144 X GRANT
> 153 2 0 0 EXT 1:182568 X GRANT
> 153 2 0 0 EXT 1:190816 X GRANT
> 153 2 0 0 EXT 1:186632 X GRANT
> 153 2 0 0 EXT 1:190824 X GRANT
> 153 2 0 0 EXT 1:186624 X GRANT
> 153 2 0 0 EXT 1:182584 X GRANT
> 153 2 0 0 EXT 1:190832 X GRANT
> 153 2 0 0 EXT 1:186648 X GRANT
> 153 2 0 0 EXT 1:182576 X GRANT
> 153 2 0 0 EXT 1:190840 X GRANT
> 153 2 0 0 EXT 1:186640 X GRANT
> 153 2 0 0 EXT 1:190784 X GRANT
> 153 2 0 0 EXT 1:187880 X GRANT
> 153 2 0 0 EXT 1:191896 X GRANT
> 153 2 0 0 EXT 1:183760 X GRANT
> 153 2 0 0 EXT 1:187888 X GRANT
> 153 2 0 0 EXT 1:191888 X GRANT
> 153 2 0 0 EXT 1:183768 X GRANT
> 153 2 0 0 EXT 1:187896 X GRANT
> 153 2 0 0 EXT 1:183328 X GRANT
> 153 2 0 0 EXT 1:187392 X GRANT
> 153 2 0 0 EXT 1:187400 X GRANT
> 153 2 0 0 EXT 1:187408 X GRANT
> 153 2 0 0 EXT 1:183352 X GRANT
> 153 2 0 0 EXT 1:187416 X GRANT
> 153 2 0 0 EXT 1:187424 X GRANT
> 153 2 0 0 EXT 1:183304 X GRANT
> 153 2 0 0 EXT 1:187432 X GRANT
> 153 2 0 0 EXT 1:187440 X GRANT
> 153 2 0 0 EXT 1:183320 X GRANT
> 153 2 0 0 EXT 1:187448 X GRANT
> 153 2 0 0 EXT 1:188264 X GRANT
> 153 2 0 0 EXT 1:184136 X GRANT
> 153 2 0 0 EXT 1:192256 X GRANT
> 153 2 0 0 EXT 1:188272 X GRANT
> 153 2 0 0 EXT 1:184144 X GRANT
> 153 2 0 0 EXT 1:192280 X GRANT
> 153 2 0 0 EXT 1:188280 X GRANT
> 153 2 0 0 EXT 1:184152 X GRANT
> 153 2 0 0 EXT 1:192272 X GRANT
> 153 2 0 0 EXT 1:188288 X GRANT
> 153 2 0 0 EXT 1:184224 X GRANT
> 153 2 0 0 EXT 1:192480 X GRANT
> 153 2 0 0 EXT 1:184232 X GRANT
> 153 2 0 0 EXT 1:184240 X GRANT
> 153 2 0 0 EXT 1:184248 X GRANT
> 153 2 0 0 EXT 1:184192 X GRANT
> 153 2 0 0 EXT 1:188328 X GRANT
> 153 2 0 0 EXT 1:184296 X GRANT
> 153 2 0 0 EXT 1:188368 X GRANT
> 153 2 0 0 EXT 1:184304 X GRANT
> 153 2 0 0 EXT 1:188376 X GRANT
> 153 2 0 0 EXT 1:184312 X GRANT
> 153 2 0 0 EXT 1:188384 X GRANT
> 153 2 0 0 EXT 1:184256 X GRANT
> 153 2 0 0 EXT 1:188392 X GRANT
> 153 2 0 0 EXT 1:184264 X GRANT
> 153 2 0 0 EXT 1:188400 X GRANT
> 153 2 0 0 EXT 1:184272 X GRANT
> 153 2 0 0 EXT 1:188408 X GRANT
> 153 2 0 0 EXT 1:184280 X GRANT
> 153 2 0 0 EXT 1:187904 X GRANT
> 153 2 0 0 EXT 1:192104 X GRANT
> 153 2 0 0 EXT 1:183840 X GRANT
> 153 2 0 0 EXT 1:187912 X GRANT
> 153 2 0 0 EXT 1:192096 X GRANT
> 153 2 0 0 EXT 1:183848 X GRANT
> 153 2 0 0 EXT 1:187920 X GRANT
> 153 2 0 0 EXT 1:192120 X GRANT
> 153 2 0 0 EXT 1:183856 X GRANT
> 153 2 0 0 EXT 1:187928 X GRANT
> 153 2 0 0 EXT 1:192112 X GRANT
> 153 2 0 0 EXT 1:183864 X GRANT
> 153 2 0 0 EXT 1:187936 X GRANT
> 153 2 0 0 EXT 1:192072 X GRANT
> 153 2 0 0 EXT 1:183808 X GRANT
> 153 2 0 0 EXT 1:187944 X GRANT
> 153 2 0 0 EXT 1:192064 X GRANT
> 153 2 0 0 EXT 1:183816 X GRANT
> 153 2 0 0 EXT 1:187952 X GRANT
> 153 2 0 0 EXT 1:192088 X GRANT
> 153 2 0 0 EXT 1:183824 X GRANT
> 153 2 0 0 EXT 1:187960 X GRANT
> 153 2 0 0 EXT 1:192080 X GRANT
> 153 2 0 0 EXT 1:183832 X GRANT
> 153 2 0 0 EXT 1:187968 X GRANT
> 153 2 0 0 EXT 1:183904 X GRANT
> 153 2 0 0 EXT 1:192040 X GRANT
> 153 2 0 0 EXT 1:187976 X GRANT
> 153 2 0 0 EXT 1:192032 X GRANT
> 153 2 0 0 EXT 1:187984 X GRANT
> 153 2 0 0 EXT 1:192056 X GRANT
> 153 2 0 0 EXT 1:187992 X GRANT
> 153 2 0 0 EXT 1:192048 X GRANT
> 153 2 0 0 EXT 1:188000 X GRANT
> 153 2 0 0 EXT 1:183872 X GRANT
> 153 2 0 0 EXT 1:192008 X GRANT
> 153 17 1562592755 1 PAG 1:25290761 IU GRANT
> 153 2 0 0 EXT 1:188008 X GRANT
> 153 2 0 0 EXT 1:183880 X GRANT
> 153 2 0 0 EXT 1:192000 X GRANT
> 153 2 0 0 EXT 1:188016 X GRANT
> 153 2 0 0 EXT 1:183888 X GRANT
> 153 2 0 0 EXT 1:192024 X GRANT
> 153 2 0 0 EXT 1:188024 X GRANT
> 153 2 0 0 EXT 1:183896 X GRANT
> 153 2 0 0 EXT 1:192016 X GRANT
> 153 2 0 0 EXT 1:188032 X GRANT
> 153 2 0 0 EXT 1:192232 X GRANT
> 153 2 0 0 EXT 1:183968 X GRANT
> 153 2 0 0 EXT 1:188040 X GRANT
> 153 2 0 0 EXT 1:192224 X GRANT
> 153 2 0 0 EXT 1:188048 X GRANT
> 153 2 0 0 EXT 1:192248 X GRANT
> 153 2 0 0 EXT 1:188056 X GRANT
> 153 2 0 0 EXT 1:192240 X GRANT
> 153 2 0 0 EXT 1:188064 X GRANT
> 153 2 0 0 EXT 1:192200 X GRANT
> 153 2 0 0 EXT 1:188072 X GRANT
> 153 2 0 0 EXT 1:187864 X GRANT
> 153 2 0 0 EXT 1:191880 X GRANT
> 153 2 0 0 EXT 1:187872 X GRANT
> 153 2 0 0 EXT 1:191872 X GRANT
> 153 2 0 0 EXT 1:183752 X GRANT
> 153 2 0 0 EXT 1:189392 X GRANT
> 153 2 0 0 EXT 1:184200 X GRANT
> 153 2 0 0 EXT 1:188336 X GRANT
> 153 2 0 0 EXT 1:184208 X GRANT
> 153 2 0 0 EXT 1:188344 X GRANT
> 153 2 0 0 EXT 1:186664 X GRANT
> 153 2 0 0 EXT 1:190792 X GRANT
> 153 2 0 0 EXT 1:186656 X GRANT
> 153 2 0 0 EXT 1:190800 X GRANT
> 153 2 0 0 EXT 1:182544 X GRANT
> 153 2 0 0 EXT 1:190808 X GRANT
> 153 2 0 0 EXT 1:186672 X GRANT
> 153 2 0 0 EXT 1:190752 X GRANT
> 153 2 0 0 EXT 1:182632 X GRANT
> 153 2 0 0 EXT 1:186696 X GRANT
> 153 2 0 0 EXT 1:190760 X GRANT
> 153 2 0 0 EXT 1:186688 X GRANT
> 153 2 0 0 EXT 1:190768 X GRANT
> 153 2 0 0 EXT 1:186712 X GRANT
> 153 2 0 0 EXT 1:190776 X GRANT
> 153 2 0 0 EXT 1:182640 X GRANT
> 153 2 0 0 EXT 1:186704 X GRANT
> 153 2 0 0 EXT 1:190720 X GRANT
> 153 2 0 0 EXT 1:186728 X GRANT
> 153 2 0 0 EXT 1:190728 X GRANT
> 153 2 0 0 EXT 1:186720 X GRANT
> 153 2 0 0 EXT 1:190736 X GRANT
> 153 2 0 0 EXT 1:182616 X GRANT
> 153 2 0 0 EXT 1:190744 X GRANT
> 153 2 0 0 EXT 1:182608 X GRANT
> 153 2 0 0 EXT 1:187280 X GRANT
> 153 2 0 0 EXT 1:184216 X GRANT
> 153 2 0 0 EXT 1:188352 X GRANT
> 153 2 0 0 EXT 1:184288 X GRANT
> 153 2 0 0 EXT 1:188360 X GRANT
> 153 2 0 0 EXT 1:183216 X GRANT
> 153 2 0 0 EXT 1:187304 X GRANT
> 153 2 0 0 EXT 1:183176 X GRANT
> 153 2 0 0 EXT 1:187296 X GRANT
> 153 2 0 0 EXT 1:183168 X GRANT
> 153 2 0 0 EXT 1:187320 X GRANT
> 153 2 0 0 EXT 1:183192 X GRANT
> 153 2 0 0 EXT 1:187312 X GRANT
> 153 2 0 0 EXT 1:183184 X GRANT
> 153 2 0 0 EXT 1:187336 X GRANT
> 153 2 0 0 EXT 1:183272 X GRANT
> 153 2 0 0 EXT 1:187328 X GRANT
> 153 2 0 0 EXT 1:183264 X GRANT
> 153 2 0 0 EXT 1:187352 X GRANT
> 153 2 0 0 EXT 1:187344 X GRANT
> 153 2 0 0 EXT 1:183280 X GRANT
> 153 2 0 0 EXT 1:187368 X GRANT
> 153 2 0 0 EXT 1:191360 X GRANT
> 153 2 0 0 EXT 1:187360 X GRANT
> 153 2 0 0 EXT 1:191368 X GRANT
> 153 2 0 0 EXT 1:187384 X GRANT
> 153 2 0 0 EXT 1:187376 X GRANT
> 153 2 0 0 EXT 1:183248 X GRANT
> 153 2 0 0 EXT 1:186888 X GRANT
> 153 2 0 0 EXT 1:191072 X GRANT
> 153 2 0 0 EXT 1:182824 X GRANT
> 153 2 0 0 EXT 1:186880 X GRANT
> 153 2 0 0 EXT 1:191080 X GRANT
> 153 2 0 0 EXT 1:186904 X GRANT
> 153 2 0 0 EXT 1:191088 X GRANT
> 153 2 0 0 EXT 1:186896 X GRANT
> 153 2 0 0 EXT 1:191096 X GRANT
> 153 2 0 0 EXT 1:186920 X GRANT
> 153 2 0 0 EXT 1:191040 X GRANT
> 153 2 0 0 EXT 1:182792 X GRANT
> 153 2 0 0 EXT 1:186912 X GRANT
> 153 2 0 0 EXT 1:191048 X GRANT
> 153 2 0 0 EXT 1:182784 X GRANT
> 153 2 0 0 EXT 1:186936 X GRANT
> 153 2 0 0 EXT 1:191056 X GRANT
> 153 2 0 0 EXT 1:186928 X GRANT
> 153 2 0 0 EXT 1:191064 X GRANT
> 153 2 0 0 EXT 1:182888 X GRANT
> 153 2 0 0 EXT 1:191008 X GRANT
> 153 2 0 0 EXT 1:182880 X GRANT
> 153 2 0 0 EXT 1:191016 X GRANT
> 153 2 0 0 EXT 1:182904 X GRANT
> 153 2 0 0 EXT 1:191024 X GRANT
> 153 2 0 0 EXT 1:182896 X GRANT
> 153 2 0 0 EXT 1:191032 X GRANT
> 153 2 0 0 EXT 1:182856 X GRANT
> 153 2 0 0 EXT 1:190976 X GRANT
> 153 2 0 0 EXT 1:190984 X GRANT
> 153 2 0 0 EXT 1:182872 X GRANT
> 153 2 0 0 EXT 1:190992 X GRANT
> 153 2 0 0 EXT 1:182864 X GRANT
> 153 2 0 0 EXT 1:191000 X GRANT
> 153 2 0 0 EXT 1:191200 X GRANT
> 153 2 0 0 EXT 1:182952 X GRANT
> 153 2 0 0 EXT 1:191208 X GRANT
> 153 2 0 0 EXT 1:182944 X GRANT
> 153 2 0 0 EXT 1:191216 X GRANT
> 153 2 0 0 EXT 1:182968 X GRANT
> 153 2 0 0 EXT 1:191224 X GRANT
> 153 2 0 0 EXT 1:182960 X GRANT
> 153 2 0 0 EXT 1:187048 X GRANT
> 153 2 0 0 EXT 1:191168 X GRANT
> 153 2 0 0 EXT 1:182920 X GRANT
> 153 2 0 0 EXT 1:187040 X GRANT
> 153 2 0 0 EXT 1:191176 X GRANT
> 153 2 0 0 EXT 1:182912 X GRANT
> 153 2 0 0 EXT 1:187064 X GRANT
> 153 2 0 0 EXT 1:191184 X GRANT
> 153 2 0 0 EXT 1:182936 X GRANT
> 153 2 0 0 EXT 1:187056 X GRANT
> 153 2 0 0 EXT 1:191192 X GRANT
> 153 2 0 0 EXT 1:182928 X GRANT
> 153 2 0 0 EXT 1:187080 X GRANT
> 153 2 0 0 EXT 1:183016 X GRANT
> 153 2 0 0 EXT 1:191136 X GRANT
> 153 2 0 0 EXT 1:187072 X GRANT
> 153 2 0 0 EXT 1:183008 X GRANT
> 153 2 0 0 EXT 1:191144 X GRANT
> 153 2 0 0 EXT 1:187096 X GRANT
> 153 2 0 0 EXT 1:183032 X GRANT
> 153 2 0 0 EXT 1:191152 X GRANT
> 153 2 0 0 EXT 1:187088 X GRANT
> 153 2 0 0 EXT 1:183024 X GRANT
> 153 2 0 0 EXT 1:191160 X GRANT
> 153 2 0 0 EXT 1:187112 X GRANT
> 153 2 0 0 EXT 1:182984 X GRANT
> 153 2 0 0 EXT 1:191104 X GRANT
> 153 2 0 0 EXT 1:187104 X GRANT
> 153 2 0 0 EXT 1:182976 X GRANT
> 153 2 0 0 EXT 1:191112 X GRANT
> 153 2 0 0 EXT 1:187128 X GRANT
> 153 2 0 0 EXT 1:183000 X GRANT
> 153 2 0 0 EXT 1:191120 X GRANT
> 153 2 0 0 EXT 1:187120 X GRANT
> 153 2 0 0 EXT 1:182992 X GRANT
> 153 2 0 0 EXT 1:191128 X GRANT
>
|||Hello, Ian
Ensure that you have indexes on the Telephone_Number columns (in both
tables). If the column is supposed to be unique in any/both of the
tables, then create a unique constraint on that column(s) (unless the
column isn't already a primary key on that table).
If it still runs slowly, you can try to update the statistics (using
"EXEC sp_updatestats") before running the query.
Razvan
|||Thanks for the advice, I've done all the things you suggested, but
noticed this afternoon that the process is getting a PAGEIOLATCH on
this spid and not returning for several hours. The process is waiting
on itself effectively.
I didn't spot this using sp_who but have got it now. Looking around the
internet it seems to suggest that the diskIO can't keep up with the
requests or that memory is paging to disk excessively, does this sound
correct?
Uri Dimant wrote:[vbcol=seagreen]
> Hi
> Don't you have a WHERE condition? Have you checked sp_lock system stored
> procedures?
> Did you update statistics on the both servers?
> <ian.wrigglesworth@.openreach.co.uk> wrote in message
> news:1162392567.098665.190840@.e3g2000cwe.googlegro ups.com...