Seperate drives for SQL install
New SQL 2016 server install on Virtual server--windows . Is it still necessary for a separate drive for tempdb? I am thinking of separate drives for data and log.
Inputs appreciated. Windows server 2016
Inputs appreciated. Windows server 2016
Last Comment
Read through this article and you should get a better idea. I'm more of a split drive kind of guy. App on primary drive, data on another drive, logs on third.
https://www.brentozar.com/archive/2017/06/separating-data-log-files-make-server-reliable/
https://www.brentozar.com/archive/2017/06/separating-data-log-files-make-server-reliable/
On the physical server side the VM is running on, can you define different physical drives for the logical ones?
If not, no matter how many logical drives you have, they will be running on the same physical ones.
If not, no matter how many logical drives you have, they will be running on the same physical ones.
ASKER
Slightwv..
---On the physical server side the VM is running on, can you define different physical drives for the logical ones?
Can you please explain this further for me.. so that I can enquire?
I am not sure what the answer is but will check with the Infrastructure team
thanks
---On the physical server side the VM is running on, can you define different physical drives for the logical ones?
Can you please explain this further for me.. so that I can enquire?
I am not sure what the answer is but will check with the Infrastructure team
thanks
When you create a virtual server you assign one or more virtual hard drives to go with it.
Depending on how you ask for the virtual drives, they may all be on the same drives on the physical disk subsystem.
Unless the administrators of your virtual environment can ensure each logical drive in on different physical drives, splitting them up on the VM side doesn't get you anything.
Depending on how you ask for the virtual drives, they may all be on the same drives on the physical disk subsystem.
Unless the administrators of your virtual environment can ensure each logical drive in on different physical drives, splitting them up on the VM side doesn't get you anything.
ASKER
Thanks for the explanation----very helpful
--Unless the administrators of your virtual environment can ensure each logical drive in on different physical drives, splitting them up on the --VM side doesn't get you anything
In your opinion, Should I ask the virtual admin to put each logical drive on a different physical drive(if that is not the case already) or better put is it worth it at all splitting log and data files for SQL Database in the VM world?
--Unless the administrators of your virtual environment can ensure each logical drive in on different physical drives, splitting them up on the --VM side doesn't get you anything
In your opinion, Should I ask the virtual admin to put each logical drive on a different physical drive(if that is not the case already) or better put is it worth it at all splitting log and data files for SQL Database in the VM world?
ASKER CERTIFIED SOLUTION
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Thanks for your inputs
ASKER
--I cannot speak to SQL Server best practice because I'm not a SQL Server DBA ---
Any other inputs from SQL DBA's
Any other inputs from SQL DBA's
ASKER
Thanks
Windows OS
This topic area includes legacy versions of Windows prior to Windows 2000: Windows 3/3.1, Windows 95 and Windows 98, plus any other Windows-related versions including Windows Mobile.
129K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
TRUSTED BY
https://docs.microsoft.com/en-us/azure/virtual-machines/windows/sql/virtual-machines-windows-sql-performance