Can Anybody guide me whether DEFRAGMENTING the drive improve the SQL Server performance in general.
What should be the location of the DATABASE files and the TRANSACTION log files.
Should they be in a single drive or seperate drives?
Thanks in advance
Jacx
For best I/O performance they should reside on different drives.HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
No comments:
Post a Comment