SQL Server Performance Series - Part 2 - Server and Database Tuning
Play SQL Server Performance Series - Part 2 - Server and Database Tuning
In the second part of this series we look at performance tuning at the server and database level. We will discuss server configuration from hardware to software, storage and database layout and configuration. You will learn how to look at server performance at a high-level using Dynamic Management Views (DMVs) to quickly determine the reason for poor performance and to identify parts of your database and application that need further attention.