SQL Server Startup Paramenter

Question

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

-T1118

Thanks in advance.

Answer 1

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.

Answer 2

Suggest you have a look at Paul Randalls blog post