Enrico van de Laar

Enrico van de Laar is a 33 year old SQL Server geek from the Netherlands that loves to write, talk, present and breathe SQL Server. He is a SQL Server MVP and frequently speaks at different SQL Server events in Europe. In September his first book “Pro SQL Server Wait Statistics” (Apress) was released ( Amazon link: )

Follow Enrico van de Laar via
04 January 2017
04 January 2017

Query Store and In-Memory OLTP

0
3
Once you have Query Store enabled on your databases, runtime statistics are generated for your queries; but what about the natively-compiled stored procedures and memory optimised tables that come with In-Memory OLTP? Do you get the full range of runtime statistics? This is an intriguing question that Enrico explores and answers.… Read more
0
3
29 November 2016
29 November 2016

Determining What Happens When You Force an Execution Plan via the Query Store

0
8
When you force a query plan via the Query Store, you will need to track what happens: Sometimes the request to force a plan will fail, and you will want to know when and why. There are several ways of getting feedback, ranging from the built-in reports to using extended events. Enrico explains the details.… Read more
0
8
13 April 2016
13 April 2016

The SQL Server 2016 Query Store: Analyzing Query Store Performance

0
14
There are some obvious advantages to having the Query Store, but what is the performance impact that it is likely to have on a busy OLTP database server? It is early days, of course and until we get more experience we have to rely on Microsoft's estimate of a performance impact of 3-5% on average. However, this will depend on a number of factors such as usage an the way it is configured. Enrico explores some of these factors in order to give a clearer picture of what you should expect.… Read more
0
14
16 March 2016
16 March 2016

The SQL Server 2016 Query Store: Forcing Execution Plans using the Query Store

0
20
The SQL Server 2016 Query Store can give you valuable performance insights by providing several new ways of troubleshooting queries, studying their plans, exploring their context settings, and checking their performance metrics. However, it can also directly affect the performance of queries by forcing Execution Plans for specific queries.… Read more
0
20
26 January 2016
26 January 2016

The SQL Server 2016 Query Store: Accessing Query Store Information Using DMVs

0
15
The SQL Server 2016 Query Store provides several new ways of troubleshooting queries, studying their plans, exploring their context settings, and checking their performance metrics. In using the Query Store to ensure that performance is as good as possible, it isn't long before it becomes important to be familiar with the DMVs that are associated with the query store, and using them in custom queries.… Read more
0
15
06 January 2016
06 January 2016

The SQL Server 2016 Query Store: Built-in Reporting

0
29
One of the most important features of the SQL Server 2016's new Query Store is the reporting. With these features, it is now possible to get a wealth of information on how your query workload is performing, either aggregated for the entire query workload or for a single query. With this information, you can see the effects of 'forcing' an execution plan for specific queries and get feedback of the consequences.… Read more
0
29
16 November 2015
16 November 2015

The SQL Server 2016 Query Store: Overview and Architecture

0
85
SQL Server's Query Store, introduced in SQL Server 2016, helps to troubleshoot query performance by capturing a range of information about query usage, CPU, memory consumption, I/O and execution time, and retaining every Execution Plan for analysis. Much of this information is available through queries. It looks set to be the most significant enhancement of SQL Server 2016.… Read more
0
85