Do they include...

  1. SYSTEM dbpsace table and index pages
  2. Secondary dbspace table and index pages
  3. Temporary dbspace table and index pages
  4. Temporary dbspace other reads and writes
  5. LOAD and UNLOAD reads and writes
  6. xp_write_file and xp_read_file reads and writes
  7. Checkpoint file operations
  8. Recovery file operations
  9. Other file operations not listed above

asked 06 Aug '16, 14:16

Breck%20Carter's gravatar image

Breck Carter
25.7k427587847
accept rate: 20%


Any page level read or write should be included.

At a minimum that would include all of 1., 2., 3., 4., 7., 8. and for:

5.: at least the writes for the LOAD and reads for the unload, 6.: any paging to/from the temporary file (or if part of an insert/update table and index updates)

Not much else would fall into item #9 (other than possible pagingfile or swap I/Os maybe)

These are low level counters updated whenever page level reads and writes are used and the items identified always fall into that category.

I'd have to drill more into some of the other I/O parts more if they are important. They might be included but I'd have to do a bit more research.

permanent link

answered 08 Aug '16, 19:16

Nick%20Elson%20SAP%20SQL%20Anywhere's gravatar image

Nick Elson S...
7.3k35107
accept rate: 31%

Thank you for being so thorough.

Points 5 and 6 were unclear...

5a. LOAD and UNLOAD reads and writes to SQL Anywhere dbspace files - I think you've answered "yes" to this one

5b LOAD AND UNLOAD reads and writes to external (text etc) non-dbspace files - for example, LOAD reads a 5G text file; does that get counted in DiskRead?

6 xp_write_file and xp_read_file reads and writes to external non-dbspace files - this is the "direct I/O" for the xp_thingies; I assumed the "indirect I/O" (e.g., an INSERT of xp_read_file return value into a blob column) is counted in point 1

(09 Aug '16, 13:04) Breck Carter
1

From my read ... and unless you have noticed a case I need to look into more ....

For 5a you are correct. For 5b my read indicates that is a no.

For 6 ... again xp_write_file( ) writes and xp_read_file( ) reads are a no case as well. {except as you've noted}

Unless either of those happen to cause I/Os of cache pages to/from the temporary file (#3) or are part of an operaton that interacts with a table they do not seem be counted.

(09 Aug '16, 13:46) Nick Elson S...
Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×2

question asked: 06 Aug '16, 14:16

question was seen: 178 times

last updated: 09 Aug '16, 13:46