IT: Database Performance Management
Have users occasionally encountered slowness and you need to figure out why? In this class we’ll discuss tools and techniques to do just that, as well as touch on capacity planning. We’ll cover how to investigate CPU, memory and IO utilization, as well as identify and resolve blocking issues. Some of the tools we’ll look at include SQL Server’s Management Data Warehouse, Activity Monitor, and SQL Profiler, as well as OS level tools such as Resource Monitor and Performance Monitor.