SQL Server Discovery

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

February 2009 Blog Posts

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