Windows 7 with SQL Express 2005

[SSiUser]

We have a test computer that we are using to test out various software applications. This one in particular uses SQL Express 2005. The test computer is Windows 7 Pro, 32-bit OS - 2 GB RAM - 2.40 GHz processor. Is there any known issues relating to the speed of an insert/read from SQL 2005 with Windows 7? I can put the same application on an XP machine and the database reads/writes are quick; but on the Windows 7 machine, they take quite a few seconds (~15). SQL Server is local on the test computer.

 

[jimbo45]

Hi there
put the DB indexes on to the fastest disks , as well as some very often accessed table spaces -- especially if these are used primarily for READ.

I think your problem isn't the SQL or Windows 7 but probably the hardware.

Your XP running system has probably been reasonably optimized for running the SQL or might have SCSI or fast disks - without knowing the hardware its impossible to say.

Your W7 machine might have horribly slow disks in it too -- this will slow down considerably ANY complex DB query.

If you can beg borrow or steal (did I say that) an SSD and can get the Windows page file and the DB indexes on to it it will FLY like greased lightning.

Cheers
jimbo