Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sanjay5219
Posting Yak Master
240 Posts |
 Posted - 2013-12-09 : 12:15:36
|
| Hi All,Is there any way to get the queries which is taking more time to execute |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2013-12-09 : 12:44:03
|
| Define "more time". Setup so_whoisactive to log active queries every minute. Alternatively, you can use run a trace or setup an extended event session.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
Expensive Query