January 14, 2004 at 11:15 am
Does anyone have any experience with the 64-bit version of SQL Server 2000 Enterprise Edition?
This is my first experience with it, and I was supprised to learn that no GUI tools ship with it. (Microsoft recommends that you log onto a 32-bit machine housing a copy of the 32-bit GUIs and connect remotely to the 64-bit version of SQL Server.)
Has anyone seen the 32-bit Enterprise Manager hang after the DBA clicks the "Read from media" button on the "Restore database" Options tab?
Jon
January 15, 2004 at 8:12 am
Jon....
I have been using the 64bit version for about a year now. I have not had any problems with restore operations, however we did not use the Read From Media Option. Please feel free to contact me if can help with anything else.
Scott Barrett
Encore Development of North America
Scott Barrett
January 15, 2004 at 9:10 am
Thanks for the response. We have 40+ SQL Servers and have used the database engine since version 4.21a, but we're just getting started with the 64-bit eval. I got around this problem by killing Enterprise Manager and rebooting.
By the way, have you seen any problems with the 32-bit Enterprise Manager interacting with 64-bit SQL Server? We had some general flakiness on a different Windows 2000 machine when we tried to register a named instance before registering the default instance. After we registered the default instance, the named instances registered okay.
We also saw problems when using a DNS CNAME to point to a disk-based backup device.
In general, do you think 64-bit SQL Server is ready for "prime time?" Do you use it in a Production environment? If so, how many simultaneous users? Have you seen any noticeable performance benefits? What enticed your shop to install and use the 64-bit version of SQL Server?
Jon
January 15, 2004 at 10:53 am
Jon...
It is definitely ready for prime time if you're willing to work around the missing tools and lack of DTS. Short of those problems, everything was fine. You will find the linked servers to anything other than another SQL Server to be very flaky. I use it to support a BI application using 64bit Analysis Services and it hasn't gone down yet. I am supporting over a terabyte of data and multiple cubes over 50gb in size each as well as basket analysis. All this running and you can't put a dent in the machine. This is truly a transition point until Yukon is available, and then it's just an upgrade!
Scott
Scott Barrett
January 16, 2004 at 9:30 am
Scott,
I assume that you need to download a 64-bit version of SP3a for this version of SQL Server. I looked for it on the Microsoft site, but did not find it. Do you have a URL?
What about MDAC? Same situation?
Jon
January 17, 2004 at 6:03 am
There is no service pack for the 64bit versions. The MDAC upgrade is done on initial installation of the server, but is not different on the client. All clients must have SP3 to connect using the 32 bit tools. If you are already up to date with your 32bit installations, you should be ready to go to use the 64bit servers!
Scott
Scott Barrett
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply