May 2010 - Posts

• Try a sample: Using the counter predicate for event sampling

  Extended Events offers a rich filtering mechanism, called predicates, that allows you to reduce the number of events you collect by specifying criteria that will be applied during event collection. (You can find more information about predicates in Using Read More... Posted Friday, May 14, 2010 5:21 PM by extended_events | 1 Comments

• Making a Statement: How to retrieve the T-SQL statement that caused an event

  If you’ve done any troubleshooting of T-SQL, you know that sooner or later, probably sooner, you’re going to want to take a look at the actual statements you’re dealing with. In extended events we offer an action (See the BOL topic that covers Extended Read More... Posted Friday, May 07, 2010 7:18 PM by extended_events | 3 Comments