Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I realise that my question isn't strictly 'database' but I know that a lot of DBA's will use the SQLIO tool to check I/O performance on their systems so I'm hoping that somebody here will be able to answer this question:

When I run SQLIO the 3rd line of output says something like:

using system counter for latency timings, 14318180 counts per second

What does that mean? I get different values on different systems, and because I'm comparing different systems I would like to know what that number is telling me (if anything).

share|improve this question

1 Answer 1

up vote 2 down vote accepted

It's an informational message, which can be ignored.

This is just the conversion factor between the timer mechanism the program uses internally and actual, real time. See this for a bit of background.

The per-second metrics that the program outputs are the ones you want to focus on. Have a look at this blog post for a tutorial on how to use SQLIO and interpret its output.

share|improve this answer
    
Thanks, I was hoping that I could ignore it - there's enough stuff for me to be thinking about with the rest of the information!! :-) –  paulH Aug 9 '13 at 16:04
    
@JonSeigel Added the links in the comments. Thanks ! –  Kin Aug 9 '13 at 16:36

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.