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 ««12

MDF and LDF locations Expand / Collapse
Author
Message
Posted Monday, October 8, 2012 4:04 PM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 1:26 AM
Points: 42,989, Visits: 36,144
For recoverability, definitely. For performance, maybe. What's the IOPS for the array? What's the required IOPS for the app?


Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1370094
Posted Monday, October 8, 2012 5:27 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, October 9, 2012 5:55 AM
Points: 2, Visits: 8
Not sure. So far this is theoretical. but I'll find out. For now assume reasonably modern equipment.
Post #1370111
Posted Tuesday, October 9, 2012 6:27 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 8:50 PM
Points: 1,242, Visits: 6,672
Consider windows page file, tempdb, db files, and log files as candidates to move.
Also part of the picture is as others point out, what kind of IO patterns there are.
And if this is a dedicated SQL server, or runs other applications.
There also is a balance of cost to service level and recoverability, unless budget is of no concern.

If you have a test environment, and a few extra old disks available (nothing fancy needed), you could set up and move the files.
Then run some load tests.

Lots of things to consider.
I tend to get some local disk for some activity, but have some SAN partitiions carved out for those I need throughput and recoverability on.
You could also search for some of the whitpapers on SQL Server Performance.
They have some very good information, although these tend to be more for those where budget does not play a factor.
I don't have the neeed to load 1 TB in less than 30 minutes.
But it is interesting to see what it takes.
Post #1370363
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse