SQL Server Startup Paramenter
I found the following value in my SQL server Star开发者_开发百科tup paramenter what is the meaning of that:
-T1118
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.
Suggest you have a look at Paul Randalls blog post
精彩评论