MS-SQL Server 2008 学习笔记一

SQL Server 2008 adds five new dynamic management views to return memory-related
information about SQL Server:
. sys.dm_os_memory_brokers—Returns information about memory brokers, the
components that track memory allocations
. sys.dm_os_memory_nodes—Returns memory allocation information for memory
allocated through SQL Server Memory Manager
. sys.dm_os_nodes—Returns information about SQL OS memory nodes, internal
structures of SQL OS that abstract hardware processor locality
. sys.dm_os_process_memory—Returns complete information about memory allocated
to SQL Server process space
. sys.dm_os_sys_memory—Describes the memory state for the operation system

 

 

 

SQLCLR Enhancements
SQL Server 2008 extends the SQLCLR by extending the 8KB size limit for CLR user-defined
types and CLR user-defined aggregates, supporting the definition of ordered table-valued
functions, providing support for multiple input parameters for user-defined aggregates,
and including the option to define static methods as user-defined functions.