Strange performance issues on Pastel Evolution (Hosted in Cloud)

H

Hubert Cumberdale

Member
Joined
Jan 29, 2010
Messages
25
Reaction score
0
Hey there,

We have been trying to figure out why certain features on Sage Evolution take more than 15 seconds to load? Then we also have strange issues like sometimes when our invoicing ladies try to put in a price (lets say they type 2) it spits out like 48571.

We host our Evolution in the cloud with a popular hosting company and use malware bytes premium for anti-virus.

I know some of the firewall rules had to be altered to get rid of some lag (not all) in the past. We have a 100Mb fibre line onsite and 200Mb line at our hosting company.

Does anyone have an idea what could cause this?

Regards
 
Are your users connecting via remote desktop or directly from their PC's using the Evolution client? Remote Desktop would be preferred for this scenario.
 
InvisibleJim said:
Are your users connecting via remote desktop or directly from their PC's using the Evolution client? Remote Desktop would be preferred for this scenario.
Click to expand...

Hey InvisibleJIM, they connect directly from PC onto a program called cloudware and then they go into Evolution through that portal.
 
Hi Hubert

Hope you are well.

Regarding the issue of Strange Performance issues on Pastel Evolution (Hosted in Cloud), we need to ascertain the following below:
1. Who actually hosts the solution for your organization?
2. Is the performance the same for all users across the board?
3. What are the specs of the Hosted PC?
4. Where about specifically within the application does the performance behave like how it is doing currently?
5. How big is the log file within the MS SQL Server/Data Folders respectively?

Await your response on the above.

Regards
Z
 
Hi Hubert

This particular issue is out of our scope and it would be better to check with the service provider first. The other thing to take note is when last was this working correctly and what has changed from then to now.
 
Last edited:
Zak007 said:
Hi Hubert

Hope you are well.

Regarding the issue of Strange Performance issues on Pastel Evolution (Hosted in Cloud), we need to ascertain the following below:
1. Who actually hosts the solution for your organization?
2. Is the performance the same for all users across the board?
3. What are the specs of the Hosted PC?
4. Where about specifically within the application does the performance behave like how it is doing currently?
5. How big is the log file within the MS SQL Server/Data Folders respectively?

Await your response on the above.

Regards
Z
Click to expand...

1. Who actually hosts the solution for your organization? - We host our VPS at Domains.co.za
2. Is the performance the same for all users across the board? - It is only on certain modules like Purchase orders, and when viewing general ledgers, the other issue like I said was when someone wants to put in a certain value like 4 it automatically puts in 5731 ie. Users experience issues on the same modules on different pc's.
3. What are the specs of the Hosted PC? EMD EPYC 7351 16 CORE WITH 24GB RAM
4. Where about specifically within the application does the performance behave like how it is doing currently? We access Evolution via cloudware and then in Evolution the biggest problems are with Purchase/Sales orders and certain users loading reports.
5. How big is the log file within the MS SQL Server/Data Folders respectively? Around 25Gb on the current database we are working on. I would say around 50GB in total size.

Hope this helps ?
 
Hubert Cumberdale said:
1. Who actually hosts the solution for your organization? - We host our VPS at Domains.co.za
2. Is the performance the same for all users across the board? - It is only on certain modules like Purchase orders, and when viewing general ledgers, the other issue like I said was when someone wants to put in a certain value like 4 it automatically puts in 5731 ie. Users experience issues on the same modules on different pc's.
3. What are the specs of the Hosted PC? EMD EPYC 7351 16 CORE WITH 24GB RAM
4. Where about specifically within the application does the performance behave like how it is doing currently? We access Evolution via cloudware and then in Evolution the biggest problems are with Purchase/Sales orders and certain users loading reports.
5. How big is the log file within the MS SQL Server/Data Folders respectively? Around 25Gb on the current database we are working on. I would say around 50GB in total size.

Hope this helps ?
Click to expand...

Where is the Cloudware server located? If not on the VPS or the same 'local' network at Domains.co.za, that could be an issue. Can you reproduce the problems if you remote desktop or teamviewer onto the VPS and run the Evolution client directly on the server?

Those log file are pretty large for your typical Evolution database. I doubt it is the source of your performance issues but you should check that your SQL logs are being correctly managed either in simple recovery mode or in full recovery mode with regular transaction log backups. An ldf file much larger than the corresponding mdf file is a dead giveaway that this is the situation and the standard reports in SQL Server Management Studio will show you that the majority of your 25GB log file is mainly white space.

The good news is that the log file size can be quickly and easily addressed using functionality native to all versions of SQL Server - as a bonus, you can also configure a SQL backup scheme with a daily full back up and transaction log backups every 20 or 30 minutes which will give you a point in time recovery and an RPO of 20 - 30 minutes as well as keeping your log file growth in check
 
3. What are the specs of the Hosted PC? EMD EPYC 7351 16 CORE WITH 24GB RAM

What they charge for this? What disks are they using?
 
@hubert, as per the message from Rog163, i think maybe we need to check how big the log file is then work out some plan to shrink this on a daily basis.

1. Has this been an issue from inception or has it started now recently?
2. What has changed from previously to now that performance has been impacted?
 
Hi Op,

What you can do is check the SQL performance using management studio to ascertain if the bottleneck is being caused by the Disk IO when the transactions are taking place. You may want to request another virtual disk be created and move the SQL Db onto that disk so the log files are separated.
 
You must log in or register to reply here.
Back
Top
Sign up to the MyBroadband newsletter
X