Have a look at the SQL built in tools for Performance tuning the new
database and that could help out.
Also make sure the SQL Server is setup correctly ie. correct memory &
If all else failes, run it on another server, if the performance is
good, reinstall the 'new environment OS & SQL Server'.
"Viktor Elvar" <viktorim.is> wrote in message
news:uwDoXVHRDHA.1556TK2MSFTNGP10.phx.gbl...server> Hi there I have a strange problem. I developing an application on myadvanched> SQL Server 2000 which is running on a 1 Gb memory and 2 GHz W2000Gb> server. The app. it self is running on my local computer 400 Mhz 256 Mb
> memory and it running wery vell. But when I put the application up on a
> different environment the SQL Server runs on a 1700 Mhz Computer with 1much> in memory and the app. is 1500 Mhz 1 Gb memory. There I have a strange
> speed problem. The database are the same, I took the databasefile and
> appended it on the new environment so it should be the same, but it is> slower and even gets timeout's. Does anyone have had similair problems or
> does anyone have any solution to this? Any configs on the new environment
> SQL server or the application server? I know this is not wery good
> information, but it is the only thig I can provide!!
> With best regads VEV