Prev: Error on log file growth.
Next: VM Disk Configuration for SQL Server (2005/2008/2008 R2).
From: tbaze on 26 Apr 2010 11:21
What do trace flags -t3601 / t3603 do and are there performance hits from
using them?
From: Erland Sommarskog on 26 Apr 2010 17:50
tbaze (tbaze(a)discussions.microsoft.com) writes:
> What do trace flags -t3601 / t3603 do and are there performance hits from
> using them?

The situation you would use them is when SQL Server bombs on startup,
because you have a number of processes that is not a power of 2. See
http://blogs.msdn.com/sqlserverfaq/default.aspx?p=7.

Generally, you should not use trace flags not documented in Books Online
(and BOL has a very small number), unless you are adviced to by a
support engineer, or you find a KB article, or this case an official blog,
which describes a scenario you have run into, and the trace flag addresses
the issue.

--
Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

From: tbaze on 27 Apr 2010 01:26


"tbaze" wrote:

> What do trace flags -t3601 / t3603 do and are there performance hits from
> using them?

Yes, I found them using that same blog post and have a clustered SQL
environment up and running with the flags. The customer, however, wants to
know what the formal definition of the flags are as well as any performance
impact. That is not clearly defined in the post.
From: Scott Morris on 27 Apr 2010 08:34
"tbaze" <tbaze(a)discussions.microsoft.com> wrote in message
news:EDFC339E-9859-4D23-9A77-57350CD20C58(a)microsoft.com...
>
>
> "tbaze" wrote:
>
>> What do trace flags -t3601 / t3603 do and are there performance hits from
>> using them?
>
> Yes, I found them using that same blog post and have a clustered SQL
> environment up and running with the flags. The customer, however, wants
> to
> know what the formal definition of the flags are as well as any
> performance
> impact. That is not clearly defined in the post.

Then talk to Microsoft support. Undocumented trace flags are not for
general use.


 | 
Pages: 1
Prev: Error on log file growth.
Next: VM Disk Configuration for SQL Server (2005/2008/2008 R2).