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 |
|
rtutus
Aged Yak Warrior
522 Posts |
 Posted - 2007-10-05 : 09:00:14
|
| Hi,When I run a query estimated plan it shows estimated IO Cost of 50 or 60. We have a RAID5 config.Is that normal.2/ an other question:If the IO of 50 or 60 is not normal, does that necessarily mean that there s problem in the Hardware, or is it also possible that the DB config or queries or indexes are causing the IO to be high?Thanks. |
|
|
evilDBA
Posting Yak Master
155 Posts |
Posted - 2007-10-05 : 09:31:21
|
| Not at all, the Query Plan generator is not aware of how your I/O system is powerful.To check where is a bottleneck on a real system (CPU, or I/O, or Locks) use I/O activity monitor http://www.sqlsolutions.com/products/IO%20Activity%20Monitor/index.html |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-10-06 : 00:11:08
|
| Also depends on how many rows involved. Did you see table scan in the plan? |
|
|
|
rtutus
Aged Yak Warrior
522 Posts |
Posted - 2007-10-09 : 08:56:20
|
| I ll check that sometime, the issue seems to be resolved for now by creating an iondex and deleting half the rows of a main table. thanks |
|
|
|
|
|
|
s it normal to have I/O cost of 50 or 60 for RAID5