Re: [OT] Sql Server writes causing contention

2019-03-27 Thread Tom P
help%40microsoft.com%7C1f0ea4d6b97e4d897f3708d666d1e890%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636809449091526278&sdata=IU8tnAITCjBxWafi3A9XpO9lF3PIwZJ8ad3t36lnxvs%3D&reserved=0> > > > > *From:* ozdotnet-boun...@ozdotnet.com *On > Behalf Of *Tom P > *Sent:* Thu

Re: [OT] Sql Server writes causing contention

2019-03-27 Thread Tom P
0ea4d6b97e4d897f3708d666d1e890%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636809449091526278&sdata=IU8tnAITCjBxWafi3A9XpO9lF3PIwZJ8ad3t36lnxvs%3D&reserved=0> > > > > *From:* ozdotnet-boun...@ozdotnet.com *On > Behalf Of *Tom P > *Sent:* Wednesday, 27 March 2019 3:34

Re: [OT] Sql Server writes causing contention

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

Re: [OT] Sql Server writes causing contention

2019-03-26 Thread Tom P
help%40microsoft.com%7C1f0ea4d6b97e4d897f3708d666d1e890%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636809449091526278&sdata=IU8tnAITCjBxWafi3A9XpO9lF3PIwZJ8ad3t36lnxvs%3D&reserved=0> >> >> >> >> *From:* ozdotnet-boun...@ozdotnet.com *On >> Behalf Of *Tom P

Re: [OT] Sql Server writes causing contention

2019-03-26 Thread Tom P
141af91ab2d7cd011db47%7C1%7C0%7C636809449091526278&sdata=IU8tnAITCjBxWafi3A9XpO9lF3PIwZJ8ad3t36lnxvs%3D&reserved=0> > > > > *From:* ozdotnet-boun...@ozdotnet.com *On > Behalf Of *Tom P > *Sent:* Wednesday, 27 March 2019 2:46 PM > *To:* ozDotNet > *Subject:* Re:

Re: [OT] Sql Server writes causing contention

2019-03-26 Thread Tom P
alloc_unit_type_desc, > >page_count > > FROM sys.dm_db_index_physical_stats > > (DB_ID(), NULL, NULL, NULL, 'DETAILED') > > WHERE OBJECT_NAME(object_id) IN (N'TomText', N'TomVarCharMax'); > > > > It’ll ret

RE: [OT] Sql Server writes causing contention

2019-03-26 Thread greg
C636809449091526278&sdata=IU8tnAITCjBxWafi3A9XpO9lF3PIwZJ8ad3t36lnxvs%3D&reserved=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 S

Re: [OT] Sql Server writes causing contention

2019-03-26 Thread Tom P
under.com%2F&data=02%7C01%7Csspahelp%40microsoft.com%7C1f0ea4d6b97e4d897f3708d666d1e890%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636809449091516274&sdata=SLHeEGAMmWUY5YIwcC4oAPYr%2F9RIZdi4MNASsdzwX2I%3D&reserved=0> > |http://greglow.me > <https://nam06.safelinks.protection

RE: [OT] Sql Server writes causing contention

2019-03-25 Thread greg
zdotnet-boun...@ozdotnet.com> mailto:ozdotnet-boun...@ozdotnet.com> > On Behalf Of Tom P Sent: Monday, 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

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
<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>

Re: [OT] Sql Server writes causing contention

2019-03-06 Thread Tom P
16274&sdata=SLHeEGAMmWUY5YIwcC4oAPYr%2F9RIZdi4MNASsdzwX2I%3D&reserved=0> > |http://greglow.me > <https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgreglow.me%2F&data=02%7C01%7Csspahelp%40microsoft.com%7C1f0ea4d6b97e4d897f3708d666d1e890%7C72f988bf86f141af91

RE: [OT] Sql Server writes causing contention

2019-03-06 Thread greg
0> http://greglow.me From: g...@greglow.com Sent: Thursday, 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.T

RE: [OT] Sql Server writes causing contention

2019-03-06 Thread greg
41af91ab2d7cd011db47%7C1%7C0%7C636809449091526278&sdata=IU8tnAITCjBxWafi3A9XpO9lF3PIwZJ8ad3t36lnxvs%3D&reserved=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

Re: [OT] Sql Server writes causing contention

2019-03-06 Thread Tom P
rosoft.com%7C1f0ea4d6b97e4d897f3708d666d1e890%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636809449091526278&sdata=IU8tnAITCjBxWafi3A9XpO9lF3PIwZJ8ad3t36lnxvs%3D&reserved=0> > > > > *From:* ozdotnet-boun...@ozdotnet.com *On > Behalf Of *Tom P > *Sent:* Thursday, 7 March 2019 11:53 AM > *To:* ozDotNet

RE: [OT] Sql Server writes causing contention

2019-03-06 Thread greg
lf Of Tom P Sent: Thursday, 7 March 2019 11:53 AM To: ozDotNet 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

Re: [OT] Sql Server writes causing contention

2019-03-06 Thread Tom P
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 several times per second maybe. On Thu, 7 Mar 2019 at 11:44, w

RE: [OT] Sql Server writes causing contention

2019-03-06 Thread greg
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: