Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I have an application using an SQL Server DB for it's data.

Simply put, I can run the code pointing to a local SQL Server(2008). Performance SUCKS BALLS. One particular move function takes about 22 seconds to return.

Same code, same function, with the ONLY change being to the underlying ODBC connection to a remote machine running the same version of SQL server, configured essentially the same (they're both development machines with copies of client DB's, with the same OS ad hardware..), the same function using the same DB(remote) completes in about 2.5 seconds.

Any ideas? I've already tried different combinations of Shared Memory/Named Pipes/TCP-IP along with restarts of the services and modifications of the ODBC settings accordingly.

XP SP3/ Intel P4 3.2 gHz 3GB RAM w / PAE

share|improve this question
1  
What is the hardware of the 2 machines also OS. Please edit your question with this info. –  t1nt1n Feb 17 '12 at 20:49
2  
What else do you run on both machines? Like "I run visual stzudio local, eating half of the memory of my pathetic small 3gb ram mchine while the remote machine has 3gb for sql server only". –  TomTom Feb 17 '12 at 21:45
    
c'mon buddy. I work for someone else who buys the hardware. I was kinda hoping for an intelligent answer. Doncha think anyone besides you knows enough to know both machines have roughly the same workload and configuration before posting inane questions(or responses)? –  Mike Dickerson Feb 17 '12 at 21:50
5  
That's a pretty adversarial response, Mike. What TomTom is pointing out is that you don't clearly define the workloads of each system. For (his) example, a SQL server with 3G of RAM running only SQL Server is going to outperform a local system running other client applications, a full Visual Studio environment, the SQL Server Management Console and SQL Server 2008. Additionally, have you used tools like PerfMon to look at general system metrics (Memory, Disk I/O, etc.)? Event Log errors in System or Application? –  Kyle Smith Feb 17 '12 at 22:16
1  
you should get the execution plan for the two environments and compare them. –  Elroy Flynn Feb 18 '12 at 23:45
add comment

2 Answers

You should do some performance monitoring on both systems at the OS level. I'm assuming both systems are running off local or direct storage. Clearly you have something different between the two. Verify that they both have the same software, patches, and processes/services running. Look through your event logs to see if there is something going on with the system that could be slowing it down.

share|improve this answer
add comment

Perhaps the remote server has more up to date and appropriate indexes or other differences.

share|improve this answer
add comment

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.