In a hurry, how to choose the right SQL server?

If you have money, just buy a server, my company's membership card server uses LenovoT260, less than 10,000 pieces, Xeon quad-core 2G memory, dual 250G hard disks for RAID, so that the data will be very safe, and the data of a bad hard disk is still there.

If funds are tight, you can match a machine by yourself, the data server does not have high hardware requirements, CPU can choose E5300, 2G memory, buy *** point of board, recommend ASUS or Gigabyte, dual hard disks, RAID card. Such a machine will be done in less than 2000. Be sure to do RAID, so as to ensure that the hard disk is broken without losing data.

Then you estimate, how much each piece of data occupies, about how many pieces of data, for the insurance period, a little larger than your budget.

It depends on the amount of data you want to retain.

The size of each piece of data, how long the data will be retained, and how many data there will be, is better under a large budget.

These sizes determine how big a server you need.

The 1st floor is equipped with 1w blocks, which is really dark.

1. After installing the SQL database on the local disk, store the data on the local disk, about 500M space is enough (recommended).

2. If the software is internet access, it is recommended to look for data companies on the network, they will provide database space for users to use! (Not recommended, because these materials are very precious, it is not recommended that others keep them for you!) ）

3. If you want to assume the server independently, agree with the answer on the first floor.

You can estimate how many members there are currently, how many members will be added every month, and how much data will be generated by monthly members. Membership management is generally 100m-200m is basically enough, and you should pay attention to data backup at ordinary times.

win2003 server,win7 is best not,Because its compatibility is poor,And everyone does not recognize his stability,There are a lot of patches,The server is best to have fewer patches,Less operation on it,1,Yes,But you need to connect to programs such as olddb and so on2, win server pays attention to security and stability,Other focus on compatibility3,Yes It must be the same network segment,The same gateway。

4 Through single sign-on technology, multiple systems are integrated in BS, which is EIIS, you see J2EE, but this is difficult and requires a lot of underlying knowledge.

SQL server, 10 clients are not very many, but because it is a database application, the performance requirements for processors and hard disks are relatively high.

You can take a look at this dual-socket quad-core server from the domestic brand Zhengrui. Standard configuration of a 32nm Xeon E5606 quad-core processor (cache), Intel 5500 server chipset motherboard, 2G DDR3 reg ECC 1333MHz memory, SAS 300G 15000 rpm enterprise-class hard disk (4 hot-swappable bays) can add or replace hard disks without shutdown, dual Gigabit network cards, the performance can be said to be very good. If you feel that the performance is not enough as the business grows in the future, you can also expand to two processors to reach 8 processing cores, and support up to 48GB DDR3 reg ECC high-speed fault-tolerant check memory.

Product model: I247789S-E

Product type: Dual-socket four-core tower server.

Processor: XEON E5606

Memory: 2G DDR3 reg ECC

Hard disk: SAS 300g

Agency: Tower.

Price: 7999

Silver service. Chongqing five-year free door-to-door service, three-year national free door-to-door service, key components more than three years free warranty.

It is recommended that you increase to 4GB memory, two SAS 300G hard disks for RAID 1 array, the total price is about 10,000 yuan, so that even if the hard disk is broken, the data will not be lost, which is very safe. The likelihood of both hard drives breaking at the same time is too low.

What I recommend to you is the server products of the domestic brand Zhengrui, their products are very cost-effective, the workmanship is very professional, compatibility, quality and the like are guaranteed, and the after-sales service is also perfect, 3 years of free warranty, 3 years of free door-to-door service, and the reputation in the industry is very good.

Dell R710 is good, only more than 10,000, good cost performance!

Depending on your situation, I think the Dell T110 or IBM X3250 will do! **All within 10,000 yuan, T110 is cheaper, about 6K, X3250** in 8K! Personally, I prefer IBM's !!

I think dell is more suitable,dell's t110 xeon quad core x3430 this is enough,ibm's is too expensive,the difference is more than 2k! What is the configuration I send you a message for? ~