Server periodically freezing - Help Stabilizing

Posted by JonDog on Server Fault See other posts from Server Fault or by JonDog
Published on 2013-11-01T18:49:38Z Indexed on 2013/11/01 21:57 UTC
Read the original article Hit count: 167

Filed under:
|
|

We run an asp.net/sql server data collection website with a hand full of clients dumping data in and running reports. We moved to a new server (specs below) and have had issues with it freezing and having to reboot it a dozen times over the pass six months. The hosting company has mentioned possible causes (listed below) but cant give a definite answer on what is going wrong. They have offered to reconfigure how ever I like. We have benefited from having a much faster system and really dont want to get rid of the ssd's unless they are the issue. Two possible setup changes that I've talked with them about are also listed below.

Any suggestions on what maybe causing the freezing issue as well as suggestion on a new setup would be great.

My main questions are: Do SSD generally have problems running the OS & SQL Server on the same RAID Array? and Are the new SSD's still unrefined enough to be running in a production environment?

Thanks

Current:
Xeon Quad Core E3-1270 3.40 Ghz
16 GB DDR3-1333 ECC SDRAM
First Hard Drive: 120GB Intel SSD
Second Hard Drive: 120GB Intel SSD
Third Hard Drive: 120GB Intel SSD
Fourth Hard Drive: 120GB Intel SSD
SAS 4 Port RAID Card
Windows 2012 Standard Edition - 64 Bit
MSSQL 2008 Web Edition

Possible Causes:
Running Sql Server & OS on same RAID Array
OS Software Issues
Using SSD's
CPU Underpowered
Not enough RAM


Option 1
2x Xeon Quad Core E5-2603 1.80 GHz
16 GB DDR3-1333 ECC SDRAM
1 x 240GB Intel SSD - OS
3 x 1 TB SATA HDD (7200 RPM) - SQL Server
SATA 4 Port RAID Card
Windows 2012 Standard Edition - 64 Bit

Option 2
Dell PowerEdge E3-1270v2 3.5GHz 4 Cores
16 GB DDR3-1600 UDIMM
4 x 128 GB Samsung 840 Pro SSD
Add-in H200 (SAS/SATA Controller), 4 Hard Drives - RAID 10
Windows 2012 Standard Edition - 64 Bit

© Server Fault or respective owner

Related posts about Windows

Related posts about sql