Two very short-lived connections to a 12.0.1.3298 database with an 8K page size were recorded with TempFilePages = 4294967281 for one connection and 4294967287 for the other.

This is not easily reproduced (ok, it's not reproducible at all), but it sure is noticeable when peak values are tracked (e.g., by Foxhound).

Here are the recorded measurements...

connection_number,sample_recorded_at,TempFilePages
16,'2012-07-23 16:33:14.503',4294967287
16,'2012-07-23 16:33:24.718',4294967287
59,'2012-07-23 16:33:24.718',4294967281
16,'2012-07-23 16:33:35.804',4294967287
16,'2012-07-23 16:33:45.233',4294967287
16,'2012-07-23 16:33:55.549',4294967287
16,'2012-07-23 16:34:04.624',4294967287

asked 12 Aug '12, 10:26

Breck%20Carter's gravatar image

Breck Carter
25.7k427586845
accept rate: 20%

edited 12 Aug '12, 10:28

And so your question is whether these values are correct and/or possible at all?

AFAIK, with 8K pages, the documented maximum dbspace size is 8.192 * 2^28 = 2^13 * 2^28 = 2^41, which is surely below the around 2^45 you have noticed...

(12 Aug '12, 17:00) Volker Barth
Replies hidden
1

...whereas my obvious question is: Where did you get these 32TB HDDs, Breck? :)

(13 Aug '12, 03:12) Volker Barth
1

HDDs? Who said anything about HDDs? This is all in RAM!

Seriously, they are clearly bogus values, for two reasons: the sheer size of the values, and the fact they reached those sizes within 10 seconds of the each connection being established. The first might be conceivable at some point in the near future, but not the second.

(13 Aug '12, 16:31) Breck Carter

Converted to hex, the two values are 0xfffffff7 and 0xfffffff1. Very suspicious. Did you have any parallel queries executing at the time?

(14 Aug '12, 04:25) Mark Culp
Be the first one to answer this question!
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:

×102

question asked: 12 Aug '12, 10:26

question was seen: 608 times

last updated: 14 Aug '12, 04:25