SAP Business one performance issue post upgrade

We recently moved from SAP Business one 8.81 to 9.1 moving from a windows 2008 server/SQL  to a Windows 2012/SQL. Both the old and new server are virtual in the same cluster on raid 5 setup. We are seeing a performance decrease were most queues are 3-4 times longer. We've added a memory and cores to the VM but the improvements are minimal. 30 GB memory to the server and at first only 8 GB was assigned to SQL but we increased it to 24 GB, but we are averaging 17 being used.  Anti-virus is not an issue.

I know it is recommended that an SQL server be on a physical server with raid one, but our old one was functional before hand. Would the upgraded system require different disk configuration.
Thomas_L_MTLAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Vitor MontalvãoMSSQL Senior EngineerCommented:
Which version (32bit or 64bit) and edition (Express, Standard, Enterprise) is the installed SQL Server?
0
Thomas_L_MTLAuthor Commented:
Microsoft SQL Server 2012 - 11.0.2100.60 (X64)
      Feb 10 2012 19:39:15
      Copyright (c) Microsoft Corporation
      Standard Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: ) (Hypervisor)
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
What else is installed in the SQL Server box?
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Thomas_L_MTLAuthor Commented:
We have the SAP server and SQL Server on the same box. Other than than SQL tools and Teamviewer host, nothing extra.
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
Ok. Applications like SSAS, SSIS and SSRS are resource consuming and if you have them installed in the same box it can cause these performance issues.
0
Thomas_L_MTLAuthor Commented:
It looks clean to me. see attached for services and features installed.

PS: It server was built by third party, I was hired a week before cut over and I never considered myself and SQL/SAP expert before hand. So some of my answer may be a little vague.
CP.JPG
SQL-services.JPG
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
Can't see anything abnormal.
How many vCPU the server had and how many it has now?
0
Thomas_L_MTLAuthor Commented:
The old server was 4, the new server was 4, but we increased it to 8 with minimal improvement.
0
Vitor MontalvãoMSSQL Senior EngineerCommented:
In a VM giving more vCPU won't mean a better performance. Do you know how much was the gain from 4 vCPU to 8?
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.