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: 173
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