Quote:
Originally Posted by DaFace
Intel Zeon CPU D-1540 @ 2.00GHz x 16 plus 128 GB RAM. I can't see much more than that in WHM. (I mean, we have 2TB hard drive space, but I'm not sure the specs of the drives or the configuration.)
|
I am not a DBA but I play one in my job and I was always told by actual DBA's is that you have to make sure that you have enough RAM plus some for growth so that all DB's sizes are less than what you have in RAM. I think you said this server holds multiple db's so that would be my first place to look.
Second SSD's for data would make a huge difference but the transaction logs need to be on a separate drive and you should probably keep that on your typical hdd because of the sequential read\write's that happen with trans logs.
A properly configured SQL server has separate drives (non OS) for data, one for logs, and possibly one for tempdb.