Date: Fri, 29 Mar 2024 10:59:58 +0000 (UTC) Message-ID: <127355984.69925.1711709998576@ip-10-0-1-26.ec2.internal> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_69924_2090927572.1711709998572" ------=_Part_69924_2090927572.1711709998572 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
SQL Diagnostic Manager lets you c= ollect statistics and perform trend analysis over time. Table Statistics al= low you to designate the days and times SQL Diagnostic Manager collects tab= le growth and reorganization statistics. Because statistics collection can = negatively impact performance, SQL Diagnostic Manager allows you to designa= te an individual Table Statistics collection time for the SQL Server i= nstances. Configure a time you know the instance is utilized less than norm= al.
In addition, you can limit the amount of performance impa= ct by utilizing the following:
You can access the Table Statistics tab o=
f the Monitor SQL Server Properties window by right-clicking the appro=
priate monitored SQL Server instance, and then selecting
Table Statistics collection is a resource= -intensive process. Schedule your collection time for non-peak hours to red= uce the possibility of your users experiencing decreased performance.
The SQL Diagnostic Manager Collection Service may not include fragmentat= ion data for a particular table for any of the following reasons: