Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

traceflag 3706

4 posts in General Discussion Last posting was on 2010-01-06 22:37:16.0Z
Raj Posted on 2010-01-06 06:22:22.0Z
Sender: 3d75.4b442aa5.1804289383@sybase.com
From: Raj
Newsgroups: sybase.public.ase.general
Subject: traceflag 3706
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4b442c1e.3dc4.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 5 Jan 2010 22:22:22 -0800
X-Trace: forums-1-dub 1262758942 10.22.241.41 (5 Jan 2010 22:22:22 -0800)
X-Original-Trace: 5 Jan 2010 22:22:22 -0800, 10.22.241.41
Lines: 10
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28830
Article PK: 78070

Hi,

Does anyone explain about this traceflag. Does it really
improve the tempdb performance ?

I would like to know the advantages of this and
disadvantages as well. Thanks in advance.

Thanks in advance.
Raj


Jason L. Froebe [TeamSybase] Posted on 2010-01-06 18:33:50.0Z
From: "Jason L. Froebe [TeamSybase]" <jason.froebe@gmail.com>
User-Agent: Thunderbird 2.0.0.23 (X11/20090817)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: traceflag 3706
References: <4b442c1e.3dc4.1681692777@sybase.com>
In-Reply-To: <4b442c1e.3dc4.1681692777@sybase.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b44d78e@forums-1-dub>
Date: 6 Jan 2010 10:33:50 -0800
X-Trace: forums-1-dub 1262802830 10.22.241.152 (6 Jan 2010 10:33:50 -0800)
X-Original-Trace: 6 Jan 2010 10:33:50 -0800, vip152.sybase.com
Lines: 26
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28835
Article PK: 78076


Raj wrote:
> Hi,
>
> Does anyone explain about this traceflag. Does it really
> improve the tempdb performance ?
>
> I would like to know the advantages of this and
> disadvantages as well. Thanks in advance.
>
> Thanks in advance.
> Raj

Trace flag 3706 no longer applies see cr 370520:

370520 The functionality implemented under CR 316222 and extended
under CR 400907 to improve the performance of DROP TABLE in temporary
databases was active by trace flag 3706 at boot time or via DBCC
TRACEON(3706). This enhancement now become the default ASE behaviour.
Consequently by default ASE will release during the drop of user tables
in tempdb the system catalog locks when not in DDL-IN-TRAN mode after
the commit of the transaction but before post commit work started. The
trace flag 3706 is therefore obsoleted. Should there be a need to turn
off this enhancement then trace flag 3708 can be used.


jason


Raj Posted on 2010-01-06 22:09:23.0Z
Sender: 3d75.4b442aa5.1804289383@sybase.com
From: Raj
Newsgroups: sybase.public.ase.general
Subject: Re: traceflag 3706
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4b450a12.5f5b.1681692777@sybase.com>
References: <4b44d78e@forums-1-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 6 Jan 2010 14:09:23 -0800
X-Trace: forums-1-dub 1262815763 10.22.241.41 (6 Jan 2010 14:09:23 -0800)
X-Original-Trace: 6 Jan 2010 14:09:23 -0800, 10.22.241.41
Lines: 34
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28838
Article PK: 78080


> Raj wrote:
> > Hi,
> >
> > Does anyone explain about this traceflag. Does it
> > really improve the tempdb performance ?
> >
> > I would like to know the advantages of this and
> > disadvantages as well. Thanks in advance.
> >
> > Thanks in advance.
> > Raj
>
> Trace flag 3706 no longer applies see cr 370520:
>
> 370520 The functionality implemented under CR 316222
> and extended under CR 400907 to improve the performance of
> DROP TABLE in temporary databases was active by trace flag
> 3706 at boot time or via DBCC TRACEON(3706). This
> enhancement now become the default ASE behaviour.
> Consequently by default ASE will release during the drop
> of user tables in tempdb the system catalog locks when not
> in DDL-IN-TRAN mode after the commit of the transaction
> but before post commit work started. The trace flag 3706
> is therefore obsoleted. Should there be a need to turn off
> this enhancement then trace flag 3708 can be used.
>
>
> jason

Can you please let me know from what version of ASE it is
default? Because we are using ASE-12.5.4

Thanks,
Raj


Bret Halford Posted on 2010-01-06 22:37:16.0Z
From: Bret Halford <bret@sybase.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.1.5) Gecko/20091204 Thunderbird/3.0
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: traceflag 3706
References: <4b44d78e@forums-1-dub> <4b450a12.5f5b.1681692777@sybase.com>
In-Reply-To: <4b450a12.5f5b.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4b45109c$1@forums-1-dub>
Date: 6 Jan 2010 14:37:16 -0800
X-Trace: forums-1-dub 1262817436 10.22.241.152 (6 Jan 2010 14:37:16 -0800)
X-Original-Trace: 6 Jan 2010 14:37:16 -0800, vip152.sybase.com
Lines: 11
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28839
Article PK: 78082

12.5.3 ESD #7 and above.

>
> Can you please let me know from what version of ASE it is
> default? Because we are using ASE-12.5.4
>
> Thanks,
> Raj