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

Investigating the Cause of SQL Server High CPU Load Conditions When They Happen

  • Article

Any DBA who is trying to find the cause of an intermittent problem with a server or database dreams of being able to use a query or procedure take a snap of the relevant variables at the point when the problem occurred. Laerte takes an example of a slow-running query hogging resources to show that you can run queries when a WMI alert is fired, and save the results for later inspection, whenever it happens.

2017-09-20

4,188 reads

Blogs

Power BI Monthly Digest – February 2020

By

In this month’s Power BI Digest Manuel I will again guide you through some...

Using Google Chrome with SSRS

By

In this post, you will learn how to resolve the Kerberos Double-Hop issue and...

Using Google Chrome with SSRS

By

In this post, you will learn how to resolve the Kerberos Double-Hop issue and...

Read the latest Blogs

Forums

"Gold Trim X" : https://fitawarezone.com/gold-trim-x/

By wooxkooa

Gold Trim X is really good for those people who have been looking for...

Copy the Code from an SSIS Package

By Oscar_Boots

Hi Forum, I want to copy the .xml code from an existing SSIS Package...

More Data

By Steve Jones - SSC Editor

Comments posted to this topic are about the item More Data

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

More Data

See possible answers