Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase «««123

Splitting DBs into multiple files for IO spread Expand / Collapse
Author
Message
Posted Wednesday, January 15, 2014 8:19 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Today @ 12:39 AM
Points: 3,136, Visits: 11,494
There is another possibility: Use the four LUNS to create a single volume on the server for the database datafiles.

The data would be spread across the four LUNS automatically by the OS when you create files there, and there wouldn’t be the problem of trying to figure out where the hot data spots are.





Post #1531135
Posted Wednesday, January 15, 2014 11:27 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Today @ 10:50 AM
Points: 6,358, Visits: 13,688
Michael Valentine Jones (1/15/2014)
There is another possibility: Use the four LUNS to create a single volume on the server for the database datafiles.

The data would be spread across the four LUNS automatically by the OS when you create files there, and there wouldn’t be the problem of trying to figure out where the hot data spots are.

That's a really bad idea. To do this requires creating dynamic volumes in windows and then striping a volume across the 4 disks. You're creating a software RAID across LUNS that are already presented from a hardware array (s). The big problem which no one seems to be grasping is that if all the LUNS don't have the same response time you'll get I\O slowdown as the others will have to wait!
Keep it simple!


-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs"
Post #1531243
« Prev Topic | Next Topic »

Add to briefcase «««123

Permissions Expand / Collapse