Memery Usage

Hello
I have an SQL Server 2005 with limited resources therefore I have limited
the max memory usage for SQL Server to 768 Mb however doesnt seem to make any
difference. SQL Server is marrily taking 844,000 Kb of memory which then
becomes an issue due to the lack of memory on that box.
Im using SQL Server 2005 fully patched.
Any ideas as to how to limit SQL Server to the actual 768Mb' (Yes I have
restarted - it doesnt help)
Thanks
Regards
Jonasthe overhead come from the application himself.
so to limit to 768Mb reduce the max memory to around 640mb
"Jonas Larsen" <JonasLarsen@.discussions.microsoft.com> wrote in message
news:D2269A45-7B92-4961-89D3-B067784403BF@.microsoft.com...
> Hello
> I have an SQL Server 2005 with limited resources therefore I have limited
> the max memory usage for SQL Server to 768 Mb however doesnt seem to make
> any
> difference. SQL Server is marrily taking 844,000 Kb of memory which then
> becomes an issue due to the lack of memory on that box.
> Im using SQL Server 2005 fully patched.
> Any ideas as to how to limit SQL Server to the actual 768Mb' (Yes I have
> restarted - it doesnt help)
>
> Thanks
> Regards
> Jonas
>
>|||There is a section of memory formally called the MemToLeave area that by
default can be as high as 386KB that gets allocated right off the top. The
MAX memory setting deals only with the buffer pool which does not include
the MemToLeave memory. So subtract 386 from the value you want to limit it
to and set the Max memory to that. You may find some minor play in those
numbers but that will ensure it doesn't use more than what you want.
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Jonas Larsen" <JonasLarsen@.discussions.microsoft.com> wrote in message
news:D2269A45-7B92-4961-89D3-B067784403BF@.microsoft.com...
> Hello
> I have an SQL Server 2005 with limited resources therefore I have limited
> the max memory usage for SQL Server to 768 Mb however doesnt seem to make
> any
> difference. SQL Server is marrily taking 844,000 Kb of memory which then
> becomes an issue due to the lack of memory on that box.
> Im using SQL Server 2005 fully patched.
> Any ideas as to how to limit SQL Server to the actual 768Mb' (Yes I have
> restarted - it doesnt help)
>
> Thanks
> Regards
> Jonas
>
>|||> default can be as high as 386KB that gets allocated right off the top. The
You meant MB instead of KB?
Linchi
"Andrew J. Kelly" wrote:
> There is a section of memory formally called the MemToLeave area that by
> default can be as high as 386KB that gets allocated right off the top. The
> MAX memory setting deals only with the buffer pool which does not include
> the MemToLeave memory. So subtract 386 from the value you want to limit it
> to and set the Max memory to that. You may find some minor play in those
> numbers but that will ensure it doesn't use more than what you want.
> --
> Andrew J. Kelly SQL MVP
> Solid Quality Mentors
>
> "Jonas Larsen" <JonasLarsen@.discussions.microsoft.com> wrote in message
> news:D2269A45-7B92-4961-89D3-B067784403BF@.microsoft.com...
> > Hello
> >
> > I have an SQL Server 2005 with limited resources therefore I have limited
> > the max memory usage for SQL Server to 768 Mb however doesnt seem to make
> > any
> > difference. SQL Server is marrily taking 844,000 Kb of memory which then
> > becomes an issue due to the lack of memory on that box.
> >
> > Im using SQL Server 2005 fully patched.
> >
> > Any ideas as to how to limit SQL Server to the actual 768Mb' (Yes I have
> > restarted - it doesnt help)
> >
> >
> > Thanks
> >
> > Regards
> > Jonas
> >
> >
> >
>|||Yes for sure. Thanks Linchi.
--
Andrew J. Kelly SQL MVP
Solid Quality Mentors
"Linchi Shea" <LinchiShea@.discussions.microsoft.com> wrote in message
news:DD4CDC0C-FC08-4507-9FBD-3A97024E70F4@.microsoft.com...
>> default can be as high as 386KB that gets allocated right off the top.
>> The
> You meant MB instead of KB?
> Linchi
> "Andrew J. Kelly" wrote:
>> There is a section of memory formally called the MemToLeave area that by
>> default can be as high as 386KB that gets allocated right off the top.
>> The
>> MAX memory setting deals only with the buffer pool which does not include
>> the MemToLeave memory. So subtract 386 from the value you want to limit
>> it
>> to and set the Max memory to that. You may find some minor play in those
>> numbers but that will ensure it doesn't use more than what you want.
>> --
>> Andrew J. Kelly SQL MVP
>> Solid Quality Mentors
>>
>> "Jonas Larsen" <JonasLarsen@.discussions.microsoft.com> wrote in message
>> news:D2269A45-7B92-4961-89D3-B067784403BF@.microsoft.com...
>> > Hello
>> >
>> > I have an SQL Server 2005 with limited resources therefore I have
>> > limited
>> > the max memory usage for SQL Server to 768 Mb however doesnt seem to
>> > make
>> > any
>> > difference. SQL Server is marrily taking 844,000 Kb of memory which
>> > then
>> > becomes an issue due to the lack of memory on that box.
>> >
>> > Im using SQL Server 2005 fully patched.
>> >
>> > Any ideas as to how to limit SQL Server to the actual 768Mb' (Yes I
>> > have
>> > restarted - it doesnt help)
>> >
>> >
>> > Thanks
>> >
>> > Regards
>> > Jonas
>> >
>> >
>> >
>>