Hi A Client has a machine : 4 x 3ghz Zeon 4 gb Memory Windows Enterprise Server 2003 SQL Server Enterprise Sp3 (it also has some form of Raid which I am waiting for more details on) The db is about 1gb on a 20gb drive with 16gb free. which takes 191 seconds to run a particular query. This machine is doing nothing else apart from running SQL Server, not even Anti Virus software. My local machine : 1 x 3ghx P4 1 gb Memory Windows XP Pro Sp2 SQL Server Personnal edtion Sp3 takes 73 seconds to run exactly the same query. Both machines have the same database on them and the query was run through Query Analyser. On paper the client's machine should be upto 4x faster rather than almost 3x slower. The client has had a 3rd party check the machine who say it is working fine. Does anybody have any ideas what could be causing this kind of difference?