Hardware is:
KingSton 8 g of pure ECC DDR3 1600 KVR16E11/8
Intel C204 S1200BTL mainboard chipset original box
Intel xeon V2 E3-1230
Intel SSD S3700 100 g SSDSC2BA100G301 original package
Intel SSD S3500 80 g SSDSC2BB080G401 original package
Huntkey navigation jia rock 520 power rating (420 w)
Intel original 4 full copper heat pipe copper bottom PWM mute fan CPU radiator 1150
Intel original independent card
The software is:
Windows 2008 r2 + SQL 2008 r2
No group of Raid, but different SQL backup every day (full backup)
This machine running, basic didn't restart, there would be two or three times a year off electricity to restart a, air conditioning room 7 * 24,
Is the so-called "ecomax" bold, Intel was more stable, faster, you also said that system could be benefited from the SSD
-- -- -- -- -- -- -- -- -- -- - in the invincibility of line -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Now the time came, want to set more than one play, and SQL 2008 R2 + win2008 R2, don't know how to configure this? Below is the Intel website
Hardware is:
Intel Server Board S1200SPL
Intel Xeon Processor v5 E3-1230
4 u Intel Server Chassis P4304XXSFCN
Intel Remote Management Module 4 Lite 2
Intel SSD DC S3510 Series
16 gb DDR4 ECC UDIMM, supporting 2133 MT/S memory
The basic don't know what is memory models
Now the question is:
1) if I use environment is workshop air conditioning room, assembly line operation basic few seconds into a data, then the SSD eat xiao? Do you want to have a array card
If you need 2) hard RAID, then two SSD group RAID 1 can? Whether to need to consider with caching and batteries? With that kind of cache? The Flash?
3) using the write back or write my use or insert is given priority to, main query is complementary,
4) SSD group raid 1, whether to need to consider the TRIM, because there is no TRIM raid 1, only the raid 0, so worry more with more slowly, but also some people said that Intel's data center level of SSD, basic is MLC, basic can ignore the TRIM, is that true?
5) I am ready to assemble two, two using SQL (release, subscription) to achieve two Server database synchronization problem, whether it is feasible?
The above is my question, it comes to matters of software and hardware, experienced people, please advise, if there are any inappropriate pay off points out!
thank you
CodePudding user response:
1) the machine has been running for 2 years, whether can consider cloud? Now on the cloud is more convenient, and the reliability is high,
2) a few seconds to insert a data for SQL Server 2008 is no problem, and you are the SSD, this problem don't worry,
3) would you consider the problem of low more with more Suggestions can optimize the database, such as increasing some index, or on the table in the business do break up, such as data on the monthly table storage,
These are some humble opinion,
CodePudding user response: