Properly gathering Performance Counter data using PowerShell

We DBA´s know how important it is to collect performance data. In this session, I will show to you how to properly use the native Get-Counter PowerShell cmdlet to get all information you need from your servers. It has never been as easy to collect performance counter data and save it to a CSV file or a SQL Server table for baselining and later analysis. You may be thinking "But I don’t know nothing about PowerShell and explicitly using .NET classes in my code". Don’t worry; you don’t need to know this to collect counters. Although this is a 100-level session, you’ll be producing 400-level results and your scripts will scale as the number of servers increase, because we’ll use asynchronous collection and processing. And better yet, we’ll schedule all of it. All this using native PowerShell cmdlets and a minimal amount of script code.
Presented by Laerte Junior at SQLBits XII
Tags (no tags)
  • Downloads
    Sorry, there are no downloads available for this session.
  • 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.