SQLServerCentral: Content tagged Performance

Grant Fritchey Reviews Minion Reindex

Grant Fritchey reviews Midnight DBA's Minion Reindex, a highly customizable set of scripts that take on the task of rebuilding and reorganizing your indexes. Read more...

By Grant Fritchey 2015/01/27 | Source: SQLServerCentral.com | Category: indexing

Rating:

|

Discuss |

Briefcase | 1,169 reads

SQL Server 2014 Checklist for Performance

A checklist to help optimize the performance of SQL Server Read more...

By Rudy Panigas 2014/12/29 | Source: SQLServerCentral.com | Category: performance

Rating:

|

Discuss |

Briefcase | 6,823 reads

Execution Plan reuse

By Steve Jones 2014/12/17 | Category: performance

Rating: (not yet rated) |

Discuss |

Briefcase | 1,688 reads

Trace Flags

By S M 2014/11/18 | Category: statistics

Rating: (not yet rated) |

Discuss |

Briefcase | 1,352 reads

Plan Guides

By Steve Jones 2014/10/20 | Category: sql server 2014

Rating: (not yet rated) |

Discuss |

Briefcase | 1,422 reads

Query the execution plan cache

This query will find the execution plans stored in the plan cache for an object that you specify in the WHERE clause. Read more...

By Derik Hammer 2014/10/02 | Source: SQLServerCentral.com | Category: performance

Rating:

|

Discuss |

Briefcase | 1,381 reads

The Ins and outs of In-Memory OLTP

As you may know, SQL Server is a very robust database, but SQL server has its performance bottlenecks. With the introduction of In-Line memory OLTP, there is a chance to get rid of the performance bottlenecks Read more...

By Roy Ernest 2014/09/16 | Source: SQLServerCentral.com | Category: microsoft sql server

Rating:

|

Discuss |

Briefcase | 5,537 reads

Find Most Expensive Stored PROCEDURE

SQL Server Stored Procedure Execute Count Script .. Read more...

By Yusuf Kahveci 2014/08/19 | Source: SQLServerCentral.com | Category: performance

Rating:

|

Discuss |

Briefcase | 2,882 reads

Report overlapping jobs

This script reports jobs which are running when another job is also running. This could be a reason for performance degradations. Read more...

By Wilfred van Dijk 2014/07/31 | Source: SQLServerCentral.com | Category: sqlagent

Rating:

|

Discuss |

Briefcase | 1,335 reads

SQL Server CPU Usage History Histogram

Returns a summary of CPU usage by SQL Server over the last 4 hours (default). Using the sample values collected in the dm_os_ring_buffers dmv, this query will show CPU usage by the SQL Server process for the last for hours even if you have no other benchmarking activities in place on your server yet. Read more...

By Jonathan Allen 2014/07/07 | Source: SQLServerCentral.com | Category: performance

Rating:

|

Discuss |

Briefcase | 2,700 reads

Using DBCC DROPCLEANBUFFERS When Testing Performance

Over the years I've had many discussions with other SQL Server Database Administrators as to whether or not you should have the database buffer pool loaded with data pages or empty when testing queries for performance. This tip will take a look at the effects on query performance for both cases by using the DBCC DROPCLEANBUFFERS statement to empty the buffer pool. Read more...

By Additional Articles 2014/06/20 | Source: MSSQLTips.com | Category: performance

Rating: (not yet rated) Rate this |

Briefcase | 7,575 reads

Finding and Eliminating Duplicate or Overlapping Indexes

Duplicate & Overlapping Indexes can be a drag on write speed and disk resources. How do we find and eliminate them quickly and effectively? Read more...

By Edward Pollack 2014/06/16 | Source: SQLServerCentral.com | Category: indexing

Rating:

|

Discuss |

Briefcase | 7,471 reads

Getting the Most out of Statistics

Statistics keep track of our data and will tell SQL Server how to make the best optimization decisions. Knowing how they work can make understanding query and performance problems much easier! Read more...

By Edward Pollack 2014/06/09 | Source: SQLServerCentral.com | Category: statistics

Rating:

|

Discuss |

Briefcase | 5,091 reads

Cardinality Regression

By Steve Jones 2014/06/02 | Category: sql server 2014

Rating: (not yet rated) |

Discuss |

Briefcase | 1,300 reads

Cursor-Killing: Retrieving Recently Modified Data

Cursors are considered by many to be the bane of good T-SQL. What are the best ways to avoid iterative T-SQL and to write queries that look and perform beautifully? In the next part of an ongoing series, we look at ways to efficiently retrieve recently modified data. Read more...

By Edward Pollack 2014/06/02 | Source: SQLServerCentral.com | Category: cursor

Rating:

|

Discuss |

Briefcase | 6,303 reads

Upgrading cardinality

By Steve Jones 2014/05/15 | Category: sql server 2014

Rating: (not yet rated) |

Discuss |

Briefcase | 1,364 reads

Hash Match

By Steve Jones 2014/05/01 | Category: performance

Rating: (not yet rated) |

Discuss |

Briefcase | 1,554 reads

Divide and Conquer - Performance Tuning

Sometimes we need to break down a complex problem into a multiple stage solution to achieve optimal performance Read more...

By Claire Mora 2014/04/08 | Source: SQLServerCentral.com | Category: t-sql

Rating:

|

Discuss |

Briefcase | 7,707 reads

Reaping the benefits of the Window functions in T-SQL

Exploring the potential benefits of the T-SQL Window functions (OVER, LAG, and LEAD) in this piece. You can learn how to achieve up to 50% performance boost by replacing a single function call. Read more...

By Eirikur Eiriksson 2014/03/24 | Source: SQLServerCentral.com | Category: sql server 2012

Rating:

|

Discuss |

Briefcase | 8,679 reads

Join Operations – Hash Match

The way in which SQL Server chooses to join your tables in a query can dramatically affect performance. In this article, Jason Brimhall explains how a hash match works and shows some performance numbers. Read more...

By Jason Brimhall 2014/03/04 | Source: SQLServerCentral.com | Category: execution plans

Rating:

|

Discuss |

Briefcase | 8,451 reads

Content with tag Performance