running mssql server 2000. experiencing extremely high mem usage - 420 000 k. Can anyone help me determine what on earth is happening? Urgent.
Appreciate any help.
tq.420MB of RAM used is no where near of being "too high". What's the total physical memory? If you have memory shortage you should set the max for SQL service (in fact you should always set the max value)|||Most of my machines run well over 2 Gb for SQL Server... 420 Mb would be heavy on a workstation (Personal Edition), but wouldn't be enough to start most of our servers.
-PatP|||420MB would be heavy on a workstation? What does it have to do with a workstation? Are you running prod environment off of it? Personal edition is for development and for occasional "select * from authors" when arguing with dbForums' bunch trying to prove the point ;)|||this is an prod environment. machine total physical memory is 523760. sqlserver.exe is using 375 000 to 420 000 k. It has been running for a year with no problems. until now...what would be the optimal value to set the max for sql?|||First, add MORE memory, at least 512MB more. With 1GB of physical memory you can set the minimum for SQL at 800MB. Since it started consuming more memory it's an indicator that some optimization needs to be performed since your volume of data increased.
No comments:
Post a Comment