Forum Replies Created

Viewing 15 posts - 136 through 150 (of 220 total)

  • RE: Deadlock on update command

    Here is the deadlock info from the SQL log, unfirttunaltey it includes both deadlock flags. Due to my monitoring software

    Date,Source,Severity,Message

    03/25/2013 10:35:35,spid34s,Unknown,waiter id=processd4d708

    03/25/2013 10:35:35,spid34s,Unknown,waiter-list

    03/25/2013 10:35:35,spid34s,Unknown,owner id=process4fa0508

    03/25/2013 10:35:35,spid34s,Unknown,owner-list

    03/25/2013 10:35:35,spid34s,Unknown,exchangeEvent id=Pipe155556480 WaitType=e_waitPipeGetRow nodeId=3

    03/25/2013...

    March 25, 2013 at 4:59 am

    #1600229

  • RE: Deadlock on update command

    You've already posted them. No, it looks like a part of the deadlock info is missing. Can you post the actual plans for both of the queries please?

    You may well...

    March 25, 2013 at 4:44 am

    #1600222

  • RE: Deadlock on update command

    bugg (3/25/2013)

    ChrisM@Work (3/25/2013)

    bugg (3/25/2013)

    After applying that index update. I am now receiving another deadlock on that same table:

    Node:1

    KEY: 9:72057602492792832 (860067b2b9d1) CleanCnt:2 Mode:X Flags: 0x1

    Grant List 2:

    Owner:0x0000000198215A40 Mode: X Flg:0x40...

    March 25, 2013 at 4:27 am

    #1600218

  • RE: Deadlock on update command

    ChrisM@Work (3/25/2013)

    bugg (3/25/2013)

    After applying that index update. I am now receiving another deadlock on that same table:

    Node:1

    KEY: 9:72057602492792832 (860067b2b9d1) CleanCnt:2 Mode:X Flags: 0x1

    Grant List 2:

    Owner:0x0000000198215A40 Mode: X Flg:0x40 Ref:1...

    March 25, 2013 at 4:03 am

    #1600213

  • RE: Deadlock on update command

    After applying that index update. I am now receiving another deadlock on that same table:

    Node:1

    KEY: 9:72057602492792832 (860067b2b9d1) CleanCnt:2 Mode:X Flags: 0x1

    Grant List 2:

    Owner:0x0000000198215A40 Mode: X Flg:0x40 Ref:1 Life:02000000 SPID:73...

    March 25, 2013 at 3:04 am

    #1600198

  • RE: Index rebuild before table update

    GilaMonster (3/21/2013)

    bugg (3/21/2013)

    Would it be okay after the insert to do an index rebuild before the update?

    Is the index rebuild necessary?

    Possibly not its, the index at 97% fragmented after the...

    March 21, 2013 at 6:34 am

    #1599347

  • RE: Deadlock on update command

    ChrisM@Work (3/20/2013)

    Add column [status] to the include list for index IX_sessionid.

    As an aside, you appear to have a fair amount of duplication in your indexes.

    Thanks for that suggestion.

    The indexes...

    March 20, 2013 at 7:22 am

    #1598883

  • RE: Deadlock on update command

    ChrisM@Work (3/19/2013)

    DDL for the table and all indexes, and the actual plans for both queries, would help diagnosis.

    An index on sessionid including status and rsn may solve the problem.

    Apologies...

    March 20, 2013 at 5:56 am

    #1598845

  • RE: Deadlock on update command

    David Griffiths-273839 (3/20/2013)

    Here is my guess as to what is happening. It's only a guess since we don't have full information.

    2. Evaluate whether the index on Status is actually beneficial...

    March 20, 2013 at 5:31 am

    #1598837

  • RE: Deadlock on update command

    ChrisM@Work (3/19/2013)

    DDL for the table and all indexes, and the actual plans for both queries, would help diagnosis.

    An index on sessionid including status and rsn may solve the problem.

    Will...

    March 19, 2013 at 9:13 am

    #1598490

  • RE: Deadlock on update command

    Anyone ? :s

    March 19, 2013 at 6:47 am

    #1598394

  • RE: Differential backups being blocked, CHECKPOINT command

    Grant Fritchey (3/19/2013)

    bugg (3/19/2013)

    Grant Fritchey (3/19/2013)

    The checkpoint process is what writes all the dirty pages to disk.This is usually a fairly quick event. If it's hanging and running for a...

    March 19, 2013 at 5:22 am

    #1598367

  • RE: Differential backups being blocked, CHECKPOINT command

    Grant Fritchey (3/19/2013)

    The checkpoint process is what writes all the dirty pages to disk.This is usually a fairly quick event. If it's hanging and running for a really long time,...

    March 19, 2013 at 4:44 am

    #1598358

  • RE: Differential backups being blocked, CHECKPOINT command

    salliven (3/19/2013)

    Is there enough memory in your server?

    18 GB on server, I think its enough

    March 19, 2013 at 4:33 am

    #1598354

  • RE: Differential backups being blocked, CHECKPOINT command

    Anyone have any insight into this?

    Blocked process:Microsoft SQL Server Management Studio

    Process ID:88

    Database:MyDB

    Host:XXXX

    User:XXXX

    Start time:12:00 PM

    SQL fragment:BACKUP DATABASE [MyDB] TO DISK = N'D:\MyDB_backup_2013_03_16_120003_1030995.dfz' WITH DIFFERENTIAL , NOFORMAT, NOINIT, NAME = N'MyDB_backup_2013_03_16_120003_1010993', SKIP,...

    March 19, 2013 at 2:48 am

    #1598330

Viewing 15 posts - 136 through 150 (of 220 total)