Performance Tuning and Troubleshooting with SQL Server 2008

Register Login

Friday, May 24, 2013

MICROSOFT SQL SERVER COMMUNITY WORLDWIDE

Videos Performance Tuning and Troubleshooting

Performance Tuning Methodologies

Performance Tuning Methodologies

In this module, you will learn the following:

Performance tuning methodologies
- Instance level
- Database level
- Application level
Overview of tools and techniques for performance analysis and tuning

SQL Server Educational Videos

1 Databases and Instances
1 Database Architecture
1  Advanced Architecture
1  SQL Server Objects
1  Managing SQL Server Data
1 Database Security
1 Basic DBA Duties
1 Concurrency Control
1 Managing SQL Objects
1 Securing and Auditing
1 Data Transfer Mechanism
1 Backups and Restores
1 Performance Tuning
1 Scalability & High Availability
1 Monitoring SQL Server

Implementing Compression

Implementing Compression

In this demonstration you will learn to:

Use the Compression Wizard to benefit from ROW or PAGE type options.
Understand how to calculate compression savings with the wizard or with scripts
Implement compression with the wizard or with scripts

Troubleshooting deadlocks

Troubleshooting Deadlocks using Profiler

In this demonstration you will learn how to:

Create a simple deadlocking event
Execute to see default behavior
Monitor with profile

Troubleshooting and Tuning Performance Issues in SQL Server 2008

In this module you will learn about performance tuning methodologies, and tools and techniques for performance analysis and tuning.

Implementing Query Hints

Implementing Query Hints

In this demonstration you will learn to:

Enforce a MERGE JOIN in a query.
Benefit from the OPTIMIZE FOR hint.
Override the row locking default with a TABLOCK hint.
Remove all shared locks with the NOLOCK hint

Implementing Plan Guides

Implementing Plan Guides

In this demonstration you will learn to:

Override an existing query with a Plan Guide.
Use the new SQL Server 2008 interface to implement Plan Guides

Privacy Statement

Terms Of Use