SSD Disk

heca

Has anyone tried to use SSD disks to increase performance? If so what was the outcome?

Marije_Brummel

I know someone that tried and he told me that after that, CPU became the big bottleneck.

Are you really sure you have tried everything else? SSD is not really cheap. :?

ara3n

Mark Brummel wrote:

I know someone that tried and he told me that after that, CPU became the big bottleneck.

That's something I have to see to believe it.

Marije_Brummel

AFAIK it was a 700 user system.

One of my customers has 600 users on NetApp and I can confirm that CPU can become a bottleneck.

You are welcome to visit when you are in Holland. 8)

heca

I know there are lots of things you could do first. But anyway if CPU becomes the bottleneck, then Nav performance could start evolving with Moores law. =D>

ara3n

Mark Brummel wrote:

AFAIK it was a 700 user system.

One of my customers has 600 users on NetApp and I can confirm that CPU can become a bottleneck.

You are welcome to visit when you are in Holland. 8)

Have you by any chance disabled a lot indexes? and sql has to sort them at run time?

I was at a client site, where they were running a report and it would take quad cpu to 90 %. The reason was that a key was disabled on sales invoice header table and the report was sorting on it.

Marije_Brummel

No. that's not the case.

Savatage

Bringing back this post. It's almost time for a new server and I was wondering if anyone is using solid state disks instead of SCSI 15k

Marije_Brummel

Yep here.

Results are amazing.

Problem though, because going to disk is so fast, once users start complaining about performance you have something real bad.

Savatage

Can I believe this WIKI?

Compared with electromechanical disks, SSDs are typically less susceptible to physical shock, are much more quiet, and have lower access time and latency.[6] However, while the price of SSDs has continued to decline in 2012,[7] SSDs are still about 10 times more expensive per unit of storage when compared to HDDs. Although they are very damage proof, current SSDs have been known to crash very occasionally.

Do they crash very occasionally?

Do you have them setup in a raid?
Have you had issues with them during power failures?

davmac1

To add to the new question - I have been reading that SSDs cannot handle as many lifetime writes as a hard disk. Is that true with the new SSDs? If it is, is that a concern with a SQL Server database - journal tables will get lots of updates for example.

Marije_Brummel

The SSD at my customer is in RAID10 and been running now for 2.5 years without failure.

It's a TMS system where we handle 1500 shipments per day, both 24hrs distribution delivery in Benelux and groupage transport in Germany/Denmark. Everything EDI, e-invoicing etc. In other words, heavily used system.