Re: FN-FORUM: Sql Server performance
date posted 25th July 2005 20:07
In addition to more RAM, having a dedicated physical hard drive for
SQL server will also boost performance. The data and log files can be
put there If you want to go crazy you can go for 3 physical drives.
one for windows, and one each for the sql server data files and the
transaction logs. Its best to keep the OS drive separate, as the OS
swap file activity will also affect SQL server.