<div>
Maybe this script is what your are after:<br />
<a href="http://www.sqlservercentral.com/Forums/Topic611107-146-2.aspx#bm1445806" rel="ugc">http://www.sqlservercentral.com/Forums/Topic611107-146-2.aspx#bm1445806</a><br />
<br />
or<br />
<br />
<a href="http://www.sql-server-performance.com/forum/threads/get-cpu-memory-usage-from-a-sql-query.16334/" rel="ugc">http://www.sql-server-performance.com/forum/threads/get-cpu-memory-usage-from-a-sql-query.16334/</a>
</div>


Maybe this script is what your are after:
http://www.sqlservercentral.com/Forums/Topic611107-146-2.aspx#bm1445806 [http://www.sqlservercentral.com/Forums/Topic611107-146-2.aspx#bm1445806]

or

http://www.sql-server-performance.com/forum/threads/get-cpu-memory-usage-from-a-sql-query.16334/ [http://www.sql-server-performance.com/forum/threads/get-cpu-memory-usage-from-a-sql-query.16334/]

<div>
the above is for performance, right? I just want query to bring back how GB RAM and how many core CPUs etc.. basic hardware details of the server.?
</div>


the above is for performance, right? I just want query to bring back how GB RAM and how many core CPUs etc.. basic hardware details of the server.?

<div>
<div class="content wysiwyg-content">
is there a sql command to see the cpu/memory instantly from a ssms window? (of the sql server on which the instance is hosted)
</div>
</div>


is there a sql command to see the cpu/memory instantly from a ssms window? (of the sql server on which the instance is hosted)

see cpu/mem from sql command?

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.

Microsoft SQL Server 2005

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.