How Can I Log and Find the Most Expensive Queries?
Posted
by Pure.Krome
on Stack Overflow
See other posts from Stack Overflow
or by Pure.Krome
Published on 2008-11-03T04:02:56Z
Indexed on
2010/04/04
8:03 UTC
Read the original article
Hit count: 242
Hi folks
The activity monitor in sql2k8 allows us to see the most expensive queries. Ok, that's kewl, but is there a way I can log this info or get this info via query analyser? I don't really want to have the Sql Management console open and me looking at the activity monitor dashboard.
I want to figure out which queries are poorly written/schema is poorly designed, etc.
Thanks heaps for any help!
© Stack Overflow or respective owner