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 |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2008-06-30 : 11:02:30
|
| In the sql server 2005 server property - (memory), this is the figure for Maximum server memory (in MB)2147483647using sql I am trying to pull this number.The query I am using is: select * from master..sysperfinfowhere object_name like '%memory%'I do not see the above figure in the returned fields from the above query.What is the counter_name in the returned fields which represents this memory setting please?Thanks |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2008-06-30 : 17:43:46
|
| try this:sp_configure 'max server memory'GreetingsWebfredThere are 10 types of people in the world: Those who understand binary, and those who don't... |
 |
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2008-07-01 : 03:55:41
|
| When I run your suggestion, it gives this error:The configuration option 'max server memory' does not exist, or it may be an advanced option.Any thoughts please? |
|
|
|
willfindavid
Starting Member
27 Posts |
Posted - 2008-07-01 : 05:00:58
|
| Use the commands below:EXEC sp_configure 'show advanced option', '1'reconfigurethen run the commandsp_configure 'max server memory'It will display the server memory |
|
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2008-07-01 : 06:19:15
|
| Is it possible to use this sql to set the memory to 80% of physical memory?Thanks |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-04 : 01:04:11
|
| You can set to specific number only. |
|
|
|
|
|
|
memory settings