on 09-18-2014 5:59 AM
Hi Everyone,
Good day!
I would like to ask something with regards to this matter:
What will be the performance and impact if SAP Business One is installed in a Virtual Machine and the MS SQL that I used is installed on the server where the virtual machine is installed(MS SQL is installed outside the virtual machine)?
Also what will be the impact when I launch SAP in client workstations?
Hope you can give your informative finding.
Thanks.
Anthony M.
I suggest that you try to migrate the SAP on a non virtual machine as that does slow the system down. Also provide sufficient ram to the system. Make sure if there is multiple Ethernet port on the server to disable all but one that is connected to the network. Also disable any unnecessary background application that may slow down the server.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
If there is no problema the mark your helpful answers and your correct answers to close the thread.
Regards
Dave
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Antony,
Please increase your RAM memory.. While using Virtual Machine it occupies more memory for the MSSQL services & VPN ...
Regards,
K.Ramasamy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Anthony,
We have many Customers running Productive Environment with this Landscape with the same quick response, maybe you check the RAM on your servers, mainteneance for SQL, Databases, SWAP, etc.
Regards,
David Almazan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Anthony,
If I understand it correctly, Why do you want to install SAP B1 server on a virtual machine? what do you want to achieve?
You might as well install SAP Business One server where SQL is installed rather than having it on a virtual machine
Regards,
JP
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi JP,
Thanks for your prompt reply.
Actually, it was installed already on the virtual machine before. I just want to know what will be the impact for this kind of setup because apparently i'm facing slowness in launching the SAP B1. I'm not sure if this might be the reason for the slowness because I have big enough space on my server and installed bigger RAM.
Thanks,
Anthony M.
Hi Anthony,
Virtualization is an extra layer, and it will impact system performance. How much, depends a lot on the size of the database, and the rate of transactions.
As a rule of thumb, with any database centric applications, avoid middle layers like virtualization, and NAS.
That said, analyzing B1 system performance is a tricky business. Slowed performance can be caused by many things, so you may have to find and eliminate several issues before you get to expected performance.
Regards,
Johan
Hi Anthony,
Performance of B1 clients on workstations is really only impacted by the quality of your network. Look at network adapters on workstations and server (are they 10/100 or 10/100/1000 ?), switches (are all ports 10/100 or 10/100/1000 ?) , cabling (cat5 or cat6 ?), wifi signal (B1 is very sensitive to wifi connectivity issues), etc ,etc.
(not talking about HANA) The ideal environment for running B1 is:
Regards,
Johan
Hi Johan,
My pleasure.
I was surfing on the web looking for answers to my question, actually just for a good one that give me a clear idea and could help me with problem, Then I read your comment.
So here is my escenary:
My customer has two servers, one for SAP B1 8.82 PL04 and the other one for SQL 2008 R2, nowadays I know that SAP require on a hosted enviroment 1GB RAM per user, in this case there are 55 concurrent users, which means that the SAP B1 Server will requires 55 GB + 4 GB OS + 8 GB for Remote Desktop Services, for a total of 67 GB (all that will be the perfect situation). But in this case the customer has in B1 Server just 9 GB of RAM (don't scare), the system runs, but obviusly is not the best.
And about the server for SQL, it has 12 GB and the production DB size is 29 GB, the SQL is limited to 8 GB.
So in this case, how much memory will be the best for the SQL, and what will be your recommendations for the B1 Server.
I will appreciate your help.
Regards.
Hi Juan,
Your customer's setup is a bit strange.
The B1 (server) program does not need its own server, because it requires absolutely no resources at all. In fact by using separate servers for the program and the database, they have created an extra bottleneck, that slows the system down.
In the scenario you describe, I recommend the following:
Regards,
Johan
Dear Johan, thanks for you reply.
Let me explain a Little more the situation.
For security reasons, many of our customers have installed B1 and SQL in separate servers, even here at my office we have that kind of landscape.
There's a lot of literature about how to make a correct sizing of SAP B1, but what happens when SAP B1 is installed on a Server (this is the applications server, where all the users connect trough RDP) and the SQL server is installed on a separate Sever. I mean how do you size the SQL respect to the quantity of users and the DB size.
I haven't found nothing explicit that could help me, just what you post on this forum.
Thanks, again.
Regards.
Hi Juan,
Ok, that makes a little more sense.
About SQl server and maximum RAM:
The maximum RAM SQL server may use is by default unlimited. That means that if your SQL Server is performing a lot of queries / tasks, it will use all the RAM it needs for that work. Even if that means that there will be no RAM left for Windows to operate (normally). If Windows cannot operate normally, all the programs that are running on it (including SQL Server), are slowed down as a result.
This is why you should set SQL Server to use all available RAM minus an amount for Windows to be able to operate. This amount depends on the Windows version and bits.
As you are running the database on its own server, the amount of (RDP) users are only relevant in estimating the workload of SQL Server.
In the example above where the database server has 12 GB, and the database is 29 GB (much larger than the available amount of RAM), the RAM setting will remain the same (8 / 4). If SQL Server is allowed to use more RAM, it will slowly strangle itself when more and more users log on and start working.
So again, I would increase the RAM of the database server, in this case to 32 GB, and set SQL Server memory to 28. A small investment and you will likely get performance that comes close to HANA.
Regards,
Johan
Hi Juan,
In general it helps with performance to put the mdf (rows data) and ldf (log) files each onto physically separate hard disks.
Dividing the rows data into multiple files and putting them in different hard disks, with B1 I would advise against it, simply because you do not know how the B1 tables interact. That means that you could move say the document tables (ORDR, RDR1, etc) onto its own disk, and the master data (OITM, etc) onto its own, but chances are that you would actually adversely affect performance.
In any case I would recommend to set up a test environment and test first.
Regards,
Johan
User | Count |
---|---|
103 | |
12 | |
11 | |
6 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.