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 […]
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 […]
Article “SQL Server 2014 – New Fundament” in iX Issue 5/2014
/0 Comments/in Columnstore Index, In-Memory OLTP/XTP, HTAP, SQL Server 2014In the May-issue of the iX, on page 56, there is an article by me which I wrote together with my colleagues Volker Heck (Cloud- and BI-Part) and Holger Schwichtenberg (copy-editing).
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 […]
