Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag Performance Rss

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

TEMPDB Configuration per vCPU

A simple script for automation of additional secondary data files of tempdb.  Read more...
By Paulo Nascimento 2014/01/14 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 1,951 reads

The Art of Performance

Tuning a SQL Server instance and improving the way it performs is a complex task that many people struggle to complete. In this piece, Steve Jones talks about the idea that it is a science as much as an art.  Read more...
By Steve Jones 2014/01/13 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 298 reads

Free eBook: 45 Database Performance Tips for Developers

As a developer, if you need to go into the database and write queries, design tables, or determine the configuration of your SQL Server Systems, these tips should help make sure you're not unnecessarily sacrificing database performance. This eBook has 45 easy tips to improve the performance of your indexes and T-SQL queries, and hunt down problems within ORM tools and database design.   Read more...
By Press Release 2014/01/02 (first published: 2013/11/04) | Source: Red-Gate | Category: tips
Rating:  Rate this |   Briefcase | 15,604 reads

Reporting Services Performance and Optimization

This technical note provides guidance for Reporting Services. The focus of this technical note is to optimize your Reporting Services architecture for better performance and higher report execution throughput and user loads.  Read more...
By Additional Articles 2013/12/24 | Source: SQLCAT | Category: reporting services (ssrs)
Rating: (not yet rated)  Rate this |   Briefcase | 3,376 reads

Index Help Utility

By Steve Jones 2013/12/11 | Category: indexing
Rating: (not yet rated) |  Discuss |   Briefcase | 1,725 reads

A few reflections on RBAR by a weary application developer

Follow the guidance of your DBA, but remember, he or she is from another land.  Read more...
By George Copeland 2013/12/09 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 6,815 reads

Free eBook: 45 Database Performance Tips for Developers

As a developer, if you need to go into the database and write queries, design tables, or determine the configuration of your SQL Server Systems, these tips should help make sure you're not unnecessarily sacrificing database performance. This eBook has 45 easy tips to improve the performance of your indexes and T-SQL queries, and hunt down problems within ORM tools and database design.   Read more...
By Press Release 2014/01/02 (first published: 2013/11/04) | Source: Red-Gate | Category: tips
Rating:  Rate this |   Briefcase | 15,604 reads

Improving SSIS Update Performance

This article includes an examination of how I improved update performance. We examine four methods of loading data into a data warehouse.  Read more...
Rating: |  Discuss |   Briefcase | 5,925 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 2013/10/28 | Source: SQLServerCentral.com | Category: merge
Rating: |  Discuss |   Briefcase | 16,425 reads

Query Stats

DBAs rarely use the full potential of sys.dm_exec_query_stats.  It’s common to see the queries for looking at the most expensive...  Read more...
By SteveHood79 2013/09/04 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,708 reads

Fixing Page Life Expectancy (PLE)

What is Page Life Expectancy (PLE), what makes it drop, and how can I manage memory better? Abusing disks slows...  Read more...
By SteveHood79 2013/08/20 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,947 reads

Workload Tuning: Finding Top Offenders in SQL Server 2012

I have to give credit where credit is due. Microsoft has definitely made performance tuning easier in SQL Server 2012. Performance...  Read more...
By jsterrett 2013/08/15 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,638 reads

A Page-Splitting Headache - Page Split Mini-Series

Page splits are a normal occurring process in an OLTP system.  However, too many page splits can cause performance issues...  Read more...
By Robert Pearl 2013/07/11 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 2,858 reads

Trace Analysis script

Script to help you analyze a trace to find worst performing procs.  Read more...
By Andie Letourneau 2013/06/25 | Source: SQLServerCentral.com | Category: performance
Rating: |  Discuss |   Briefcase | 1,333 reads

Nested Loops, Parallelism and Confusion

I’m 30 today. In addition, it’s been 10 years since I started working with SQL Server. In my twenties, I fell in...  Read more...
By Matan_Yungman 2013/06/11 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 477 reads

What's changed recently?

Often when tracking down problems, you need to know if anything has changed recently, this script will tell you...  Read more...
By Ian Stirk 2013/06/10 | Source: SQLServerCentral.com | Category: performance
Rating: |  Discuss |   Briefcase | 2,384 reads

Automating SQL Traces

Capturing the activity on a server when a problem occurs can be a challenge for many DBAs. This article shows how you can automate the capture of information when a CPU spike occurs.  Read more...
By Clark Froebe 2013/05/23 | Source: SQLServerCentral.com | Category: sql trace
Rating: |  Discuss |   Briefcase | 5,255 reads

Object Qualification

I came across an interesting issue recently with NHibernate, now it is widely known I despise ORM’s, in my experience...  Read more...
By Chris McGowan 2013/05/22 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 1,214 reads

Better Coding, More Savings

The way we write code impacts our users, but it can also impact our wallet, especially in cloud computing. Steve Jones wonders how many people bother to profile and test their code.  Read more...
By Steve Jones 2013/05/13 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 264 reads

Staggering SQLIO Sessions Across Multiple Volumes

In a previous post, I discussed running SQLIO against multiple files.  The purpose in using multiple files is being able...  Read more...
By StrateSQL 2013/04/22 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated) |  Discuss |   Briefcase | 952 reads
<< Newer    Items 21 to 40 of 42    Older >>
 
Tags
t-sql (9)    
blogs (8)    
tuning (4)    
administration (3)    
editorial (3)    
execution plan (3)    
indexing (3)    
sql server 2014 (3)    
cardinality estimates (2)    
execution plans (2)    
hash match (2)    
merge (2)    
optimization (2)    
query optimizer (2)    
sql trace (2)    
window functions (2)    
actual execution plan (1)    
actual plan (1)    
best practices (1)    
binary flags (1)    
bit operations (1)    
bottle necks (1)    
conditional split (1)    
cpu usage data (1)    
cursor (1)    
database design (1)    
database development (1)    
database performance (1)    
database weekly (1)    
debug (1)    
deleted (1)    
duplicates (1)    
estimated plan (1)    
identity (1)    
index (1)    
in-line memory (1)    
inserted (1)    
integration services (ssis) (1)    
jobs (1)    
lag (1)    
lead (1)    
lookup table (1)    
microsoft sql server (1)    
orm (1)    
over clause (1)    
page life expectancy (1)    
page splits (1)    
parallelism (1)    
query optimization (1)    
reporting services (ssrs) (1)    
schedule (1)    
scope_identity (1)    
software development (1)    
sql server 2012 (1)    
sqlagent (1)    
sqlh2 (1)    
sqlio (1)    
sqlpass (1)    
sqlprep (1)    
statistics (1)    
tally table (1)    
tips (1)    
tools (1)    
update (1)