Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.


Windows 7: Windows 7 with SQL Express 2005

04 Feb 2010   #1
SSiUser

XP
 
 
Windows 7 with SQL Express 2005

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.


My System SpecsSystem Spec
.
05 Feb 2010   #2
jimbo45

Linux CENTOS 7 / various Windows OS'es and servers
 
 

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
My System SpecsSystem Spec
Reply

 Windows 7 with SQL Express 2005




Thread Tools




Similar help and support threads
Thread Forum
sql server 2005 installation fails on windows 7
Hi, sql server installation fails on windows 7. Any ideas to resolve this problem.
Software
SQL server 2005 and Windows 7
Hi, I would like to know if it's possible to run SQL server 2005 Developer edition under Windows 7 x64. My Vista installation is messed up so I want to try clean install of Windows 7 but I need SQL server 2005 working.
Software
Sql server express 2005
Okay this is driving me batty and any help y'all could offer would be most appreciated!! I have an old (2002-era) proprietary program I use for work that ran FINE on 32-bit XP without any special tweaking. It also runs fine on 32-bit W7 on my laptop. I couldn't get it to install normally in...
Software
Win 7 Network Libraries SQL Server Express 2005
Hi all, Mod from SQLTeam.com/forum suggests that I am unable to start SQL Server Express 2005 due to problem with Win 7 Network Libraries SQL Server Forums - SQL Server 2005 Express Login Here is the output of the event log from the last time I tried to start SQL Server Thanks -winston...
Network & Sharing
Windows Messenger 5.1 with OCS 2005
Hello, is it possible to connect with windows 7 and Windows Messenger 5.1 to a OCS system? We use XP with messenger 5.1 and OCS and plan to migrate to windows 7. Perhaps anyone of you have any hints for me. Thank you
Software
SQL 2005 Tools and Windows 7
Does anyone know if SQL 2005 tools will work on a system with Windows 7 OS?
Software


Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

© Designer Media Ltd

All times are GMT -5. The time now is 00:27.

Twitter Facebook Google+



Windows 7 Forums

Seven Forums Android App Seven Forums IOS App