January 15, 2012 at 8:24 am
I was given a VM Machine and it is to home to a Data Warehouse on one instance and Several Relational Databases on another instance.
The Relational DB's are used for reporting.
I need to make a case for RAID configuration for the machine I was provided has three disk with different sizes which is a problem.
I'm concerned about potential performance and bottleneck issues.
Any thought would be greatly appreciated.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
January 17, 2012 at 12:29 pm
Welsh Corgi (1/15/2012)
I was given a VM Machine and it is to home to a Data Warehouse on one instance and Several Relational Databases on another instance.The Relational DB's are used for reporting.
I need to make a case for RAID configuration for the machine I was provided has three disk with different sizes which is a problem.
I'm concerned about potential performance and bottleneck issues.
Any thought would be greatly appreciated.
In regards to different size drives for a RAID configuration, my understanding is that it can be done but you are limited by the size of the smallest drive.
Are these three disks allocated to your VM or are they shared by other VMs on the same physical host?
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply