[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SQL server with 8GB and 9x% used

Posted on 2011-10-12
10
Medium Priority
?
253 Views
Last Modified: 2012-05-12
Hi,

I´m right working with a EMC server, running a virtual 2008 r2 and sql 2008 rs standar with only one DDBB.

Database has more than 2xx tables but only 15 users right now. The server was built using 8 GB, sql up to 6250MB.

SQL Server SP1 is NOT installed. The installer company does not want to do this!!!.

When the server is started everything goes fine, some weeks after this, the memory.. the total server amount memory usage grows up to 6x% 7x%.

After a invoicing process, heavy, the sql server uses up its 6,250MB ...  this is until here, OK, but the total used ran goes up to 97 or 98 or 99%.

The sql server fulll its reserver memory.

Who is using  from 6,250MB  up to 8GB? why? because there no other software installed....

Shall this server have more ram installed? how much more?

Regards
0
Comment
Question by:heze54
  • 6
  • 4
10 Comments
 
LVL 17

Expert Comment

by:Chris Mangus
ID: 36957223
The Max Memory setting is only for SQL's buffer pool.  SQL Server can also allocate memory outside this boundary for extended SP's, COM objects, EXE's DLL's, etc.  Because of this it is sometimes normal for SQL Server private bytes to exceed the max server setting.

Are you having a performance problem or just seeing that SQL is using a lot of memory?
0
 

Author Comment

by:heze54
ID: 36957239
Hi,

Some performance problems.Not always
0
 
LVL 17

Accepted Solution

by:
Chris Mangus earned 2000 total points
ID: 36957297
If your invoicing process is run during business hours it's likely that you will see a performance hit.  You could either offload the invoicing to non-business hours or as a quick, cheap hit, add more memory.  
0
Simplify Active Directory Administration

Administration of Active Directory does not have to be hard.  Too often what should be a simple task is made more difficult than it needs to be.The solution?  Hyena from SystemTools Software.  With ease-of-use as well as powerful importing and bulk updating capabilities.

 

Author Comment

by:heze54
ID: 36957328
Yes, I can not be scheduled for running at 12 am hours..


The SQL 2008 sp1 installing, could resolve part or whole problem? as far as I know, the sp1 fixes some performance problem... doesn´t it?


regards
0
 
LVL 17

Expert Comment

by:Chris Mangus
ID: 36957467
I don't know all of the issues fixed in service pack 1.  If you are using SQL 2008 non-R2 there is now a service pack 2 as well.
0
 

Author Comment

by:heze54
ID: 36958748
running 2008 r2 standar
0
 
LVL 17

Expert Comment

by:Chris Mangus
ID: 36958970
The service pack 2 would be the most current service pack for you to install.
0
 
LVL 17

Expert Comment

by:Chris Mangus
ID: 36958973
Sorry, service pack 1 is the most current for 2008R2.
0
 

Author Comment

by:heze54
ID: 36964401
The owner has   reduced the  sql memory from 6,2GB to 4,5GB.

goodd idea?

any opinions?

regards
0
 
LVL 17

Expert Comment

by:Chris Mangus
ID: 36964440
6.2GB would have been a good value.  4.5GB is not an appropriate value assuming SQL Server is the only thing running on the server.  It's too low.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

For anyone that has accidentally used newSID with Server 2008 R2 (like I did) and hasn't been able to get the server running again because you were unlucky (as I was) and had no backups - I was able to get things working by doing a Registry Hive rec…
This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
To efficiently enable the rotation of USB drives for backups, storage pools need to be created. This way no matter which USB drive is installed, the backups will successfully write without any administrative intervention. Multiple USB devices need t…
This tutorial will walk an individual through the process of transferring the five major, necessary Active Directory Roles, commonly referred to as the FSMO roles to another domain controller. Log onto the new domain controller with a user account t…
Suggested Courses

873 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