IO data pattern

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

SQLbee Ten Centuries Points: 1009 More actions · Answer 1

I dont think that there is a direct way to do this.

You can, however, use system performance counters for disk usage: split I/O.

You also need to track the usage of each drive and then correlate this data with the profiler.

Regards

Akhil

repent_kog_is_near SSCertifiable Points: 7278 More actions · Answer 2

Akhil,

can you please explain the part "correlate this data with the profiler", please..

thx

Dan

MANU-J. SSC-Dedicated Points: 31126 More actions · Answer 3

Read it here.

MJ

arr.nagaraj SSCertifiable Points: 6528 More actions · Answer 4

You can also refer to the link below for identifying page splits

Regards,
Raj