Kevin,

as Server is running in 32 GB RAM, I forgot the possibility of keeping/reading all pages from memory irrespective of hard disk and fusion-io.

As you suggested, I 've done a write and read test today with 1.5 GB table by cleaning buffer in each stage.

I can observe 5 times improvement in Fusion-IO read when compared with read from hard-disk.

one more intresting point is, write speed was not par with reading from Fusion-io.

I have asked specification details of both hard disk and fusion-io from network team and we have planned stress test on both hard disk and fusion-io in this weekend.

One more curious question.

as a best practice, We seperate mdf, ndf, ldf and tempdb in seperate drives. as of now all in fusion-io. hope this wont be a problem for Fusion-io.

thanks all for your valuable time and inputs.