Microsoft SQL Server Performance Monitoring and Tuning

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 304

	Top 5 DBA tasks that are a waste of time (and might be hurting your SQL Server) Submitted By: SearchSQLServer.com | 09 Dec 2009 TIP - While some DBA tasks are less important than most, others can be completely pointless. Could you be wasting valuable time without even knowing it?

	SQL Server Mailbag: Asymmetric encryption, log shipping issues Submitted By: SearchSQLServer.com | 07 Dec 2009 SQL SERVER MAILBAG - In this edition of the SQL Server Mailbag, our expert tackles reader BI and data warehousing questions including encryption queries and the difference between SSAS editions.

	Using traces in SQL Server Profiler Submitted By: SearchSQLServer.com | 12 Nov 2009 TIP - A SQL Server Profiler trace can provide critical information on a problem query in a matter of seconds. Learn how – and when – to run the application.

	VIEW ALL EXPERT TECHNICAL ADVICE ON MICROSOFT SQL SERVER PERFORMANCE MONITORING AND TUNING

REFERENCE & LEARNING: 1 - 3 of 128

	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 6

	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.

	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.

	SQL Server 2000 indexing dos and don'ts SearchSQLServer.com | 14 Feb 2006 INTERVIEW - In the second part of this three-part feature, Edgewood Solutions' Jeremy Kadlec outlines best and worst practices for indexing in SQL Server 2000.

	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 Stored Procedures, SQL/Transact SQL (T-SQL), SQL Server Backup and Recovery, SQL Server Security, SQL Server High Availability, Scalability and Reliability