Posted by Erland Sommarskog on 09/29/88 11:25

Mohamed Gad (mohamed.gad@gmail.com) writes:
> the database are the same, I made a backup from the developement one and
> restored it to the Test one,

Thanks. That is valuable information. It would have been a good idea
to include that originally, to avoid unnecessary speculation.

> so, it should be all the same, I don't know what's going wrong, but,
> I'll do some Monitoring for some counters and I'll share the results
> with you, maybe we could reach somewhere.

Did you ever post the queries and the query plans?

It's difficult to give good advice with so little information. I would
definitely look into setting up a second instance on the dev box, and
install SP4 on it, to see whether the service pack is part of the equation.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp

[Back to original message]