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 |
|
Aleph_0
Yak Posting Veteran
79 Posts |
 Posted - 2012-02-23 : 17:00:51
|
| What do you look for when you look at "scan count", "logical reads", "physical reads" etc.? Lower numbers? Do you look at all of them, or are some not very illuminating?I thought this might be a way I could try to see if parts of my query (script? file? I still don't know the jargon) are inefficient. I tried looking at Estimated Execution Plans but was denied permission (and I don't blame the IT guys). Am I on the right track?Thanks, as always! |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2012-02-23 : 17:50:10
|
>>Am I on the right track?Yes, execution plans and statistics IO are great optimization tools and are things you want to get familiar with. The lower the read and scan counts the better.  Be One with the OptimizerTG |
 |
|
|
|
|
|
Can anyone explain Statistics IO messages?