Hi Tom,
Can you post the table schema? What rate are the writes coming in at? Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax SQL Down Under | Web: <https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.sqldownunder.com%2F&data=02%7C01%7Csspahelp%40microsoft.com%7C1f0ea4d6b97e4d897f3708d666d1e890%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636809449091516274&sdata=SLHeEGAMmWUY5YIwcC4oAPYr%2F9RIZdi4MNASsdzwX2I%3D&reserved=0> www.sqldownunder.com | <https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgreglow.me%2F&data=02%7C01%7Csspahelp%40microsoft.com%7C1f0ea4d6b97e4d897f3708d666d1e890%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636809449091526278&sdata=IU8tnAITCjBxWafi3A9XpO9lF3PIwZJ8ad3t36lnxvs%3D&reserved=0> http://greglow.me From: [email protected] <[email protected]> On Behalf Of Tom P Sent: Thursday, 7 March 2019 11:40 AM To: ozDotNet <[email protected]> Subject: [OT] Sql Server writes causing contention Hi folks Scenario: Multiple apps writing to a Log table in the same Sql Server database. Some apps hitting the table A LOT. No app reads from this table. No updates also. Just plain writes adding new rows. Problem: Contention causing timeout errors. Can anybody explain why this could be case? Cheers Tom -- Thanks Tom
