New Extended Events for Tracing in SQL Server 2014
This article contains a list of new Extended Events, the tracing framework in SQL Server in the new 2014 release.
Comparing Extended Events vs SQL Trace – or why SQL Trace & Profiler are just a thing of the past :-)
/0 Comments/in Extended Events, Tracing & MonitoringAs a reminder: Extended Events have been integrated in SQL Server since SQL Server 2008. And since SQL Server 2012 SP1, all events existing in SQL Trace have been available. In addition, Extended Events have also been available for Analysis Services since SQL Server 2012 Tracing Analysis Services (SSAS) with Extended Events – Yes it […]
PreCon Performance Analysis & Tuning Techniques at SQLSaturday in Istanbul
/in Conferences, Performance, SQLPASS, Tracing & MonitoringWhat a year: after as many as 3 SQLSaturdays (Denmark, Netherlands, Germany) behind me, I will now also speak at SQSaturday #258 in Istanbul, Turkey. And after my first PreCon this year at the SQLSaturday in Germany, which I was co-presenting together with Mladen Prajdić, on the part “XEvents”, I will now be giving a […]
Performance overhead of tracing with Extended Event targets vs SQL Trace under CPU Load
/0 Comments/in Extended Events, Performance, SQL Trace & Profiler, Tracing & MonitoringInspired by the Blog Post “Measuring Observer Overhead of SQL Trace vs. Extended Events” by Jonathan Kehayias, I was curious to do some more benchmarking. I have already presented the results in my SQL Server Master-Class workshops on XEvents as well as at the PreCon of the SQLSaturday #230. Now I am finally sharing them […]
Survey: Which Tracing and Analysis-Tools do you use for SQL Server?
/0 Comments/in Extended Events, SQL Trace & Profiler, SQLPASS, Surveys/Umfragen, Tracing & MonitoringIn my session Session „Hasta la vista Profiler – Tracing with Extended Events“, which I have presented at several occasions, I used to ask the audience which tools they used for monitoring so far. I would like to use this platform to survey on a broader range as to which tools are being used by […]
Extended Event File Target size vs SQL Server Trace trace file – a comparison
/0 Comments/in Extended Events, SQL Trace & Profiler, Tracing & MonitoringNo big science, more out of curiosity this time.. The Extended Events File Target for SQL Server saves data using xml, which as is well known, is a bit “chatty”. A student in my recent SQL Server Master-Class workshop on extended events came up with the question for how much (more) space he would have […]
Tracing Analysis Services (SSAS) with Extended Events – Yes it works and this is how
/0 Comments/in Analysis Services, Extended Events, Tracing & MonitoringOne of the features new in Analysis Services 2012 is the support of the SQL Server Extended Events Framework. While there is no GUI support for that, yet, it is however possible to set up a XEvent session via DDL commands – just like it was in the “old days” with SQL Server 2008/ 2008 […]
SQL Server Master-Class Seminars – For all those who want to know exactly what’s what – Starting in May with Extended Events
/0 Comments/in Certification, MCM & MCSM, MVP, Extended Events, Seminare, SQLPASS, Tracing & MonitoringMy First Blog Post here is partly for my own cause, but on the other hand, it is for You and all those who are inquisitive and eager to learn in terms of SQL Server: I have often been asked if I wouldn’t want to write a book sometime to share my knowledge, or to […]
Locking & READONLY Filegroups vs READONLY Databases
/0 Comments/in Extended Events, Locking & Blocking, PerformanceThe Topic Locking and Read-Only for filegroups and databases is one of the ongoing myths around SQL Server in forums – and at least half of the information unfortunately wrong. Since I recently fell into the trap myself, I want to write down, how it really is. To have a definite picture, I made 3 […]
