Large C# and VB solutions load significantly faster in 15.5 update

On average, 50 percent of all solutions opened by Visual Studio users open in ten seconds or less. However, large solutions can take longer to load because there are a lot of projects that Visual Studio needs to process. Over the last six months, we looked at ways to make solution load much faster, even…


Test Experience Improvements

There have been several significant improvements to the test experience that range across Visual Studio and Visual Studio Team Services. These efforts involved frameworks and tooling for both .NET and C++, but all had a common goal: make testing with our developer tools a great experience. .NET Side-by-side Performance Comparison These improvements are best shown…


JSON vs CLR UDT – performance comparison

Ability to create custom user defined types in CLR and use them in SQL Server is introduced in SQL Server 2005. In SQL Server 2016 is added JSON support that might be alternative for storing complex objects. Since JSON is stored as NVARCHAR and CLR is a type, it is questionable what would be better…


JSON parsing is faster than Spatial equivalent

One of the most common assumption when people talk about JSON in SQL Server is that it is slow because it is placed in “plain text” and there is no native type. Instead of the assumption it is better to experiment and compare performance of JSON with some real native type. In this post, I…


JSON parsing 10x faster than XML parsing

Usually, when people talk about the performance of JSON in SQL Server, they are starting with “JSON is not actually a native type, it is just a plain text” and imply that it is probably too slow. It is true that JSON is stored as NVARCHAR and that there is no special type like for…


Is Dynamics 365 Server-Side Sync filling up your database?

Our PFE colleague in Norway Ritesh Ranjan recently published the following article on his blog. We are cross-posting here for your reading pleasure! Well, if you are wondering, looking at the TraceLogBase table size, that there is a problem with the Dynamics CRM Server-Side Sync, then I would say ‘NO’. There is no problem with…


RyuJIT Just-in-Time Compiler Optimization Enhancements

I’d like to tell you about some of the recent changes we’ve made as part of our ongoing work to extend the optimization capabilities of RyuJIT, the MSIL-to-native code generator used by .NET Core and .NET Framework. I hope it will make for an interesting read, and offer some insight into the sorts of optimization opportunities we have…


Great MSDN Blogs for Testers Using VSTS

Hi, I’m just going to post a bunch of redirects here to help you find other testing resources.   https://blogs.msdn.microsoft.com/devops/tag/testing/ This blog is brought to you by the team developing the testing capabilities in Visual Studio.   https://blogs.msdn.microsoft.com/testingspot/ This is a blog that my team puts out monthly, it contains various performance and testing information.


Four Traits of Great Performance Testers

Whether you are a hiring manager looking for the right candidate or a current performance tester who wants to become better, these four traits will help. Passion in technology My first question in every interview is “What is the reason you perused a career in the IT field?”. This filters out people who are not…


Load Test Network Connection Monitoring

Questions around how to understand the number of connections an application is using have always existed, and have become important for various reasons over the years. There was one instance that changed my perspective on monitoring active and inactive network connections. It was an application which used an Oracle backend. At the time we were…