Re: [OT] Sql Server writes causing contention

2019-03-27 Thread Tom P
3708d666d1e890%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636809449091526278=IU8tnAITCjBxWafi3A9XpO9lF3PIwZJ8ad3t36lnxvs%3D=0> > > > > *From:* ozdotnet-boun...@ozdotnet.com *On > Behalf Of *Tom P > *Sent:* Thursday, 28 March 2019 5:41 AM > *To:* ozDotNet > *Subject:*

Re: [OT] Sql Server writes causing contention

2019-03-27 Thread Tom P
3708d666d1e890%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636809449091526278=IU8tnAITCjBxWafi3A9XpO9lF3PIwZJ8ad3t36lnxvs%3D=0> > > > > *From:* ozdotnet-boun...@ozdotnet.com *On > Behalf Of *Tom P > *Sent:* Wednesday, 27 March 2019 3:34 PM > *To:* ozDotNet > *Subject:* Re: [OT] Sql

Re: [OT] Sql Server writes causing contention

2019-03-27 Thread David Rhys Jones
=SLHeEGAMmWUY5YIwcC4oAPYr%2F9RIZdi4MNASsdzwX2I%3D=0> >>> |http://greglow.me >>> <https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgreglow.me%2F=02%7C01%7Csspahelp%40microsoft.com%7C1f0ea4d6b97e4d897f3708d666d1e890%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%

Re: [OT] Sql Server writes causing contention

2019-03-26 Thread Tom P
7e4d897f3708d666d1e890%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636809449091526278=IU8tnAITCjBxWafi3A9XpO9lF3PIwZJ8ad3t36lnxvs%3D=0> >> >> >> >> *From:* ozdotnet-boun...@ozdotnet.com *On >> Behalf Of *Tom P >> *Sent:* Wednesday, 27 March 2019 2:46 PM >> *To

Re: [OT] Sql Server writes causing contention

2019-03-26 Thread Tom P
091526278=IU8tnAITCjBxWafi3A9XpO9lF3PIwZJ8ad3t36lnxvs%3D=0> > > > > *From:* ozdotnet-boun...@ozdotnet.com *On > Behalf Of *Tom P > *Sent:* Wednesday, 27 March 2019 2:46 PM > *To:* ozDotNet > *Subject:* Re: [OT] Sql Server writes causing contention > > > >

Re: [OT] Sql Server writes causing contention

2019-03-26 Thread Tom P
Fgreglow.me%2F=02%7C01%7Csspahelp%40microsoft.com%7C1f0ea4d6b97e4d897f3708d666d1e890%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636809449091526278=IU8tnAITCjBxWafi3A9XpO9lF3PIwZJ8ad3t36lnxvs%3D=0> > > > > *From:* ozdotnet-boun...@ozdotnet.com *On > Behalf Of *Tom P > *Sent:* Wedne

RE: [OT] Sql Server writes causing contention

2019-03-26 Thread greg
=0> http://greglow.me From: ozdotnet-boun...@ozdotnet.com On Behalf Of Tom P Sent: Wednesday, 27 March 2019 10:20 AM To: ozDotNet Subject: Re: [OT] Sql Server writes causing contention Hi Greg When I run this on my local Sql install and insert dummy data all works as expected like

Re: [OT] Sql Server writes causing contention

2019-03-26 Thread Tom P
pahelp%40microsoft.com%7C1f0ea4d6b97e4d897f3708d666d1e890%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636809449091516274=SLHeEGAMmWUY5YIwcC4oAPYr%2F9RIZdi4MNASsdzwX2I%3D=0> > |http://greglow.me > <https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgreglow.me%2F=02%7C01%7Csspahelp%40microsoft.com%

RE: [OT] Sql Server writes causing contention

2019-03-25 Thread greg
y, 25 March 2019 2:48 PM To: ozDotNet mailto:ozdotnet@ozdotnet.com> > Subject: Re: [OT] Sql Server writes causing contention Thanks, but tried that and still the same Cheers On Mon, 25 Mar 2019 at 13:37, Greg Low mailto:g...@greglow.com> > wrote: Am traveling so can’t

Re: [OT] Sql Server writes causing contention

2019-03-24 Thread Greg Low
, March 25, 2019 2:48 pm To: ozDotNet Subject: Re: [OT] Sql Server writes causing contention Thanks, but tried that and still the same Cheers On Mon, 25 Mar 2019 at 13:37, Greg Low mailto:g...@greglow.com>> wrote: Am traveling so can’t test but try removing the TEXTIMAGE ON clause Regards,

Re: [OT] Sql Server writes causing contention

2019-03-24 Thread Tom P
76 4913 > fax > SQL Down Under | Web: www.sqldownunder.com > > -- > *From:* ozdotnet-boun...@ozdotnet.com on behalf of Tom P < > tompbi...@gmail.com> > *Sent:* Monday, March 25, 2019 1:04 pm > *To:* ozDotNet > *Subject:* Re: [OT] Sql Ser

Re: [OT] Sql Server writes causing contention

2019-03-24 Thread Greg Low
of Tom P Sent: Monday, March 25, 2019 1:04 pm To: ozDotNet Subject: Re: [OT] Sql Server writes causing contention I only changed the data type from text to varchar(max) in the table and removed the FILLFACTOR 90. I then selected all the rows from the old table and inserted into the new one

Re: [OT] Sql Server writes causing contention

2019-03-24 Thread Tom P
-- > *From:* ozdotnet-boun...@ozdotnet.com on behalf of Tom P < > tompbi...@gmail.com> > *Sent:* Monday, March 25, 2019 10:47 am > *To:* ozDotNet > *Subject:* Re: [OT] Sql Server writes causing contention > > Hi Greg > > I have done as you suggested below bu

Re: [OT] Sql Server writes causing contention

2019-03-24 Thread Greg Low
Dr Greg Low SQL Down Under Pty Ltd Mobile: +61419201410 Office: 1300775775 From: ozdotnet-boun...@ozdotnet.com on behalf of Tom P Sent: Monday, March 25, 2019 10:47 am To: ozDotNet Subject: Re: [OT] Sql Server writes causing contention Hi Greg I have done as you

Re: [OT] Sql Server writes causing contention

2019-03-24 Thread Tom P
/?url=http%3A%2F%2Fwww.sqldownunder.com%2F=02%7C01%7Csspahelp%40microsoft.com%7C1f0ea4d6b97e4d897f3708d666d1e890%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636809449091516274=SLHeEGAMmWUY5YIwcC4oAPYr%2F9RIZdi4MNASsdzwX2I%3D=0> > |http://greglow.me > <https://nam06.safelinks.prot

Re: [OT] Sql Server writes causing contention

2019-03-06 Thread Tom P
2F9RIZdi4MNASsdzwX2I%3D=0> > |http://greglow.me > <https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgreglow.me%2F=02%7C01%7Csspahelp%40microsoft.com%7C1f0ea4d6b97e4d897f3708d666d1e890%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636809449091526278=IU8tnAITCjBxWafi3A9XpO9lF3PIwZJ8

RE: [OT] Sql Server writes causing contention

2019-03-06 Thread greg
day, 7 March 2019 2:10 PM To: 'ozDotNet' Subject: RE: [OT] Sql Server writes causing contention It’s easy to see. Try executing this: USE tempdb; GO DROP TABLE IF EXISTS dbo.TomText; GO DROP TABLE IF EXISTS dbo.TomVarCharMax; GO CREATE TABLE dbo.TomText ( TomTextID bigint

RE: [OT] Sql Server writes causing contention

2019-03-06 Thread greg
6lnxvs%3D=0> http://greglow.me From: ozdotnet-boun...@ozdotnet.com On Behalf Of Tom P Sent: Thursday, 7 March 2019 1:20 PM To: ozDotNet Subject: Re: [OT] Sql Server writes causing contention Very interesting about the storage of the text type. Do you have a Microsoft link by any

Re: [OT] Sql Server writes causing contention

2019-03-06 Thread Tom P
11db47%7C1%7C0%7C636809449091526278=IU8tnAITCjBxWafi3A9XpO9lF3PIwZJ8ad3t36lnxvs%3D=0> > > > > *From:* ozdotnet-boun...@ozdotnet.com *On > Behalf Of *Tom P > *Sent:* Thursday, 7 March 2019 11:53 AM > *To:* ozDotNet > *Subject:* Re: [OT] Sql Server writes causing contenti

RE: [OT] Sql Server writes causing contention

2019-03-06 Thread greg
Subject: Re: [OT] Sql Server writes causing contention Logid bigint Datetime Type varchar Message text I don’t have the stats yet but some of the apps are services that run batches of things and have busy periods during the day where they could write maybe 10,000 thousand rows. Possibly s

Re: [OT] Sql Server writes causing contention

2019-03-06 Thread Tom P
526278=IU8tnAITCjBxWafi3A9XpO9lF3PIwZJ8ad3t36lnxvs%3D=0> > > > > *From:* ozdotnet-boun...@ozdotnet.com *On > Behalf Of *Tom P > *Sent:* Thursday, 7 March 2019 11:40 AM > *To:* ozDotNet > *Subject:* [OT] Sql Server writes causing contention > > > > Hi folks &g

RE: [OT] Sql Server writes causing contention

2019-03-06 Thread greg
day, 7 March 2019 11:40 AM To: ozDotNet 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 add

[OT] Sql Server writes causing contention

2019-03-06 Thread Tom P
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