Solarwinds Recommend for Optimum Performance you should have SQL with SSD :
For more demanding environment its is Strongly recommended for the customer to have the Orion SQL DB on SSD .
Traditional Microsoft SQL Server data-base deployments required large data storage typically composed of arrays of rotating hard disks drives (HDD) configured in a storage array network (SAN) over a network connection .
As data volume increases the database performance quickly degrades due to increase I/O and network bottlenecks.
Replacing slower HDD's with faster solid state drives (SSD) instantaneously relives I/O bottlenecks and improves performance but the cost of upgrading a SAN storage can be significant. However performance will be optimum .
For more
Reduce Performance Bottlenecks of Microsoft SQL Server Database.
Please see SSD as recommended below.
For more details about your general questions please see the post below.
- I have a very large Orion database. What should I check?
- I have database performance issues. How can i improve my database performance?
- Why do my Orion database tables have high fragmentation?
- Why is my Orion database growing so quickly?
- Why does my Orion performance decrease each day?
- Why is my Orion Web Console loading data at a slow rate?
- How can I store a large number of Syslog and Trap files?
Quick Orion database health check guide - SolarWinds Worldwide, LLC. Help and Support
