I want to use 10 GB Max for sql server.

Question

Post reply

I want to use 10 GB Max for sql server.

forsqlserver

SSCoach

Points: 18902
More actions
November 22, 2011 at 11:26 pm

#250997

I have 16 CPU and 16 Gb RAM in sqlserver.
In max memory it is showing 2147483647 value.
I want to use 10 GB Max for sql server.
What value I should write there?
Thanks

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply

Sgar... SSCarpal Tunnel Points: 4409 More actions · Answer 1

10240 as it is in MB.

AWE enabled???

Sagar Sonawane
** Every DBA has his day!!:cool:

forsqlserver SSCoach Points: 18902 More actions · Answer 2

Thats the confusion why Microsoft has written this long value??

Awe is not enabled it is 64 bit.

Thanks

Sgar... SSCarpal Tunnel Points: 4409 More actions · Answer 3

http://msdn.microsoft.com/en-us/library/ms190673.aspx

will answer your Question...

Sagar Sonawane
** Every DBA has his day!!:cool:

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 4

Saga... (11/22/2011)
http://msdn.microsoft.com/en-us/library/ms190673.aspx
will answer your Question...

Note: This feature (Enabling AWE Memory for SQL Server)will be removed in the next version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible.

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 5

Did you try this?

sp_configure 'show advanced options', 1;

GO

RECONFIGURE;

GO

sp_configure 'max server memory', N; -- Change N to suite your needs

GO

RECONFIGURE;

GO

Server Memory Options

http://msdn.microsoft.com/en-us/library/ms178067.aspx

forsqlserver SSCoach Points: 18902 More actions · Answer 6

My question is this.

why Microsoft has written this long value

Thanks

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 7

forsqlserver (11/22/2011)
My question is this.
why Microsoft has written this long value

the default setting for max server memory is 2147483647 megabytes (MB). The minimum amount of memory you can specify for max server memory is 16 MB.

Sgar... SSCarpal Tunnel Points: 4409 More actions · Answer 8

It is the maximum server memory supported by SQL Server. You can calculate!!

Sagar Sonawane
** Every DBA has his day!!:cool:

forsqlserver SSCoach Points: 18902 More actions · Answer 9

Should I enable awe also??

It is a 64 bit server.

Thanks

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 10

forsqlserver (11/23/2011)
Should I enable awe also??
It is a 64 bit server.

Nope.

forsqlserver SSCoach Points: 18902 More actions · Answer 11

I want to do the load testing for this 10 gb MEMORY.

How can I do this..

Have u some code..

Thanks

Devendrakumar SSC-Forever Points: 42493 More actions · Answer 12

forsqlserver (11/23/2011)
I want to do the load testing for this 10 gb MEMORY.
How can I do this..
Have u some code..

There are 3rd party tools available for load testing. BTW... Load testing for how many users / connections?