Date: Thu, 28 Mar 2024 13:46:36 +0000 (UTC) Message-ID: <1923017878.67923.1711633596064@ip-10-0-1-26.ec2.internal> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_67922_1054053270.1711633596060" ------=_Part_67922_1054053270.1711633596060 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
The Tempdb Contention (ms) alert provides the latch wait time (in millise= conds) for tempdb allocation maps. The three tracked allocation page types = are:
Latch = contention of this sort is usually an indication that you need to create mo= re tempdb data files. In some situation, using Trace Flag 1118 may also all= eviate tempdb contention. This alert occurs only on instances running SQL&n= bsp;Server 2005 or above.
=
span>