Troubleshooting data movement latency between synchronous-commit AlwaysOn Availability Groups

Writer: Simon Su Technical Reviewer: Pam Lahoud, Sourabh Agarwal, Tejas Shah Applies to: SQL Server 2014 SP2, SQL Server 2016 SP1, SQL Server 2017 RTM  In synchronous-commit mode AG nodes sometimes you may observe your transactions are pending on HADR_SYNC_COMMIT waits. HADR_SYNC_COMMIT waits indicate that SQL server is waiting for the signal from the remote…


Load solutions faster with Visual Studio 2017 version 15.6

As we have been working to improve the solution load experience in Visual Studio 2017, you may have read our blog about these improvements in version 15.5. With version 15.6, we have introduced parallel project load, which loads large .NET solutions twice as fast as earlier versions when you reload the same solution. This video…


Windows 10 1709 – Explorer ist sehr langsam auch der Kontext Menü

Hallo zusammen, Ich möchte einige Berichte bestätigen, wonach man mit Windows 10 1709 und aktivierten App-V eine massive Verzögerung beim Aufruf der Kontext-Menüs feststellen kann sowie auch beim ersten Start des Explorers als Datei Manager. Die Ursache liegt nach ersten Untersuchungen in der Art und weise wie wir (App-V) die Shell Extensions bzw. generell das…


PowerShell Profiling

In the following post, Premier Developer Consultant Lizet Pena De Sola shows us how to analyze the performance of PowerShell scripts to pinpoint code with high CPU consumption and optimize resource usage. As part of my job I help developers take a closer look at the source code and analyze it under the “microscope”. Part…


More Showplan enhancements – UDFs

Cross post with http://aka.ms/sqlserverteam As I mentioned on yesterday’s post, with the recent release of SQL Server 2017 CU3, we released yet more showplan enhancements: you can see other posts related to showplan enhancements here. In this article I’ll talk about the second showplan improvement we worked on, to assist in the discoverability of UDF…


More Showplan enhancements – UDFs

As I mentioned on yesterday’s post, with the recent release of SQL Server 2017 CU3, we released yet more showplan enhancements: you can see other posts related to showplan enhancements here. In this article I’ll talk about the second showplan improvement we worked on, to assist in the discoverability of UDF usage impact on query…


Analyze Synchronous Commit Impact on High Commit Rate Workloads

Recently the SQL Server Always On Support team at Microsoft CSS published a blog on analyzing the performance impact of Synchronous Commit AG’s with workloads that perform a large number of small transactions. For Synchronous AG’s every transaction commit needs to be hardened on the transaction log of the secondary replica and the hardening has…

1

Unified Service Desk 3.2.0 is Released

Continuing towards our goal towards a high performance, more reliable and secure Unified Service Desk, we have released the latest version 3.2.0. (https://go.microsoft.com/fwlink/p/?linkid=867343) Unified Service Desk version 3.2.0 has major enhancements on performance diagnostics, faster load times for CRM entity pages and graceful handling and recovery of crashed or unresponsive Internet Processes. The highlights of…


Improve SAP BW Performance by Applying the Flat Cube

Overview SAP released the Columnstore Optimized Flat Cube over two years ago. We want to give a brief explanation of the benefits and advantages of using the Flat Cube – and in consequence engage customers to apply it. The Flat Cube has many benefits, for example, improved BW query performance and faster Data Transfer Processes…