Troubleshooting Performance Problems in SQL Server 2005 2008

Sometimes a poorly designed database or a system that is improperly configured for the workload can cause the slowdowns in SQL Server. Administrators need to proactively prevent or minimize problems and, when they occur, diagnose the cause and take corrective action. This paper provides step-by-step guidelines for diagnosing and troubleshooting common performance problems by using publicly available tools such as SQL Server Profiler, Performance Monitor, dynamic management views, and SQL Server Extended Events (Extended Events) and the data collector, which are new in SQL Server 2005 and 2008.

SQL Server Partial Availability

This covers SQL Server 2005 features that enable appropriately designed solutions to achieve partial availability and remain online after a disk subsystem hardware failure.

SQL Server AlwaysOn Solution for HA & DR

To discusses how to reduce planned and unplanned downtime, maximize application availability, and provide data protection using SQL Server 2012 AlwaysOn high availability and disaster recovery solutions.

SQL Server Useful DMVs

SQL Server DMV queries are very useful to check current and historical information. They are widely used during troubleshooting and performance tuning.

Python Official Doc

First stop to learn python, including full tutorial, library references, language references, howto, search function, very handy. Highly recommended.

Python Programming 2nd Edition

Nice book about python programming, my 1st python book, takes me thru all I need for programming in python.

Microsoft SQL Server 2008 Introduction

A very good SQL Server 2008 book written by Peter Debetta, Greg Low, and Mark Whitehorn. This book draw the picture of SQL Server 2008, which involved security and administration, performance, programmability, business integlligence enhancements and etc. Worth having a read.