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:*
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
=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%
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
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
>
>
>
>
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
=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
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%
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
, 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,
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
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
--
> *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
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
/?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
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
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
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
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
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
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
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
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
23 matches
Mail list logo