Solved

What is the T-SQL command to list SQL 2012 Instance with CPU, Memory and Diskspace

Posted on 2014-11-04
5
117 Views
Last Modified: 2015-01-11
Hello there,

What is the t-sql command to list SQL instance with CPU,Memory and Diskspace details.

Please advise.

Thanks and Regards
0
Comment
Question by:goprasad
  • 5
5 Comments
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
Comment Utility
Sql commands are run within an instance, so it cannot list any other instances.
These data are rather system informations... either get some serious monitoring tool, or investigate iin poweshell...
0
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
Comment Utility
Sql commands are run within an instance, so it cannot list any other instances.
These data are rather system informations... either get some serious monitoring tool, or investigate iin poweshell...
0
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
Comment Utility
Sql commands are run within an instance, so it cannot list any other instances.
These data are rather system informations... either get some serious monitoring tool, or investigate iin poweshell...
0
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
Comment Utility
Sql commands are run within an instance, so it cannot list any other instances.
These data are rather system informations... either get some serious monitoring tool, or investigate iin poweshell...
0
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
Comment Utility
Sql commands are run within an instance, so it cannot list any other instances.
These data are rather system informations... either get some serious monitoring tool, or investigate iin poweshell...
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

763 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now