CODEWITHSUNDEEP
sqlsql-server
John
John

Reputation: 721

SQL Server Startup Paramenter

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

-T1118

Upvotes: 1

Views: 116

Answers (2)

Oded
Oded

Reputation: 499002

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.

Upvotes: 2

SPE109
SPE109

Reputation: 2951

Suggest you have a look at Paul Randalls blog post

Upvotes: 2

Related Questions