| Author |
Topic |
|
krij
Starting Member
9 Posts |
 Posted - 2009-02-23 : 01:37:30
|
| Hi,I am getting 10000 to 90000 index searches/sec. Is it ok or not? |
|
|
karthik_padbanaban
Constraint Violating Yak Guru
263 Posts |
Posted - 2009-02-23 : 02:05:07
|
| your question is not clear.Karthik |
 |
|
|
krij
Starting Member
9 Posts |
Posted - 2009-02-23 : 03:42:10
|
Karthik,I have captured perfom results for 1 hour and the results/values between 0 to 90000.(ie., min:0 and max:90000)Is these values are with in acceptable range?quote:
Originally posted by karthik_padbanaban
your question is not clear.Karthik
|
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2009-02-23 : 04:22:18
|
| It depends on selectivilty of your columns. Also , when you look at queries in your Execution Plan , do you have any scans?Jack Vamvas--------------------http://www.ITjobfeed.com |
|
|
|
krij
Starting Member
9 Posts |
Posted - 2009-02-23 : 06:42:51
|
Jack - There's no scan in my execution plan, but perfmon results (1 hour) shows 3 to 7 full scans/sec.quote:
Originally posted by jackv
It depends on selectivilty of your columns. Also , when you look at queries in your Execution Plan , do you have any scans?Jack Vamvas--------------------http://www.ITjobfeed.com
|
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-23 : 06:55:44
|
| Actually it should be between 1 and 2 . Use DMV for missing index. Do you know which query is running slow? |
|
|
|
krij
Starting Member
9 Posts |
Posted - 2009-02-23 : 07:00:36
|
| I have listed out top 10 queries (Order by READS Desc) from trace and I check the execution plan for these queries, there's no scans only I can see the scans and high index searches in 1 hour test. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-23 : 07:03:53
|
| How long did they run? Remember Index scan can be same as scan if all rows have to be fetched. |
|
|
|
krij
Starting Member
9 Posts |
Posted - 2009-02-23 : 07:13:43
|
| All the queries took below 1-2 Seconds only. |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-23 : 07:17:05
|
quote:
Originally posted by krij
All the queries took below 1-2 Seconds only.
Then the table could be smaller in Which Scan performs better than with index. Run standard reports for Queries. |
|
|
|
krij
Starting Member
9 Posts |
Posted - 2009-02-23 : 07:23:50
|
But the perfmon Index searches/sec shows 0 to 90000 (avg: 10000-55000). Is it acceptable range? quote:
Originally posted by sodeep
quote:
Originally posted by krij
All the queries took below 1-2 Seconds only.
Then the table could be smaller in Which Scan performs better than with index. Run standard reports for Queries.
|
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2009-02-23 : 07:49:06
|
| Why are you worried if queries are running in 1-2 secs? |
|
|
|
|
Index Searches/Sec