SQL Server 2000
I am at best here a "user" when it comes to SQL. Which of course makes me the most qualified to handle this *sigh*
We have a Windows 2003 R2 x64 bit server running the 32bit version of SQL Server 2000 we inherited.
I thought you can't use the 32bit version on a 64bit OS? I noticed the performance logs are not working. Related? Any other issues I might run into?
We have a Windows 2003 R2 x64 bit server running the 32bit version of SQL Server 2000 we inherited.
I thought you can't use the 32bit version on a 64bit OS? I noticed the performance logs are not working. Related? Any other issues I might run into?
-Daniel
Comments
-
bertieb
Member Posts: 1,031 ■■■■■■□□□□
It'll run in 32bit mode. I've only seen it once and had the same issues as you have. Didn't experience any other issues but it wasn't a heavily utilised system.
As for the counters, see if you can launch perfmon in 32 bit mode. There aren't any SQL 2000 x64 counters, so they wont appear in x64 perfmon. There is an article somewhere, I'll see if I can find it.
Edit: http://social.technet.microsoft.com/Forums/en-US/sqldatabaseengine/thread/3432292b-d25a-4659-8983-8497e1b0a0c0
PS Get it upgraded to SQL2005/SQL2008 x64
The trouble with quotes on the internet is that you can never tell if they are genuine - Abraham Lincoln