SQL Server Performance – Favourite posts on sqlserver-dba.com

11 March,2013 by Jack Vamvas

Here is a selection of SQL Server Performance related posts I’ve written over the last few years on www.sqlserver-dba.com . In my daily work , I deal with many SQL Server performance problems covering all aspects of issues , many of them repeat offenders. Check DBA Scripts for wider range of scripts.


 Performance Myth : Replacing a CURSOR with a WHILE LOOP and think you are not processing with a row

It’s still row by row processing!

SQL Server - Last time a stored procedure was executed

Useful script for clean up processes


Performance Monitor Counters for SQL Server performance testing

I use these SQL  performance monitor counters as a starting point

Mobile Commerce and SQL Performance Tuning

A large area of growth for  DBAs specialising in performance tuning

SQL Server Storage and IO performance

A summary on how to manage relationships with Storage Infrastructure


SQL Server – Troubleshoot DBCC SHRINKDATABASE slow performance

DBCC SHRINKDATABASE is not advised as a regular practise , but sometimes it’s necessary and slow performance can kill the server. This is a troubleshooting approach

SQL Server Performance Killers

These are the top 10 repeat offenders

 SQL Server Performance Checklist

I’m not a big fan of checklist for root cause analysis, but they are useful as a healthcheck

SQL Server – Performance Top Queries by Total CPU Time

A script to identify queries per Total CPU time. Useful when experiencing sudden performance decrease

SQL Server – Current queries executing on SQL Server

I use this script almost daily. Simple but highly effective in production issues


SQL Performance tuning - Asking the right question

The first step in performance troubleshooting

 SQL Performance tuning - Drilling into the problem

You’ve defined the performance problem , next step is how to solve it

SQL Server – Min Memory Per query and performance

Only change Minimum memory per query under certain circumstances

 SQL Server – Monitor SQL Transaction Log AutoGrowth for performance issues

Transaction Log Auto Growth can kill SQL Server Performance . Find out how to monitor

Author: Jack Vamvas (http://www.sqlserver-dba.com)


Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.


Post a comment on SQL Server Performance – Favourite posts on sqlserver-dba.com

sqlserver-dba.com | SQL Server Performance Tuning | SQL Server DBA:Everything | FAQ | Contact|Copyright & Disclaimer