Posted by Erland Sommarskog on 12/11/06 22:34

mike (vettes_n_jets@yahoo.com) writes:
> I agree with you michael....the excuse (reason) i was given is that they
> did not trust sql64 at the time...just out of beta

Now, wait! The only sql64 that in beta alone was Liberty, the 64-bit
version of SQL 2000. If that version was an option for them, it means
that your 64-bit box is an Itanium machine. As far as I know there is
quite a performance penalty running 32-bit programs on Itanium.

It's a different thing, if the machine is an x64 box. Particularly, if
you are running SQL 2000, since there is no x64 version of SQL 2000.
If you are running SQL 2005, the 64-bit version is still to prefer, I
guess, but there is no direct penalty for running the 32-bit version
on x64.

> but the system waas moving along ok....and all of a sudden, come to a >
> crawl running same as before this super slow down

The cause could very well be that the query plans for some common queries
have gone awry.

I would run profiler and capture events that run more than, say, 100 ms.
The events to include are RPC:Completed, SQL:BatchCompleted, SP:Completed,
SP:StmtCompleted and SP:Recompile.


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

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]