http://sqlblog.com/blogs/allen_white/archive/2009/10/09/performance-data-gathering.aspxAs a DBA, one of the things I struggled with was gathering all my important system information in one place, so I could see easily where my problems might be. Gathering perfmon data, combining it with trace data, adding in disk space information - itenCommunityServer 2.1 SP2 (Build: 61129.1)http://sqlblog.com/blogs/allen_white/archive/2009/10/09/performance-data-gathering.aspx#17597Mon, 12 Oct 2009 12:27:06 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:17597ALZDBA<p>Once again, a very nice and applicable sample Allen !</p> <p>Thumbs up for Seattle ;)</p> http://sqlblog.com/blogs/allen_white/archive/2009/10/09/performance-data-gathering.aspx#18742Wed, 11 Nov 2009 16:38:57 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:18742michael moen<p>Hey,</p> <p>drop me a line how we can stay in touch. I really like working with you!.</p> http://sqlblog.com/blogs/allen_white/archive/2009/10/09/performance-data-gathering.aspx#18792Thu, 12 Nov 2009 18:51:58 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:18792Leif Abbott<p>Allen, I attended your session at SQLPass on Gathering SQL Server Performance Data with PowerShell. &nbsp;I was wondering if there was any way I could get the scripts that you used in your various demo's. &nbsp;I really enjoyed your presentation and was hoping I could use the scripts and adapt them to work in my organization. If this is something that is feasible, please email me: &nbsp;abbottl (at) wsdot.wa.gov</p> http://sqlblog.com/blogs/allen_white/archive/2009/10/09/performance-data-gathering.aspx#27705Mon, 09 Aug 2010 09:42:16 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:27705Adrian<p>I was wondering on whether SQL Server's Data Collector (Management Data Warehouse) is not a nicer alternative for this.</p> http://sqlblog.com/blogs/allen_white/archive/2009/10/09/performance-data-gathering.aspx#27709Mon, 09 Aug 2010 12:24:54 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:27709AllenMWhite<p>Leif - the script should be downloadable from the PASS site.</p> <p>Adrian, the problem with MDW (from my perspective) is that it only works for SQL Server 2008 and beyond, and many of us are still supporting servers running SQL 2005 and SQL 2000. &nbsp;This method works for all of them.</p> http://sqlblog.com/blogs/allen_white/archive/2009/10/09/performance-data-gathering.aspx#28334Thu, 26 Aug 2010 18:15:34 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:28334Glen<p>Allen,</p> <p>So the scripts are only available to those who attended SQLPass?</p> http://sqlblog.com/blogs/allen_white/archive/2009/10/09/performance-data-gathering.aspx#28836Fri, 17 Sep 2010 16:54:51 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:28836Jim Puder<p>Allen,</p> <p>I attended your 24Hrs of SQL PASS this week (9/15/2010), and was wondering if you might be posting the script you used to gather SQL performance. &nbsp;You were going a little fast and it was a bit hard for me to follow the whole discussion.</p> <p>Jim Puder</p> http://sqlblog.com/blogs/allen_white/archive/2009/10/09/performance-data-gathering.aspx#33053Mon, 31 Jan 2011 12:54:48 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:33053Aaron Bertrand<p>In a current project, I need to collect performance counters from a set of virtual machines that are</p> http://sqlblog.com/blogs/allen_white/archive/2009/10/09/performance-data-gathering.aspx#48990Tue, 07 May 2013 21:18:59 GMT21093a07-8b3d-42db-8cbf-3350fcbf5496:48990Jim Dorame<p>Allen is there way way to gather the perfmon data generated from a 32 bit instance of SQL Server 2005 from a 64 bit client?</p>