Home > SQL Server Topics > Microsoft SQL Server Administration > Microsoft SQL Server Performance Monitoring and Tuning
SQL Server Topics:
EMAIL THIS
 TOPICS HOME   BROWSE ALL SQL SERVER TOPICS     RSS FEEDS 

Microsoft SQL Server Performance Monitoring and Tuning


From testing and monitoring to indexing and troubleshooting, you're sure to find a resource to help resolve your Microsoft SQL Server performance problems. To ensure your SQL Server databases and applications run at their full potential, you must continually identify performance problems and quickly address bottlenecks. This page features resources covering all aspects of SQL Server performance and tuning, with details on debugging applications, optimizing database performance and more. Also, be sure to check out our recent tutorials on SQL Server performance tuning via indexes and queries.
IN THIS TOPIC:  EXPERT TECHNICAL ADVICE (281) , REFERENCE & LEARNING (123) , VIDEO (4) , NEWS (7) , WEBCASTS (4) , DEFINITIONS (5)

MUST READ
Using dynamic management views to monitor and tune performance of SQL Server
TIP - Dynamic management views help monitor SQL Server health and tune performance. Learn how to use DMVs to retrieve critical data on the internal workings of SQL Server.
Tutorial: Performance tuning SQL Server via queries, indexes and more
TUTORIAL - Get the basics for tuning SQL Server performance with this tutorial on queries, indexing, storage, memory and any errors or issues that can cause SQL Server slowdown.
Avoid cursors in SQL Server with these methods to loop over records
TIP - Avoid using a SQL Server cursor for looping over records row by row. Alternate methods use temp tables instead of SQL cursors that slow down performance.

  EXPERT TECHNICAL ADVICE: 1 - 3 of 281
Performance implications of transaction log autogrowth in SQL Server
Submitted By: SearchSQLServer.com | 25 Jun 2009
TIP - Take a closer look at the performance implications of shrinking transaction log files in SQL Server.
The short course on how SQL Server really works
Submitted By: SearchSQLServer.com | 10 Jun 2009
TIP - Have you been thrust into the DBA role simply because there's no one else to do it? No worries. Here you'll learn the basics of how data moves from disk to memory in SQL Server.
Determining the source of full transaction logs in SQL Server
Submitted By: SearchSQLServer.com | 27 May 2009
TIP - Many DBAs at some point have had to deal with a full transaction log. Check out these steps for finding the cause to quickly solve the problem.
VIEW ALL EXPERT TECHNICAL ADVICE ON MICROSOFT SQL SERVER PERFORMANCE MONITORING AND TUNING

  REFERENCE & LEARNING: 1 - 3 of 123
Microsoft SQL Server 2008 Resource Governor primer
Ross Mistry | 01 Apr 2009
BOOK EXCERPT - In this chapter excerpt from "Microsoft SQL Server 2008 Management and Administration", learn how Resource Governor can improve SQL Server performance.
Top 10 SQL Server Tips of 2008
SearchSQLServer.com | 16 Dec 2008
THE YEAR IN REVIEW - Get the top 10 SQL Server tips of 2008 on topics such as clustered index design, log shipping setup, date/time data conversions and many other aspects of SQL Server.
Tutorial: Performance tuning SQL Server via queries, indexes and more
SearchSQLServer.com | 09 Dec 2008
TUTORIAL - Get the basics for tuning SQL Server performance with this tutorial on queries, indexing, storage, memory and any errors or issues that can cause SQL Server slowdown.
VIEW ALL REFERENCE & LEARNING ON MICROSOFT SQL SERVER PERFORMANCE MONITORING AND TUNING

  VIDEO: 1 - 3 of 4
SQL Server PerfMon counters for access methods and buffer manager
SearchSQLServer.com | 28 Apr 2008
VIDEO - 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.
Monitoring SQL Server disk I/O with PerfMon counters
SearchSQLServer.com | 02 Apr 2008
VIDEO - As a DBA, you need to understand the I/O of your SQL Server disk subsystem. In part three of this screencast series, learn how to track I/O in your direct-attached storage disks (DASD). Get optimal throughput values to keep ...
SQL Server PerfMon counters for Windows operating systems
SearchSQLServer.com | 17 Mar 2008
VIDEO - SQL Server PerfMon counters can help DBAs troubleshoot and even avoid bottlenecks on Windows operating systems. In part two of this screencast, learn the best practices and maximum values to watch for when using counters to ...
VIEW ALL VIDEO ON MICROSOFT SQL SERVER PERFORMANCE MONITORING 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.
Minding the data and databases
SearchDataManagement.com | 20 Jul 2006
ARTICLE - The role of the database administrator can be broad or delineated by specialization. DBAs are constantly at the mercy of the project size, scope and application complexity.
VIEW ALL NEWS ON MICROSOFT SQL SERVER PERFORMANCE MONITORING AND TUNING

  WEBCASTS: 1 - 3 of 4
Crash Course in SQL Server Capacity Planning - Expert Webcast

VIEW WEBCAST
PREMIERED:   26 OCT 2006, 09:00 EDT (13:00, GMT)
SUMMARY:   Attend this webcast to hear from industry expert Hilary Cotter about the tools required to get up to speed and off the ground with SQL Server capacity planning.
SQL Server performance monitoring and tuning how-tos - Vendor Podcast

DOWNLOAD PODCAST
PREMIERED:   22 AUG 2006, 09:00 EDT (13:00, GMT)
SUMMARY:   Learn how to develop a systematic approach to SQL Server database performance tuning. Buck Woody will detail how to define performance tuning components, collect and interpret monitoring metrics, and put a performance tuning action plan in place.
Delivering Enterprise Storage & Server Management for SQL - Vendor Webcast

VIEW WEBCAST
PREMIERED:   20 JUN 2006, 14:00 EDT (18:00, GMT)
SUMMARY:   This Webcast will cover high performance server profiles for SQL, improving application performance with Veritas Storage Foundations for Windows and how to improve the availability of your SQL application.
VIEW ALL WEBCASTS ON MICROSOFT SQL SERVER PERFORMANCE MONITORING 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 MICROSOFT SQL SERVER PERFORMANCE MONITORING AND TUNING

SEE ALSO - Topics Related to Microsoft SQL Server Performance Monitoring and Tuning: 
Microsoft SQL Server Tools and Utilities, Microsoft SQL Server Installation, SQL Server Interoperability, SQL Server Replication, SQL Server Backup and Recovery, SQL Server Security, SQL Server High Availability, Scalability and Reliability



Microsoft SQL Server Performance Monitoring and Tuning Solutions - SQL Server Topics

HomeNewsTopicsITKnowledge ExchangeTipsAsk the ExpertsMultimediaWhite PapersIT Downloads
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




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