Gotchas – Microsoft Graph/Outlook REST API throttling, best practices

In recent times, I was working with this customer where they make Graph API calls, Say, GET https://graph.microsoft.com/v1.0/users/YYY@XXX.onmicrosoft.com/mailFolders/inbox/messages?$skip=0&$top=30&$select=bodypreview,categories,conversationid,from,hasattachments,id,isdraft,isread,lastmodifieddatetime,parentfolderid,receiveddatetime,replyto,sender,sentdatetime,subject,torecipients and few other GET (read operations of mail folders/single item handles specifically) and few POST/PATCH calls. They noticed, once the throttling threshold is exceeded, Microsoft Graph limits any further requests from that client for a period of…


Troubleshooting ASP.NET Core Performance Problems

This is a guest post by Mike Rousos I recently had an opportunity to help a developer with an ASP.NET Core app that was functionally correct but slow when under a heavy user load. We found a few different factors contributing to the app’s slowdown while investigating, but the majority of the issues were some…


SQL Server on Linux: Quick Performance Monitoring

I have been asked several times about how to get a Performance Monitor like view on Linux.   There are lots of Linux tools available (top, iotop, Grafana, and SQL Sentry just scratch the surface of available options) to monitor the Linux system.  Allow me to share one such example to capture and monitor a system….


Improving the responsiveness of critical scenarios by updating auto load behavior for extensions

The Visual Studio team partners with extension authors to provide a productive development environment for users, who rely on a rich ecosystem of quality extensions. Today, we’re introducing an update to extension auto load based on feedback from our community of developers, who need to quickly start Visual Studio and load their solution while deferring…


Replication Enhancement – Improved Distribution Database Cleanup

Replication Distribution database is the perhaps the most important entity in the entire replication topology. Apart from storing the replication metadata and history for replication agents, the distribution database, in case of transactional replication, also provides intermediate storage for the transactions and commands that will be shipped to the subscribers. These transactions and commands stored…


Flat Cube became default in SAP BW

Overview The following features have been optionally available in SAP BW on Microsoft SQL Server for several years: SQL Server Columnstore for BW cubes (as of SAP BW 7.0) See also https://blogs.msdn.microsoft.com/saponsqlserver/2018/04/26/columnstore-became-default-in-sap-bw Columnstore Optimized Flat Cube (as of SAP BW 7.4) The impact of these features is described in https://blogs.msdn.microsoft.com/saponsqlserver/2017/05/08/performance-evolution-of-sap-bw-on-sql-server. Customer experience showed, that using…


Columnstore became default in SAP BW

Overview The following features have been optionally available in SAP BW on Microsoft SQL Server for several years: SQL Server Columnstore for BW cubes (as of SAP BW 7.0) Columnstore Optimized Flat Cube (as of SAP BW 7.4) See also https://blogs.msdn.microsoft.com/saponsqlserver/2018/04/26/flat-cube-became-default-in-sap-bw The impact of these features is described in https://blogs.msdn.microsoft.com/saponsqlserver/2017/05/08/performance-evolution-of-sap-bw-on-sql-server. Customer experience showed, that using…


Azure Load Balancing Solutions: A guide to help you choose the correct option

In this post, Sr. App Dev Manager Fidelis Ekezue explain Azure Load Balancing options and highlight considerations for choosing a solution. Azure Load Balancing Solutions: When to choose which one? Microsoft Azure provides customers with many ways to load balance traffic requests to their environments. Customers have the options to choose Traffic Manager, Azure Load…


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…