Should I buy an SSD for Windows 2003 R2 SP2 for DB 1C?

T

topbanana2012-06-28 13:46:31

Windows

topbanana, 2012-06-28 13:46:31

Starts to lack hard drive performance when ~10 people work on the terminal server. Now there is a regular sata hard drive without any raid. Is it worth taking an SSD to SATA3 for a database? What about the lack of TRIM support in 2003?

If you take an SSD, then which one?

Reply

Answer the question

In order to leave comments, you need to log in

7 answer(s)

N

Nikolai Turnaviotov, 2012-06-28
@topbanana

I would upgrade to 2008r2, we have a terminal farm, two or three dozen people live on nodes with 2 gigabytes of memory in 1s clients, but the bases live on a different machine.
A server without a raid is equal to downtime and reboot, if the screw dies - it takes a lot of time to restore from backups if the databases are large.
So do not spare 100-200 bucks for a simple hardware raid from an adapter and a pair of 10k speed sas screws, they will be clearly faster than the obviously desktop broom on which everything now lives.
The main thing is to beautifully argue this to the authorities - otherwise, if everything dies and is simple, they will arrange a brainwash for you.
and when there is a paper letter to the management about the need to buy iron, you will take it out of the table and say, “But I warned you, Kozlov!”

R

Roman Kutenko, 2012-06-28
@Sky4eg

Or maybe it's better to build RAID 1 + 0

C

charliez, 2012-06-28
@charliez

without trim and without a hard raid, you run the risk of spending the night with your server, restoring the system and database.
in extreme cases, you can keep the database on an SSD and back it up as often as possible.
I recommend intel 520 series
habrahabr.ru/post/133924/

S

shipovalov, 2012-06-28
@shipovalov

you can try to push the database to a RAM disk (in RAM)

A

amc, 2012-06-29
@amc

IMHO, it's better to take two SSDs and soft-trade / controller in RAID-1. If your 1C file shuts up, especially the seven, then you don’t have enough IOPS, and that’s what SSD will give you. Otherwise, you need to take SAS 15k, which will not be cheap, and the IOPS increase is much less compared to SSD.
State the complete server configuration (platform, processor, memory).

A

Alexander, 2012-06-28
@kryoz

At the expense of TRIM - the problem is solved by virtualizing the 1C server.

I

inoks, 2012-11-06
@inoks

Definitely worth using an SSD. This has been discussed many times
on the 1C forums .