Right Click Menu taking 1+ minute to open

[Former Member]

Hi All,

After upgrading a client to SBO 2007 the right click menu takes more than a minute to open. If they go for example to a business partner address, right click on the address and then want to cut and paste it will take at least 2 minutes.

Any idea what I can check. SAP in general seems a bit slow. Where can I check if the anti-virus blocks something?

The upgrade process itself also took a long time. On my local notebook it takes about an hour, on their server it took over 4 hours - same database. The server specs itself seems to be more than sufficient.

Thanks in advance,

Adele

[Former Member]

What is your B1 PL? It might be better if you update to the latest one.

Thanks,

Gordon

[Former Member]

Check this SAP Note: 783183 Slow performance in SQL or Business One

[https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/smb_searchnotes/display.htm?note_langu=E&note_numm=783183]

[Former Member]

Thank you for the reply, but can you please post the contents of the note here or if you can't can I give you my e-mail address?

[Former Member]

here we go

Slow performance in SQL or Business One

Symptom

Bad performance when running SQL query or when using certain

SAP Business One functionalities.

This problem occurs due to Non-optimized table statistics.

For each table in the database, SQL Server automatically maintains the

information below:

1.Number of data pages used by each table.

2.Number of rows in each table

3.Number of INSERTS, UPDATES, and DELETES that affect the keys of the table since the last statistics update.

In order to enable SQL Server Query Optimizer to make good decisions, it must have up-to-date statistics on the tables and indexes in the database.

When installing SQL, the auto update statistics check box (in database

properties / Options tab page) is checked automatically.

Even though the check box is set automatically, on large tables this

procedure might not work perfectly

Other terms

Performance, Bad performance, system is stuck, Update statistics,

SQL statistics, update SQL statistics

Reason and Prerequisites

Functionality Description

Solution

To solve the problem, initiate the "update statistics".

Run the Stored Procedure below on each company database:

EXEC sp_updatestats

To run the Stored Procedure for each database, use the syntax below:

Use Demo_DE

Go

SP_Updatestats

Use Demo_US65

GO

SP_Updatestats

To avoid it causing work load, it is recommended to run it during

night hours.

There is an option to set the Stored Procedure into SQL job

(In SQL Enterprise Manager / Maintenance folder)and schedule it for

night hours.

Refer to the "SQL Server Books Online" for details about creating jobs:

Job\Creating\How to create a job

Job\Steps\Creating job steps.

In "Steps => Edit Job Steps:

1. Select database: Master

2. The Command content in "Steps" window:

Use Demo_DE

Go

SP_Updatestats

Use Demo_US65

GO

SP_Updatestats

Note:

To enable SQL jobs, the "SQL Server Agent" should be started from

"SQL Server Service Manager".

For more information please refer to:

http://www.sql-server-performance.com/statistics.asp

>

[Former Member]

Thanks Steffen, I'm going to give this a try.

[Former Member]

I executed the above stored procedure on the database and it didn't have any effect. The right click menu is still slow. If you go to business partners and right click on the address field (or any other field) the menu takes at least 40 seconds - 2 minutes to show.

Any ideas?

[Former Member]

This problem is still occurring. Right-click menu takes very long to show, please help!

Edited by: Rui Pereira on Apr 30, 2009 3:00 PM

[Former Member]

Hi

Please take a look at this thread.

Hope this helps

Bishal