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.
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
SQL 2005 wait event statistics are a good step forward, but are only useful for isolated testing, and to get a global impression on how the SQL Server is spending its time. Mario Broodbakker demonstrates why it would be much better if SQL Server collected those statistics per session and per subtask.… Read more
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