Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Performance Rss

<< Newer    Items 21 to 40 of 71    Older >>
 

Query Performance Report

The procedure created by this script rolls up the collected query execution statistics and groups them daily by the plan hash value.  Read more...
By Steven Guest 2016/01/20 | Source: SQLServerCentral.com | Category: performance
Rating: |  Discuss |   Briefcase | 4,822 reads

Testing SQL Server Backup Performance with Trace Flag 3042

Starting with SQL Server 2008 a new feature which allowed us to create compressed backup files by pre-allocating space. This tip will look at the performance impacts of disabling pre-allocation of space using the 3042 SQL Server trace flag.  Read more...
By Additional Articles 2015/05/19 | Source: MSSQLTips.com | Category: trace flag
Rating: (not yet rated)  Rate this |   Briefcase | 6,263 reads

Identifying Start Dates not Aligned with End Dates on a Prior Row

When effective end dates don't align properly with effective start dates for subsequent rows, what are you to do?  Read more...
By Dwain Camps 2015/03/24 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 6,235 reads

Understanding Graphical Execution Plans - Part 1: Explaining the Plan

Understanding execution plans is a good basic skill for all DBA's and SQL developers. Darren White gives us an overview of what execution plans are in SQL Server and how they are used.  Read more...
By Darren White 2015/02/13 (first published: 2014/02/18) | Source: SQLServerCentral.com | Category: execution plans
Rating: |  Discuss |   Briefcase | 26,445 reads

Performance of the SQL MERGE vs. INSERT/UPDATE

The SQL MERGE statement offers convenience, safety and elegance, but how does it perform compared to other methods?  Read more...
By Dwain Camps 2015/02/06 (first published: 2013/10/28) | Source: SQLServerCentral.com | Category: merge
Rating: |  Discuss |   Briefcase | 33,811 reads

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,810 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 | 7,838 reads

Execution Plan reuse

By Steve Jones 2014/12/17 | Category: performance
Rating: (not yet rated) |  Discuss |   Briefcase | 1,907 reads

Trace Flags

By S M 2014/11/18 | Category: statistics (data)
Rating: (not yet rated) |  Discuss |   Briefcase | 1,482 reads

Plan Guides

By Steve Jones 2014/10/20 | Category: sql server 2014
Rating: (not yet rated) |  Discuss |   Briefcase | 1,506 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,551 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,939 reads

Find Most Expensive Stored Procedure (By Execution Count)

SQL Server Stored Procedure Execute Count Script ..   Read more...
By Yusuf Kahveci 2015/09/08 | Source: SQLServerCentral.com | Category: performance
Rating: |  Discuss |   Briefcase | 4,940 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 2016/07/29 | Source: SQLServerCentral.com | Category: sqlagent
Rating: |  Discuss |   Briefcase | 1,937 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 2015/09/18 | Source: SQLServerCentral.com | Category: performance
Rating: |  Discuss |   Briefcase | 4,150 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 | 8,393 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 2016/07/08 (first published: 2014/06/16) | Source: SQLServerCentral.com | Category: indexing
Rating: |  Discuss |   Briefcase | 11,071 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 (data)
Rating: |  Discuss |   Briefcase | 5,236 reads

Cardinality Regression

By Steve Jones 2014/06/02 | Category: sql server 2014
Rating: (not yet rated) |  Discuss |   Briefcase | 1,369 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: cursors
Rating: |  Discuss |   Briefcase | 6,366 reads
<< Newer    Items 21 to 40 of 71    Older >>
 
Tags
t-sql (10)    
blogs (8)    
execution plans (6)    
indexing (6)    
administration (5)    
tuning (5)    
editorial (3)    
sql server 2014 (3)    
cardinality estimates (2)    
hash match (2)    
merge (2)    
optimization (2)    
query optimizer (2)    
sql trace (2)    
statistics (data) (2)    
window functions (2)    
actual execution plan (1)    
actual plan (1)    
agent jobs (1)    
best practices (1)    
binary flags (1)    
binding (1)    
bit operations (1)    
bottle necks (1)    
comparison (1)    
conditional split (1)    
counter (1)    
cpu usage data (1)    
cursors (1)    
cxpacket (1)    
data mining (1)    
database design (1)    
database development (1)    
database performance (1)    
database weekly (1)    
dateadd (1)    
debug (1)    
deleted (1)    
dm_os_performance_counters (1)    
duplicates (1)    
effective dates (1)    
estimated plan (1)    
foreign keys (fk) (1)    
i/o performance (1)    
identity property (1)    
in-line memory (1)    
inserted (1)    
instant file initialization (ifi) (1)    
integration services (ssis) (1)    
jdbc (1)    
lag (1)    
lead (1)    
lookup table (1)    
machine learning (1)    
microsoft sql server (1)    
orm (1)    
over clause (1)    
page life expectancy (1)    
page splits (1)    
parallelism (1)    
query optimization (1)    
r language (1)    
rcte (1)    
referential integrity (1)    
reporting services (ssrs) (1)    
schedule (1)    
scope_identity (1)    
set-based loop (1)    
software development (1)    
sparse columns (1)    
sql server 2005 (1)    
sql server 2012 (1)    
sql server 2016 (1)    
sql server dmvs (1)    
sqlagent (1)    
sqlh2 (1)    
sqlio (1)    
sqlpass (1)    
sqlprep (1)    
string_split (1)    
tally table (1)    
tips (1)    
tools (1)    
trace flag (1)    
update (1)