tempdb page allocation contention text is misleading
I think the content of the issue "Configure the tempdb database to reduce page allocation contention." is misleading.
It states "SQL Server is experiencing contention when it tries to allocate pages. This can have a substantial impact on performance."
How are we collecting this information? From performance statistics or from the state of the trace flags?
This issue is showing on a totally idle server that I just added to OMS so I think it is from the trace flag status. If this is the case then the statement that "SQL Server is experiencing contention when it tries to allocate pages. " is not write. There has been no contention for page allocation on an idle server.
I totally agree that there is a 'risk' of contention and the text should be altered to reflect that.
Having a value of 6.9 and a high impact suggests that if the issue is resolved there will be a big change in observed performance. I'm pretty sure that my idle server wont be any faster if I resolve the issue as described in the supporting documentation.
Suggesting we can make a big improvement when we cant guarantee it is misleading.
and the suggested fix is to enable T1118, but that trace flag is not needed on 2016 and above.