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

Cardinality Estimation for Correlated Columns in SQL Server 2016

When we introduced the new CE back in SQL Server 2014, several changes were done regarding the assumptions of the model. These changes were introduced because the vast potential for variations in data distribution, volume and query patterns, made some of the model assumptions not applicable. The 4 assumptions for the pre-2014 model were: Independence:…


New extended events for database recovery progress

In yesterday’s blog post, I talked about a new extended event for backup and restore. Continuing with the theme of insights into progress of long running tasks, another area we have invested in is database recovery. As most of you can attest, there is limited information available during database recovery activities such as Analysis, Redo…

0

New extended event to track backup and restore progress

Backup and restore are long running tasks in SQL Server with limited insights into progress. Often a question asked is “How much longer will it take for this operation to complete?”. Though there are trace flags and DMVs that provide some information, they are either unstructured (ex: trace flags send output to error logs and…

0

Record breaking performance numbers for SQL Server 2014

Record breaking performance numbers were recently published for SQL Server 2014 for various hardware systems. TPC-E (which measures the online transaction processing workload) and TPC-H (which is a decision support benchmark) numbers at the link below show SQL Server in the top ten price/performance for different hardware and OS platforms. TPC-E: http://www.tpc.org/tpce/results/tpce_price_perf_results.asp TPC-H: http://www.tpc.org/tpch/results/tpch_price_perf_results.asp  

1

We are running the latest bits

Microsoft SQL Server continues its transformational journey by pushing out some key features which would help customers realize the true potential of their data. Incidentally, the SQL Server engineering group uses a large number of SQL Server deployments to manage our lab systems, test run scheduling, engineering dashboards and build systems. These are critical systems…


Encryption options in RESTORE HEADERONLY

Backup Encryption was introduced in SQL Server 2014 as way to encrypt the data while creating a backup. By specifying the encryption algorithm and the encryptor (a Certificate or Asymmetric Key) when creating a backup, you can create an encrypted backup file. However, there was no ability to look at encryption metadata in an encrypted…

2

IO Statistics now available for queries that use Columnstore indexes

Prior to SQL Server 2014 Service Pack 1, if you turned on STATISTICS IO for queries that touch Columnstore index, it would always report 0 as seen in the simple example below:   CREATE TABLE t (c INT) GO INSERT INTO t VALUES (1) GO CREATE CLUSTERED COLUMNSTORE INDEX cci ON t GO SET STATISTICS…

0

Eliciting your feedback about upgrading SQL Server

SQL Server DBAs –   The SQL Server engineering team needs you and your input! We’re running a high-velocity planning program about upgrading SQL Server and this process is literally driven on your feedback. Don’t think you need a super-sized monster system to qualify; we’re looking for a wide range of inputs and perspectives. If…