THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Extended Events » SQL Server   (RSS)
  • Capturing query and IO statistics using Extended Events

    The commands SET STATISTICS TIME ON SET STATISTICS IO ON return information about query executions and are very useful when doing performance tuning work as they inform how long a query took to execute and the amount of IO activity that occurred as a result of that query. These are very effective features however to my ...
    Posted to Jamie Thomson (Weblog) by jamiet on March 5, 2014
  • Trapping SQL Server Errors with Extended Events

    One very useful usage of Extended Events is the ability to trap SQL Server error without the need to have a server trace running (which, btw, is deprecated), with the additional feature of being able to query the data as soon as it comes in. This means that we a solution to monitor and trap errors as soon as they happen can be easily created, in ...
    Posted to Davide Mauri (Weblog) by manowar on March 17, 2013
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement