Performance

External Article

Using the SQL Monitor Estate Pages

  • Article

Kathi Kellenberger introduces the new Estate monitoring pages in SQL Monitor 9, and explains how they will help DBAs monitor and safeguard the security, stability and availability of all servers in their care.

2019-04-18 (first published: )

External Article

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

Blogs

Creating a user for a STONITH resource in vSphere

By

I previously blogged about how to create a STONITH resource for a pacemaker cluster...

Default event_file path for Extended Events

By

Foreword Have you ever wondered where the .xel file is saved when you create a...

Query Store Hints in SQL Server 2022

By

Another neat little feature in SQL Server 2022 is Query Store Hints. This is...

Read the latest Blogs

Forums

Display Top N values of a table with calculation next to it

By Soof1234

Hi, In Power BI Report Builder I need to use SSRS code for my...

Package runs in Debug mode but fails otherwise

By Alexp012

Hi We have a SSIS package that uploads data to Blob storage. The package...

Can anyone suggest a plan with backup full and backup log without backup diff ?

By vpmaciel

I need only one backup full at mid night, and one backup log each...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers