SQL Server is a resource-intensive database system that requires adequate CPU and memory capacity to run transactions with acceptable performance. Another resource that can cause poor performance is the storage subsystem. We should carefully plan storage subsystems for SQL Server and follow Microsoft best practices to place files on multiple storage systems to reduce IO overheads and improve database performance. Sometimes, we start facing performance issues despite having all the best practices in place and adequate computing resources allocated to the SQL Server. The reason behind this could be anything from code level changes to the increased workload to poor
