Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

see cpu/mem from sql command?

Posted on 2013-05-17
4
381 Views
Last Modified: 2013-05-17
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)
0
Comment
Question by:25112
  • 2
  • 2
4 Comments
 
LVL 7

Expert Comment

by:Ross Turner
ID: 39174673
0
 
LVL 5

Author Comment

by:25112
ID: 39175543
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.?
0
 
LVL 7

Accepted Solution

by:
Ross Turner earned 500 total points
ID: 39175556
0
 
LVL 5

Author Comment

by:25112
ID: 39175684
very good- thanks!
0

Featured Post

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
Two types of users will appreciate AOMEI Backupper Pro: 1 - Those with PCIe drives (and haven't found cloning software that works on them). 2 - Those who want a fast clone of their boot drive (no re-boots needed) and it can clone your drive wh…

808 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question