Performance tune your SQL Server

Home > SQL Server Learning Center

EMAIL THIS


Learning Center:	Performance tuning

Last Updated: Apr 20, 2006

To keep SQL Server running smoothly, you must always monitor performance and quickly address bottlenecks. Here you'll find the tips and tools you need to get started.
>>	Ask Performance and Tuning expert Jeremy Kadlec for troubleshooting advice.
>>	Look up more SQL Server performance and tuning tutorials and tips in this section.

Learning Guide: Performance tuning A to Z

(20 Apr 2006)

From testing and monitoring to tuning and troubleshooting, you're sure to find a tip or tool to help you resolve your SQL Server performance dilemmas in this guide.

Read Full Story


ADVICE:
>>	Develop a performance baseline TIP :Don't just release new software and hope for the best. A performance baseline offers a less stressful option. Learn about ...
>>	T-SQL performance problems and solutions TIP :Not all SQL Server performance problems are database-related. Poorly written T-SQL code could be to blame. Identify query ...
>>	SQL Server Clinic: Stop locking and blocking TIP :Locking ensures SQL Server properly processes transactions, but too much locking brings transactions to a halt. This SQL ...
>>	Checklist: Maximize SQL Server backup performance TIP :Improve the I/O throughput of SQL Server backups with this checklist by Edgewood Solutions' Greg Robidoux. It includes ...
>>	SQL Server performance tuning worst practices TIP :Here are some recommendations for correcting SQL Server performance tuning worst practices and improving overall system ...


LEARNING TOOLS:
>>	Learning Guide: SQL Server performance tuning A to Z
>>	Find and fix SQL Server 2000 performance issues
>>	Checklist: Load testing -- the magic bullet for SQL Server performance tuning
>>	SQL Server performance-tuning checklist: Ready, set, go!
>>	FAQ: SQL Server performance boosters

Digg This!

StumbleUpon

Del.icio.us

RELATED CONTENT

	SQL Server performance and tuning
	A guide to advanced new features in SQL Server Management Studio 2008, part 2
	Top 10 SQL Server Tips of 2008
	Tutorial: Performance tuning SQL Server via queries, indexes and more
	A guide to basic new features in SQL Server Management Studio 2008, part 1
	Tutorial: SQL Server indexing tips to improve performance
	SQL Server virtualization pros and cons: Weigh the performance impact
	How to configure storage in SQL Server DB with more writes than reads
	Avoid cursors in SQL Server with these methods to loop over records
	Solve SQL Server errors and more from the DBA trenches -- part 2
	Tutorial: Learn SQL Server basics from A-Z

SQL/Transact SQL (T-SQL)

The sqlcmd utility in SQL Server

How to create a SQL inner join and outer join: Basics to get started

Avoid cursors in SQL Server with these methods to loop over records

Implementing security audit in SQL Server 2008

New datetime data types in SQL Server 2008 offer flexibility

Basic objects of T-SQL in SQL Server 2008

Using T-SQL data types in SQL Server 2008

SQL Server 2008 function types in T-SQL

Additional T-SQL operations in SQL Server 2008

Using DATEADD and DATEDIFF to calculate SQL Server datetime values

SQL/Transact SQL (T-SQL) Research

SQL Server overview

The sqlcmd utility in SQL Server

Top 10 SQL Server Tips of 2008

Tutorial: Performance tuning SQL Server via queries, indexes and more

Tutorial: SQL Server indexing tips to improve performance

How to create a SQL inner join and outer join: Basics to get started

SQL Server Service Broker Tutorial and Reference Guide

How to configure storage in SQL Server DB with more writes than reads

Avoid cursors in SQL Server with these methods to loop over records

Solve SQL Server errors and more from the DBA trenches -- part 2

Tutorial: Learn SQL Server basics from A-Z

SQL Server overview Research

RELATED GLOSSARY TERMS

Terms from Whatis.com − the technology online dictionary

contiguity (SearchSQLServer.com)

contiguous (SearchSQLServer.com)

drilldown (SearchSQLServer.com)

hashing (SearchSQLServer.com)

hybrid online analytical processing (SearchSQLServer.com)

RELATED RESOURCES

2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems

Search Bitpipe.com for the latest white papers and business webcasts

Whatis.com, the online computer dictionary

>	SQL Server restore how-tos
>	Learning Center: Top 10 SQL Server security tips
>	SQL Server 2005 data mining
>	SQL Server 2005 security
>	Database design decisions
View All Topics

SEARCH

TechTarget provides enterprise IT professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective IT purchase decisions and managing their organizations' IT projects - with its network of technology-specific Web sites, events and magazines.


TechTarget Corporate Web Site \| Media Kits \| Site Map All Rights Reserved, Copyright 2005 - 2009, TechTarget \| Read our Privacy Policy