April 15, 2004 at 3:19 am
The PHYSICAL MEMORY that the server machine has is 1572288 k but after few hours the available memory only left 1000 to 9960. There is no any task appear in the Application tab in the Task Manager. The application that using the most memory was the SQL SERVER. My question is how am I trace that the SQL SERVER affecting the memory in the machine and how am I going to settle it. Thanks for the advance.
lss
April 15, 2004 at 9:19 am
How much memory is on the machine? What else is running?
On a 4GB server, I expect SQL to run steady at 1.7GB. On a 2GB machine, I think it's usually 1.4GB or so. If you need to limit this, and you don't necessarily do need to, in Enterprise Manager, right click the server, Properties, select the Memory tab and set the max amount. And the min if you need to as well.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply