L
L
LiptonOlolo2021-06-23 15:27:02
1C
LiptonOlolo, 2021-06-23 15:27:02

How to host 100+ 1C databases?

Good day.
There is a server computer with +-100 databases, there are many accountants who connect to the databases on the server from their computers. Because of this, it turns out that everyone enters the bases for a very long time (sometimes for 20 (!) Minutes).
The local network is made in 1 Gbit.
Server on windows (there is an idea that he is to blame for everything, is it so? Is it worth moving to Linux?). Xeon e-2144g processor, 32 GB RAM, raid 1 of 2 disks.
Where should we even look? Cloud solutions from 1C will not work (there is no budget).

Answer the question

In order to leave comments, you need to log in

5 answer(s)
L
LollyFox, 2021-06-24
@LollyFox

The number of infobases in this case does not really matter. The most important thing is how many concurrent users there are, how many in one database, the size of the databases, file or SQL, the way clients connect to the server, HDD or SSD ... - you didn’t specify any of this, and without it there will be guesswork.
If there are more than a dozen users, the file databases are in a shared folder, and the HDDs, then the launch of 20 minutes is quite expected.

Server on windows (there is an idea that he is to blame for everything, is it?

Most likely, but not a fact, that switching to Linux will solve the problem, because. The problem is not with the OS.

D
Drno, 2021-06-23
@Drno

Well, moving to an SSD is a must. You can put 4pcs in raid10.
If the databases are file - it's not surprising that everything freezes .. (judging by the consumption of RAM, it is), especially if they are not small. Translate the databases to SQL... then at least it will upload only the necessary data to the user, and not almost the entire database... and the RAM will immediately take care of the cache and the necessary things))

A
Alexander Chernykh, 2021-06-23
@sashkets

1C loves to be in the terminal, as it happened historically. And if you are already switching to RDP, then the entire working environment of the user needs to be transferred to a terminal server. And this is 1C, client-banks, browsers, documents, etc.
Calculate memory based on 400-600Mg / person (although you may have other numbers, try to get the "fattest" one into the terminal and work). Mine also take 1.5 GB per brother, but the truth is they don’t deny themselves anything
raid1 is good, but raid10 is better
Karoche, you need a budget, whatever one may say

V
VitalyChaikin, 2021-06-23
@VitalyChaikin

Sometimes such a lag occurred when one of the users printed to his printer and now, at the entrance to 1C, he somehow tries to find this printer, but it is not there (it is turned off at the moment). It was observed during terminal work.
So check out this option.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question