SolarWinds & SQL Server Best-Practices

Solarwinds

DB First Steps:

  1. Does your SQL server meet the requirements (or multi-module requirements)?
  2. Have you checked your environment against the list of commonly overlooked requirements?
  3. Are your DB files stored correctly? 

Microsoft SQL Server Resources:

  1. Top Level: The Transaction Log (2017)
    1. Manage the Size of the Transaction Log File
    2. SQL Server Transaction Log Architecture & Management Guide
    3. View/Change Database Properties
    4. Recovery Models

SolarWinds: DB Management/Optimization:

  1. Review & Adhere To: SQL Server Performance Optimization and Best Practices
    1. How to spot Performance Issues
    2. Use SolarWinds Database Performance Analyzer
    3. Use the SQL Activity Monitor
    4. Resource Waits
    5. Data File I/O
    6. SQL Server Configuration
    7. Why not RAID 5?
    8. SQL and Memory Consumption
    9. SQL Server and Virtual Machines
    10. Checklist
  2. Review & Adhere To: SQL Database Management Best Practices
    1. Troubleshoot database size
    2. Troubleshoot degraded performance
  3. Review & Adhere TO: SQL Server configuration best practices for NPM
    1. Maximize SQL Server performance
    2. Hardware recommendations
    3. Recommendations for multi-CPU systems, optimal settings of I/O subsystem
    4. Initial size and autogrowth settings for data files and log files in the tempdb
    5. Database Recovery Modes
    6. Settings and Recommendations Checklist
  4. Review SolarWinds documentation on Optimizing Retained Data
    1. Find out what tables take up most space in the database
    2. Set polling settings to defaults
    3. Set retention settings to defaults
    4. Optimize log files

Orion Best Practices & Detail Links

  1. Rebooting The Orion Server Instructions & Best Practices