SQL Server Discovery

Better, faster, cheaper ...pick two.
posts - 14, comments - 80, trackbacks - 0

Wednesday, February 11, 2009

Find System information using SQL Server

If you don't have local login rights on a Server and need to find system resources onboard. Here is a little TSQL script that will display useful information like CPU, memory and pagefile size:


USE [master]; GO SELECT      cpu_count ,   hyperthread_ratio ,   physical_memory_in_bytes / 1048576 AS 'mem_MB' , virtual_memory_in_bytes / 1048576 AS 'virtual_mem_MB' ,   max_workers_count ,   os_error_mode ,   os_priority_class FROM     sys.dm_os_sys_info


Hope it helps!

posted @ Wednesday, February 11, 2009 6:31 PM | Feedback (4) |

Powered by:
Powered By Subtext Powered By ASP.NET