Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 681
  • Last Modified:

Memory Leak on Goldmine Server

Hi,

Of late, Ive been rebooting our SQL 2005 box more often. Previously, I would do a reboot once a month if I was lucky but now, we are rebooting every couple of days.

Ive logged onto the server this morning and fired up the task manager and I can see the Commit Charge growing by 1mb a second. Its currently showing 2545mb of 5223mb. Im summarising when the process gets up to 5223mb this is when the server will require rebooting.

Is this normal behaviour for this process? What can be done to bring the memory leak under control?

Server is running Windows 2003 Server with SP2 applied. From what I can see, there is no SP on the SQL2005 side of things. Have you guys got any advice about applying Service Packs to Goldmine, any problems or steps I need to be aware of ?

Thanks
DW
0
daiwhyte
Asked:
daiwhyte
  • 4
  • 4
  • 3
2 Solutions
 
GMGeniusCommented:
Firstly you should apply the SP as soon as you can, just make sure no one is logged into GoldMine (rename the license.bin to license.biu after they all log out to stop them logging back in again until your ready)

Just install the SP like any other update and reboot/restart the SQL server.

As for the memory leak, this problem has been around for a long time and its not generally a GoldMine issue.

SQL2000 used to be worse but SQL2008 is much better. its normal to see this happen in a heavily used system.

Not much you can do about it really. Is your GoldMine Databases set to "Simple" or "Full" recovery?
0
 
daiwhyteAuthor Commented:
Hi GMG,

I will update the SP, from what I can see, its upto SP4, can I just apply that one or do I have to go SP1, Sp2 etc?

DB is set to Full since we do Log Shipping of the Transaction logs to a 2nd server (although I have killed this process whilst I try and find the source of the problem)

DW
0
 
GMGeniusCommented:
SP's normally contain all upto that SP
0
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 
stevengraffCommented:
SQL Server is a VERY memory-hungry application. It will consume all memory available to it. Don't worry; this is "normal." Installing service packs will not "solve" this because it's not really a problem. The best thing you can do to improve the performance of your SQL server is... add more memory to the machine!
0
 
daiwhyteAuthor Commented:
Steven,

The server has 4gb installed already and I would love to take it to 8 or even 16gb but this would require me to upgrade the OS to 64bit unless you are aware of a cunning way I can get round this?

Dave
0
 
GMGeniusCommented:
No way around that. You must be on a 64bit OS.
0
 
daiwhyteAuthor Commented:
If I was to rebuild the os to 64bit would I need a 64bit version of Goldmine?
0
 
stevengraffCommented:
No such thing.
0
 
stevengraffCommented:
You'll need to back up your SQL db to an external drive, then re-install Windows and SQL (don't forget the service packs), then restore your db.
0
 
GMGeniusCommented:
You would need to Install the 64bit SQL server
0
 
daiwhyteAuthor Commented:
Thanks guys.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

  • 4
  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now