SQL Server performance and tuning
Home > SQL Server Topics > SQL Server Administration > SQL Server performance and tuning
SQL Server Topics:
EMAIL THIS
 TOPICS HOME   BROWSE ALL SQL SERVER TOPICS   SQL SERVER INFO CENTERS   RESOURCE CENTERS     RSS FEEDS 

SQL Server performance and tuning


To ensure your SQL Server databases and applications run at their full potential, you must continually identify performance problems and quickly address bottlenecks. From testing and monitoring to indexing and troubleshooting, find a resource to help improve SQL Server performance.
IN THIS TOPIC:  EXPERT TECHNICAL ADVICE (211) , REFERENCE & LEARNING (115) , NEWS (7) , BEST WEB LINKS (3) , DEFINITIONS (5)

MUST READ
SQL Server PerfMon counters for Windows operating system (OS)
SCREENCAST - SQL Server MVP Kevin Kline walks you through best practices and maximum values to watch for when using PerfMon counters to monitor OS performance.
How to use the LEFT vs. RIGHT OUTER JOIN in SQL
BOOK EXCERPT - Learn about LEFT vs. RIGHT OUTER JOINs in SQL queries when using OUTER JOIN for multiple tables. In this book excerpt, also see how to use the SELECT statement and embed SQL JOINs.
Tricks to increase SQL Server query performance
TIP - Tricks optimizing SQL Server query performance include choosing CREATE TABLE over SELECT INTO and a stored procedure method over linked server queries.
Update SQL Server table statistics for performance kick
TIP - Find out how to update and tune table statistics in SQL Server to ensure data accuracy and boost performance. Learn auto and manual update commands.
Identify performance bottlenecks in SQL Server
STEP-BY-STEP GUIDE - Identify and resolve performance bottlenecks in SQL Server. Learn how to locate thses log jams with System Monitor, SQL Profiler and DMVs.

  EXPERT TECHNICAL ADVICE: 1 - 3 of 211
SQL SERVER PERFORMANCE AND TUNING EXPERTS
Denny Cherry
Senior Database Administrator / Architect

ASK A QUESTION
Jeremy Kadlec
Principal Database Engineer
ASK A QUESTION
Check SQL Server database and log file size with this stored procedure
13 May 2008
TIP - Check the size of your SQL Server database with the undocumented stored procedure sp_SDS and get results beyond sp_spaceused. Also calculate log file size and monitor DB growth.
Find size of SQL Server tables and other objects with stored procedure
Submitted By: Richard Ding | 09 Apr 2008
TIP - Check the size of SQL Server tables and other database objects with an original stored procedure, sp_SOS, that expands on sp_spaceused. Calculate space and perform more functions.
SQL Server tempdb best practices increase performance
26 Mar 2008
TIP - Get increased SQL Server tempdb performance with these best practice settings for physical files, storage arrays, statistics updates and indexing temp tables.
VIEW ALL EXPERT TECHNICAL ADVICE ON SQL SERVER PERFORMANCE AND TUNING

  REFERENCE & LEARNING: 1 - 3 of 115
SQL Server PerfMon counters for access methods and buffer manager
Kevin Kline, SQL Server MVP | 28 Apr 2008
SCREENCAST - SQL Server MVP Kevin Kline focuses on PerfMon counters for SQL Server and shares best practices for tracking IO intensive access methods and buffer manager activity.
Monitor SQL Server disk I/O with PerfMon counters
Kevin Kline | 02 Apr 2008
SCREENCAST - In part 3 the SQL Server PerfMon counters screencast series, get the optimal values when monitoring performance counters for physical disk reads and writes and disk queue length.
SQL Server PerfMon counters for Windows operating system (OS)
Kevin Kline | 17 Mar 2008
SCREENCAST - SQL Server MVP Kevin Kline walks you through best practices and maximum values to watch for when using PerfMon counters to monitor OS performance.
VIEW ALL REFERENCE & LEARNING ON SQL SERVER PERFORMANCE AND TUNING

  NEWS: 1 - 3 of 7
SQL Server 2000 indexing Q&A to create and tune indexes
SearchSQLServer.com | 23 Oct 2007
INTERVIEW - Know how to choose proper indexes for your business situation. In part one of this two-part indexing series, Edgewood Solutions' Jeremy Kadlec answers common indexing questions.
Microsoft offers beefed-up backup beta
SearchWinIT.com | 27 Sep 2006
ARTICLE - System Center Data Protection Manager 2006 version 2 now covers Exchange 2000 Server, Exchange Server 2003, SQL Server 2000 and SQL Server 2005.
SQL Server DBMS' growing popularity is no coincidence
SearchSQLServer.com | 05.26.2006
OPINION - SQL Server offers more robust features at a lower price point than competing database management systems, making its growing popularity no surprise to contributor Adam Machanic. In this column, he details the advantages of ...
VIEW ALL NEWS ON SQL SERVER PERFORMANCE AND TUNING

  BEST WEB LINKS: 1 - 3 of 3
SQL Server index tuning
About.com | 22 Jul 2005
BEST WEB LINK - Many database administrators are familiar with performance tuning. The Index Tuning Wizard allows your SQL Server to operate more efficiently by enhancing the index selection process.
How to performance tune SQL Server 7.0
About.com | 22 Jul 2005
BEST WEB LINK - These eight tips from Microsoft will allow you to tune the performance of your SQL Server with little difficulty.
Introduction to Microsoft SQL Server
About.com | 22 Jul 2005
BEST WEB LINK - Here is a comprehensive introduction to Microsoft SQL Server 2000, which details the various tools available to SQL Server users.
VIEW ALL BEST WEB LINKS ON SQL SERVER PERFORMANCE AND TUNING

  DEFINITIONS: 1 - 3 of 5
contiguous
10 Oct 2002
WORD - Contiguous describes two or more objects that are adjacent to each other. In computing, contiguous data is data that is moved or stored in a solid uninterrupted block. In general, contiguous data can be accessed more ...
hybrid online analytical processing
17 Mar 2001
WORD - Hybrid online analytical processing (HOLAP) is a combination of relational OLAP (ROLAP) and multidimensional OLAP (usually referred to simply as OLAP). HOLAP was developed to combine the greater data capacity of ROLAP with ...
contiguity

WORD - Contiguity (from Latin contiguus and contingere, to have contact with) is the state of being in close proximity with or even touching another object. In data processing, a group of data fields that are contiguous (rather ...
VIEW ALL DEFINITIONS ON SQL SERVER PERFORMANCE AND TUNING

SEE ALSO - Topics Related to SQL Server performance and tuning: 
SQL Server Online Transaction Processing (OLTP), SQL Server backup and recovery, SQL Server clustering, SQL Server security, SQL Server availability, SQL Server data warehousing/business intelligence, SQL Server installation, SQL Server integration/interoperability, SQL Server replication, SQL Server database design and modeling


HomeNewsTopicsITKnowledge ExchangeTipsAsk the ExpertsWebcastsWhite PapersIT Downloads
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
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  |  Reprints  |  Site Map




All Rights Reserved, Copyright 2005 - 2008, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts