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 |
|
nitin1111
Starting Member
13 Posts |
 Posted - 2010-04-06 : 07:14:04
|
| Hi,how to tune select query in 2008I have got select query to tune.I used sql profiler to create trace file and used database engine tunning advisor to get recommandation for trace files. but I did not get any recommandation.users are complaining about slow response time.pls help me how to solve this issue. M.N.Dani |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-04-06 : 07:22:30
|
| whats the query doing? do you have proper indexes which can be used by query? did you try analysing execution plan/------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2010-04-06 : 07:29:17
|
| post the query.If you've used any wrapper functions (ISNULL, DATEDIFF, etc) then you'll be unable to make use of any potentially helpful index.Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
nitin1111
Starting Member
13 Posts |
Posted - 2010-04-06 : 08:21:46
|
| Thanks..I have got execution plan... But not able to analyze ..please help me how to start with analization.M.N.Dani |
|
|
|
Transact Charlie
Master Smack Fu Yak Hacker
3451 Posts |
Posted - 2010-04-06 : 08:34:51
|
| psot the query and the plan.You should look for:table / index scanskey lookupsWrapper functionsMissing indexbefore considering any more esoteric things.Charlie===============================================================Msg 3903, Level 16, State 1, Line 1736The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION |
|
|
|
|
|
|
how to tune select query in 2008