This will return the Total Physical Memory:
<cffunction name="getTotalPhysicalMemory" output="No" returntype="any" description="Total Physical Memory">
<cfset var getTotalPhysicalMemory = "">
<cfquery name="getTotalPhysicalMemory" datasource="yourdsn" username="youruserName" password="yourpasswd">
use master
select physical_memory_in_bytes/(1024.0*1024.0*1024.0) as physical_mem_in_gb
from sys.dm_os_sys_info
</cfquery>
<cfreturn getTotalPhysicalMemory>
</cffunction>
And this one will return the Number of Processors:
<cffunction name="getTotalNumberOfProcessors" output="No" returntype="any" description="Total number of processors">
<cfset var getTotalNumberOfProcessors = "">
<cfquery name="getTotalNumberOfProcessors" datasource="yourdsn" username="youruserName" password="yourpasswd">
use master
select cpu_count from sys.dm_os_sys_info
</cfquery>
<cfreturn getTotalNumberOfProcessors>
</cffunction>
Cya soon...