performance

SQL 2014 Cardinality Estimator: Why You Should Care – Part 2

SQL 2014 Cardinality Estimator: Why You Should Care – Part 2

In the previous post I talked about how query optimization works, the role the Cardinality Estimator (CE) plays, and why you should care. Today I am going to break down some of the details about the differences between the old and new CE, as well as show some examples and scenarios. What’s New in the SQL 2014(…)

SQL 2014 Cardinality Estimator: Why You Should Care

SQL 2014 Cardinality Estimator: Why You Should Care

This is the first of two posts on the new Cardinality Estimator in SQL Server 2014.  SQL Server 2014 comes with a lot of shiny things. Hekaton (or as Microsoft Marketing likes to call it, In-Memory OLTP), updateable Columnstore indexes, and buffer pool extensions are some of the more common enhancements. All of those new(…)

Performance Metrics for SQL Server 2014

Performance Metrics for SQL Server 2014

We all crave routine in our life, from the time we are babies through adulthood. Routine and familiarity. This extends to how we do performance monitoring and troubleshooting. Everyone has their favorite set of tools to help get the job done, tools that have a familiar routine involved to make them work best for us. Over the(…)

SQL Server Troubleshooting Useful Links

SQL Server Troubleshooting Useful Links

When it comes to troubleshooting performance issues with SQL Server queries, you don’t need an advanced degree in rocket surgery. You just need an idea of what the possible bottlenecks are and then apply some common sense. I “bucketize” performance issues by following a process of asking some simple questions. It goes something like this: Are all queries(…)

Load More