Database Journal
MS SQL Oracle DB2 Access MySQL PostgreSQL Sybase PHP SQL Etc SQL Scripts & Samples Links Database Forum

» Database Journal Home
» Database Articles
» Database Tutorials
MS SQL
Oracle
DB2
MS Access
MySQL
» RESOURCES
Database Tools
SQL Scripts & Samples
Links
» Database Forum
» Sitemap
Free Newsletters:
DatabaseDaily  
News Via RSS Feed


follow us on Twitter
Database Journal |DBA Support |SQLCourse |SQLCourse2
 

Featured Database Articles

Database News

Posted Nov 7, 2005

AMD64 + MS SQL Server 2005 = a Revolution in Database Solutions

By Linda Cole

AMD is planning a revolution in database solutions. AMD64 and SQL Server 2005 supports database platforms that previously required high-end proprietary servers to run. The combination utilizes the advantages of 64-bit and dual-core technology, providing a comprehensive business environment and an operational environment with smaller, power efficient servers. The immediate benefit to DBAs of moving from single-core to dual-core is the ability to use smaller, more powerful servers to run databases or fewer servers to run applications.

Benchmarks show one AMD 4P Dual-Core server provides comparable performance to some of the 8 processor or single-core servers on the market today, and does it at a smaller cost. The TPC for the AMD 4P Dual-Core servers weighed in at $2.40, while for a comparable 8P server it was just below $6.00.

On the other side of the street, Intel is also offering x86 based processors that are 64-bit and they have been introducing dual-core technology in servers, just as AMD has, but with a different underlying architecture than AMD. AMD calls their architecture Direct Connect Architecture, which allows different components (the processor chips, the memory, the IO chips) to be directly connected together when you build your hardware system. This provides a high-speed environment for moving data around, compared to the Intel technology, which uses an older architecture often referred to as a front-side bus architecture, where all of the processors on the system have to go through one single chip, called the Memory Controller Hub, before it goes out to memory or IO.

"The Legacy x86 architecture tends to have bottlenecks, whereas we provide an infrastructure where the chips are interconnected with technology that allows more even data distribution and flow on the system," said Margaret Lewis, Commercial Software Strategist for AMD. She went on to say, "One of the things the database really needs is for the processor to access data that's in the memory banks of the computer as fast and efficiently as possible. One of our big revolutions is to provide what we call an Integrated Memory Controller."

The Integrated Memory Controller provides fast memory access that helps improve application performance. The CPU has dedicated bandwidth for memory, and low latency. In addition, bandwidth increases with the addition of CPU's.

In terms of customer success, Margaret Lewis pointed to MySpace.com, a popular social networking and music website. MySpace currently has 32 million users, is growing at a rate of 130,000 new users a day and processing 15 billion transactions daily. Deploying AMD64 and SQL Server 2005 technology provided them with much needed headroom for growth. The 64-bit capabilities improved connections between web servers and databases.

"AMD's 64-bit Dual-Core technology and MS SQL Server 2005 is going to provide a lot of utility to the database world, with people's growing data demands." Stated Margaret Lewis.

For additional information, please visit http://www.amd.com/.



Database News Archives

Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 




Latest Forum Threads
Database News Forum
Topic By Replies Updated
Efficient SQL Server Indexing by Design lcole 0 April 30th, 12:38 PM
Mine Oracle Database, SQL Server and Other Databases with Monarch Data Pump Pro V10.5 lcole 0 April 30th, 12:37 PM
Oracle Database and Oracle Fusion Middleware for Private Social Network Application lcole 0 April 30th, 12:31 PM
Oracle Database Maintains a Stronghold in the DBMS Market lcole 0 April 30th, 12:30 PM


















Thanks for your registration, follow us on our social networks to keep up-to-date