KBI 310456 Enhancement: Data Size In TempDB Rules In Argent for SQL Server For Calculating The Data Size In TempDB

Version

Argent Advanced Technology 1304-L and above

Date

Friday, 3 May 2013

Summary

Argent Advanced Technology has been enhanced with a new Rule category ‘Data Size In TempDB Rules‘ in Argent for SQL Server to calculate the percentage of data size in tempdb

Example 1:

Rule ‘TEMPDB_SIZE_SQL2008_AT_LIMIT‘ is broken if the data size in tempdb is equal to 50%

Example 2:

Rule ‘TEMPDB_SIZE_SQL2008_EXCEEDING_LIMIT‘ is broken if the data size in tempdb is between 50% and 80%

Example 3:

Rule ‘TEMPDB_SIZE_SQL2008_MAJOR_OVERLOAD‘ is broken if the data size in tempdb is more than 50%

Technical Background

N/A

Resolution

N/A