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 ?