pmuddam,

Do you have any indexes on the other columns? If not, the predicates in the WHERE clause will cause SQL Server to scan the whole table.

e.g. Without an index, the...

ClearTrace[/url] by Bill Graziano from ScaleSQL Consulting will suck in profile traces and give you really good summary.

SQLNexus by Jack Li from Microsoft Support goes a little bit deeper....

There's heaps of info about this, but here's a start....

from Microsoft

Average Disk/sec Read & Average Disk/sec Write:

On well-tuned I/O subsystems, ideal values would be:

1–5 ms for Log (ideally...