locked
Exchange MP causing blocking on MS SQL DB RRS feed

  • Question

  • Hi All,

    Latley i have been facing this issue of event id 2115 in my SCOM management console popping up frequently, which basically shows delay in DBW writes. 

    On the SQL end i found that below qurey is the major contributer for blocking:

    insert bulk dbo.MT_Microsoft$Exchange$2010$Mailbox$DatabaseCopiesReplay_Log ([EntityChangeLogId] BigInt, [BaseManagedEntityId] UniqueIdentifier, [Pre_ObjectStatus_4AE3E5FE_BC03_1336_0A45_80BF58DEE57B] UniqueIdentifier, [Post_ObjectStatus_4AE3E5FE_BC03_1336_0A45_80BF58DEE57B] UniqueIdentifier, [Pre_InstanceName_4FEC5B23_41CB_170D_7993_3696590A5B2E] NVarChar(256) COLLATE SQL_Latin1_General_CP1_CI_AS, [Post_InstanceName_4FEC5B23_41CB_170D_7993_3696590A5B2E] NVarChar(256) COLLATE SQL_Latin1_General_CP1_CI_AS, [Pre_ActiveDirectorySite_345B3252_CF66_3B59_BEBF_8E14470AA817] NVarChar(256) COLLATE SQL_Latin1_General_CP1_CI_AS, [Post_ActiveDirectorySite_345B3252_CF66_3B59_BEBF_8E14470AA817] NVarChar(256) COLLATE SQL_Latin1_General_CP1_CI_AS, [Pre_ServiceName_91F96188_20F7_EA32_E7A3_014BBE47FB08] NVarChar(256) COLLATE SQL_Latin1_General_CP1_CI_AS, [Post_ServiceName_91F96188_20F7_EA32_E7A3_014BBE47FB08] NVarChar(256) COLLATE SQL_Latin1_General_CP1_CI_AS, [Pre_AssetStatus_B6E7674B_684A_040D_30B8_D1B42CCB3BC6] UniqueIdentifier, [Post_AssetStatus_B6E7674B_684A_040D_30B8_D1B42CCB3BC6] UniqueIdentifier, [Pre_SuppressAlert_AC3BEE30_F0E4_DCCF_7218_31C49E2EC0B5] Bit, [Post_SuppressAlert_AC3BEE30_F0E4_DCCF_7218_31C49E2EC0B5] Bit, [Pre_DisplayName] NVarChar(4000) COLLATE SQL_Latin1_General_CP1_CI_AS, [Post_DisplayName] NVarChar(4000) COLLATE SQL_Latin1_General_CP1_CI_AS, [Pre_Notes_5CFC0E2A_AB82_5830_D4BB_0596CBED1984] NVarChar(4000) COLLATE SQL_Latin1_General_CP1_CI_AS, [Post_Notes_5CFC0E2A_AB82_5830_D4BB_0596CBED1984] NVarChar(4000) COLLATE SQL_Latin1_General_CP1_CI_AS)<o:p></o:p>

    I know exchange mp is always a pain, but how to trouble shoot and fix it ?

    TIA,

    Prajul Nambiar.

    Tuesday, July 14, 2015 11:20 AM

Answers

All replies