Poor perfomance in Windows Server 2008 R2 Entreprise

[Former Member]

Hi everyone

In facing a problem and i don't have a clue ho to solve it. The application performance is very poor in a brand new server comparing to the performance in my laptop:

Same database

Same SBO Version

Same Add-on

No formated searchs at all

The server has only one network card an on IP address

For testing purposes in running SAP Business One Client on Database Server

No else is working

SERVER

Windows Server 2008 R2 Enterprise

SQL SERVER and License Server ans SAP BUSINESS ONE client:

-Processor     : Intel(R) Xeon(R) CPU E5-2640 0 2.50 GHz (4 processors)

-Installed RAM : 32 GB

- System Type  : 64-bit Operating System

SQL SERVER:

-SQL SERVER 2008 R2 65-bit (vesion 10.50.4000)

-Database size 600 Mb (Brand new)

MY LAPTOP

Windows 7 Professional

SQL SERVER and License Server ans SAP BUSINESS ONE client:

-Processor     : Intel(R) Core(TM) i7-3540M CPU @ 3.00 Ghz

-Installed RAM : 8 GB

- System Type  : 64-bit Operating System

SQL SERVER:

-SQL SERVER 2008 R2 65-bit (vesion 10.50.4000)

-Database size 600 Mb (Brand new)

Same database, same add-on

Specifc task with an Add-on on server 12 seconds

Specifc task with an Add-on on laptop 3 seconds

Tks in advance

[Former Member · Accepted solution]

Hi everyone,

The solution was to change the power options (from balance to high performance) and format the hard disks where the databases are with alocation unit size = 64 kb.

Thanks for everything

[Former Member]

Hi Nelson,

What is the performance manager showing on the server?

Could the memory be limited in the SQL instance?

Regards,

John

[Former Member]

The memory is not limited

[Johan_H]

Hi Nelson,

There is one thing that can impact performance on a server. Could you test limiting the memory to about 75% - 85% of the size of the RAM ?

Regards,

Johan

[Former Member]

I agree with Johan,  MS SQL will take all the memory on the box if you leave it as above.

[Former Member]

I change the max memory to 24576 (75%). But the memory never goes up 50% of the total.

[Former Member]

Hi Nelson,

Does not look as though it is a RAM or Processing problem by looking at that.

If this is a virtual machine and the physical machine is serving multiple VM's from one hard drive it could be that one of the other VM's is taking up a lot of the physical resource of the hard drive.

Is it possible to run this VM in isolation?

Regards,

John

[Former Member]

Hi John,

It is not a VM.

Tks

[Former Member]

You have mentioned previously "The server is running on VMHare". It that not true?

[Former Member]

Hi Gordon,

We changed the server to a physical infrastructure because of the performance.

[Former Member]

I see. What is the RAID level of the server? That may greatly affecting the performance.

[Former Member]

Hi Gordon it is in Raid 1.

We will test SSD drives during next week.

Tks for everything

[Former Member]

Check if you have any antivirus or firewall running. Sound like your server OS is checking lots more to run applications.

Check your event log to see if you got any errors.

[Former Member]

Hi Gordon, the problem seems to be SQL. The server is running on VMHare, our supplier is carrying out tests. We suspect that is related to the speed of the disks.

There are no antivirus or firewall installed. That is responsibility of the DataCenter infrastructure.

Tks anyway

[Johan_H]

Hi Nelson,

The speed of the disks should not be an issue, as in current generation servers (which a data center should be using) reading and writing to the disks is all routed through the HDD / RAID controller card.

Virtualization will slow down database applications.

When you say data center, I understand that the server is not in the same location as you are ? If so, that means that the speed and quality of your internet connection will have a decided impact on performance, and also any firewall devices and/or VPN routers between your workstation and your internet connection.

Regards,

Johan

[Former Member]

Hi Johan,

The problem should not be the internet connection, the SB1 client is installed on the server and we access by an RDP connection.

We have another server connected through a 1Gbps connection and in that server same operation takes 30 seconds (remember my laptop 3 seconds)

Specifications of the 3rd server

-Processor     : Intel(R) Xeon(R) CPU E5-2609 v2 2.50 GHz (2 processors)

-Installed RAM : 64 GB

- System Type  : 64-bit Operating System

i just can't explain this to the administration

[Johan_H]

Okay, in that case the impact of the quality of your internet connection will be much less, but still should not be ruled out completely.

I think you are on the right track with examining the server configuration and quality at the data center.

You said that basic operations in the B1 client were slower as well, as on your laptop. When you did all your testing, did you use the exact same (copy of) company database both on your laptop and on the server ?

Regards,

Johan

[Former Member]

	SERVER 01	SERVER 02	DESKTOP
SBO Version	SAP Business One 9.0 (9.00.059) PL: 07 (64-bit)	=	=
SQL SERVER	SQL Server 2008 R2 | 10.50.4000	=	=
SQL Location	SERVER 01	SERVER 02	DESKTOP
OS	Windows Server  2008 R2 Entreprise	=	Windows 7 Professional
Disk Configuration	C – OS E – Data   F - Logs	C – OS   E – Data+Logs	C-OS+Data+Logs
Memory	32 Gb	64 Gb	8 Gb
CPU	E5-2630 v2 @ 2.60 GHz (4 processors)   4 cores	E5-2609 v2 @ 2.50 GHz (2 processors)   8 cores	I7-3540M @ 3.00 GHz (1 processor)   4 cores
Open a Sales Order	2.23 seconds	2.2 seconds	0.8 second
Drag & Related Invoices	4.09 seconds	2.87 seconds	1.23 seconds
Add-on	None	None	None

I just can't explain this times.

[Johan_H]

Hi Nelson,

For the comparison you did, it is very important to know that you tested the exact same thing.

So on all three configurations did you:

• use the exact same database ? With the exact same amount of transactions, with the exact same amount of users working concurrently in the company database ?
• open the exact same sales order ?
• use Drag & Relate in the exact same way ?

Regards,

Johan

[Former Member]

Hi Johan,

same database,only 1 user working same sales order, same useof Drag & Relate.

[Johan_H]

Looking at those specs, it comes to mind that this may be a GUI issue.

Could you please test running a demanding query on each of these configurations ?

[Former Member]

I performed an update to the same amount of lines

declare @Tempo datetime

select @Tempo=GETDATE()

update jdt1 set jdt1.refdate = jdt1.refdate

select datediff(ms,@Tempo,GETDATE())

Times

Server 01 - 1800 miliseconds

Server 02 - 600 miliseconds

Desktop - 300 miliseconds

Maybe something with disk or SQL configuration?

[kothandaraman_nagarajan]

Hi,

Please close all other application in server and run only SAP B1.

Thanks & Regards,

Nagarajan

[Former Member]

Hi Nagarajan

The server only has SQL and B1 running.

B1 version is 9.0 PL07 (64 bits)

The add-on is developed by my self, but is the same add-on that is running on my laptop

B1 performance without add-on is also very poor.

Simple task like navigate through BP takes 2 seconds for each BP and in my laptop is much faster.

[Johan_H]

Hi Nelson,

Your laptop allocates hardware resources differently than your server. There are a couple of things you can check:

• Memory settings in MS SQL Server. Look at for recommendations.
• Even though your server is brand new, that does not guarantee that all parts (hard disks, network cards, etc, etc) are working optimally or have been set up properly. Also check the quality of your electrical net (is it nice and steady, or do you get a lot of variance). Your laptop is protected from variance by the battery, is your server connected to the power grid via a UPS, or directly ? If a UPS, is one of its properties to even out the power supply to the server ?
• Server Hard disk configuration. Does your server have a dedicated hard drive for your databases  ? What RAID has been set up ? (See same article)

Regards,

Johan

[Former Member]

Hi Johan,

i run some more tests and probably the problem is in SQL.

a query that takes 20 seconds on my laptop takes 30 seconds on server.

I will look at your advice and then i let you know the result

[Former Member]

Hi,

What is your B1 version/PL? What add-on do you run?

Thanks,

Gordon

[Former Member]

Hi Gordon,

B1 version is 9.0 PL07 (64 bits)

The add-on is developed by my self, but is the same add-on that is running on my laptop

B1 performance without add-on is also very poor.

Simple task like navigate through BP takes 2 seconds for each BP and in my laptop is much faster.

The server only has SQL and B1 running.