ВС
виртуализировать. Как клиенты будут подключаться - тонкими клиентами с личных ПК или RemoteApp/RDP? Размер ИБ?
Тонкими. 58Гб.
Size: a a a
2020 August 20
I
Всем привет. Поделитесь из опыта конфигами железа на сервер для postgresql + 1c сервера на centos для ~100 единовременных коннектов. И как лучше сделать, все на одном или на разные разнести? Спасибо.
Xeon >3300Ghz 64Gb Ram, nvme диски, база не большая, будет летать
СГ
Xeon E2176, 64 RAM, 2 x SSD (enterprise nvme). Ну можно памяти до 128, хотя и 64 хватит на мой взгляд. Это одна конфигурация или несколько?
СГ
Xeon >3300Ghz 64Gb Ram, nvme диски, база не большая, будет летать
+++
ВС
Xeon E2176, 64 RAM, 2 x SSD (enterprise nvme). Ну можно памяти до 128, хотя и 64 хватит на мой взгляд. Это одна конфигурация или несколько?
Одна. А лучше на одной машине или разнести 1с сервер и бд?
СГ
Одна. А лучше на одной машине или разнести 1с сервер и бд?
виртуализировать. но СУБД лучше в контейнере сделать или на самом хосте
СГ
у неё самая большая нагрузка на диск будет. Для остального виртуализация не страшна
СГ
виртуализировать. но СУБД лучше в контейнере сделать или на самом хосте
потом при необходимости намного проще будет масштабироваться - ВМ с 1С-сервером просто уедет на отдельную железку
SZ
и не забыть настроить правильно постгрю, иначе и при таких ресурсах все будет лагать безбожно
П
и не забыть настроить правильно постгрю, иначе и при таких ресурсах все будет лагать безбожно
А если за тюнинг не хотять платить?
SZ
А если за тюнинг не хотять платить?
ну заплатят потом куда больше, гы
П
Как правило так и происходить
ВС
Спасибо.
DR
*question 1*
Design a database for school management system. This system will be able to perform following functionalities: System could register the different classes having information like class id, class name System could register students having information like their registration number, name, father name, class name, phone number and address. System could register teachers according to their qualification having information; id, name, cell no, qualification and salary. System could register subjects having information like subject id, subject name and credit hrs. In this system user can allocate one and more than one subjects to every teacher. System could keep the record of results of every students having information like student_regno, student name, subjects, obtained marks, total marks and status (fail/pass). System could manage the fee records of students having information like; student name, class name, month, payment date, paid amount. System could keep the record of attendance of every students on daily basis having information like; student_reg_no, student name, attendance date, status(present/absent). Question (part a): draw complete normalize ERD of the above mentioned requirement. Identify primary key and relationship degree of table if having. Question: (Part b) Convert these relational tables (which you create in solution of question no 1) into logical database (in Microsoft Sql Server) and then make a diagram (ERD) from your Sql server. Name of this database must be your Name & registration number as mentioned in University Portal like (Haseeb_1403). Insert 3 rows in each table. Upload your Diagram (ERD pic) in Answer sheet. And also write the sql syntax of table creation and insertion etc in answer sheet. Note: In part b answer you have to write queries which you have written for table creation and data insertion. & then at the end
Design a database for school management system. This system will be able to perform following functionalities: System could register the different classes having information like class id, class name System could register students having information like their registration number, name, father name, class name, phone number and address. System could register teachers according to their qualification having information; id, name, cell no, qualification and salary. System could register subjects having information like subject id, subject name and credit hrs. In this system user can allocate one and more than one subjects to every teacher. System could keep the record of results of every students having information like student_regno, student name, subjects, obtained marks, total marks and status (fail/pass). System could manage the fee records of students having information like; student name, class name, month, payment date, paid amount. System could keep the record of attendance of every students on daily basis having information like; student_reg_no, student name, attendance date, status(present/absent). Question (part a): draw complete normalize ERD of the above mentioned requirement. Identify primary key and relationship degree of table if having. Question: (Part b) Convert these relational tables (which you create in solution of question no 1) into logical database (in Microsoft Sql Server) and then make a diagram (ERD) from your Sql server. Name of this database must be your Name & registration number as mentioned in University Portal like (Haseeb_1403). Insert 3 rows in each table. Upload your Diagram (ERD pic) in Answer sheet. And also write the sql syntax of table creation and insertion etc in answer sheet. Note: In part b answer you have to write queries which you have written for table creation and data insertion. & then at the end
DR
*question 1*
Design a database for school management system. This system will be able to perform following functionalities: System could register the different classes having information like class id, class name System could register students having information like their registration number, name, father name, class name, phone number and address. System could register teachers according to their qualification having information; id, name, cell no, qualification and salary. System could register subjects having information like subject id, subject name and credit hrs. In this system user can allocate one and more than one subjects to every teacher. System could keep the record of results of every students having information like student_regno, student name, subjects, obtained marks, total marks and status (fail/pass). System could manage the fee records of students having information like; student name, class name, month, payment date, paid amount. System could keep the record of attendance of every students on daily basis having information like; student_reg_no, student name, attendance date, status(present/absent). Question (part a): draw complete normalize ERD of the above mentioned requirement. Identify primary key and relationship degree of table if having. Question: (Part b) Convert these relational tables (which you create in solution of question no 1) into logical database (in Microsoft Sql Server) and then make a diagram (ERD) from your Sql server. Name of this database must be your Name & registration number as mentioned in University Portal like (Haseeb_1403). Insert 3 rows in each table. Upload your Diagram (ERD pic) in Answer sheet. And also write the sql syntax of table creation and insertion etc in answer sheet. Note: In part b answer you have to write queries which you have written for table creation and data insertion. & then at the end
Design a database for school management system. This system will be able to perform following functionalities: System could register the different classes having information like class id, class name System could register students having information like their registration number, name, father name, class name, phone number and address. System could register teachers according to their qualification having information; id, name, cell no, qualification and salary. System could register subjects having information like subject id, subject name and credit hrs. In this system user can allocate one and more than one subjects to every teacher. System could keep the record of results of every students having information like student_regno, student name, subjects, obtained marks, total marks and status (fail/pass). System could manage the fee records of students having information like; student name, class name, month, payment date, paid amount. System could keep the record of attendance of every students on daily basis having information like; student_reg_no, student name, attendance date, status(present/absent). Question (part a): draw complete normalize ERD of the above mentioned requirement. Identify primary key and relationship degree of table if having. Question: (Part b) Convert these relational tables (which you create in solution of question no 1) into logical database (in Microsoft Sql Server) and then make a diagram (ERD) from your Sql server. Name of this database must be your Name & registration number as mentioned in University Portal like (Haseeb_1403). Insert 3 rows in each table. Upload your Diagram (ERD pic) in Answer sheet. And also write the sql syntax of table creation and insertion etc in answer sheet. Note: In part b answer you have to write queries which you have written for table creation and data insertion. & then at the end
Hey guys
Hello me
Hello me
dd
Please ask the questions russian language
dd
It's russian language xhat room
dd
Xchat=chat
is
*question 1*
Design a database for school management system. This system will be able to perform following functionalities: System could register the different classes having information like class id, class name System could register students having information like their registration number, name, father name, class name, phone number and address. System could register teachers according to their qualification having information; id, name, cell no, qualification and salary. System could register subjects having information like subject id, subject name and credit hrs. In this system user can allocate one and more than one subjects to every teacher. System could keep the record of results of every students having information like student_regno, student name, subjects, obtained marks, total marks and status (fail/pass). System could manage the fee records of students having information like; student name, class name, month, payment date, paid amount. System could keep the record of attendance of every students on daily basis having information like; student_reg_no, student name, attendance date, status(present/absent). Question (part a): draw complete normalize ERD of the above mentioned requirement. Identify primary key and relationship degree of table if having. Question: (Part b) Convert these relational tables (which you create in solution of question no 1) into logical database (in Microsoft Sql Server) and then make a diagram (ERD) from your Sql server. Name of this database must be your Name & registration number as mentioned in University Portal like (Haseeb_1403). Insert 3 rows in each table. Upload your Diagram (ERD pic) in Answer sheet. And also write the sql syntax of table creation and insertion etc in answer sheet. Note: In part b answer you have to write queries which you have written for table creation and data insertion. & then at the end
Design a database for school management system. This system will be able to perform following functionalities: System could register the different classes having information like class id, class name System could register students having information like their registration number, name, father name, class name, phone number and address. System could register teachers according to their qualification having information; id, name, cell no, qualification and salary. System could register subjects having information like subject id, subject name and credit hrs. In this system user can allocate one and more than one subjects to every teacher. System could keep the record of results of every students having information like student_regno, student name, subjects, obtained marks, total marks and status (fail/pass). System could manage the fee records of students having information like; student name, class name, month, payment date, paid amount. System could keep the record of attendance of every students on daily basis having information like; student_reg_no, student name, attendance date, status(present/absent). Question (part a): draw complete normalize ERD of the above mentioned requirement. Identify primary key and relationship degree of table if having. Question: (Part b) Convert these relational tables (which you create in solution of question no 1) into logical database (in Microsoft Sql Server) and then make a diagram (ERD) from your Sql server. Name of this database must be your Name & registration number as mentioned in University Portal like (Haseeb_1403). Insert 3 rows in each table. Upload your Diagram (ERD pic) in Answer sheet. And also write the sql syntax of table creation and insertion etc in answer sheet. Note: In part b answer you have to write queries which you have written for table creation and data insertion. & then at the end
Where is the question?😁 How w much money u need too create this system on 1c app?
a
доброго утра
коллеги, по какой причине могла слететь лицензия в конфигуруции с выделенным сервером лицензий?
есть две виртуальные машины в 1с кластере, обе на centos7 - postgres+1c и сервер лицензирования c активированным многопользовательским ключем
коллеги, по какой причине могла слететь лицензия в конфигуруции с выделенным сервером лицензий?
есть две виртуальные машины в 1с кластере, обе на centos7 - postgres+1c и сервер лицензирования c активированным многопользовательским ключем