SQL Anywhere Feedback - CONNECTION_PROPERTY ( 'TempTableCachePages' )

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

CONNECTION_PROPERTY ( 'TempTableCachePages' )

Breck Carter [TeamSybase]

2005-06-16, 11:23 am

When a query needs "temporary space" for intermediate results,
etcetera, it may allocate pages in the RAM cache before using the
temporary file.

The space used in the temporary file is available via
CONNECTION_PROPERTY ( 'TempTablePages' ), but not the space used in
the cache; hence this request for CONNECTION_PROPERTY (
'TempTableCachePages
' ).

Both numbers are needed to accurately detect and monitor rogue
connections that are doing cartesian products and other stupid query
tricks.

Breck

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com

Sponsored Links