It is normal for us to have to face poorly performing queries or even
complete failure in our SQL server environments. This can happen for a variety
of reasons including poor Database Designs, hardware failure,
improperly-configured systems and OS Updates applied without testing. As
Database Administrators, we need to take precaution to minimize the impact of
these problems when they occur, and so we need the tools and methodology
required to identify and solve issues quickly. In this Session we will use
PowerShell to explore some common troubleshooting techniques used in our
day-to-day work as s DBA. This will include a variety of such activities
including Gathering Performance Counters in several servers at the same time
using background jobs, identifying Blocked Sessions and Reading & filtering
the SQL Error Log even if the Instance is offline.
The approach will be using some advanced PowerShell techniques that allow us
to scale the code for multiple servers and run the data collection in
asynchronous mode.
