SQL Server on Linux Findings

The estimated reading time for this post is 10 minutes

I tried to explore more regarding SQL Server on Linux operating system, and I found few mysterious stuff which I hope they are interesting to you as well.

Finding 1: That is Microsoft SQL Server Developer Edition

Finding2: Runs on top of Microsoft Windows NT 6.2 (9200 Build)

Finding3: Root directory is C:\

Finding4: Supports NUMA Nodes.

Finding5: The following features are not exist:

  • SQL Server Error Log.
  • SQL Server Full-Text Search.
  • Supports Resource Governor without Max IOPS configuration.
  • SQL Server Audit.
  • Management Data Warehouse.
  • SQL Server Agent.
  • SQL Server PowerShell.
  • Linked Servers.
  • Synonyms.
  • FileStream.
  • Database and Server Triggers.
  • AlwaysOn Failover Cluster Instance.
  • AlwaysOn Availability Group.

Finding 6: The following features are available:

  • Transparent Data Encryption.
  • Supports Resource Governor without Max IOPS configuration.
  • Memory Optimized FileGroup.
  • In-Memory OLTP.
  • Policy Based Management.
  • Database Snapshot.
  • Extended Events.
  • Service Broker.
  • Plan Guide.
  • Sequence.
Finding 7: The following DMVs are available and working.

sys.dm_resource_governor_resource_pool_volumes
sys.dm_os_hosts
sys.dm_os_memory_brokers
sys.openkeys
sys.dm_os_memory_allocations
sys.dm_db_xtp_nonclustered_index_stats
sys.dm_db_mirroring_past_actions
sys.dm_xe_session_object_columns
sys.dm_os_loaded_modules
sys.dm_db_task_space_usage
sys.dm_os_memory_objects
sys.availability_groups_cluster
sys.dm_audit_class_type_map
sys.dm_os_schedulers
sys.dm_os_server_diagnostics_log_configurations
sys.dm_hadr_instance_node_map
sys.dm_io_cluster_valid_path_names
sys.dm_os_dispatcher_pools
sys.dm_xtp_transaction_stats
sys.dm_exec_query_profiles
sys.dm_os_threads
sys.dm_exec_requests
sys.dm_tran_commit_table
sys.dm_exec_query_parallel_workers
sys.dm_fts_outstanding_batches
sys.dm_exec_query_optimizer_memory_gateways
sys.dm_repl_tranhash
sys.dm_hadr_cluster
sys.dm_qn_subscriptions
sys.dm_db_session_space_usage
sys.availability_read_only_routing_lists
sys.dm_xtp_gc_stats
sys.dm_exec_query_optimizer_info
sys.dm_xe_map_values
sys.dm_db_xtp_index_stats
sys.dm_tran_top_version_generators
sys.dm_fts_fdhosts
sys.dm_xe_sessions
sys.trigger_event_types
sys.dm_db_log_space_usage
sys.traces
sys.dm_hadr_name_id_map
sys.dm_os_waiting_tasks
sys.dm_exec_background_job_queue
sys.dm_db_missing_index_details
sys.dm_clr_properties
sys.dm_os_sublatches
sys.dm_exec_session_wait_stats
sys.dm_os_buffer_pool_extension_configuration
sys.dm_exec_query_memory_grants
sys.dm_resource_governor_external_resource_pool_affinity
sys.dm_logpool_hashentries
sys.dm_tran_current_snapshot
sys.dm_exec_valid_use_hints
sys.dm_db_column_store_row_group_operational_stats
sys.dm_os_wait_stats
sys.dm_os_memory_node_access_stats
sys.availability_replicas
sys.dm_os_spinlock_stats
sys.dm_database_encryption_keys
sys.dm_tran_global_transactions_log
sys.availability_groups
sys.dm_db_xtp_checkpoint_stats
sys.dm_hadr_availability_replica_states
sys.dm_broker_connections
sys.dm_db_mirroring_auto_page_repair
sys.dm_exec_compute_node_status
sys.dm_server_registry
sys.dm_os_dispatchers
sys.dm_os_stacks
sys.dm_tran_global_recovery_transactions
sys.dm_external_script_execution_stats
sys.dm_db_xtp_object_stats
sys.dm_filestream_non_transacted_handles
sys.dm_xe_session_targets
sys.dm_audit_actions
sys.dm_hadr_availability_group_states
sys.database_query_store_options
sys.dm_os_ring_buffers
sys.dm_hadr_physical_seeding_stats
sys.dm_db_xtp_table_memory_stats
sys.dm_db_missing_index_groups
sys.dm_hadr_cluster_members
sys.dm_db_uncontained_entities
sys.dm_exec_cached_plans
sys.dm_hadr_availability_replica_cluster_states
sys.user_token
sys.dm_exec_sessions
sys.dm_broker_forwarded_messages
sys.dm_resource_governor_resource_pools
sys.dm_os_memory_clerks
sys.dm_hadr_auto_page_repair
sys.dm_db_xtp_memory_consumers
sys.dm_repl_articles
sys.dm_xe_session_events
sys.dm_external_script_requests
sys.dm_fts_memory_buffers
sys.dm_fts_index_population
sys.securable_classes
sys.dm_db_rda_migration_status
sys.dm_tran_current_transaction
sys.dm_os_cluster_properties
sys.dm_os_child_instances
sys.dm_exec_connections
sys.dm_server_memory_dumps
sys.dm_xtp_threads
sys.system_components_surface_area_configuration
sys.dm_exec_background_job_queue_stats
sys.event_notification_event_types
sys.dm_os_host_info
sys.dm_os_memory_broker_clerks
sys.dm_filestream_file_io_handles
sys.dm_exec_distributed_requests
sys.dm_xtp_transaction_recent_rows
sys.dm_hadr_availability_replica_cluster_nodes
sys.dm_tran_database_transactions
sys.dm_filestream_file_io_requests
sys.dm_exec_external_work
sys.dm_exec_function_stats
sys.dm_cdc_log_scan_sessions
sys.dm_os_memory_cache_clock_hands
sys.dm_repl_schemas
sys.dm_db_mirroring_connections
sys.dm_resource_governor_external_resource_pools
sys.dm_db_xtp_checkpoint_files
sys.dm_db_partition_stats
sys.trace_event_bindings
sys.dm_os_sys_memory
sys.trace_events
sys.dm_io_pending_io_requests
sys.dm_xtp_system_memory_consumers
sys.dm_hadr_cluster_networks
sys.dm_os_nodes
sys.dm_tcp_listener_states
sys.dm_os_memory_cache_entries
sys.dm_os_virtual_address_dump
sys.dm_cryptographic_provider_properties
sys.dm_tran_transactions_snapshot
sys.dm_os_memory_cache_hash_tables
sys.availability_databases_cluster
sys.dm_cdc_errors
sys.dm_resource_governor_configuration
sys.dm_exec_external_operations
sys.dm_exec_query_stats
sys.dm_exec_compute_nodes
sys.dm_fts_semantic_similarity_population
sys.trace_columns
sys.fulltext_system_stopwords
sys.dm_clr_tasks
sys.dm_db_xtp_hash_index_stats
sys.dm_os_worker_local_storage
sys.dm_db_persisted_sku_features
sys.dm_db_index_usage_stats
sys.dm_os_buffer_descriptors
sys.dm_tran_active_snapshot_database_transactions
sys.dm_server_services
sys.dm_tran_active_transactions
sys.dm_tran_global_transactions_enlistments
sys.dm_db_file_space_usage
sys.dm_broker_activated_tasks
sys.availability_group_listeners
sys.dm_broker_queue_monitors
sys.dm_exec_distributed_sql_requests
sys.dm_os_memory_cache_counters
sys.dm_tran_session_transactions
sys.trace_categories
sys.dm_clr_appdomains
sys.dm_db_xtp_gc_cycle_stats
sys.dm_exec_trigger_stats
sys.dm_os_memory_pools
sys.fulltext_languages
sys.dm_os_latch_stats
sys.dm_io_backup_tapes
sys.dm_resource_governor_workload_groups
sys.dm_hadr_database_replica_states
sys.dm_resource_governor_resource_pool_affinity
sys.dm_os_sys_info
sys.dm_tran_locks
sys.dm_exec_procedure_stats
sys.dm_exec_dms_services
sys.dm_hadr_database_replica_cluster_states
sys.dm_exec_distributed_request_steps
sys.dm_db_xtp_checkpoint_internals
sys.dm_exec_query_transformation_stats
sys.dm_exec_query_resource_semaphores
sys.dm_repl_traninfo
sys.dm_exec_compute_node_errors
sys.dm_db_missing_index_group_stats
sys.dm_exec_dms_workers
sys.dm_hadr_automatic_seeding
sys.trace_subclass_values
sys.dm_column_store_object_pool
sys.dm_os_performance_counters
sys.dm_os_workers
sys.dm_xe_session_event_actions
sys.dm_db_script_level
sys.dm_server_audit_status
sys.dm_db_rda_schema_update_status
sys.dm_io_cluster_shared_drives
sys.availability_group_listener_ip_addresses
sys.dm_os_tasks
sys.fulltext_document_types
sys.login_token
sys.dm_xe_packages
sys.dm_logpool_stats
sys.fulltext_semantic_languages
sys.spatial_reference_systems
sys.dm_os_memory_nodes
sys.dm_tran_version_store
sys.dm_os_windows_info
sys.dm_os_cluster_nodes
sys.dm_xtp_gc_queue_stats
sys.dm_os_process_memory
sys.dm_tran_global_transactions
sys.dm_xe_objects
sys.dm_xe_object_columns
sys.dm_db_xtp_transactions
sys.dm_clr_loaded_assemblies
sys.index_resumable_operations
sys.dm_db_column_store_row_group_physical_stats
sys.database_scoped_configurations
sys.time_zone_info
sys.database_scoped_credentials
sys.masked_columns
sys.internal_partitions
sys.database_credentials
sys.remote_data_archive_tables
sys.remote_data_archive_databases
sys.external_file_formats
sys.external_data_sources
sys.column_encryption_key_values
sys.column_encryption_keys
sys.column_master_keys
sys.periods
sys.memory_optimized_tables_internal_attributes
sys.external_tables
sys.security_predicates
sys.security_policies
sys.column_store_row_groups
sys.selective_xml_index_namespaces
sys.selective_xml_index_paths
sys.query_store_runtime_stats_interval
sys.query_store_runtime_stats
sys.query_store_query_text
sys.query_store_query
sys.query_store_plan
sys.query_context_settings
sys.hash_indexes
sys.column_store_dictionaries
sys.column_store_segments
sys.filetable_system_defined_objects
sys.filetables
sys.sequences
sys.registered_search_properties
sys.registered_search_property_lists
sys.fulltext_stopwords
sys.fulltext_stoplists
sys.fulltext_index_fragments
sys.database_audit_specification_details
sys.database_audit_specifications
sys.conversation_priorities
sys.change_tracking_tables
sys.spatial_index_tessellations
sys.spatial_indexes
sys.function_order_columns
sys.sql_expression_dependencies
sys.table_types
sys.system_sql_modules
sys.system_internals_allocation_units
sys.system_internals_partition_columns
sys.system_internals_partitions
sys.plan_guides
sys.module_assembly_usages
sys.type_assembly_usages
sys.fulltext_index_catalog_usages
sys.service_queue_usages
sys.parameter_type_usages
sys.column_type_usages
sys.message_type_xml_schema_collection_usages
sys.parameter_xml_schema_collection_usages
sys.column_xml_schema_collection_usages
sys.asymmetric_keys
sys.internal_tables
sys.certificates
sys.crypt_properties
sys.key_encryptions
sys.symmetric_keys
sys.xml_schema_collections
sys.transmission_queue
sys.routes
sys.remote_service_bindings
sys.xml_schema_component_placements
sys.xml_schema_wildcard_namespaces
sys.xml_schema_wildcards
sys.xml_schema_attributes
sys.xml_schema_model_groups
sys.xml_schema_elements
sys.xml_schema_facets
sys.xml_schema_types
sys.xml_schema_components
sys.xml_schema_namespaces
sys.extended_properties
sys.database_files
sys.conversation_endpoints
sys.conversation_groups
sys.service_contract_usages
sys.services
sys.service_contract_message_usages
sys.service_contracts
sys.service_message_types
sys.fulltext_catalogs
sys.destination_data_spaces
sys.partition_schemes
sys.filegroups
sys.data_spaces
sys.partition_range_values
sys.partition_parameters
sys.partition_functions
sys.assembly_references
sys.assembly_files
sys.assemblies
sys.database_permissions
sys.database_role_members
sys.database_principals
sys.schemas
sys.assembly_types
sys.types
sys.sql_dependencies
sys.service_queues
sys.synonyms
sys.numbered_procedure_parameters
sys.numbered_procedures
sys.assembly_modules
sys.sql_modules
sys.trigger_events
sys.events
sys.event_notifications
sys.triggers
sys.procedures
sys.foreign_key_columns
sys.foreign_keys
sys.default_constraints
sys.check_constraints
sys.key_constraints
sys.fulltext_index_columns
sys.fulltext_indexes
sys.stats_columns
sys.stats
sys.index_columns
sys.allocation_units
sys.partitions
sys.xml_indexes
sys.indexes
sys.identity_columns
sys.computed_columns
sys.system_parameters
sys.PARAMETERS
sys.system_columns
sys.columns
sys.system_views
sys.system_objects
sys.extended_procedures
sys.views
sys.tables
sys.objects
sys.resource_governor_external_resource_pool_affinity
sys.resource_governor_external_resource_pools
sys.resource_governor_resource_pool_affinity
sys.database_filestream_options
sys.server_audit_specification_details
sys.server_audit_specifications
sys.server_file_audits
sys.server_audits
sys.change_tracking_databases
sys.server_principal_credentials
sys.cryptographic_providers
sys.resource_governor_resource_pools
sys.resource_governor_workload_groups
sys.resource_governor_configuration
sys.server_event_sessions
sys.server_event_session_targets
sys.server_event_session_fields
sys.server_event_session_events
sys.server_event_session_actions
sys.master_key_passwords
sys.database_recovery_status
sys.database_mirroring
sys.credentials
sys.server_assembly_modules
sys.server_sql_modules
sys.server_trigger_events
sys.server_triggers
sys.database_mirroring_endpoints
sys.server_events
sys.server_event_notifications
sys.endpoint_webmethods
sys.service_broker_endpoints
sys.soap_endpoints
sys.via_endpoints
sys.tcp_endpoints
sys.http_endpoints
sys.endpoints
sys.messages
sys.configurations
sys.sql_logins
sys.linked_logins
sys.remote_logins
sys.servers
sys.server_permissions
sys.server_role_members
sys.server_principals
sys.master_files
sys.backup_devices
sys.database_mirroring_witnesses
sys.databases
sys.sysservers
sys.sysremotelogins
sys.sysprocesses
sys.sysperfinfo
sys.sysopentapes
sys.sysoledbusers
sys.sysmessages
sys.syslogins
sys.syslockinfo
sys.sysdevices
sys.sysdatabases
sys.syscursortables
sys.syscursors
sys.syscursorrefs
sys.syscursorcolumns
sys.syscurconfigs
sys.sysconfigures
sys.syscharsets
sys.syslanguages
sys.syscacheobjects
sys.sysaltfiles
sys.sysfiles
sys.sysfilegroups
sys.sysmembers
sys.sysusers
sys.systypes
sys.sysreferences
sys.sysprotects
sys.syspermissions
sys.sysindexkeys
sys.sysindexes
sys.sysfulltextcatalogs
sys.sysconstraints
sys.sysforeignkeys
sys.sysdepends
sys.syscomments
sys.all_sql_modules
sys.syscolumns
sys.sysobjects
sys.all_parameters
sys.all_columns
sys.all_views
sys.all_objects

Hamid J. Fard

I am SQL Server Data Platform Expert with more than 9 years’ of professional experience, I am currently Microsoft Certified Master: SQL Server 2008, Microsoft Certified Solutions Master: Charter-Data Platform, Microsoft Data Platform MVP and CIW Database Design Specialist. I also do Pig, Hive and Sqoop development regarding Hadoop Big Data platform. After a few years of being a production database administrator I jumped into the role of Data Platform Expert. Being a consultant allows me to work directly with customers to help solve questions regarding database issues for SQL Server.

More Posts

Follow Me:
FacebookLinkedIn


Leave a Comment

Be the First to Comment!

Notify of
avatar
1000
wpDiscuz