Some of the most common actions DBAs often resort to are:
- Tuning queries to minimize the amount of data returned.
- Adding extra spindles or flash for performance
- Increased RAM
- Index maintenance to improve read and/or write performance.
Watch On Demand Webinar: Improving SQL Server Virtual Machine Storage Performance
Most performance degradation is a software problem that can be solved by software
None of these actions will prevent hardware bottlenecks that occur due to the FACT that 30-40% of performance is being robbed by small, fractured, random I/O being generated due to the Windows operating system (that is, any Windows operating system, including Windows 10 or Windows Server 2019).