Performance Issue in 8.8

[Former Member]

Having worked on 2005 & 2007, we never faced performance issue. Installation is simple and smooth.

While I did a fresh install of 8.8 PL9 on Win-2008 and Sql-2008 (RAID5 server Xeon 4GB RAM),

installation is not smooth as earlier versions. Now it is successfully installed but performance

of client is too slow. It took 5-10 minutes to connect the company. No firewall on client and

server. There is only one network card on server.

Does anyone face this issue?

Anyone has experience of 8.8 on Win-2003/SQL-2005?

Please update.

Regds,

OM

[juan_marrero]

Dear Om,

Thanks for your details and replies from rest of collaborators. I would like to suggest one additional action to monitor the login sequence from any cliente machine.

Could you please verify the following and update us with your results :

• De-activate any alerts for the affected user.

• Deactivate firewalls on client and server for testing.

• Check size of History Log in General Settings > Services tab (if to high some delays will be faced)

• Capture the login event with a netstat:

- Open command prompt (start > run > cmd) and run netstat -an 1 > C:\LoginB1.txt. in one the affected PCs

- With the command prompt up and running, login to B1

- After the workstation is successfully logged in, stop the command netstat -an 1 > C:\LoginB1.txt in the command prompt using Ctrl + C.

- This will create in C: a text file called LoginB1.txt

Analyze this details and if possible do the same in any other machine not facing this issue. Compare then both documents and look for ports in use a stablished communication.

Feel free to post your results in this thread for further analisis.

Regards,

Juan Manuel Marrero

SAP Business One Forums Team

[Former Member]

Hi Juan,

Thanks for your suggestions - my issue seems to have been resolved by following an old SAP Note and disabling the second port on a dual network card & restarting the server!

[Former Member]

Hi,

We would recommend you to kindly check the server security audit logs (under Control Panel>Administrative services>Event Viewer>security). This would help to identify the exact client user trying to logon to the sql server for the particular failed login.

Henceforth, the cause of the failed login can then be narrowed down after mapping the security logs to the sql server logs.

Hope this helps. Let us know for further information.

Regards,

Abhinav Banerjee

Edited by: Abhinav Banerjee on Sep 9, 2010 6:33 PM

[former_member1269712]

Hi,

I am using SBO 8.8 PL12 on Windows 2003 server and sql 2005 and also at our client place Windows 2008 and SQL server 2008 (initially we are using 8.8 PL05 and now PL12). But we are not facing any speed issue. We faced some bit of issues in initial stages but now it is running smoothly after starts some services.

Thanks

SD

[Former Member]

Hi All,

Please open a ticket to SAP to have the team take a look. Seem strange this "lag". Do you have two license servers or two network cards?

Regards,

Paul

[yvonne_doyle]

Hi All,

Take a look at SAP note number 1404153 and check if it is applicable to your case. This is a known issue in Business One where there is a slow login to B1 due to too many tax codes (over 10,000) defined in a company DB. A fix for this issue is released in PL12.

Check the number of records in tables such as OSTC, STC1.

Kind Regards,

Yvonne

[Former Member]

We are also having an issue.

Brand new server, we have installed a demo database and it takes 2-3 minutes for SAP to start up with no addons.

We are currently still investigating, but no answer as yet.

[Former Member]

We have a similar issue, brand new server, fresh install of SAP, with a restored & upgraded database. Server client connection is fine, but other client connections take ages.

I have noticed the the SQL server logs errors stating : "Login failed for user ''. Reason: An attempt to login using SQL authentication failed. Server is configured for Windows authentication only. [CLIENT: 192.168.1.17]".

These run several times over the time the user is logging in.

The SQL server is configured for either SQL or Windows, the sa password has been entered into the license server - although we would much prefer to be able to use trusted groups as in the past!

A resolution would be good!?

[Former Member]

You may check this thread:

Thanks,

Gordon