Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Data Files and Log Files

Author  Topic 

amsqlguy
Yak Posting Veteran

89 Posts

Posted - 2009-02-18 : 13:57:00
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

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-02-18 : 13:58:32
Duplicate, locking thread.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page
   

- Advertisement -