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
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,
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:
22 matches
Mail list logo