Connection properties   The following connection properties have been added in this release:

• allow_snapshot_isolation
• ansi_substring
• ApproximateCPUTime
• conn_auditing
• default_dbspace
• ExprCacheAbandons
• ExprCacheDropsToReadOnly
• ExprCacheEvicts
• ExprCacheHits
• ExprCacheInserts
• ExprCacheLookups
• ExprCache
• GetData
• HeapsCarver
• HeapsLocked
• HeapsQuery
• HeapsRelocatable
• HttpServiceName
• http_session_timeout
• java_location
• java_main_userid
• LastPlanText
• LockCount
• LockedCursorPages
• LockTableOID
• materialized_view_optimization
• max_query_tasks
• max_temp_space
• MultiPageAllocs
• NcharCharSet
• oem_string
• post_login_procedure
• QueryHeapPages
• ReqCountActive
• ReqCountBlockContention
• ReqCountBlockLock
• ReqCountBlockIO
• ReqCountUnscheduled
• ReqTimeActive
• ReqTimeBlockContention
• ReqTimeBlockIO
• ReqTimeBlockLock
• ReqTimeUnscheduled
• ReqStatus
• RequestsReceived
• RetryConnectionTimeout
• SessionCreateTime
• SessionID
• SessionLastTime
• SnapshotCount
• synchronize_mirror_on_commit
• tsql_outer_joins
• verify_password_function

For more information about connection properties, see Accessing connection property values.

Server properties   The following server properties have been added in this release:

• CachePinned
• CacheReadEng
• CacheSizingStatistics
• CarverHeapPages
• ConsoleLogMaxSize
• CollectStatistics
• DebuggingInformation
• DefaultNcharCollation
• DiskReadEng
• ExchangeTasks
• FirstOption
• FunctionMaxParms
• FunctionMinParms
• HeapsRelocatable
• HeapsLocked
• HeapsQuery
• HeapsCarver
• IsEccAvailable
• IsRsaAvailable
• LastConnectionProperty
• LastDatabaseProperty
• LastOption
• LastServerProperty
• MapPhysicalMemoryEng
• MaxConnections
• MultiProgrammingLevel
• NumLogicalProcessors
• NumLogicalProcessorsUsed
• NumPhysicalProcessors
• NumPhysicalProcessorsUsed
• QueryHeapPages
• RememberLastPlan
• RemoteputWait
• RequestFilterConn
• RequestFilterDB
• RequestLogMaxSize
• RequestsReceived
• ServerName
• StartDBPermission

For more information about these properties, see Accessing database server property values.

Database properties   The following database properties have been added in this release:

• AccentSensitive
• AlternateServerName
• ArbiterState
• AuditingTypes
• CleanablePagesAdded
• CleanablePagesCleaned
• EncryptionScope
• http_session_timeout
• IOParallelism
• JavaVM
• LockCount
• MirrorState
• NcharCollation
• NcharCharSet
• NextScheduleTime
• PartnerState
• ReceivingTracingFrom
• SendingTracingTo
• SnapshotCount
• SnapshotIsolationState
• VersionStorePages
• XPathCompiles

For more information about these properties, see Accessing database property values.

Performance monitor statistics properties   The following Performance Monitor statistics have been added in this release:

• Cache: Multi-Page Allocations
• Cache: Panics
• Cache: Scavenge Visited
• Cache: Scavenges
• Cache Pages: Allocated Structures
• Cache Pages: File
• Cache Pages: File Dirty
• Cache Pages: Free
• Comm: Requests Received
• Heaps: Carver
• Heaps: Query Processing
• Heaps: Relocatable Locked
• Heaps: Relocatable
• Mem Pages: Carver
• Mem Pages: Pinned Cursor
• Mem Pages: Query Processing
• Version Store Pages

For more information about these statistics, see Performance Monitor statistics.