SQL server with 8GB and 9x% used

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
heze54Asked:
Who is Participating?
 
Chris MangusConnect With a Mentor Database AdministratorCommented:
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
 
Chris MangusDatabase AdministratorCommented:
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
 
heze54Author Commented:
Hi,

Some performance problems.Not always
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.

 
heze54Author Commented:
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
 
Chris MangusDatabase AdministratorCommented:
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
 
heze54Author Commented:
running 2008 r2 standar
0
 
Chris MangusDatabase AdministratorCommented:
The service pack 2 would be the most current service pack for you to install.
0
 
Chris MangusDatabase AdministratorCommented:
Sorry, service pack 1 is the most current for 2008R2.
0
 
heze54Author Commented:
The owner has   reduced the  sql memory from 6,2GB to 4,5GB.

goodd idea?

any opinions?

regards
0
 
Chris MangusDatabase AdministratorCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.