Skip to content
Advertisement

SQL Server Startup Paramenter

I found the following value in my SQL server Startup paramenter what is the meaning of that:

-T1118

Advertisement

Answer

From this blog post:

Trace flag 1118 forces uniform extent allocations instead of mixed page allocations. The trace flag is commonly used to assist in TEMPDB scalability by avoiding SGAM and other allocation contention points.

User contributions licensed under: CC BY-SA
6 People found this is helpful
Advertisement