Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kamalkishore_in
Yak Posting Veteran
76 Posts |
 Posted - 2002-09-05 : 01:52:39
|
| Hi guys,I am performing some queries on two different servers but it is taking two entirely differnent timings on 2 different servers.One is taking the time of 1 hrAnother is taking the time of 5 Hrs.I need to know that what could be reason. And what are the possible reason for delay.Any help will be appriciated..Thankx and waiting |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2002-09-05 : 01:59:28
|
| Hi!Have the servers got the same hardware, operating system and SQL server version? Are the servers configurations equal? Is the data in the tables queried the same on both servers? Are the tables indexed equally on both servers? Do they have the same workload?Regards,Kalle Dahlberg |
 |
|
|
kamalkishore_in
Yak Posting Veteran
76 Posts |
Posted - 2002-09-05 : 22:56:52
|
| Hi again,Both have everything same. But I need to understand by the term Server Configuration: what all it contains.thankx and waiting for replyThankx again |
|
|
|
AndrewMurphy
Master Smack Fu Yak Hacker
2916 Posts |
Posted - 2002-09-06 : 06:42:02
|
| couple of things....1. compare the query plans on both servers.2. compare SQL Profiler logs on both servers....having activiated them to log the appropriate SQL activities before the queries run.if you problem is SQL related....one or both of those will have the information to the source of the problem. If you don't find something there, then the problem may be a general server performance problem....pointing to something like overall CPU Load, overall disk sub-system performance, memory demand problems. |
|
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2002-09-06 : 07:25:26
|
| What version of sql server?v7sp3+ takes a lot longer than v7sp2- (but has the advantage of working)Check that you are using all processors and have similar memory available.Other than that it's down to indexes, fragmentation, page splitting, logging, ...==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
|
|
|
|
|
|
Same query differs two servers