cancel
Showing results for 
Search instead for 
Did you mean: 

Memory keeps increasing for SQLServr.exe in Task Manager

Former Member
0 Kudos

Hi

For one of our SAP B1 customers, we have SQL Server 2008 R2 as the database server and SAP Business One 8.81 PL 09 with Windows Server 2003 64 bit as the Operating system. We have installed couple of our add- ons also in the server. After starting the SAP application the sqlservr.exe in the task manager increasing consumes memory to a point where the server automatically restarts. We have analyzed from our end and found that there is no memory leakage. We tested without connecting the add-on, but the memory keeps increasing although the rate at which it is increasing had come down.

We have released the objects using garbage collection (gc.collect) in our add-ons but still the issue persists.

Please suggest us a solution since this has become a major issue for us.

Regards

Louis

Accepted Solutions (0)

Answers (4)

Answers (4)

former_member217514
Active Contributor
0 Kudos

If it is the SQLServr process that is growing, the first thing I think of is SBO_SP_TransactionNotification or SBO_SP_PostTransactionNotice.

When you installed your add-ons, did you also add code to SBO_SP_TransactionNotification?  Even if you unistall your add-ons or disable your add-ons, the code usually isn't removed from SBO_SP_TransactionNotification.

Former Member
0 Kudos

Hi Louis,

You need to find out which add-on cause the trouble by disable them all and run it one by one. Once you find the problematic one, Debug the add-on.

Thanks, Gordon

EunSeok_Bang
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi Louis

It's very difficult to find a root-cause for this kind of performance issue.

first of all, I recommend to check the central page for performance issue https://websmp209.sap-ag.de/~sapidb/011000358700001268862008E

If you can't address your issue from the link, it's better to contact SAP support to let them investigate your environment. they have a lot of experiences for variety of environments.

Regards

Eunseok

Former Member
0 Kudos

Hi,

Disable the antivirus temporarily, goto Task Manager and look for program who is consuming the memory, terminate the program and look what thats program.

Uninstall all add-on and restart the program if the problem persist it might be infected by a malware.

Thanks.

Clint