...thanks. I see it now. Been thrown into a DBA role in the past year, and didn't know that.

Trial and error, live and learn i guess...

Hi there,

Thanks for your detailed reply. While I had thought about using perfmon, for whatever reason I was hoping there would be some "magical" SQL/DBCC/showplan thingy to just tell me...

Interesting thread.

I have done both and continue to do both in some sense.

I think which one is for you depends on what you like to do.

Production Support DBA can be...