Flag -T1118, "Concurrency enhancements for the tempdb database", is it required with SQL 2

Hi:
Is the flag -T1118 required to solve the problem described in
http://support.microsoft.com/kb/328551, when you have SQL Server 2000 with
Service Pack 4, or it's unecessary?
I'm not sure if this is unecessary. I didn't see, anywhere, something
like "Hey, man, apply SP4, create multiple files for tempdb, and forget
the -T1118 flag, it's not required anymore...". The documentation says, in a
shy way, that's the problem is solved on SP4, but I've found places that
says to always create multiple files for tempdb.
What's the correct? Should I always have -T1118 applied or it's not
required?
TIA,
--
Ravi Wallau
nospam@.nospam.orgYou might want to do a feedback on that KB asking for clarification. Here's what is going on:
Trace flag 1118 will mean no allocations from mixed extents (except from IAM pages). This can
increase concurrency on your tempdb as it will decrease hit on the SGAM page.
The fix in the KB mean that several files for tempdb will be used in a round-robin fashion,
essentially spreading out SGAM hit over several files.
You can combine one with the other. Since eliminating mixed extents for data will mean increased
storage utilization, I recommend you go for the KB fix to start with. If you still feel you have
resource contention of the tempdb SGAM page, try adding trace flag 1118 as well.
We recently had a discussion in the MVP group on how the article is worded, but I have a feeling
that the discussion didn't trigger a re-wording in the article...
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"Ravi Ambros Wallau" <nospam@.nospam.com> wrote in message
news:OykXgqtRGHA.5900@.tk2msftngp13.phx.gbl...
> Hi:
> Is the flag -T1118 required to solve the problem described in
> http://support.microsoft.com/kb/328551, when you have SQL Server 2000 with Service Pack 4, or it's
> unecessary?
> I'm not sure if this is unecessary. I didn't see, anywhere, something like "Hey, man, apply
> SP4, create multiple files for tempdb, and forget the -T1118 flag, it's not required anymore...".
> The documentation says, in a shy way, that's the problem is solved on SP4, but I've found places
> that says to always create multiple files for tempdb.
> What's the correct? Should I always have -T1118 applied or it's not required?
> TIA,
> --
> Ravi Wallau
> nospam@.nospam.org
>sql