R_P
February 8, 2023, 12:08pm
1
Hi All,
I am planning to buy Ignition Gateway Server & Sql Server with below spec.
Dell
Power Edge R450 Motherboard with Broadcom 5720 Dual
Port 1GB On-Board LOM, Intel Xeon Silver 4309Y 2.8 G,
8C/16T,10.4GT/s, 12M Cache, Turbo, HT(105W) DDR4-2666,
RAID 1, Windows 2019 Standard, 16 CORE, Digitally Fulfilled
Recovery image, Multi Language, Keyboard and Mouse
Microsoft Sql Server 2019 - Standard Edition - 2 core pack
Anybody has used sam config? Pls let us know feedback to move ahead
pturmel
February 8, 2023, 12:30pm
2
How much RAM will the Ignition Gateway have?
What hardware are you going to put the SQL Server on? How much storage will it have?
How many tags will your application have? And how many of those will be OPC tags? How many of these tags will be set up for history, and at what pace?
How many Vision clients will you be supporting?
How many Perspective clients will you be supporting?
What is the resolution and max time frame of the trends these clients will be displaying?
{ The Dell hardware is decent, as far as you've shown. Tech people I respect have low opinions of Broadcom Ethernet chipsets, fwiw. }
R_P
February 8, 2023, 1:02pm
3
Thanks for quick response. Pls find below spec. i m planning now for server as per tags requirement
How much RAM will the Ignition Gateway have? - 16 GB
What hardware are you going to put the SQL Server on?
Intel® Xeon® Silver 4309Y 2.8G, 8C/16T, 10.4GT/s, 12M Cache, Turbo, HT (105W) DDR4-2666
How much storage will it have? - 1.2 TB SAS HD
How many tags will your application have? 5000 Tags
And how many of those will be OPC tags? 2000 OPC UA
& 3000 AB/Siemens
How many of these tags will be set up for history, and at what pace?2000
How many Vision clients will you be supporting?NA
How many Perspective clients will you be supporting? 12 Nos
What is the resolution and max time frame of the trends these clients will be displaying? 15 min
I'd get more RAM for both gateway and SQL server. 16GB is pretty thin for that number of Perspectve clients. I wouldn't get less than 64GB for each, and configure Ignition to have ~32GB. The rest looks fine.
I don't ever buy or deploy Microsoft software, but I wonder if you can install a 2-core SQL Server license on an 8-core machine. Might want to check on that. Or not use SQL Server (I wouldn't).
1 Like