Tag Archives: Performance

Waitresource Key

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

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

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