The forum will be down for scheduled maintenance on Saturday, March 4 beginning at 10am EST. Actual downtime is unknown but may be several hours.

Why does sa_conn_properties() return a value of TempFilePages for the current connection that is wildly different from CONNECTION_PROPERTY ( 'TempFilePages' ) which should return the same value?

It may not be fair for the following query to call it "Incorrect TempFilePages" because (I think) it is a snapshot of the TempFilePages value when it has been momentarily inflated by the process of calculating the sa_conn_properties() result set itself.

HOWEVER, if that is the explanation, perhaps sa_conn_properties() could be modified to avoid using that inflated value.

SELECT @@VERSION,
       CONNECTION_PROPERTY ( 'TempFilePages' ) AS "Correct TempFilePages",
       Value AS "Incorrect TempFilePages"
  FROM sa_conn_properties()
 WHERE PropName = 'TempFilePages'
   AND Number = @@SPID;

@@VERSION,Correct TempFilePages,Incorrect TempFilePages
'12.0.1.3810','14',794

asked 22 Feb '13, 15:38

Breck%20Carter's gravatar image

Breck Carter
26.8k421580826
accept rate: 20%

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:

×101

question asked: 22 Feb '13, 15:38

question was seen: 365 times

last updated: 22 Feb '13, 15:38