G-Productions | dm_os_sys_info


	Home Microsoft SQL Server DigiMailing iRN Contact	Keyword

Views

DMV

Functions

sys.dm_os_sys_info


	This is a view in the mssqlsystemresource database. Returns a miscellaneous set of useful information about the computer, such as the hyperthread ratio, the max worker count, and other resources used by and available to SQL Server.

Syntax


CREATE VIEW sys.dm_os_sys_info AS SELECT * FROM OpenRowset(TABLE SYSINFO)

Last revision 2008RTM

See also


	sp_sysutility_mi_get_dac_execution_statistics_internal (Procedure)

News


	Query a named instance Sybase+ASE+silent+install SQL 2008 R2 Deprecated procedures in SQL2008 Reporting Services item-level role definitions Create all your missing indexes Converting datetime field Start MSSQL Server Profiler at time Replicating MSSQL Server views Exploring Microsoft Sharepoint The OLE DB provider "SQLNCLI10" for linked server indicates. Mobile solar charger Oracle to SQL Server replication Cannot insert the value NULL into column Undocumented Microsoft SQL Server 2008 VMware Zoekmachine optimalisatie SQL Servers hidden objects FckEditor Flash in Ajax De hype die AJAX heet Barcode scannen MySQL; Gratis, makkelijk en snel! PHP sIFR; de combinatie tussen HTML en Flash