ammounpierre
asked on
SQL ON SSD ?
Hello Gurus
I am to deploy a SQL 2008 ERP in a Hyper-V environment.
What is the best scenario for my HDDs setup ?
I would like to benefit from a SSD Drive to get high performance on SQL.
Do I install the whole VM that contain SQL on an SSD Drive ? Or I install the VM on a "normal" RAID 5 and then the DB on a SSD ?
Thank you
(Windows 2008 R2 Enterprise - Sql 2008/2012)
I am to deploy a SQL 2008 ERP in a Hyper-V environment.
What is the best scenario for my HDDs setup ?
I would like to benefit from a SSD Drive to get high performance on SQL.
Do I install the whole VM that contain SQL on an SSD Drive ? Or I install the VM on a "normal" RAID 5 and then the DB on a SSD ?
Thank you
(Windows 2008 R2 Enterprise - Sql 2008/2012)
Install the VM on normal disk and store the user databases on the SSD, also move the tempdb database to the SSD storage too. master, model, msdb are probably not that necessary.
Also bear in mind that if your bottleneck is CPU or memory this system will not run any faster, this will just affect the read and write performance.
Also bear in mind that if your bottleneck is CPU or memory this system will not run any faster, this will just affect the read and write performance.
ASKER
Thank you for the reply.
The Physical server will be used for many VMs , but they are not "Critical" in terms of speed..(Email mDaemon,File Server,etc...)
I was thinking about a scenario like this...
Can u please confirm if this is the best config. ?
Have SSD for Windows 2008 + Hyper V services. (100GB SSD)
Have all the VMs on Raid 5 (3 HDD SAS 500GB)
Have the SQL VM (Windows+SQL Server+DB) on a separate SSD (3*200GB Raid 1)
Thanks
The Physical server will be used for many VMs , but they are not "Critical" in terms of speed..(Email mDaemon,File Server,etc...)
I was thinking about a scenario like this...
Can u please confirm if this is the best config. ?
Have SSD for Windows 2008 + Hyper V services. (100GB SSD)
Have all the VMs on Raid 5 (3 HDD SAS 500GB)
Have the SQL VM (Windows+SQL Server+DB) on a separate SSD (3*200GB Raid 1)
Thanks
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I dont think you will see any benefit for using the SSD for the OS of this VM. The only benifit i can think is if the system is excessively paging. In which case you are having memory issues anyway.
As per my original post. If feel it would be better to use the SSD for the user databases and tempdb.
From the RAID perspective, RAID 1+0 is probably the best way to go.
As per my original post. If feel it would be better to use the SSD for the user databases and tempdb.
From the RAID perspective, RAID 1+0 is probably the best way to go.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If you want the entire VM to benefit from the SSD, use the entire SSD datastore for OS and Database disk.
I would recommend RAID 10 for performance for any Virtual Machine.