Understanding .dat-i and .dat-u from server statistics

176
2
01-26-2022 07:01 AM
StanleyBrown
New Contributor

tl;dr What is the format of .dat-i and .dat-u files in arggisssystem/statistics?

I'm trying to analyse usage patterns for our web services so I can optimise resource allocation (for example, increasing/decreasing running instances). I've tried a few methods that didn't quite work:

  1. The statistics report tool built into ARCGIS server manager is not suitable for this task because it can only produce pretty limited statistical outputs.
  2. The export function that is built-in only produces a few data points at a time which makes it a very slow way of extracting the data that sits behind it. (Approx 3 hours to get a sample of 20 .csv's)
  3. The API works, but only seems able to retrieve total figures. It doesn't seem to have a parameter that lets me specify a date range for the data.

So I've found the place where the statistics are actually saved:

StanleyBrown_1-1643194424835.png

Location of files ^. Although at first menacing, both the .dat-i and the .dat-u files turned out to be structured like csv's.

StanleyBrown_2-1643194535562.png

Sample .dat-i ^

StanleyBrown_3-1643194570218.png

Sample .dat-u ^

So it seems I have managed to find all the statistics I could ever want in a simple machine-readable format that is well suited for statistical analysis. Hurrah! However, I'm not quite sure what most of the fields actually are.

The first field in both is an epoch timestamp in milliseconds. The second is the address of each service.

Then the .dat-i files have 4 other fields:

  1. The number 60
  2. The number 0.000
  3. Either 1.000, 2.000, or 3.000
  4. Either 0.000, 30.000, 58.000 or 60.000

Wheras, the dat-u files have 7 other fields:

  1. An integer, mostly under 100
  2. 0, 1, 2 or 3
  3. 0
  4. 0
  5. An integer, mostly under 100, mostly the same value as field 1.
  6. A 3 decimal place value, mostly under 1
  7. A 3 decimal place value, typically higher than field 7.

I have some of my own guesses for some of these, but it would be really helpful if any of you either know for sure what they are, have good guesses, or can point me to the documentation for this. Also, what is the difference between the dat.i and the dat.u files? Thanks for reading!

0 Kudos
2 Replies
berniejconnors
Occasional Contributor III
StanleyBrown
New Contributor

Thanks Bernie!

That's working wonders, I knew there had to be an easier way. Thanks so much for pointing it out.

Stanley