Troubleshoot Database Concurrency in SQL Server with sp_locks

sp_locks is a useful tool which can help a DBA in detecting and troubleshooting blocking and concurrency scenarios. This article demonstrates a worked example of using sp_locks to troubleshoot a database concurrency issue.

Indexed Views

This article will show you the importance of Indexed Views and how they can help performance.

A Check and Foreign Key Constraint Improves Query Performance

Check and foreign key constraint do not degrade performance but actually improve it.

Create a Performance Baseline Repository

This article demostrates how to create a Baseline repository that holds summarized data of all SQL Executions executed on an instance of SQL Server.

Performance Counters

Performance Issue with large number of Virtual Log Files in SQL Server Transaction Log

SQL Server transaction log files have an internal structure called the Virtual Log File or VLF. When the number of VLFs grow out of control due to autogrowth the log can become fragmented and cause delay. In this tip we look at how to see how many VLFs exist as well as how this can be reduced to a more reasonable number.

An Informal Look at Database Performance

A review on the basic steps to correct a poorly performing query

Early September Free Training from PASS VCs

Hope you got plenty of rest over your Labor Day holiday because the PASS Virtual Chapters have some great free training lined up for you.

Using Dynamic Management Objects to Monitor I/Os Against an Instance of SQL Server

To ensure that queries run as efficiently as possible, the database administrator needs to monitor performance to find inefficient queries. This article focuses on exploring how a DBA can monitor the I/Os against an instance of SQL Server, using Dynamic Management Objects, or more commonly know as Dynamic Management Views (DMVs) and Functions (DMFs).

Parallelism and Performance: Are You Getting Full Return on Your CPU Investment?

A webinar from the PASS Performance VC on Aug 3, 2010