Performance

Optimizing Your Query Plans with the SQL Server 2014 Cardinality Estimator

  • Article

SQL Server 2014 introduces the first major redesign of the SQL Server Query Optimizer cardinality estimation process since version 7.0. The goal for the redesign was to improve accuracy, consistency and supportability of key areas within the cardinality estimation process, ultimately affecting average query execution plan quality and associated workload performance. This paper provides an overview of the primary changes made to the cardinality estimator functionality by the Microsoft query processor team, covering how to enable and disable the new cardinality estimator behavior, and showing how to troubleshoot plan-quality regressions if and when they occur.

2018-06-26

2,974 reads

Why is My Database Application so Slow?

  • Article

When your application is running slowly, the reflex action is to blame the database queries. It is certainly true that some of the more extravagant delays can be fairly blamed on a missing index or unnecessary locking, but there are other potential villains in the drama, including the network and the application itself. Dan Turner points out that you could save a lot of time and money by working out for sure where the problems lie before diving into the detail.

2017-11-02

7,358 reads

Blogs

Inspector V2.6 now available

By

As always the code can be found here in our github repoWe updated our...

Data Mesh: Centralized ownership vs decentralized ownership

By

I have done a ton of research lately on Data Mesh (see the excellent...

Daily Coping 23 Jul 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Define All The Steps Up Front

By Grant Fritchey

Comments posted to this topic are about the item Define All The Steps Up...

Having users access .dtsx (package file) saved on LAN

By redoak

Hello All, I created a package file (.dtsx) via SSDT. I took the folder...

AG is continually reporting failover due to mirroring connect error

By webrunner

Hello experts, I'm seeing this Always On Availability Group behavior around every 5 minutes....

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers