Re: Setting Max Server Memory in 64 bit machine
- From: plevexier <plevexier@xxxxxxxxxxxx>
- Date: Sun, 23 Dec 2007 16:24:56 -0800 (PST)
On Dec 21, 12:10 pm, Carlos <carlosara...@xxxxxxxxxxxxx> wrote:
I am runningSQL2005 Standard under Windows 2003 Standard with 8 GB of RAM
in one of our 64 bit servers; I noticed minservermemorywas set for some
reason to 128 MB and maxservermemoryto 6114 MB by the previous DBA. We
plan to upgrade it to 32 GB. What is the best approach when changing those
values ? Should I change those values to the defaults (0 - 2147483647) or
create min and max boundaries? . This box is only utilzed bySQL.
Also I know that those changes are reconfigured dynamically so no need to
reboot, but would this place any performance hit in theserverand should I
useManagementstudio or sp_configure ? (for some reason I don't trustManagementstudio for these type of changes :))
Thanks,
Carlos
Check that URL for detailed explanation:
http://www.sqldruid.com/Articles/MemoryManagementinSQLServer2005/tabid/56/Default.aspx
Patrice
.
- Prev by Date: Re: cannot acees two databases as owner
- Next by Date: Re: Problem with install of MS SQL 2005 Standard on two node clust
- Previous by thread: Re: Setting Max Server Memory in 64 bit machine
- Next by thread: cannot acees two databases as owner
- Index(es):
Relevant Pages
|
