Marrafeiro
New member
- Local time
- Today, 23:05
- Joined
- Oct 24, 2023
- Messages
- 8
Hi everyone,
I'm going to try explain my problem, my english is not my native language, so i'm sorry if i make any mistake.
My company have a software made in access, it have around 700mb of size, is believe is a big app. The data is in an SQL Server, so we have all the tables linked to MS ACCESS. our architecture of bussiness is:
1- Our Clients (around 300) enter in our servers
2- Each client have 1 accdb file in a network shared driver
3- our server structure is all virtual based with load balencer, 1 server for AD, GPO and 1 shared driver for all servers. 1 server with SQL Server. And around 6 servers where the clients connect.
Our problem is it is slow when we open the MS ACCESS or sometimes when we open some forms. Is not the querys are slow, it seems to be all the Access in general. For example when we open the access file it take around 20s before start run our first querys.
Before we had a monolitical structure, where we had the files, sql, ad, gpo, etc, all in one server, and it was faster, to open it was around 5seconds. Now it can take to up 1 minute. Any1 have any ideia what it could be?
Again, i'm sorry for my English.
I'm going to try explain my problem, my english is not my native language, so i'm sorry if i make any mistake.
My company have a software made in access, it have around 700mb of size, is believe is a big app. The data is in an SQL Server, so we have all the tables linked to MS ACCESS. our architecture of bussiness is:
1- Our Clients (around 300) enter in our servers
2- Each client have 1 accdb file in a network shared driver
3- our server structure is all virtual based with load balencer, 1 server for AD, GPO and 1 shared driver for all servers. 1 server with SQL Server. And around 6 servers where the clients connect.
Our problem is it is slow when we open the MS ACCESS or sometimes when we open some forms. Is not the querys are slow, it seems to be all the Access in general. For example when we open the access file it take around 20s before start run our first querys.
Before we had a monolitical structure, where we had the files, sql, ad, gpo, etc, all in one server, and it was faster, to open it was around 5seconds. Now it can take to up 1 minute. Any1 have any ideia what it could be?
Again, i'm sorry for my English.