SQL 2008 Express on compressed volume?

• mbp2112

  SSC Veteran

  Points: 244

  More actions

  November 24, 2008 at 8:01 am

  #215670

  Howyadoin,

  I've been brought in to shepherd a back-end migration from Access 2000 to SQL 2008 Express. The Access back-end is terribly overloaded (~30 users) and is constantly hiccupping, therefore I'm going to SQL.

  The server on which Access currently resides is running Win2K Advanced Server and the drive has (to my surprise) drive compression and indexing service enabled. In my past experience, both are generally considered bad in this sort of application. Is there a valid reason to have these enabled?

  Thanks,

  -Mark P.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737226

  More actions

  November 24, 2008 at 8:45 am

  #902529

  Compression makes sense to save space, but if you're that tight on space, the read/write from a DB will be problematic. If you can spare the space, I'd uncompress.