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

Cross post with https://aka.ms/sqlserverteam 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…


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

Cross post with https://aka.ms/sqlserverteam 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…


@@VERSION and SERVERPROPERTY – What changed?

  Cross post with aka.ms/sqlserverteam 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,…


Comparison Tool released with latest SSMS

Cross post with aka.ms/sqlserverteam 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)…


Cardinality Estimation for Correlated Columns in SQL Server 2016

  Cross post with aka.ms/sqlserverteam 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…


Ninja Troubleshooting- User Interface freezing during SQL Server database restore.

Hello world 🙂 To sum up, i was working with one of my customers regarding the UI (User Interface) freezing while restoring (Symantec NetBackup) a database into SQL Server 2012, leading to a unresponsive behavior from the server. Scenario (VMware guest – WS2012R2): Started with gathering performance counters to jump into the analysis and even though…

1