Advertisement

10.09.2006 at 02:34AM PDT, ID: 22017459
[x]
Attachment Details
[x]
The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

  • The Grade of the Solution
  • The Zone Rank of the Expert Providing the Solution
  • The Number of Author and Expert Comments
  • The Number of Experts Contributing
  • The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

sqlservr.exe eats memory

Tags: memory
Hi!

sqlservr.exe is eating my SBS servers memory.
The server has been up in five days and already takes 1,6GB of RAM. This can't be normal? A search in EE results in nearly nothing.


We've upgraded from 2gb to 4gb memory last week because the server is consuming just around 2gb of RAM after a few days uptime and ahead. From the taskmanager there appears like a standard RAM consuming, many applications taking up some amount of RAM where store.exe and sqlservr.exe has the main peaks with about 500mb each. The decision was easy, we've bought more memory. Our only use of SQL SERVER (so far) is the built-in used by SBS (Sharepoint for example). Is appear for me like that SQL server now sense that are more available psysical RAM and takes that RAM for itself.

The questions are:
1. Can I do something to reduce the memory of SQLSERVR.EXE?
2. What and how?
Start your free trial to view this solution
Question Stats
Zone: OS
Question Asked By: dingir
Solution Provided By: redseatechnologies
Participating Experts: 2
Solution Grade: A
Views: 296
Translate:
Loading Advertisement...
10.09.2006 at 02:51AM PDT, ID: 17689546

Rank: Guru

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
10.09.2006 at 04:28AM PDT, ID: 17689899

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
10.09.2006 at 04:51AM PDT, ID: 17690005

Rank: Guru

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
10.09.2006 at 05:30AM PDT, ID: 17690169

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
10.09.2006 at 05:09PM PDT, ID: 17694787

Rank: Genius

All comments and solutions are available to Premium Service Members only.

Start your 7 day free trial and see for yourself why Experts Exchange is the easiest and most proven technology resource in the world. Get Started

Already a member? Login to view this solution.

 
 
Loading Advertisement...
Microsoft
  • Internet Protocols
  • Applications
  • Development
  • OS
  • Hardware
  • Windows Security
Apple
  • Operating Systems
  • Hardware
  • Programming
  • Networking
  • Software
Internet
  • Search Engines
  • File Sharing
  • WebTrends / Stats
  • Spy / Ad Blockers
  • Web Browsers
  • New Net Users
  • Web Development
  • Chat / IM
  • Anti Spam
  • Web Servers
  • Anti-Virus
  • Email Clients
Gamers
  • Tips
  • Online / MMORPG
  • Puzzle
  • Emulators
  • Action / Adventure
  • Role Playing
  • Consoles
  • Game Programming
  • Strategy
  • Sports
  • Misc
  • Computer Games
Digital Living
  • Hardware
  • New Net Users
  • New Users
  • Software
  • Digital Music
  • Gaming World
  • Home Security
  • Apple
  • Networking Hardware
Virus & Spyware
  • Vulnerabilities
  • IDS
  • Encryption
  • Anti-Virus
  • Operating Systems Security
  • Software Firewalls
  • WebApplications
  • Cell Phones
  • Operating Systems
  • Internet
  • Hardware Firewalls
Hardware
  • Handhelds / PDAs
  • Displays / Monitors
  • Components
  • Networking Hardware
  • Peripherals
  • Laptops/Notebooks
  • Storage
  • Servers
  • Desktops
  • New Users
  • Misc
  • Apple
Software
  • System Utilities
  • Industry Specific
  • Network Management
  • Photos / Graphics
  • Page Layout
  • VMWare
  • Misc
  • Web Development
  • OS
  • CYGWIN
  • Voice Recognition
  • Message Queue
  • Quality Assurance
  • Security
  • Firewalls
  • MultiMedia Applications
  • Development
  • Database
  • Office / Productivity
  • Business Management
  • OS/2 Apps
  • Server Software
  • Internet / Email
ITPro
  • OS
  • Storage
  • Encryption
  • Operating Systems Security
  • Apple Hardware
  • Laptops & Notebooks
  • Servers
  • Networking Hardware
  • Peripherals
  • Devices
  • Displays / Monitors
  • WebTrends / Stats
  • Search Engines
  • Firewalls
  • WebApplications
  • IDS
  • Vulnerabilities
  • Email Clients
  • File Sharing
  • Spy / Ad Blockers
  • Web Browsers
  • Web Servers
  • Networking
  • Anti-Virus
  • Chat / IM
  • Anti Spam
Developer
  • Web Servers
  • Web Browsers
  • Game Programming
  • Dev Tools
  • Industry Specific
  • Office / Productivity
  • Database
  • CYGWIN
  • Web Development
  • Search Engines
  • File Sharing
  • WebTrends / Stats
  • Programming
  • Content Management
  • Application Servers
  • Protocols
Storage
  • Removable Backup Media
  • Storage Technology
  • Servers
  • Grid
  • Remote Access
  • Backup / Restore
  • Misc
  • Hard Drives
OS
  • Miscellaneous
  • Security
  • Development
  • Linux
  • VMWare
  • MainFrame OS
  • Unix
  • Apple
  • OS / 2
  • AS / 400
  • BeOS
  • Microsoft
  • VMS / OpenVMS
Database
  • Oracle
  • Miscellaneous
  • MySQL
  • Software
  • Sybase
  • Contact Management
  • PostgreSQL
  • Data Manipulation
  • Clarion
  • InterSystems Cache
  • Siebel
  • MUMPS
  • OLAP
  • SQLBase
  • SAS
  • GIS & GPS
  • 4GL
  • Berkeley DB
  • DB2
  • Informix
  • Interbase / Firebird
  • FoxPro
  • Reporting
  • LDAP
  • Filemaker Pro
  • MS SQL Server
  • dBase
  • MS Access
Security
  • Misc
  • Web Browsers
  • Software Firewalls
  • Operating Systems Security
  • File Sharing
  • Spy / Ad Blockers
  • Vulnerabilities
  • WebApplications
  • IDS
  • Anti-Virus
  • Encryption
  • Anti Spam
  • Email Clients
  • VPN
  • Chat / IM
Programming
  • Editors IDEs
  • Installation
  • Handhelds / PDAs
  • Multimedia Programming
  • System / Kernel
  • Algorithms
  • Game
  • Signal Processing
  • Project Management
  • Open Source
  • Database
  • Misc
  • Languages
  • Processor Platforms
  • Theory
Web Development
  • Scripting
  • Blogs
  • Web Servers
  • Software
  • Search Engines
  • Web Graphics
  • Images
  • Internet Marketing
  • Images and Photos
  • Components
  • Document Imaging
  • Web Languages/Standards
  • Illustration
  • WebApplications
  • Fonts
  • WebTrends / Stats
  • Authoring
  • Digital Camera Software
  • Miscellaneous
Networking
  • Protocols
  • Apple Networking
  • Network Management
  • Message Queue
  • Application Servers
  • Content Management
  • File Servers
  • Email Servers
  • Misc
  • Java Editors & IDEs
  • Wireless
  • Networking Hardware
  • Backup / Restore
  • System Utilities
  • ISPs & Hosting
  • Web Servers
  • Storage Technology
  • Removable Backup Media
  • Servers
  • Broadband
  • Grid
  • OS / 2
  • Novell Netware
  • Unix Networking
  • Windows Networking
  • Security
  • Telecommunications
  • Operating Systems
  • Linux Networking
Other
  • Community Advisor
  • Lounge
  • Community Support
  • New Net Users
  • Philosophy / Religion
  • Math / Science
  • Miscellaneous
  • URLs
  • Expert Lounge
  • Politics
  • Puzzles / Riddles
Community Support
  • Suggestions
  • New to EE
  • New Topics
  • Community Advisor
  • CleanUp
  • Announcements
  • General
  • Feedback
  • Input
  • EE Bugs
 
10.09.2006 at 02:51AM PDT, ID: 17689546

Rank: Guru

Hi dingir,

SQL, much like Exchange, eats memory - that is what it does.  What good is memory to you if it isnt being used?

I have experienced this myself with a tiny PHPBB2 forum - few users, few posts, massive memory usage.

This is also the exact reason why you do not put exchange and SQL on the same server (a downside of SBS, but not the end of the world)

This forum is the only decent link I could find (in 3 google pages) but it is generally accepted that SQL, like Exchange, is a memory pig.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=339023&SiteID=1

It should level out - if it doesn't, then you either have a memory leak in your database, or you are misconfigured.

Run this - for exchange, but will at least rule that out -> http://www.microsoft.com/downloads/details.aspx?familyid=dbab201f-4bee-4943-ac22-e2ddbd258df3

Run this - for SQL -> http://www.microsoft.com/downloads/details.aspx?FamilyID=B352EB1F-D3CA-44EE-893E-9E07339C1F22&displaylang=en

Hope that helps,

-red
 
10.09.2006 at 04:28AM PDT, ID: 17689899
Hi red!

Thank's for answer :). 500-600mb memory is hughe for a application to run, but thats ok for me!
After all we got 4gb memory for applications.

The really "why" is that SQL server rans from 500-600MB to about 1½ GB for just a week after a double of the memory :/. I've tried that analyzer tools for SQL. Neat tool! But I'm not familiar with SQL and didn't understand a word of those warnings and exclamations apperared there :), except that a major of them referred to our WSUS.
 
10.09.2006 at 04:51AM PDT, ID: 17690005

Rank: Guru

Memory usage went up because physical memory went up.

SQL is basically "reserving it" - creating a buffer pool.

This guide may help in limiting how much it uses, and includes a quote about why it is happening (which I quoted below)

http://support.microsoft.com/kb/321363

"As long as enough memory is available to prevent paging (between 4 - 10 MB), the SQL Server buffer pool will continue to grow"

-red
Accepted Solution
 
10.09.2006 at 05:30AM PDT, ID: 17690169
Hi! many words around this :-). There was a lot more to read on google about sqlservr.exe. They talking about that you mention. SQL Server is buffering all querys in memory for the ability to give faster answer every next time. They also tells that SQL Server do this for so long there exists memory that not compete with other program who need the memory. That should be the reason why the amount exploded after I've installed more memory. The reason that SQL Server takes up a lot of memory is just a better-performance-issue. Someone also tells that the SQL Server release memory when other programs are requesting it. If it release it immidietly or doing some schedule memorycheck any time of the day, i don't know?! :p.

I've got some pages where I am able to control the amount of memory taken up by SQL Server. I feel it like setting the pagefile size for the operating system. You can freeze it and you can let the system decide the size by its own needs. And that's more! I also readed that SQL SERVER STANDARD Edition has a limit, it can't allocate more memory than 2gb. If anyone needs a SQL Server who allocates more memory, they need a enterprise edition. That means, if I sum all four SQLSERVR instances on the SBS Server, I got 1948MB. Pretty much like a 2gb limit. I feel that the SQL server has done its fully allocation of memory and are happy with it :-). The rest of my 600mb free memory is totally free for backups, operating resources and other extra functions runned by users.
 
10.09.2006 at 05:09PM PDT, ID: 17694787

Rank: Genius

Take a look at both links mentioned in this blog post:  http://msmvps.com/blogs/bradley/archive/2005/08/27/64328.aspx

Jeff
TechSoEasy
Assisted Solution
 
 
20080236-EE-VQP-29