July 16, 2010 at 10:45 am
Switched a server to VMWARE and since batch running is slow. (I didnt want to put this heavy load SQL server on VMWARE). Have tried many things (turned off hyper threading, differnet LUNs for tempdb, data, logs) I think we may need more memory but are running windows 2003 standard. Think next test is to to enterprise and go 8gb RAM. I am getting deadlocks and I am having trouble deciphering them. Can someone take a look and give me a general idea where to go or even does anyone have a site or read for me on how to decipher this trace flag -1222 data.
Date,Source,Severity,Message
07/16/2010 11:37:07,spid16s,Unknown,waiter id=process84aa78 mode=IX requestType=wait
07/16/2010 11:37:07,spid16s,Unknown,waiter-list
07/16/2010 11:37:07,spid16s,Unknown,owner id=process84a4d8 mode=S
07/16/2010 11:37:07,spid16s,Unknown,owner-list
07/16/2010 11:37:07,spid16s,Unknown,pagelock fileid=1 pageid=1031860 dbid=7 objectname=api_pm_svsd105_test.dbo.rx_datasup id=lock24fd9040 mode=S associatedObjectId=72057594670415872
07/16/2010 11:37:07,spid16s,Unknown,waiter id=process84a4d8 mode=S requestType=wait
07/16/2010 11:37:07,spid16s,Unknown,waiter-list
07/16/2010 11:37:07,spid16s,Unknown,owner id=process84aa78 mode=IX
07/16/2010 11:37:07,spid16s,Unknown,owner-list
07/16/2010 11:37:07,spid16s,Unknown,pagelock fileid=1 pageid=627822 dbid=7 objectname=api_pm_svsd105_test.dbo.rx_dataemp id=lock1dd38dc0 mode=IX associatedObjectId=72057594658619392
07/16/2010 11:37:07,spid16s,Unknown,resource-list
07/16/2010 11:37:07,spid16s,Unknown,INSERT INTO rx_datasup (ls_id<c/>sup_id<c/>fac_id<c/>grp_id<c/>pp_date<c/>rpt_type<c/>emp_id<c/>sup_type<c/>status<c/>status_date<c/>fwd_from<c/>fwd_to<c/>emp_data_id) VALUES (0<c/>-589120634<c/>-1406261495<c/>-7795725<c/>'07/11/2010'<c/>0<c/>-737544864<c/>0<c/>0<c/>GETDATE()<c/>0<c/>0<c/>-1256927668)
07/16/2010 11:37:07,spid16s,Unknown,inputbuf
07/16/2010 11:37:07,spid16s,Unknown,unknown
07/16/2010 11:37:07,spid16s,Unknown,frame procname=unknown line=1 sqlhandle=0x02000000dd22ba2d4ab4d1e6a32ee771e3916fef72ab02e9
07/16/2010 11:37:07,spid16s,Unknown,INSERT INTO [rx_datasup]([ls_id]<c/>[sup_id]<c/>[fac_id]<c/>[grp_id]<c/>[pp_date]<c/>[rpt_type]<c/>[emp_id]<c/>[sup_type]<c/>[status]<c/>[status_date]<c/>[fwd_from]<c/>[fwd_to]<c/>[emp_data_id]) values(@1<c/>@2<c/>@3<c/>@4<c/>@5<c/>@6<c/>@7<c/>@8<c/>@9<c/>getdate()<c/>@10<c/>@11<c/>@12)
07/16/2010 11:37:07,spid16s,Unknown,frame procname=adhoc line=1 stmtstart=196 sqlhandle=0x020000008d8b682af229cedf194b7f100793bc0f4696a97c
07/16/2010 11:37:07,spid16s,Unknown,executionStack
07/16/2010 11:37:07,spid16s,Unknown,process id=process84aa78 taskpriority=0 logused=3272 waitresource=PAGE: 7:1:1031860 waittime=1328 ownerId=4467751 transactionname=implicit_transaction lasttranstarted=2010-07-16T11:37:05.803 XDES=0x5930e5d8 lockMode=IX schedulerid=1 kpid=5956 status=suspended spid=69 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2010-07-16T11:37:05.873 lastbatchcompleted=2010-07-16T11:37:05.867 clientapp=Payrollmation(R) Hub Service hostname=APITEST hostpid=4984 loginname=PMADMIN isolationlevel=read committed (2) xactid=4467751 currentdb=7 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128058
07/16/2010 11:37:07,spid16s,Unknown,SELECT count(*) AS approvable_count FROM rx_dataemp INNER JOIN rx_datasup ON rx_datasup.emp_data_id = rx_dataemp.id WHERE (rx_datasup.sup_id = -589120634) AND (rx_datasup.grp_id = -7795725) AND (rx_datasup.pp_date = '07/11/2010') AND (rx_datasup.rpt_type = 0) AND (rx_datasup.sup_type = 0) AND (rx_dataemp.status <> 4)
07/16/2010 11:37:07,spid16s,Unknown,inputbuf
07/16/2010 11:37:07,spid16s,Unknown,SELECT count(*) AS approvable_count FROM rx_dataemp INNER JOIN rx_datasup ON rx_datasup.emp_data_id = rx_dataemp.id WHERE (rx_datasup.sup_id = -589120634) AND (rx_datasup.grp_id = -7795725) AND (rx_datasup.pp_date = '07/11/2010') AND (rx_datasup.rpt_type = 0) AND (rx_datasup.sup_type = 0) AND (rx_dataemp.status <> 4)
07/16/2010 11:37:07,spid16s,Unknown,frame procname=adhoc line=1 sqlhandle=0x02000000697ce00b7c94325a745d34a47ee35e470eecdaaf
07/16/2010 11:37:07,spid16s,Unknown,executionStack
07/16/2010 11:37:07,spid16s,Unknown,process id=process84a4d8 taskpriority=0 logused=0 waitresource=PAGE: 7:1:627822 waittime=1375 ownerId=4467470 transactionname=implicit_transaction lasttranstarted=2010-07-16T11:37:05.643 XDES=0x5930f3b8 lockMode=S schedulerid=1 kpid=5896 status=suspended spid=71 sbid=0 ecid=0 priority=0 transcount=1 lastbatchstarted=2010-07-16T11:37:05.803 lastbatchcompleted=2010-07-16T11:37:05.800 clientapp=Payrollmation(R) Hub Service hostname=APITEST hostpid=4984 loginname=PMADMIN isolationlevel=read committed (2) xactid=4467470 currentdb=7 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128058
07/16/2010 11:37:07,spid16s,Unknown,process-list
07/16/2010 11:37:07,spid16s,Unknown,deadlock victim=process84a4d8
07/16/2010 11:37:07,spid16s,Unknown,deadlock-list
July 16, 2010 at 11:01 am
What do you mean you "switched" a server? I assume this is physical to virtual, but perhaps you can provide more details?
One of the things that bites people at times going to virtual servers is a lack of IO. A virtual disk does not perform as well as a physical one, especially if it's the same one that the host is running on.
Follow me on Twitter: http://www.twitter.com/way0utwest
Forum Etiquette: How to post data/code on a forum to get the best help
My Blog: www.voiceofthedba.com
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply