Sunday, March 25, 2012

32bit SQL 2000 to 64bit SQL 2005

We detached a 32bit 2000 db and attached it to 64 bit 2005 server.

We have an Itanium server will all the bells and whistle's, but when we run the loadrunner, the cpu max's at 100%. Even a sp_who2 spikes the CPU.

I ran the dbcc for stats and reindex, I also recompiled all procs.

I've tried it in both the 8.0 and 9.0 compatibility modes with almost no difference.

Can we attach a 32bit 2000 db on a 64 bit server?

Any other suggestions for me to take a look at?

We are suppose to have our POC by EOD, so your help would be greatly appreciated.

Thanks

Susan

Still having same issues.

|||Attaching a 32 bit database to a 64 bit server is supported. Can you look in the SQL log and see if it reports any errors?sql

No comments:

Post a Comment