DaveWentzel.com All Things Data
This is the landing page for my PerformanceCollector utility. Download the latest version.
The full writeup is available on my blog under PerformanceCollector.
PerformanceCollector is designed on the YAPP (Yet Another Performance Profiling) method of performance management in Oracle. This was made possible in SQL Server with the advent of the DMVs in SQL 2005. DBAs still swear by Profiler to do the bulk of their performance monitoring, even though this tool is soon to be deprecated in favor of Extended Events.
See my Performance Page for lots of other interesting SQL Server performance tips and scripts.