improve the sap b1 performance

[Former Member]

hi friends,

          i need to want improve the sap b1 performance . we are using SQL server 2008 R2 and 16 GB ram. 11 add-ons we are using . but it is occupying the performance 15.42 GB. i saw the performance in the task manager -> performance. so sap b1 is hanging in the server .  client system also hanging and some time slowly working when server is working well.

so i need a some ideas or instructions . we are using 36 crystal report and including layout also, we are using sap b1 8.8 PL12.  and we are using more approval process like 20 and 11 to 13 fms and 50 to 60 query reports. and we are having 30 license . add-ons all are exe

what are ways are there? i need to improve the server with sap b1 performance? server should not hang any situation? and client system also need to improve the  performance. basically what is the system requirements need to improve the sap b1 performance.

i hope you friends give your best ideas are documents proof. i hope you will understand my problems. and how to check the performance level ? what are performance i need to check.?

[KennedyT21 · Accepted solution]

Hi Ramesh,

• Refer to the Optimizing the SQL SAP Database.pdf you can find on the SAP Business One partner page and forum.
• The communication between the Terminal Services server(s) or Citrix server(s) and the SQL server should be at minimum of 1gig. You can purchase an inexpensive Dell 3-4 port 1gig hub or equivalent for around $200.00 and install it on the Business One server(s) and see a huge increase in performance.
• Create a .BAT file and put it in the startup for the Citrix or Terminal Server servers to delete .TMP files in the %userprofile%\local settings\temp folder at startup.
• Make sure all SQL queries, as well as any other remote access to the database, use the (NOLOCK) command next to each table accessed, otherwise it accesses the tables with a share lock. You could easily be locking thousands of records and pages of the database without this.
• Microsoft Windows does not do a good job of freeing up memory, improper log-out’s, etc. Re-booting Microsoft servers at a minimum of once per week is important.
• Antivirus software on the SAP Business One related servers: Don’t check and download the latest updates and virus definition files during the day, do it at night only. Do not do system scans during the day, maybe do the full scans at night. The real time scans need to be scaled back so it doesn’t include the SAP Business One executable files as well as Microsoft SQL programs. Consider stopping the real time scanning for an afternoon and see how your performance is effected. Note: if a MS-SQL database get’s infected with a virus, which I’ve never seen yet, you have to restore the database anyway.
• Review your work station antivirus scanning and updates also. If they are running during the day, these scans or updates on the work station give the impression that SAP Business One is slow but in reality it is the work station causing the slowness.
• Identify all software that is running on the SAP Business One servers. Only install and run what is really needed. The SQL server shouldn’t have much running on it, besides SQL and MS-Fax.
• Review the event logs daily or as often as needed to verify proper setup and installation.
• Review the SAP Business One and SQL Service Backup schedules. Typically we recommend these backups occur at 6am, 7pm, and perhaps lunch. These backups will typically slow the system down so trade off’s have to be evaluated.
• Backups to tape will also affect performance while running. Typically we recommend that client’s perform backup’s to tape while users are not on the system or if you run 24×7 when the user count as at the lowest.
• Review all Microsoft Windows performance logs to make sure there are no issues that require correction.
• Setup and auto-run SQL database maintenance jobs each night.
•               Run Raid 1 or Raid 10 on the disks that the databases are on. Raid 5 is one of the slowest configurations for just about any ERP or Business Management database, due to the added disk I/O for additions, updates and deletes. It just isn’t necessary and is not worth the negative hit on performance.
• In summary, you need to look at hardware, the network and other software that is running, just as much as you are looking at the database server and the business software. Unfortunately, when the business software is “slow”, the users think that is the problem, when in fact, a lot of the time it is other software and configurations that are the true problem.

Regards

Kennedy

[Former Member]

Is there any tool to increase the performance of SAP B1 9.0

Regards,

Krishna K

[Former Member]

Hi,

The link you posted is for SAP channel partner only. If you are customer, you will have no permission.

You need to check the bottle neck of the performance related to your specific environment. The server for 16G would be one to upgrade first.

Thanks,

Gordon

[shakeelahmad]

what is the procedure to purchase fixed asset in 8.82 version

[kothandaraman_nagarajan]

Hi,

Please post as new as new discussion. This is standard forum rule.

Thanks & Regards,

Nagarajan

[KennedyT21]

Hi Ramesh,

Also you can try the followings:

1. Run dbcc checkdb query on the database which checks the logical and physical integrity of all the objects in the database

2. Go thru the SAP Notes below:

     Note 548772 - The system performance in SAP Business One is very slow

     Note 783183 - Slow performance in SQL or Business One

     Note 542032 - performance of work flow

     Note 1071165 - Low performance while using FMS in long documents

     Note 826789 - Analyse Formatted Searches (Performance)

     Note 950111 - Workaround for Formatted Search Performance Issue

     Note 1002715 - Performance for Document with Freights Enabled

     Note 974574 - Low performance for Items that manages serials

     Note 1180342 - Update doc takes long time when rounding method is By Document

     Note 1114099 - Long time to open sales documents forms for non-superusers

3. You can restore the database to another server, one with better resources

SQL DataBase Tune

1. Run Sql Activity Monitor.

2. Instal Performance Reports - performance dash board u can find missing index and fix the index part.

3. Analyses Query in database engine tuning advisory.

http://msdn.microsoft.com/en-us/library/ms176064.aspx

Check with this link. Try in the Test environment.

Regards

Kennedy

[Former Member]

KINDLY PROVE THE BELOW LINK PATH

HTTP://service.sap.com > SAP Channel Partner Portal > Login > SAP Business Management Solutions > SAP Business One > Support > Support Self Help and Library > Performance.

[KennedyT21]

Hi ramesh kannan,

https://websmp109.sap-ag.de/~form/handler?_APP=00200682500000002702&_EVENT=DISPLAY&_HIER_KEY=2011000...

Link what you asked required partner Suser Id to access this

Hope Helpful

Regards

Kennedy

[Former Member]

Nice information really help.

Regards

Rajkumar Gupta

[Former Member]

HI  Kennedy

where can i found these notes

Thanks

[kothandaraman_nagarajan]

Hi,

Notes can be found from Customer web portal and you need "S"user ID and password.

Thanks  & Regards,

Nagarajan

[Former Member]

thanks nagarajan

[KennedyT21]

Hi Ramesh

Check with These Links

http://scn.sap.com/community/business-one/blog/2012/08/13/performance-impacting-mistake-no-1-ummmmit...

http://scn.sap.com/community/business-one/blog/2012/08/09/performance-best-practices-for-sap-busines...

Hope Helpful

Regards

Kennedy