Logging Schema-changes in a Database using DDL Trigger
/0 Comments/in Miscellaneous, Scripts, Security, Tracing & MonitoringTracing 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.
The new SQL Server Master-Class in – why SQLSentry Bootcamp
/0 Comments/in Extended Events, Seminare, Tracing & MonitoringFirst off, the most important information in a nutshell: From 26-28 June, I am conducting a new SQL Server Master-Class: The Performance Troubleshooting Bootcamp with SQLSentry (shorthand: PSS*). For those in a hurry, the link for registration right below: http://sql-server-master-class.com/#PSS
Where is that Preemptive Wait coming from?
/3 Comments/in Extended Events, In-Memory OLTP/XTP, HTAP, Performance, Security, SQL Server 2016, Tracing & MonitoringIn this article I will bring together several techniques for troubleshooting a performance- and security-related “phenomenon” I recently noticed when doing some tests with Natively Compiled Stored Procedures.
Sessions submitted for major conferences 2016. Topics: Security – Performance – In-Memory
/in Conferences, Extended Events, In-Memory OLTP/XTP, HTAP, Performance, Security, SQL Server 2016, SQLPASS, Tracing & MonitoringAfter the great success of the German SQLKonferenz in February, where I had the honor of presenting the new security features of SQL Server 2016 together with Joachim Hammer, the Program Manager of the security teams of the relational SQL Engines at Microsoft in Redmond (more info), I finally found time to go about the […]
My conference sessions in 2015: from Extended Events over In-Memory to Security
/in Columnstore Index, Conferences, Extended Events, In-Memory OLTP/XTP, HTAP, Locking & Blocking, Security, Seminare, Storage EngineFinally I get to write about my conference-talks in 2015. The year started really great with the German SQL Server Konferenz in Darmstadt with 2 sessions on In-Memory OLTP in SQL Server 2014 – one of them being even a full-day PreCon, which I co-presented with Niko Neugebauer, who was talking about Clustered ColumnStore Indexes.
How to import Extended Events session event_file target and parse deadlock-graph
/0 Comments/in Extended Events, Locking & Blocking, Tracing & MonitoringThis time it’s about one of the things that Extended Events do better and more easily than all techniques before: Saving of deadlock-events that occurred and analyzing the respective deadlock-graph.
Free SQL Deadlock Collector & Parser published at codeplex
/0 Comments/in Extended Events, Locking & Blocking, Scripts, Tracing & MonitoringToday I redeemed a promise made long ago: To provide the deadlock-collector framework, which I developed for use at my customers’, as a Codeplex project. Until now I have only given it out to attendees of my SQL Server Master-Classes and a few fellow Microsoft Certified Masters. From today on it is freely available to […]
Performance/ Management Data Warehouse Data Collector & AlwaysOn Availability Groups
/0 Comments/in MDW, Tracing & MonitoringThis time, we are dealing with the „MDW“, short for Management Data Warehouse,( http://msdn.microsoft.com/en-us/library/bb677306.aspx), which I like to recommend as a minimal performance logging-approach. From time to time, and most recently in the context of my PASS Essential „SQL Server Analysis tools & Techniques for Performance und general Monitoring“, the question arises as to whether […]
