Platinum Sponsor

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.
Presented by Laerte Junior at SQLBits XI
  • Downloads
    Slide deck available Slide Deck 834 KB
    Video available MP4 Video Low 102 MB
    Samples available Demo Code 77 KB
    Video available MP4 Video Med 194 MB
    Video available MP4 Video HD 534 MB
  • SpeakerBIO
    Laerte_Junior.jpg
    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/
  • Video
    The video is not available to view online.
  • Session Files Explorer
    The network name cannot be found.