Home Forums SQL Server 2005 Administering Sql Server (Recommended) Configuration Settings : 2000 & 2005 RE: Sql Server (Recommended) Configuration Settings : 2000 & 2005

  • In general the defaults are pretty good and in most cases shouldn't be changed unless you have a good reason. The exception is the max memory if the server in question has lots of memory (which your doesn't)

    It's usually recommended that the OS, the SQL data file and the log files all go onto separate physical drives. You only appear to have one drive, so that's not possible.

    p.s. Please post in the appropriate forum next time

    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

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass