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

Content with tags SQL Server 2008, Performance Tuning Rss

   Items 1 to 12 of 12   
 

Get Top Queries Taxing SQL Server CPUs

Script which uses SQL Server DMOs to gather top CPU taxing queries which can benifit most from tuning.  Read more...
By Prakash Heda 2012/03/10 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 2,588 reads

SQL 2005 vs. SQL 2008 Part 1 - (Backup File Sizes and Times)

SQL 2008 has some key improvements over SQL 2005. This article deals with backup compression and faster backups in SQL 2008  Read more...
By Kevin van der Merwe 2011/05/30 (first published: 2008/05/05) | Source: SQLServerCentral.com | Category: compression
Rating: |  Discuss |   Briefcase | 22,131 reads

What's the best way to count?

By Dave 2010/10/19 | Category: t-sql
Rating: (not yet rated) |  Discuss |   Briefcase | 4,226 reads

Managing Large Data Sets in SQL Server 2005 and 2008

Easily manage operations against large data sets, be able to stop and start operations at a whim and throttle them up or down to manage system performance.  Read more...
By Zach Mided 2010/01/04 | Source: SQLServerCentral.com | Category: large data sets
Rating: |  Discuss |   Briefcase | 10,438 reads

Tuning the Performance of Change Data Capture in SQL Server 2008

Change data capture is a new feature in SQL Server 2008 that provides an easy way to capture changes to data in a set of database tables so these changes can be transferred to a second system like a data warehouse. This document provides guidance on how to configure change data capture parameters to maximize data capture performance while minimizing the performance impact on the production workload. The scope of this document is limited to the capture of change data and the cleanup process. Querying the changed data is out of scope for this white paper.  Read more...
Rating:  Rate this |   Briefcase | 2,022 reads

Using Star Join and Few-Outer-Row Optimizations to Improve Data Warehousing Queries

In this white paper we discuss two of the new features in SQL Server 2008, Star Join and Few-Outer-Row optimizations. We test the performance of SQL Server 2008 on a set of complex data warehouse queries designed to highlight the effect of these two features and observed a significant performance gain over SQL Server 2005 (without these two features).  Read more...
By Additional Articles 2009/09/10 | Source: Microsoft MSDN | Category: sql server 2008
Rating: (not yet rated)  Rate this |   Briefcase | 3,834 reads

SQL Server 2008 Analysis Services Performance Guide

Because Microsoft SQL Server Analysis Services query and processing performance tuning is a fairly broad subject, this white paper organizes performance tuning techniques into the following three segments.   Read more...
By Additional Articles 2009/08/04 | Source: Microsoft MSDN | Category: analysis services (ssas)
Rating: (not yet rated)  Rate this |   Briefcase | 2,373 reads

Troubleshooting Performance Problems in SQL Server 2008

This white paper provides step-by-step guidelines for diagnosing and troubleshooting common performance problems by using publicly available tools.  Read more...
By Additional Articles 2009/07/31 | Source: TechNet Blogs | Category: troubleshooting
Rating:  Rate this |   Briefcase | 4,181 reads

Using the Resource Governor

SQL Server 2008 introduces a new feature, the Resource Governor, which provides enterprise customers the ability to both monitor and control the way different workloads use CPU and memory resources on their SQL Server instances. This paper explains several practical usage scenarios and gives guidance on best practices.  Read more...
By Additional Articles 2009/07/20 | Source: TechNet Blogs | Category: sql server 2008
Rating: (not yet rated)  Rate this |   Briefcase | 1,691 reads

Improving Performance with SQL Server 2008 Indexed Views

This document describes the indexed views capability of SQL Server 2005 and SQL Server 2008, including the new support for partition-aligned views added to SQL Server 2008. Indexed views are explained and specific scenarios in which they may provide performance improvements are discussed.  Read more...
By Additional Articles 2009/06/19 | Source: TechNet Blogs | Category: sql server 2008
Rating:  Rate this |   Briefcase | 3,074 reads

Investigating SQL Server 2008 Wait Events with XEVENTS

Some reasons for the slow-running of database applications aren't obvious. Occasionally, even the profiler won't tell you enough to remedy a problem, especially when a SQL Statement is being forced to wait. Now, in SQL Server 2008, come XEvents, which allow you to look at those waits that are slowing your SQL Statements. Mario Broodbakker continues his series about SQL Server Wait Events  Read more...
By Additional Articles 2008/08/20 | Source: SQLServerCentral.com | Category: sql server 2008
Rating:  Rate this |   Briefcase | 1,698 reads

SQL 2005 vs. SQL 2008 Part 1 - (Backup File Sizes and Times)

SQL 2008 has some key improvements over SQL 2005. This article deals with backup compression and faster backups in SQL 2008  Read more...
By Kevin van der Merwe 2011/05/30 (first published: 2008/05/05) | Source: SQLServerCentral.com | Category: compression
Rating: |  Discuss |   Briefcase | 22,131 reads
   Items 1 to 12 of 12   
 
Tags
sql server 2005 (3)    
dmv (2)    
t-sql (2)    
analysis services (ssas) (1)    
backup / restore (1)    
change data capture (cdc) (1)    
compression (1)    
data warehousing (1)    
dmo (1)    
extended events (1)    
indexed views (1)    
large data sets (1)    
profiler (1)    
resource governor (1)    
row_number() (1)    
sql server 2012 (1)    
star schemas (1)    
system monitor (1)    
top cpu queries (1)    
troubleshooting (1)    
xevents (1)