Tag Archives: Performance

T-SQL Tuesday #037 – SARGability – Not Just For WHERE Clauses

Posted on December 11, 2012 by

T-SQL Tuesday is a monthly SQL Server blogging event. One of us sets a topic for the month’s event, and we all have a week in which to write a blog post that fits that topic. This month’s event is … Continue reading →

Posted in SQLServerPedia Syndication, T-SQL Tuesday | Tagged , , | 1 Comment

#T-SQL Tuesday #35 – Soylent Green

Posted on October 9, 2012 by

T-SQL Tuesday is a monthly SQL Server blogging event.  One of us sets a topic for the month’s event, and we all have a week in which to write a blog post that fits that topic.  This month’s event is … Continue reading →

Posted in SQLServerPedia Syndication, T-SQL Tuesday | Tagged , , | 1 Comment

Waitresource Key

Posted on January 24, 2012 by

I was watching a server this morning, making sure that there was nothing untoward going on, and I caught sight of a LCK_M_S waittype with a very long number in the Resource column: KEY: 26:72057594819903488 (6b0068a71fb9). I watched a bit … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , | Leave a comment

Agresso Database Servers – Maintenance Checklist

Posted on November 16, 2010 by

This is some information that was not made available to us, the DBA team, on a site I worked at recently.  I suspect that I was not in a unique situation, so I’m providing the DB Server parts of those … Continue reading →

Posted in SQLServerPedia Syndication | Tagged , , , , | Leave a comment

Application Performance – Agresso

Posted on June 11, 2010 by

Application performance enhancement is not just about index tuning. It’s about designing and writing the application properly. Here I take a look at the Agresso system and some of the problems we have observed with it. Continue reading →

Posted in SQLServerPedia Syndication, Uncategorized | Tagged , | 5 Comments