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 |