The Posh DBA: Troubleshooting SQL Server with PowerShell
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.
Laerte Junior
Laerte Junior is a PASS RM, Senior Powershell Expert Consultant at Confio Software and an active member of the Microsoft community in Brasil. He is a skilled Principal Database Architect, Developer, and Administrator, specializing in SQL Server and Powershell Programming with over 8 years of hands-on experience. He holds a degree in Computer Science and has accomplished a number of certifications (including MCDBA), and is an expert in SQL Server 2000 / SQL Server 2005 / SQL Server 2008 technologies. Also he is a HUGE Star Wars Fan, his main skill."May The Force be with us"
http://shellyourexperience.wordpress.com/ UID:SQLBITS1519SEQUENCE:0 DTSTAMP:20130526T002724Z END:VEVENT END:VCALENDAR