December 16, 2004 at 1:15 pm
Hello,
I have just installed SQL server 2000 Developer edition on 4 different machines.
The first machine is a DELL Lattitude D600 Notebook with 1.25GB of RAM and a 1.4GHZ processor.
The second machine is a Workstation with a 3.2GHZ processor, 2GB or RAM and a RAID 5 hard drive
The third machines is a DELL Lattitude D600 Notebook with 1.25GB of RAM and a 1.4GHZ processor.
The fourth machine is a Workstation with a 3.2GHZ processor, 2GB or RAM and a RAID 5 hard drive
Both machines have Windows XP SP2
We are running the same query on all machines but suprisingly the DELL laptops are running the query in 2min and the workstations are running it in 21min. I have not changed the configuration of either SQL Server instances. Is there something i am missing regarding the configuration of running the query on a laptop opposed to a more powerful workstation.
Any help would be greatly appreciated.
Cheers,
Ismail Qadry
December 16, 2004 at 2:57 pm
COuld be a number of things. Did you use the same connection for the workstatiosn and laptop or where the networks different? What other processes were running on each machine. The biggest issue I usually see when large differences occurr is the amount of available memory at the time of execution for the dataset to be loaded or the networks are extrememly different 10MB versus 100MB. You should in standard see better performanc on the Workstation as long as the queries are exactly the same, use profiler and see that sql is running the queires the same, if that is truely the case then there is some other bottleneck involved and since you say raid 5 hard drvie I assume scsi which should be faster but CPU also could be a factor depending on the L1 and L2 cache. I am thinking thou it will be memory or network related most likely.
December 16, 2004 at 3:07 pm
Thanks for the info.
Just for some clarification. The queries are running on the local machine of each install rather than over a network. The same number of processes were running on each of the machines so there was no difference there.
On the workstations we moved the database to reside on the C: drive rather than the RAID drive and it still ran for 20min. So i dont think the RAID is causing any problems.
It's very odd because the databases are exact copies rather than being rebuilt so i would imagine that the queries are running the same. I will use profiler and check to make sure though.
My first guess was the memory but i'm not quite sure.
December 16, 2004 at 3:25 pm
Definently see if everything is occurring the same with Profiler, also take a look at the execution plan on each machine to see if something is happening different with the way it is accessing the data. And use task manager to see what the memory in use looks like.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply