Click here to Skip to main content
15,607,737 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
My query is running very very slow on one server but works fine on another. System settings are identical(hardware configuration, OS , Sql Server settings ...). It is not about query, I tested different queries and still got the same results. Anyone know what is going on ?


You must analyze the query execution plan to realize where the problem are.

Analyzing a Query

Share this answer
Angela Lucchesi 16-Apr-13 5:13am    
Thanks @JAFC
Hello Angela

I suggest you to check performance on the Database Indexes (fill factor, fragmentation... check index key columns and included columns), windows log to find any error related to disk that is causing you trouble... RAM, motherboard, RAID status.

Compare rpm of your servers hard drives vs size of the larger table involved on your query.

Does the query problem occur when you run it locally or remotely (through a program using ADO for example)?
Does it use linked server or openquery to another server?

Best regards.
Share this answer
Any errors ? Try to reinstall SQL Server. You may also want to check your hard drive. Are there any other processes running on the second server? Have you tried running performance counters and checking what specifically is causing the slowdown?

Share this answer

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900