Identify data patterns - Ran or Seq ?

Question

Identify data patterns - Ran or Seq ?

curious_sqldba

SSC-Dedicated

Points: 36494
More actions
January 26, 2016 at 3:48 pm

#324271

Is there a way or any perfmon counter that could help in identifying whether my data pattern against a drive is sequential or random? Also how do i capture outstanding requests? Thank you.

Viewing 3 posts - 1 through 2 (of 2 total)

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

Jeff Moden SSC Guru Points: 1004406 More actions · Answer 1

curious_sqldba (1/26/2016)
Is there a way or any perfmon counter that could help in identifying whether my data pattern against a drive is sequential or random? Also how do i capture outstanding requests? Thank you.

Data pattern for what? Clustered index? Non-clustered index? Single row GUI lookups? Batch jobs? Pages? Extents? Underlying disk sectors at the OS level?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

curious_sqldba SSC-Dedicated Points: 36494 More actions · Answer 2

Data access pattern on Drive, someone asked me this question " What is your data pattern on K drive, is it more like random or sequential", i know typically for logs would be sequential , i was wondering if there is a scientific way to gather this metric.