sql System Information

Select
	@@version As [version],
	SERVERPROPERTY('productversion') As product_version,
	SERVERPROPERTY ('productlevel') As product_level,
	SERVERPROPERTY ('edition') As edition,
	cpu_count,
	hyperthread_ratio,
	(physical_memory_in_bytes/1024)/1024 As [physical_memory_mb],
	(virtual_memory_in_bytes/1024)/1024/1024 As [virtual_memory_mb],
	(SELECT SUM(awe_allocated_kb) / 1024 as [AWE allocated, Mb] FROM sys.dm_os_memory_clerks) As awe_allocated_memory_mb,
	sqlserver_start_time,
	DATEDIFF(dd, sqlserver_start_time, GETDATE()) As uptime_days
From sys.dm_os_sys_info
Grabs a set of useful system information about the SQL Server

Updated: Tuesday 14th June 2011, 10:16pm

There are 0 comments

Leave a comment of your own

Comments are currently closed.