Browse by Tags

Related Posts
  • Blog Post: SQL 2012 System health–fast analysis

    Once we encounter a few problems with the SQL 2012 and we need to analyze it, what will be the first recommended step to start with? During my last post I have discussed the default trace in SQL and its benefits. SQL 2008 introduced a new option called extended events (which is also know as Xevents...
  • Blog Post: Did you know , Dead locks can be track from the System Health in SQL 2012

      Before using SQL server 2008, in order to capture a deadlock, we had to create a server side/profiler trace or use trace flags 1204, 1222. If you were lucky enough to work with SQL 2008/2008R2 you could have tried using XEvents (which were introduced in SQL 2008). SQL Server 2012 added a new feature...