Real experiences with 64 bit SQL Server

I am about to buy some database hardware, and am considering buying a
dual 64-bit opteron server. In the past, we have run been running the
32-bit version of SQL Server 2000.

Has anybody tried the new 64-bit version of Sql Server 2000? Can we
assume that something that works in the 32-bit world will work in the
64 bit, or are we going to spend time debugging Microsoft code? Also,
which flavor of 64-bit windows operating system did you use?

Any experiences you want to share are much appreciated...
-Cheers,
RichardFirst, we don't support the AMD Opteron processor, yet. I believe that we
might with a future service pack. The following site,
http://www.microsoft.com/sql/64bit/...info/sysreq.asp, says we only
support the Itanium 2 processor.

Once past that, please have a look at the following two KBs for information
regarding 64-bit Tools and DTS support:

http://support.microsoft.com/?kbid=813953
http://support.microsoft.com/?kbid=810927

--
Sincerely,
Stephen Dybing

This posting is provided "AS IS" with no warranties, and confers no rights.

"Richard" <rvlasimsky@.voneconsulting.com> wrote in message
news:d72c60b6.0408260924.6270e6ac@.posting.google.c om...
>I am about to buy some database hardware, and am considering buying a
> dual 64-bit opteron server. In the past, we have run been running the
> 32-bit version of SQL Server 2000.
> Has anybody tried the new 64-bit version of Sql Server 2000? Can we
> assume that something that works in the 32-bit world will work in the
> 64 bit, or are we going to spend time debugging Microsoft code? Also,
> which flavor of 64-bit windows operating system did you use?
> Any experiences you want to share are much appreciated...
> -Cheers,
> Richard|||In article <d72c60b6.0408260924.6270e6ac@.posting.google.com>,
rvlasimsky@.voneconsulting.com says...
> I am about to buy some database hardware, and am considering buying a
> dual 64-bit opteron server. In the past, we have run been running the
> 32-bit version of SQL Server 2000.
> Has anybody tried the new 64-bit version of Sql Server 2000? Can we
> assume that something that works in the 32-bit world will work in the
> 64 bit, or are we going to spend time debugging Microsoft code? Also,
> which flavor of 64-bit windows operating system did you use?
> Any experiences you want to share are much appreciated...

Richard - I appreciate your desire to move into the future, but lets
face a simple truth: Tried and proven are always more stable.

If you want to run a low end server then purchase a Dual Xeon system
based on the ASUS PC-DL Deluxe motherboard. This board supports up to
4GB of RAM, has two RAID (SATA) Controllers, Standard IDE, and 1GB LAN.
When it comes to a low-end server, something that is not based on a Quad
board, the Dual Xeon PC-DL is a screamer. I've built more than a dozen
of these for test labs and two for production environments. If you don't
want to go to the expense of SCSI, consider the Promise SX6000 6 drive
IDE RAID Controller with 128MB of cache. With the SX6000 you can have a
single RAID-5 array (6 x 250GB) IDE base, a MIRROR set (2 x 250GB) on
the Intel SATA RAID Controller) and a MIRROR set (2 x 40GB) on the
standard IDE channel for the OS.

With this system you can run the OS on a 40GB partition, the Database
Log files on the a 250GB mirror and the database data files on a 1.2TB
RAID 5 array. Oh, forgot the most important part - the SX6000, while
being just ATA133 allows for "hot-swapping" IDE drives.

In a chenbro case, with dual 550W PSU's and a DVD+RW drive, and Windows
2003 Standard Server (5 CAL) I can get these for about $4,400 USD.

--
--
spamfree999@.rrohio.com
(Remove 999 to reply to me)