-->
Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

DotNine SQL Server and more

I am a database specialist from the Netherland with my main focus on Microsoft SQL Server. My IT career began 14 years ago as a System Administrator. I have been working with SQL Server for more then 10 years now and a full time DBA for 5 years.

Comparing plan consistency and query performance using the Query Store Replay script

The 1.2 version of the Query Store Replay script a number of new features are added that return information of the query behavior on the target server. More specifically, in version 1.2 you are able to compare execution plans and query runtime statistics between replay executions on the source and… Read more

2 comments, 1,163 reads

Posted in DotNine SQL Server and more on 30 December 2016

Replay your workload through the Query Store Replay script!

One of the great features of the Query Store is that it stores query execution plans and runtime performance on-disk and makes it easily accessible through its DMVs and built-in reporting.
Using the information inside the Query Store can make database migrations to higher SQL Server versions far easier, since… Read more

3 comments, 203 reads

Posted in DotNine SQL Server and more on 19 December 2016

Query Store Database Dashboard v1.3 released!

Next to releasing a new version of sp_WhatsupQueryStore, I just released the 1.3 version of the Query Store Database Dashboard!

Release notes:

  • Forced execution plan overview removed Instead you should use sp_WhatsupQueryStore to quickly analyse forced plans by running EXEC sp_WhatsupQueryStore @dbname = ‘your database’, @return_forced_plans = 1.

    You…

Read more

0 comments, 143 reads

Posted in DotNine SQL Server and more on 15 December 2016

sp_WhatsupQueryStore v1.2 available

sp_WhatsupQueryStore v1.2 has just been released!
In this new version additional parameters are added to control what information is returned and a change has been made to the information that is returned by default.

Releasenotes:

  • Changed what information is returned by default when no additional parameters are supplied.
    In the…

Read more

1 comments, 149 reads

Posted in DotNine SQL Server and more on 15 December 2016

sp_WhatsupQueryStore version 1.1 released

Today I released a new version of the sp_WhatsupQueryStore stored procedure. sp_WhatsupQueryStore returns many configuration and performance metrics that are stored inside the SQL Server Query Store through an easy to use stored procedure.

In version 1.1 many new optional parameters are added that influence the output of the stored… Read more

0 comments, 153 reads

Posted in DotNine SQL Server and more on 6 December 2016

Retrieving Query Store query performance data through sp_WhatsupQueryStore

This afternoon I tweeted that a new Query Store related stored procedure I created is available: sp_WhatsupQueryStore.This blog post goes into more detail on how you can use sp_WhatsupQueryStore to easily and quickly retrieve query performance data from the Query Store.

Installation

The first thing you want to do… Read more

12 comments, 1,556 reads

Posted in DotNine SQL Server and more on 24 November 2016

SQL Server 2016 SP1 Query Specific Wait Statistics Available Through Execution Plans

SQL Server 2016 SP1 added loads of cool new features and options. One of those is a change that expands the amount of information that is stored inside an execution plan. Since I love using Wait Statistics as a way to identify performance bottlenecks, I was literally jumping through the… Read more

4 comments, 1,238 reads

Posted in DotNine SQL Server and more on 20 November 2016

Query Store changes in SQL Server vNext CPT1

Not only did we receive a brand new Service Pack for SQL Server 2016 this week, since yesterday we are able to play with the first Community Technology Preview (CTP) of SQL Server vNext!

Since I adore the Query Store feature which was introduced in SQL Server 2016, a large… Read more

0 comments, 205 reads

Posted in DotNine SQL Server and more on 17 November 2016

SQL Server 2016 SP1: DBCC CLONEDATABASE now with Query Store data!

SQL Server 20016 SP1 is released today and it introduces a truck load of new features and options. Even better, it makes many of the Enterprise only features available in Standard!

Ever since SQL Server 2014 SP2 introduced the new DBCC CLONEDATABASE command to create a schema and statistics… Read more

2 comments, 272 reads

Posted in DotNine SQL Server and more on 16 November 2016

Query Store Instance Dashboard

Last week I shared my custom Query Store Dashboard that can be used to view additional performance information that isn’t always directly available through the built-in Query Store reports.

The dashboard I shared last week returns information on a per-database basis by right-clicking a database with the Query Store enabled… Read more

1 comments, 393 reads

Posted in DotNine SQL Server and more on 7 November 2016

Query Store custom SSMS performance dashboard

As most of you might know, I am a big fan of the Query Store feature inside SQL Server 2016. There is however one feature I dearly miss, the ability to customize or build reports underneath the Query Store folder in SQL Server Management Studio.

Even though the built-in reports… Read more

2 comments, 1,632 reads

Posted in DotNine SQL Server and more on 2 November 2016

DBCC CLONEDATABASE and sensitive data

Just over 2 months ago Service Pack 2 for SQL server 2014 was released. Included in this Service Pack is a new DBCC command, DBCC CLONEDATABASE. As the name suggest this command can be used to make a clone of your user database without the table data. Instead it creates… Read more

0 comments, 476 reads

Posted in DotNine SQL Server and more on 28 September 2016

Broadening Horizons: From DBA to Data Science #2 Math Fundamentals

In the previous article in this blog series I told you my plans of expending my horizons towards the Data Science field. As I noted in that article my first steps towards Data Science consists of getting my math knowledge up-to-date again on math areas like linear algebra and matrices. Read more

0 comments, 1,150 reads

Posted in DotNine SQL Server and more on 6 June 2016

Broadening horizons: from DBA to Data Science #1

As an IT professional we are used to spending a lot of time learning about new technologies or how we can improve our knowledge on the products we work with. For more than 10 years now I have been working with SQL Server and still continue to learn new things… Read more

5 comments, 2,123 reads

Posted in DotNine SQL Server and more on 2 June 2016

SQL Server 2016 – It just runs faster SQL Server Engineer Blog Post Overview

In March the CSS SQL Server Engineers started to blog about various new enhancements made to the SQL Server Engine in SQL Server 2016. Even though these performance enhancements don’t get as much attention as the big new features introduced in SQL Server 2016 (like Query Store), they can play… Read more

1 comments, 2,473 reads

Posted in DotNine SQL Server and more on 13 April 2016

SSMS Preview Plan Comparison Tool and Plan Viewer Optimizations

With the February release of the SQL Server Management Studio (SSMS) Preview Microsoft introduced a nice new tool inside SSMS, the Plan Comparison Tool.
Like the name suggests, the tool makes it possible for you to compare different plans inside SSMS, but it doesn’t stop there. Microsoft also managed to… Read more

0 comments, 350 reads

Posted in DotNine SQL Server and more on 6 April 2016

Talking about the Query Store at SQLBits!

From the 4th till the 7th of May 2016 one of the biggest SQL Server conference in the world will be in Liverpool promising four days of great SQL Server sessions and training. Just take a look at the agenda to be blown away by the amount of… Read more

0 comments, 315 reads

Posted in DotNine SQL Server and more on 29 March 2016

SQL Server Management Studio Preview

You may have heard that SQL Server Management Studio (SSMS) is now available as a stand-alone installation package outside of the SQL Server setup (as a preview version). With the release of SQL Server 2016 RC0, Microsoft decided to cut the cords with SQL Server Management Studio as it has… Read more

1 comments, 392 reads

Posted in DotNine SQL Server and more on 18 March 2016

Session Based Wait Statistics in SQL Server 2016

As you probably know I am very fond of SQL Server Wait Statistics (shameless book link) and the options they provide for analyzing SQL Server performance. During SQL Server version releases new options became available to monitor and/or analyze Wait Statistics but one option for Wait Statistics analysis… Read more

0 comments, 411 reads

Posted in DotNine SQL Server and more on 14 March 2016

Pro SQL Server Wait Statistics available now!

Remember that blog post from April this year that I announced working on my first ever SQL Server related book “Pro SQL Server Wait Statistics”? Well good news, it is available now!

Pro SQL Server Wait Statistics is available in a variety of different formats, including ePub, Kindle and paperback… Read more

1 comments, 1,123 reads

Posted in DotNine SQL Server and more on 2 September 2015

Older posts