Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
elektrobank
Starting Member
15 Posts |
 Posted - 2003-07-04 : 02:15:05
|
| Is there a query that I can run to get information about the machine that SQL Server is using such as how much memory the machine has, how much memory is free, how much CPU is used. I found xp_availablemedia gives me the available disk space but could not find anything that will give me the others.I was looking into using xp_cmdshell but couldn't find any DOS commands that would give me this information either. Any suggestions? |
|
|
byrmol
Shed Building SQL Farmer
1591 Posts |
Posted - 2003-07-04 : 02:17:48
|
exec master..xp_msver DavidM"SQL-3 is an abomination.." |
 |
|
|
elektrobank
Starting Member
15 Posts |
Posted - 2003-07-04 : 03:36:28
|
| This gives me the amount of physical memory in the computer, but is there anyway I can get the amount of free memory also?Thanks! |
|
|
|
|
|
|
Getting available memory