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…


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…


Optimize your Azure spend

In this post, App Dev Manager Priti Kalani shares insight toward optimizing the services you deploy and manage in the Microsoft cloud. Azure tools to optimize and manage your cloud spending Azure has made deploying cloud infrastructure and applications convenient and productive for organizations. Azure also provides tools to help you with managing the spend…


AX Performance Monitor 101 – Setup Perfmon for continuous monitoring with rolling files

  Windows Performance Monitor (PerfMon) is likely the most useful tool (together with our DynamicsPerf package) to monitor and diagnose performance problems related with your Microsoft Dynamics AX infrastructure and, in general, for any software running on Windows operating systems. Given its importance, is surprising how many people is not using it properly or, even worst, is not using…


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…


Calculate Pi to measure processor performance

We know that computers can calculate very quickly, but how do we compare performance between code? I know that processors have been improving immensely since my first processor in 1971 (see https://blogs.msdn.microsoft.com/calvin_hsia/2005/10/30/my-toys-over-the-years/ ). As improvements come to processors, not all programs take advantage of them. As processor manufacturers come up with new improvements (such as…


Where Did Application Insights Put my Performance Counter Data?

Premier Developer consultant Tim Omta recently shared this quick tip on his blog about where Application Insights performance counter data is stored after it’s pushed into Azure Diagnostics. I ran into an issue finding performance counter values I had pushed to Application Insights and wanted to note it to save others some time. You can…


High Value Scenarios – 4-Step Load Test

High Value Scenarios consist of multiple elements that can help to describe attributes of an applications performance effectively. There are a few different scenarios that I use on a day to day basis, which provide excellent analysis points. In this post, I will attempt to explain one of the scenarios, how to build it, how…


Setting up Always on Availability Group

Note: It is expected that reader has basic understanding of Always On Availability groups.   Pre-requisites :- Setting up Windows Server Failover Cluster (WSFC) Installation of Windows Server edition (2008 R2 or higher), SQL Server 2012, Windows Cluster + KB for quorum voting configuration, SQL Light Speed and DFS. The primary and the secondaries on…