SQL Server - Top Recommendations
1. TempDB - The Number of Logical CPUs, the number of Tempdb Data files it should be.
2. Target Memory counter should not exceed maximum allocated memory. Anyhow we should continuously monitor its spike before allocating more memory.
3. Page Life Expectancy value should be more than 300 as good sign.
4. Buffer Cache Hit Ratio - More than 90%
5. Continuously capture/watch the number of active virtual log files for the database to be able to analyze the overall need for Log file initial size.
6. DBCC Checkdb should run for all the database fortnightly/weekly.
7. Verify Backups - It's necessary that Backup set should be valid once finished (but takes some more time).
For rest other missing recommendations, we will continuously work on this article and provide some more info to improve the performance and proactive monitoring of your databases.
Best Regards
Amit Vaid
No comments:
Post a Comment