Posts
Full day PreCon Practical Performance Analysis in Melbourne at Asia & Australia Tour 2018
/0 Comments/in Azure, Conferences, HADR, AlwaysOn, Locking & Blocking, Performance, SecurityAs it has almost become a habit by now for me, I will be touring Asia this summer. This year not only Asia, but for the first time also Australia. (There, however, is winter, which sometimes leads to funny confusion in agreements until you get used to this.) 1st stop: Singapore – Azure SQL Database […]
Tracing with XEvents in Azure SQL Database
/0 Comments/in Azure, Extended Events, Tracing & MonitoringBeing Developer, Administrator or simply Support for an Azure SQL Database based Application, there are those moments when the Azure-provided Dashboard-capabilities are not sufficient and you need to conduct a throughout trace of certain statements occurring.
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 […]
