October 8, 2008 at 8:35 pm
We have a complex query that is causing problems, pegging the CPU on our development server. On my localhost i run the query in Management Studio, and it runs in 25 seconds. Connecting to the dev box and running the same query takes over 4 minutes to run.
My local machine looks like:
Windows XP Professional, Service Pack 2
Intel CPU, 2.00 GHz
2 GB of RAM
SQL Server 2005
The dev box looks like:
Windows Server 2003, Service Pack 2
AMD Athlon 64 X2 Dual Core Processor 4600+ 2.41 GHz
2 GB of RAM
SQL Server 2005
On my local machine, SQL Server is using ~500MB of RAM, and on the dev box it's using ~1.4GB. There isn't much else that's happening on the dev box, it's a dedicated server.
Can someone provide a little guidance for what i can do to troubleshoot this and figure out why the performance is so bad on the dev box?
Thanks for your time.
October 9, 2008 at 12:15 am
Hi,
check the following:
- are both databases the same size?
- check the two query plans. Are they the same?
- are other queries running in development machine?
Good luck
PSA
October 9, 2008 at 2:01 am
Also check:
- SQL version (equal ?)
- physical drive design, location of datafiles/logfiles
- statistics
- index fragmentation
Wilfred
The best things in life are the simple things
October 9, 2008 at 11:04 am
Hi
Is both the SQL servers are 32 bit?? if the server one is 64 bit try to set max memory for SQL server
Cheers
🙂
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply