February 18, 2009 at 11:58 am
Guys,
I have four read and write intensive databases on the same instance. I am currenlty having data files two of them on one Physical drive and data files for other two of them on second physical drive. Same is the case with my log files. is this the right way to do it. Also for databases which have both read and write intensive operations is it is advisable to have data files SAN Fiber channel drives or SATA drives
Any suggestions and inputs would help.
Thanks
February 18, 2009 at 2:10 pm
Best thing would be to have each log on a separate physical drive and, if possible each data file on a separate physical drive
RAID or single disks?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
February 19, 2009 at 7:42 am
It is a SAN disk, is it advisable to have all the data files for the 4 databases on single disk and log files. Should tempdb be always on seperate disk
Thanks
February 19, 2009 at 7:46 am
It is always better to have TempDB on a separate Physical disk. Regarding the 4 DB files being on separate disks, Yes it is a good idea. You can go one step further by creating file groups for Data and Indexes separate for each DB (Thats what I have read...).
Maybe the Gurus here can give more advice regarding that.
-Roy
February 19, 2009 at 8:13 am
am (2/19/2009)
It is a SAN disk, is it advisable to have all the data files for the 4 databases on single disk and log files. Should tempdb be always on seperate disk
I'm not quite sure what you're asking, but the best config (and it's not always attainable) is to have each data file and each log file on its own separate physical array.
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply