THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Allen White

TechEd 2010 Followup

Last week I presented a couple of sessions at Tech Ed NA in New Orleans. It was a great experience, even though my demos didn't always work out as planned. Here are the sessions I presented:

DAT01-INT Administrative Demo-Fest for SQL Server 2008

  • SQL Server 2008 provides a wealth of features aimed at the DBA. In this demofest of features we'll see ways to make administering SQL Server easier and faster such as Centralized Data Management, Performance Data Warehouse, Resource Governor, Backup Compression and more.

DAT306 Gather SQL Server Performance Data with PowerShell

  • We all know how important it is to keep a baseline of performance metrics that allow us to know when something is wrong and help us to track it down and fix the problem. We don't always know how to do this easily and consistently. This session will walk you through a series of PowerShell scripts you can schedule which will capture the most important data and a set of reports to show you how to use that data to keep your server running smoothly.

I've attached the scripts I used for the demos. Please feel free to use these, and enhance them with your own needs, but please attribute this work to me if you publish your enhancements.



Published Sunday, June 13, 2010 3:25 PM by AllenMWhite




Mark V said:

Hi Allen,

I really would love to see your PowerShell performance scripts. The post says "I've attached the scripts I used for the demos." Are they really? I don't see them...

June 17, 2010 3:26 PM

AllenMWhite said:

Mark, the attachment to this blog post. contains the scripts.  Inside the file is another zip file called  Inside that are the scripts I used in the demos at Tech Ed.  The getperf.ps1 script will gather the performance statistics as I discussed in the presentation.

June 17, 2010 3:45 PM

Ayyappan said:

Hi Allen,

How are you? Do you remember me?

Please write a book on PowerShell. because, you are very good in writing scripts. it will be very much helpful to the SQL community.



June 18, 2010 5:54 AM

Allen White said:

For the last year and a half or so I've been presenting a session on how to gather perfmon data with

August 21, 2011 7:06 PM
New Comments to this post are disabled

About AllenMWhite

Allen White is a consultant and mentor for Upsearch Technology Services in Northeast Ohio. He has worked as a Database Administrator, Architect and Developer for over 30 years, supporting both the Sybase and Microsoft SQL Server platforms over that period.

This Blog


Privacy Statement