Solved

SQL running with 4 GB?

Posted on 2011-02-11
7
336 Views
Last Modified: 2012-05-11
Just wondering what the issues will be when running SQL 2005 Standard and one database for solarwins exclusively which requires 3GB.

The OS is 2003 64bit with 4-6GB.

I heard SQL can eat up all the memory on the system. Any tunning involved?
0
Comment
Question by:snyderkv
7 Comments
 
LVL 23

Assisted Solution

by:jakethecatuk
jakethecatuk earned 250 total points
ID: 34870107
SQL will use whatever memory is available from the OS.

It's rare for an application to specify how much memory it will need on the database server.  Do you have any documentation frmo Solarwinds about this.
0
 
LVL 13

Expert Comment

by:geek_vj
ID: 34870128
>>I heard SQL can eat up all the memory on the system. Any tunning involved?
This is a wrong perception about SQL Server. When OS is running, no application can take all the memory from OS. However, there is every chance that SQL Server can become a bottleneck for system. As such, you need to ensure that you set the maximum server memory accordingly.

Ideally, you need to leave 2 GB exclusively for OS for smooth running (When total memory is 4-6 GB). In addition to OS, if you have any antivirus/apps running on the server, then they may need additional allocation of memory.
0
 

Author Comment

by:snyderkv
ID: 34870160
Ok thanks, how do I leave 2GB exclusively for the OS without SQL jacking it?

I'm not sure what this article is saying but the HowTo docs just confused me more.

http://support.microsoft.com/kb/321363
Contents:
When you start SQL Server, SQL Server memory usage may continue to steadily increase and not decrease, even when activity on the server is low. Additionally, the Task Manager and Performance Monitor may show that the physical memory available on the computer is steadily decreasing until the available memory is between 4 to 10 MB.

This behavior alone does not indicate a memory leak. This behavior is normal and is an intended behavior of the SQL Server buffer pool.

By default, SQL Server dynamically grows and shrinks the size of its buffer pool (cache) depending on the physical memory load reported by the operating system. As long as enough memory is available to prevent paging (between 4 - 10 MB), the SQL Server buffer pool will continue to grow. As other processes on the same computer as SQL Server allocate memory, the SQL Server buffer manager will release memory as needed. SQL Server can free and acquire several megabytes of memory each second, allowing it to quickly adjust to memory allocation changes.
0
Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

 
LVL 13

Accepted Solution

by:
geek_vj earned 250 total points
ID: 34870177
>>how do I leave 2GB exclusively for the OS without SQL jacking it?
The best way is to keep a memory limit for SQL Server. You can do it by going to Management Studio --> Right click on the server --> Properties --> Memory --> Set the maximum memory for SQL Server on the right side.

For example, if your total memory is 4 GB, then keep the maximum limit for SQL Server as 2 GB so that 2 GB will be left for OS. Hope this helps!
0
 

Author Comment

by:snyderkv
ID: 34870186
Thanks men
0
 
LVL 12

Expert Comment

by:NormanMaina
ID: 34870305
The vendor probably was talking about the requirement for SQL Server as a whole not their database in particular.
4GB will run fine expecially on 64 bit OS.
To further improve server performance you can:
Optimize on read/Write performance
-set up RAID1 with two disks and have the OS and sql server log files run from here.
-Set up RAID 3 with at least 3 disks and put the SQL Server database files in here and any other important data.

0
 

Author Comment

by:snyderkv
ID: 34870840
Cool thanks again
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
In this video I am going to show you how to back up and restore Office 365 mailboxes using CodeTwo Backup for Office 365. Learn more about the tool used in this video here: http://www.codetwo.com/backup-for-office-365/ (http://www.codetwo.com/ba…

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now