SQL Server performance and tuning

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