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 |
|
vicki
Posting Yak Master
117 Posts |
 Posted - 2002-02-25 : 15:38:43
|
| Hi there,How do find out the total amount of memory available for each server? Actually I want to execute the query to return these information for me so I can created the application page to display these information .For example: My comapny have 10 servers and I want to find out the memory available for each serverThanks |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-02-25 : 16:02:18
|
| Do you mean the amount of physical memory on the machine, or the amount of memory being consumed by SQL Server?-Chad |
 |
|
|
vicki
Posting Yak Master
117 Posts |
Posted - 2002-02-25 : 16:11:12
|
| how about both?Thanks |
|
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2002-02-25 : 16:55:46
|
| I don't know of any way to get either one through SQL Server. There may be some extended stored procedures to get physical memory, but SQL memory would have to be obtained through Perfmon AFAIK.You can run Winmsd for system info, but this isn't a SQL utility.This stuff should be done outside of SQL. Create a COM object, or .Net assembly to retrieve the info for you.-Chad |
|
|
|
|
|
|
Server Memmory