It is not a Hardware problem. The SQL Server 2000 Machine
which is slower is configured to 512 MB RAM 866 MHZ
Processor (Intel) and has an 16 GB HDD. Also I want to
mention that this server is not dedicated.
After all We resetup the machine but the queries running
slower more than ever. At this time we use SQL 7.0 Because
it is more fast so our work is going on.
After that we will probably stay on this solution because
there is nothing else to do.
Thank you for replying
>Using LIKE with a wildcard at the beginning ( '%xxx')
will always force a
>table scan no matter how many idexes you have. So if
it's slower on one
>machine than the other it is most likely due to the
hardware setup. The
Quote:>second machine probably has slower disks and or less
ram.. If you run it
Quote:>several times you should get the table into cache
(assuming it all fits) and
Quote:>then it will be mostly be how fast can the processor
filter out all the bad
>rows from the good ones.
>Andrew J. Kelly, SQL Server MVP
>> Hi all, I have the following problem:
>> I have the same Database ( inc. Indexes, data,
>> etc) on one machine which has SQL Server 2000 SP1 and in
>> one with SQL Server 7.0 SP2. My problem is that
>> queries to the sqlserver 2000 database they are very
>> slower than the same queries on SQL 7.0 Database. I am
>> using a query like " Select * from table where column
>> like '%case%' " The Execution time on the first server
>> 30 seconds and on the second is 5. Can anyone help me
>> that? can anyone describe me why 's that delay?
>> What is going wrong. The machines was clean before the
>> Server Installations and they followed the same
>> Installation Plan.
>> Also the machine with the SQLServer 2000 has More RAM ,
>> Disk Space and a better Proccessor