Speed Matters – Turbo Charging Data Services with EF Core

Premier Developer consultant Rob Vettor brings us this post on performance of the new Entity Framework Core. Entity Framework Core (EF Core) has arrived and brings with it several long-awaited improvements. Officially released this past June, EF Core is a complete rewrite of the Entity Framework. While the high-level developer APIs (DbContext, LINQ queries, etc.)…


Parallel Processing in SAP

New generations of CPUs do not provide any significant single-thread performance improvements. Instead, the number of logical CPU cores is increasing with each new CPU generation. You can significantly reduce the runtime of a task by running sub-tasks in parallel on many CPU cores. However, splitting a task into sub-tasks consumes additional resources (CPU and…


Automatic plan correction in SQL Server 2017

Automatic plan correction is a new automatic tuning feature in SQL Server 2017 that identifies SQL query plans that are worse than previous one, and fix performance issues by applying previous good plan instead of the regressed one.


Automatic index management in Azure SQL database

Azure SQL Database has a built-in intelligence mechanism that can automatically tune and improve performance of your queries by dynamically adapting the database schema to your workload. In Azure SQL Database, you don’t need to worry about the index analysis and design, because Azure SQL Database learns about your workload and ensures that your data…


Get the Workflow details using the WorkflowInstanceID

When troubleshooting Sharepoint Workflows, one need that often comes out, is regarding how to get more details about a specific Workflow Instance on the Workflow Manager Databases. This is due to the fact that this is usually the piece of information we get from the Sharepoint and most of the times people do not know…


Performance evolution of SAP BW on SQL Server

In SAP customer support, we still see several customers running old SAP BW code that cannot leverage the improvements we delivered within the last years. In this blog, we want to demonstrate the huge performance improvements which can be achieved even without hardware replacements. Until 2011, the standard configuration of BW queries on SQL Server…


Performance: rxExecBy vs gapply on Spark

rxExecBy is a new API of R server release 9.1, it partitions input data source by keys and applies user defined function on each partitions. gapply is a SparkR API that also provides similiar functionality, it groups the SparkDataFrame using specified columns and applies the R function to each group.   Prepare Environment The performance…


New in SSMS: Query Performance Troubleshooting made easier!

The community already uses tools that can make it easier to read and analyze query plans (including SSMS), but these require significant expertise in understanding query processing and plans in order to be able to actually find and fix root causes. In the latest version of SSMS that released last week, we debut a new…