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?
 
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
 
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
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Vitor MontalvãoMSSQL Senior EngineerCommented:
What else is installed in the SQL Server box?
0
 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.