Data Files and Log Files - SQL Server Forums

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 2005 Forums

SQL Server Administration (2005)

Data Files and Log Files

Author

Topic

amsqlguy
Yak Posting Veteran

89 Posts

Posted - 2009-02-18 : 13:57:36

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 : 14:00:40

I don't have the answer to your question, but one thing that can significantly help is by optimizing tempdb. How many data files do you have for tempdb? How many CPUs can SQL Server see?

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

Subscribe to my blog

saurabhsrivastava
Posting Yak Master

216 Posts

Posted - 2009-02-19 : 23:29:21

Fibre channel drives are faster. Smaller FC disk 76GB would result in faster READ/WRITE operation than 300GB FC drives, message is go for several smaller drives rather one big to improve IO.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources