SQLIO Disk Subsystem Benchmark Tool is being retired

We are retiring the “SQLIO Disk Subsystem Benchmark Tool” and the download will no longer be available starting today. The download page will still be online for a while since this tool is very popular in various search engines. SQLIO download page has been updated to redirect to the dskspd tool. Microsoft recommends using dskspd…

2

SQL Server 2016 – Added information on TempDB Spill events – xEvents

My previous post was about new information added to spill warnings. Those are visible at the query plan level, but what about if you need to track for an extended period of time? While spills are something that denotes some type of inefficiency, starting with IO usage where only memory usage was expected, but also…


Transactional Replication to Azure SQL DB is now in public preview.

  As announced yesterday during my presentation at Pass Summit 2015, you can now configure Azure SQL DB as a subscriber of SQL Server Transactional Replication. This new capacity of Transactional Replication is available starting with the following versions\updates of SQL Server: Community Technology Preview (CTP) 3.0 of SQL Server 2016 SQL Server 2014 Service…

1

SQL Server 2016 – Added information on TempDB Spill events – Showplan

For those that have some experience analyzing query plans, you probably have come across spills to TempDB. These warnings can show up in Hash or Sort operations as a yellow exclamation mark. In fact, although both use TempDB, these are quite different in intent and also in implementation. For instance, a hashing operation that spills…


@@VERSION and SERVERPROPERTY – What changed?

With the recent release of SQL Server 2014 SP1 CU3 and SQL Server 2014 RTM CU10, you will notice another change in the output @@VERSION. The motivation to introduce this change in the @@VERSION output string is completeness of the string information itself. This has been true over the years, as we have been introducing…


How we moved from on-premise to Azure Virtual Machine

We had previously blogged about moving some of our on-premise SQL Server environments which manages critical functions necessary for releasing the SQL Server builds to all our customers. We announced SQL Server 2016 CTP 2.4 which was made available on September 30th, 2015. You can download the preview from the Microsoft TechNet Evaluation Center site….

0

Released: System Center Management Pack for SQL Server and Replication (6.6.2.0)

We are happy to announce that a new version of SQL Server and Replication Management Packs has been released! Only the English version is available at this time. Localized management packs for this version will be made available at a later time. Downloads available: Microsoft System Center Management Pack for SQL Server enables the discovery…


MSSQLTIGER at SQL PASS Summit 2015

The SQL PASS Summit is round the corner and we are quite excited about it. The Microsoft SQL Server Tiger team will be at the SQL PASS Summit and is looking forward to meet the SQL Family. We will also be speaking at a few sessions during this summit. The PASS Summit is the world’s…

0

Comparison Tool released with latest SSMS

The ability to compare plans is something that a lot of people have to do for troubleshooting reasons. Maybe it’s to find why a query or batch suddenly slowed down; to understand the impact of a rewrite; or observe how a specific performance-enhancing change introduced to the design (like an index) has effectively changed the…


Multi-fold increase in throughput for big gateway query compiles in SQL Server

There are some exciting new changes in the database engine that dramatically improves query compilation scalability in SQL Server 2014 and SQL Server 2016. These changes are yet another reason to upgrade your SQL Server versions. When a query first starts and has to be compiled in SQL Server, it needs to acquire memory for…

5