Neste artigo Slavao discute e demonstra como utilizar as DMVs do SQL Server 2005 para responder perguntas como:
Q. How many sockets does my machine have?
Q. Is my machine hyper threaded?
Q. Does my 32 bit system have /3GB or /Userva switch in boot.ini?
Q. How much physical memory my machine has?
Q. How many threads/workers SQL Server would use if the default value in sp_configure for max worker threads is zero?
Q. What is a size of AWE window or what is the max amount of memory right now that can be used by QO, QE and Caches simultaneously when SQL Server running in AWE mode?
O interessante é que todas estas perguntas são respondidas realizando SELECT em uma única DMV, a sys.dm_os_sys_info.
Para saber mais veja o artigo no link http://blogs.msdn.com/slavao/archive/2006/08/22/713357.aspx
Abraços,
Rodrigo Fernandes