I recently moved a large database to a new brand server with 8GB of
ram.
I didn't notice in the taskmanager it shows, like SQL Server is using
just 2.8GB ... always.
Anytime of the day I see, it says 2.8GB of ram.
Do I need an special parameter or something to tell SQL Server take up
all the rest of the RAM available ? The server is for SQL Server alone.
see
http://www.sql-server-performance.com/awe_memory.asp
"craigkenisston@.hotmail.com" wrote:
> I recently moved a large database to a new brand server with 8GB of
> ram.
> I didn't notice in the taskmanager it shows, like SQL Server is using
> just 2.8GB ... always.
> Anytime of the day I see, it says 2.8GB of ram.
> Do I need an special parameter or something to tell SQL Server take up
> all the rest of the RAM available ? The server is for SQL Server alone.
>
Showing posts with label usingjust. Show all posts
Showing posts with label usingjust. Show all posts
Monday, March 19, 2012
Monday, March 12, 2012
Is SQL Server using all my RAM ?
I recently moved a large database to a new brand server with 8GB of
ram.
I didn't notice in the taskmanager it shows, like SQL Server is using
just 2.8GB ... always.
Anytime of the day I see, it says 2.8GB of ram.
Do I need an special parameter or something to tell SQL Server take up
all the rest of the RAM available ? The server is for SQL Server alone.see
http://www.sql-server-performance.com/awe_memory.asp
"craigkenisston@.hotmail.com" wrote:
> I recently moved a large database to a new brand server with 8GB of
> ram.
> I didn't notice in the taskmanager it shows, like SQL Server is using
> just 2.8GB ... always.
> Anytime of the day I see, it says 2.8GB of ram.
> Do I need an special parameter or something to tell SQL Server take up
> all the rest of the RAM available ? The server is for SQL Server alone.
>
ram.
I didn't notice in the taskmanager it shows, like SQL Server is using
just 2.8GB ... always.
Anytime of the day I see, it says 2.8GB of ram.
Do I need an special parameter or something to tell SQL Server take up
all the rest of the RAM available ? The server is for SQL Server alone.see
http://www.sql-server-performance.com/awe_memory.asp
"craigkenisston@.hotmail.com" wrote:
> I recently moved a large database to a new brand server with 8GB of
> ram.
> I didn't notice in the taskmanager it shows, like SQL Server is using
> just 2.8GB ... always.
> Anytime of the day I see, it says 2.8GB of ram.
> Do I need an special parameter or something to tell SQL Server take up
> all the rest of the RAM available ? The server is for SQL Server alone.
>
Subscribe to:
Posts (Atom)