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 |
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
 Posted - 2009-11-27 : 09:22:46
|
| Deal All,I am very new to analyze the Execution plan for the query.Can anybody help me to read the execution plan for any query.Any guidance in this regard very much helpful.like physical operation ,Logical operation,Estimated I/O cost,Read etc etc.Thanks,Gangadhar |
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2009-11-27 : 10:28:52
|
| Look for the scans...and look to eliminate same, especially table scans.scans mean indexes are not being used. sometimes unavoidable, but preferable not to be there.post some particular samples and we may be able to assist more. |
 |
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
|
|
denis_the_thief
Aged Yak Warrior
596 Posts |
Posted - 2009-11-27 : 11:37:50
|
| Those execution plans still make me scratch my head a lot. But I think a good one is the Operator cost's Percentage, that is usually a good indicator of where the 'bottleneck' is. |
|
|
|
GilaMonster
Master Smack Fu Yak Hacker
4507 Posts |
Posted - 2009-11-27 : 15:18:38
|
| It can be, but it can also be completely misleading. Those percentages are estimates. They are based on the cost estimates that the query optimiser comes up with. If statistics are out of date or there's a parameter sniffing problem those estimates can be way, way off and hence the percentages can be as well.--Gail ShawSQL Server MVP |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2009-11-29 : 09:02:45
|
| Prior to do doing the analysis : ensure your statistics are up to date. Even though Query Analysis through the EXecution plans is very effective , also consider the application and how many\what types of calls it is makeing on the database ,Also , to keep the analysis consistent - clear cache and buffers prior to testingJack Vamvas--------------------http://www.ITjobfeed.com |
|
|
|
|
|
|
|
|
Performance tuning