Re: Intanium
From: Andrew Madsen (andrew.madsen_at_harley-davidson.com)
Date: 05/24/04
- Next message: mark: "Re: problem converting nvarchar column to datetime"
- Previous message: Aaron Bertrand - MVP: "Re: Can I output the result of sp_spaceused to a table ?"
- In reply to: Drackewl: "Intanium"
- Messages sorted by: [ date ] [ thread ]
Date: Mon, 24 May 2004 09:54:07 -0500
We recently did a proof of concept using HP Itanium based servers to see if
we could gain any performance in our data warehouse. We found we gained a
major hit in Analysis Services and a minor increase in the regular database
operations. MSAS is memory intensive and we could run parallel processes in
the 64-bit world. We also could consolidate servers because of the 16
exabyte memory availability.
If we did a lot of memory caching or loading of the database we got good
increases in the speed of a regular database but not enough to warrant the
use of Itanium servers for that function. All-in-all the higher processor
speeds for a regular RDBMS in the 32-bit world made up for the memory issues
you find there. But if you have that high end BI type of database function
then IMHO 64-bit is the way to go.
-- Andrew C. Madsen Information Architect Harley-Davidson Motor Company "Drackewl" <anonymous@discussions.microsoft.com> wrote in message news:100bc01c43f0a$a69ff460$a601280a@phx.gbl... > Does anybody have an opinion on these Itanium servers for > SQL 2000? Is the investment worth the speed for a mid- > size company? Or, will P4 multi-processors with a tonnes > of RAM, possibly load-balanced do the trick? The problem > I have is not the cost of the Itanium server it's the > cost of both Win2K Adv & SQL Enterprise. > > Presently I have a quad PIII Zeon 1000 MHz with 5GB RAM. > We have this one SP to process our manufacturing data > which takes 6 hours to complete. Can anybody estimate > what the results would be with an Itanium server? > > Thanks in advance! > Brad > > >
- Next message: mark: "Re: problem converting nvarchar column to datetime"
- Previous message: Aaron Bertrand - MVP: "Re: Can I output the result of sp_spaceused to a table ?"
- In reply to: Drackewl: "Intanium"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|