Browse by Tags

• ExtendedEvents
• Internals
• Performance
• SQL2005
• T-SQL

• Parsing Extended Events xml_deadlock_report

  Jonathan Kehayias and Paul Randall posted more than a year ago great articles on how to monitor historical deadlocks using Extended Events system_health default trace. Both tried to fix on the fly bug in xml output that caused failures in xml validation. Read More... Posted Monday, May 10, 2010 5:31 AM by Michael Zilberstein | 15 Comments Filed under: SQL2008, ExtendedEvents

• Monitoring page splits with Extended Events

  After reading Kalen Delaney's post about single insert causing 10 page splits, I wanted to see those splits in detail - their order at first place. And in SQL Server 2008 there is a way to trace splits - using new Extended Events infrastructure. Here Read More... Posted Thursday, February 05, 2009 6:05 PM by Michael Zilberstein | 20 Comments Filed under: Internals, SQL2008, ExtendedEvents

• MERGE statement syntax modified

  This is probably known to all but I've just found out - MERGE command syntax had been modified since CTP6. In the beginning of 2008 I had built a system on CTP6 and this week, while preparing for production deployment, found out that procedures are failing Read More... Posted Tuesday, September 16, 2008 10:03 PM by Michael Zilberstein | 0 Comments Filed under: SQL2008, T-SQL

• Query performance troubleshooting in SQL Server 2008: query_hash and query_plan_hash

  Recently I have noticed 2 new columns added to sys . dm_exec_query_stats and sys . dm_exec_requests DMVs in SQL Server 2008: query_hash and query_plan_hash. Those columns can greatly enhance performance monitoring process. In SQL 2005 main query I'm using Read More... Posted Tuesday, September 09, 2008 6:52 PM by Michael Zilberstein | 4 Comments Filed under: SQL2005, Performance, SQL2008