Monday, July 15, 2019

MSSQL: Using DBCC to gather statistic

Trying to get statistic for performance diagnostic for a bloated vCenter table - VPX_EVENT.

https://docs.microsoft.com/en-us/sql/t-sql/database-console-commands/dbcc-show-statistics-transact-sql?view=sql-server-2017
dbcc show_statistics ("table_name", index_name);
use vcdb_2016
dbcc show_statistics ("vpx_event", pk_vpx_event);
dbcc show_statistics ("vpx_event", pk_vpx_event) with histogram;

No comments:

Post a Comment

MSSQL: Getting more detail information for failed jobs.

Often when a job failed, it provides trivial information for diagnostic. In order to expand the detail of the failed job, it can be done th...