Mario Broodbakker

For almost two years now, Mario has been working as an Oracle performance engineer for HP Windows Integrity Engineering in Redmond, Washington. Before that, he spent more than 10 years doing Oracle performance consultancy and benchmark work in his native Holland for HP, Compaq and Baan Development. Challenged by the lack of usable performance data in SQL Server 2000, he developed his own interface and tools, as a sort of pet project. Although his daily work is purely Oracle related it's still fun and educating to pick up the SQL Server challenge during a rainy weekend (they do exist in the Seattle area). Some of his hobby projects can be seen and downloaded at www.sqlinternals.com, Mario can be reached at mariob at sqlinternals.com.

Follow Mario Broodbakker via
24 July 2008
24 July 2008

Investigating SQL Server 2008 Wait Events with XEVENTS

0
32
Some reasons for the slow-running of database applications aren't obvious. Occasionally, even the profiler won't tell you enough to remedy a problem, especially when a SQL Statement is being forced to wait. Now, in SQL Server 2008, come XEvents, which allow you to look at those wait events that are slowing your SQL Statements. Mario Broodbakker continues his series about SQL Server Wait Events SQL Server 2008 wait event based performance analysis using XEvents… Read more
0
32
22 March 2007
22 March 2007

SQL Server Wait Events: Taking the Guesswork out of Performance Profiling

0
61
Measuring what is actually happening is always the best course of action when investigating performance issues on databases, rather than relying on cache hit ratios, or best practices, or worst of all, guesswork. This article introduces some techniques that will allow you to pinpoint exactly where the performance issues are in your system, so you'll know exactly where to spend your time (and money) in solving them. … Read more
0
61