May 18, 2012 at 3:36 am
Hi..... Guys,
Is sql server using 25% RAM of total memory available?
for eg: if 10 GB of total RAm is der then SQL Server going to use 2.5 GB of memory i.e 25%
Is this correct or not ? reply
thnx.............
May 18, 2012 at 4:01 am
How much memory SQl server will be using depends only on your configuration of Min and Max Server memory configuration parameter. By default it will use as much memory as is there is available.
http://msdn.microsoft.com/en-us/library/ms180797(v=sql.105).aspx
GulliMeel
Finding top n Worst Performing queries[/url]
Improve the performance of Merge Join(special case)
How to Post Performance Problem -Gail Shaw[/url]
May 18, 2012 at 4:49 am
Saggy (5/18/2012)
Hi..... Guys,Is sql server using 25% RAM of total memory available?
for eg: if 10 GB of total RAm is der then SQL Server going to use 2.5 GB of memory i.e 25%
Is this correct or not ? reply
thnx.............
You need to provide some infomration to get the correct answer:
1. What operating system you are using & is it 32 bit or 64 bit?
2. Have you set the min memory & max memory settings for SQL Server?
May 18, 2012 at 5:44 am
If it is SQL 2005/8 on Server 2003 x86 with 4 gb of ram, use the following
Min server memory at 1gb
max server memory at 3gb
This assumes one instance of sql server is running on the server and is not sharing with applications.
x64 means you probably have at least 8gb of memory on the machine with server 2008.
So, always leave 4gb for server 2008,
For example, say you have 12gb,
1. set max to be 12gb-4gb(OS) = 8gb
2. set min to be 1/2 of max, so 4gb
If you have loads of databases with users connecting to them, use resource governor and create several resource pools for high utilizaiton databases. Paul Randal has a good video on this.
http://technet.microsoft.com/en-us/sqlserver/gg508905.aspx
He shows how throddling is accomplished by sql server if you specify custom resource pools. Just look at video, I'll let him do the talking.
May 18, 2012 at 5:50 am
SQL Server 2008 R2 express edition
OS: Windows SBS Server 2011 and 64 bit edition.
thnx..........
May 18, 2012 at 6:18 am
Saggy (5/18/2012)
SQL Server 2008 R2 express editionOS: Windows SBS Server 2011 and 64 bit edition.
thnx..........
Okay, as you said you have 64 bit OS I assume you have installed 64 bit SQL Server too. In that case, if you see SQL Server memory usage as 25% then yes it is using 2.5 GB memory.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply