performance Tag

The Five DBA Food Groups

Tomorrow is Thanksgiving here in the USA. It's a day where we are supposed to be thankful for what we have been given and instead we mostly use it as an excuse to eat obscene amounts of food, watch 10 hours of NFL action, and force...

SQL Server 2014 Cardinality Estimator
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...

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...