Windows Server 2008

Remember the 33 new DMVs in SQL Server 2008 post? I was just poking around in SQL Server 2008  CTP6 and wanted to know if there were any new Dynamic Management Views since CTP5. There are 13 new DMVs in CTP6 and there are a total of 46 new Dynamic Management Views compared to SQL server 2005. The list of them is below, I think their names make clear what the dmv is supposed to do (or at least I think I know)

 
dm_audit_actions
dm_audit_class_type_map
dm_cdc_errors
dm_cdc_log_scan_sessions
dm_cryptographic_provider_algorithms
dm_cryptographic_provider_keys
dm_cryptographic_provider_properties
dm_cryptographic_provider_sessions
dm_database_encryption_keys
dm_db_mirroring_auto_page_repair
dm_db_mirroring_past_actions
dm_db_persisted_sku_features
dm_exec_procedure_stats
dm_exec_trigger_stats
dm_filestream_oob_handles
dm_filestream_oob_requests
dm_fts_fdhosts
dm_fts_index_keywords
dm_fts_index_keywords_by_document
dm_fts_outstanding_batches
dm_fts_parser
dm_os_dispatcher_pools
dm_os_dispatchers
dm_os_memory_brokers
dm_os_memory_node_access_stats
dm_os_memory_nodes
dm_os_nodes
dm_os_process_memory
dm_os_spinlock_stats
dm_os_sys_memory
dm_resource_governor_configuration
dm_resource_governor_resource_pools
dm_resource_governor_workload_groups
dm_server_audit_status
dm_sql_referenced_entities
dm_sql_referencing_entities
dm_tran_commit_table
dm_xe_map_values
dm_xe_object_columns
dm_xe_objects
dm_xe_packages
dm_xe_session_event_actions
dm_xe_session_events
dm_xe_session_object_columns
dm_xe_session_targets
dm_xe_sessions
 

 

The 13 DMVs listed below are new in CTP6

 

dm_audit_actions
dm_audit_class_type_map
dm_db_persisted_sku_features
dm_exec_procedure_stats
dm_exec_trigger_stats
dm_fts_fdhosts
dm_fts_index_keywords
dm_fts_index_keywords_by_document
dm_fts_outstanding_batches
dm_fts_parser
dm_os_dispatchers
dm_os_memory_node_access_stats
dm_server_audit_status

If you want to find out what the names of all the new DMVs are by running a query on your SQL Server 2008 box and you don't have a linked server to a SQL Server 2005 box then don't worry I have prepared the query below for you.

 
SELECT * FROM sysobjects
WHERE name LIKE 'dm_%'
AND name NOT IN('dm_os_hosts',
'dm_exec_cached_plan_dependent_objects',
'dm_os_memory_allocations',
'dm_os_loaded_modules',
'dm_db_task_space_usage',
'dm_os_memory_objects',
'dm_os_schedulers',
'dm_os_threads',
'dm_exec_requests',
'dm_db_missing_index_columns',
'dm_repl_tranhash',
'dm_qn_subscriptions',
'dm_db_session_space_usage',
'dm_exec_query_optimizer_info',
'dm_tran_top_version_generators',
'dm_os_waiting_tasks',
'dm_exec_background_job_queue',
'dm_exec_cursors',
'dm_db_missing_index_details',
'dm_clr_properties',
'dm_os_sublatches',
'dm_exec_query_memory_grants',
'dm_tran_current_snapshot',
'dm_io_virtual_file_stats',
'dm_exec_xml_handles',
'dm_os_wait_stats',
'dm_exec_text_query_plan',
'dm_broker_connections',
'dm_os_stacks',
'dm_os_ring_buffers',
'dm_db_missing_index_groups',
'dm_exec_cached_plans',
'dm_exec_sessions',
'dm_broker_forwarded_messages',
'dm_os_memory_clerks',
'dm_repl_articles',
'dm_fts_memory_buffers',
'dm_fts_index_population',
'dm_tran_current_transaction',
'dm_os_child_instances',
'dm_exec_connections',
'dm_exec_background_job_queue_stats',
'dm_fts_active_catalogs',
'dm_tran_database_transactions',
'dm_os_memory_cache_clock_hands',
'dm_repl_schemas',
'dm_db_mirroring_connections',
'dm_db_index_operational_stats',
'dm_db_partition_stats',
'dm_io_pending_io_requests',
'dm_os_memory_cache_entries',
'dm_os_virtual_address_dump',
'dm_tran_transactions_snapshot',
'dm_exec_query_plan',
'dm_os_memory_cache_hash_tables',
'dm_exec_query_stats',
'dm_clr_tasks',
'dm_os_worker_local_storage',
'dm_db_index_usage_stats',
'dm_db_index_physical_stats',
'dm_os_buffer_descriptors',
'dm_tran_active_snapshot_database_transactions',
'dm_tran_active_transactions',
'dm_db_file_space_usage',
'dm_broker_activated_tasks',
'dm_broker_queue_monitors',
'dm_os_memory_cache_counters',
'dm_tran_session_transactions',
'dm_clr_appdomains',
'dm_exec_sql_text',
'dm_os_memory_pools',
'dm_os_latch_stats',
'dm_io_backup_tapes',
'dm_fts_memory_pools',
'dm_os_sys_info',
'dm_tran_locks',
'dm_exec_query_transformation_stats',
'dm_exec_query_resource_semaphores',
'dm_repl_traninfo',
'dm_db_missing_index_group_stats',
'dm_fts_population_ranges',
'dm_os_performance_counters',
'dm_os_workers',
'dm_io_cluster_shared_drives',
'dm_os_tasks',
'dm_exec_plan_attributes',
'dm_tran_version_store',
'dm_os_cluster_nodes',
'dm_clr_loaded_assemblies')

Enjoy exploring these DMVs

 

 

 By Tom Henderson and Rand Dvorak, Network World Lab Alliance , Network World , 02/21/2008.

We tested Windows Server 2008 Enterprise Edition RTM on a switched Gigabit Ethernet D-Link network using primarily a Dell 1950 server equipped with a dual quad-core 1.6GHz CPU, 32GB of dynamic RAM, two Broadcom Gigabit Ethernet network interface cards connecting it to the network and a QLogic 2GB Fibre Channel card connecting it to our internal storage-area network.

To assess operating system compatibility, we also ran Windows Server 2008 on other servers including an HP585G2 with four, dual-core AMD Athlon 64 CPUs with 4GB of DRAM per card and Compaq NetIntelligent Gigabit Ethernet NICs; three Compaq DL-140 boxes (each with dual Intel Xeon CPUs running at 3GHz). The client machines used in testing included various HP and Apple workstations and notebooks running Windows XP SP2, Windows 2000 Professional, Apple 10.4.11 or 10.5.1.

We imported 100,000 users into the Active Directory using LDIFF, creating 32 groups, and seven administrative domains. After importation, we randomly checked each of the Active Directory components for signs of an accurate importation; it was successful. We then made various changes to users, groups, and policy objects and watched for the changes to appear in the new Windows 2008 AD audit logs. Despite the comparative size, changes were fast.

In terms of performance testing, we ran a series of tests where files and folder were copied using four HP PCs, each formatted with fresh copies of Windows XP SP2 first and then with fresh copies of Vista SP1. We copied identical folders containing 60MB of files (a mixture of files ranging from 1K to 17.2MB) on our Dell 1950 PowerEdge server (no antivirus software was used on clients or server) using a batch file, noting copy execution times. Vista SP1 copies were significantly faster over the Ethernet 10Base-T hub that we connected the PCs to the server with (emulating slower speed links). We also compared streaming times using MP3 files from each server.

We also tested performance between NDIS2 (Vista) and NDIS1 (Windows XP, and various SAMBA clients) for file/folder copy speed performance, and found NDIS2/VISTA clients are strongly favored in busy networks.

We measured simple disk access through file/folder copying on a server (rather than client-to-server) to be the same between Windows 2003 and Windows 2008 Server Editions. We tested iSCSI host and target software, and found it to have the same speed as R2-supported file I/O.

We also tested IIS 7 via Web get/posts using inclining concurrency of the get/posts (using static pages), and found that there was no additional performance advantage of Windows 2003 over 2008 server editions until concurrency (number of users getting and posting) was raised significantly, where Windows 2008 and IIS 7 became very fast compared with Windows 2003 and IIS 6. Both versions of IIS were running in default/unoptimized configurations.

Logon compatibility was checked between Windows 2008 Enterprise Edition with Windows 2000 Professional, XP (SP1 and SP2), Vista (with and without SP1,which was released on the same day with the RTM of Windows 2008 Server editions), MacOS 10.4.11, 10.5.1, Ubuntu Linux, Red Hat Linux Enteprise 5, and Debian Sarge. We also used Windows 2008 Enterprise Server (six instances) as a VM guest operating system under VMware ESX 3.5 with no issues. We discovered that support for Macintosh/Linux in advanced services such as Network Access Protection is absent (and can be handled as an unprotected exception), and other Macintosh services (formerly known as Microsoft Services for Macintosh) are no longer supported; these included AppleTalk cross-platform support, and secure logon (encrypted with hash using differing access methods).

http://www.networkworld.com/reviews/2008/022108-windows-2008-test-how.html