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 |
|
thaniparthi.rao
Yak Posting Veteran
96 Posts |
 Posted - 2008-04-03 : 14:29:59
|
| 1. could any one tell me in a simple way how to troubleshoot long running queries.2.what is the default recovery model |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-03 : 14:45:55
|
| Post the queries for help |
 |
|
|
thaniparthi.rao
Yak Posting Veteran
96 Posts |
Posted - 2008-04-03 : 15:06:56
|
| In general any query . how do we approach. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-03 : 15:14:07
|
| Do you have any query that is taking long time or you have to find? |
|
|
|
thaniparthi.rao
Yak Posting Veteran
96 Posts |
Posted - 2008-04-03 : 15:21:34
|
| I mean how do we find it. after that how do we approach in general,like the steps we do follow to improve the performance of a query. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-03 : 15:35:13
|
| You have run profiler and watch which queries are running for long time. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-03 : 22:44:48
|
| What's your definition of long running query? Once you get them with profiler, you can look at query's execution plan and ensure sql uses proper index. |
|
|
|
|
|
|
long running queries