When running SQL Server coupled with a bepoke frontend we're experiencing serious performance issues when it's run on a dual xeon server with 1Gig Mem.
When exactly the same setup is run on a standard desktop it runs much faster????
Any ideas would be very much appreciated.
Both application and SQL server are running on the same machine.