question about partitions and Sql Databases
Our sql server is a VM with vmware. I know that the classical way to set up partitions for a sql server was to have 3 partitions.
1) for the os
2) for the mdf
3) for the ldf files
I have also heard that since vmware has came to prominence that this is not a big concern anymore. meaning.... you can responsibly run a sql server install on 2 partitions now.
1) os
2) mdf and ldf
Can someone confirm that it is ok to run sql servers with either setup. currently we are choosing the second way of setting up our sql servers, but i have a vendor that is highly recommending that we go to the classic 3 partition setup.
Thanks a bunch!
1) for the os
2) for the mdf
3) for the ldf files
I have also heard that since vmware has came to prominence that this is not a big concern anymore. meaning.... you can responsibly run a sql server install on 2 partitions now.
1) os
2) mdf and ldf
Can someone confirm that it is ok to run sql servers with either setup. currently we are choosing the second way of setting up our sql servers, but i have a vendor that is highly recommending that we go to the classic 3 partition setup.
Thanks a bunch!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Correct, Partitions are old fashioned, and should no longer be used really for virtual machines!
e.g. if you have two partitions per virtual disk, C: and D:, how do you extend C: drive ?
Answer with difficulty.
In terms of performance it's going to make no difference.
3 Partitions, will make it easier to manage.
As for disk space, it should not matter, however because your VMware Guys live in the dark ages, expanding disks will make their life harder and a headache.
So 2 or 3 whatever makes you feel more comfortable.
e.g. if you have two partitions per virtual disk, C: and D:, how do you extend C: drive ?
Answer with difficulty.
In terms of performance it's going to make no difference.
3 Partitions, will make it easier to manage.
As for disk space, it should not matter, however because your VMware Guys live in the dark ages, expanding disks will make their life harder and a headache.
So 2 or 3 whatever makes you feel more comfortable.
ASKER
virtual disks are something i have no control of. i am able to request 3 partitions from the vmware guys or 2. thats the only criteria i could choose.
i would rather choose 2... its easier to manage disk space that way.