Not sure if I'm explaining this properly but I have 5 physical drive.
2 physical drisks map to 1 logical drive C - This I'm using for OS and SQL Server
3 physical disks map to 1 logical drive D - This I want to use for .MDF and .LDF
Is it worth creating additional logical drives so my files would split up like the below:
Drive D - .MDF files
Drive E - .LDF files
Drive F - tempDB .LDF file
Drive G - tempDB .MDF file
Drive H - .NDF files
Somehow I think it won't make a difference as these additional drives are not physical drives but does anyone know if I can get better performance by having these extra LUNs?
---------------------------------------------------------
It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens[/url]
Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn