KBI 310451 Enhancement: Database Settings Best Practices Rules In Argent for SQL Server For Database Performance Improvement

Version

Argent Advanced Technology 1304-L and above

Date

Friday, 3 May 2013

Summary

Argent Advanced Technology has been enhanced with a new set of Rules called ‘Database Settings Best Practices‘ in Argent for SQL Server which check database areas for performance improvement




Click For Full Size

Technical Background

These are checks which should generally be done immediately after an instance is brought online and is setup

However, running these checks across all SQL Servers will show areas for performance improvement and potentially cut off a looming performance issue

  1. Check Auto-Shrink Option

    2. Checks the status of database property ‘AutoShrink‘ is set to true

  2. Check AutoClose Option

    3. Checks the status of database property ‘AutoClose‘ is set to true

  3. Page Verify

    4. Checks the status of database property ‘Page Verify‘ is not set to CHECKSUM

  4. Auto Create Statistics

    5. Checks the status of database property ‘Auto Create Statistics‘ is turned off

  5. Auto Update Statistics

    6. Checks the status of database property ‘Auto Update Statistics‘ is turned off

  6. Auto Update Statistics Asynchronous

    7. Checks the status of database property ‘Auto Update Statistics Asynchronous‘ is turned off

Resolution

N/A