Windows Databases Make the

 
 
By Matthew Hicks  |  Posted 2003-11-08 Email Print this article Print
 
 
 
 
 
 
 


List"> Winters latest database survey also reveals the rise of new platforms for running the worlds biggest databases. For the first time, a database running on Microsoft Windows reached the top 10 list for transaction processing databases, and Windows database grew the fastest in size. Verizon Communications, which runs its transaction processing database on the Microsoft SQL Server database software on Windows, reached sixth place in size for all environments at 5.3 terabytes. It was the top transaction-processing database on the Windows platform.
"Windows is popular, but it has been seen as not very scalable," Winter said. "While its still not the architecture of choice for the most demanding of environments, its clearly become more scalable."
Database managers at Verizon said they have noticed scalability improvements in more recent version of Microsoft SQL Server. In fact, Verizon faced a doubling in the size of its top database in the past year as it began storing 13 months of data rather than 6 months, said Noah Gomez, lead development database administrator. An upgrade to SQL Server 2000, from SQL Server 7.0, helped Verizon handle the big data jump. The company decided to partition the data into more manageable chunks, and the updated database software provided improved query optimization and query plans for data partitioning, said Jose Amando-Blanco, lead production database administrator. Click here for information on Microsofts forthcoming version of SQL Server, code named Yukon. The company released a prerelease version late last month.
The winning database underlies a customer-care billing application for Verizon and is one of 11 databases, all on SQL Server, that comprise a system it calls Common Office Front End Engine, or COFEE. Three of those other database also reached Winters top 10 list for transaction processing databases on Windows. As the databases have grown so has the need for the Verizon DBAs to closely monitor and manage them. "You want to double your data, but you need to keep the same performance that the customer representatives are used to," Amando-Blanco said. "You need to be more proactive in finding out what the hot spots are on the database and which stored procedures are being called the most." Next page: Who won Winters Top 10?


 
 
 
 
Matthew Hicks As an online reporter for eWEEK.com, Matt Hicks covers the fast-changing developments in Internet technologies. His coverage includes the growing field of Web conferencing software and services. With eight years as a business and technology journalist, Matt has gained insight into the market strategies of IT vendors as well as the needs of enterprise IT managers. He joined Ziff Davis in 1999 as a staff writer for the former Strategies section of eWEEK, where he wrote in-depth features about corporate strategies for e-business and enterprise software. In 2002, he moved to the News department at the magazine as a senior writer specializing in coverage of database software and enterprise networking. Later that year Matt started a yearlong fellowship in Washington, DC, after being awarded an American Political Science Association Congressional Fellowship for Journalist. As a fellow, he spent nine months working on policy issues, including technology policy, in for a Member of the U.S. House of Representatives. He rejoined Ziff Davis in August 2003 as a reporter dedicated to online coverage for eWEEK.com. Along with Web conferencing, he follows search engines, Web browsers, speech technology and the Internet domain-naming system.
 
 
 
 
 
 
 

Submit a Comment

Loading Comments...
 
Manage your Newsletters: Login   Register My Newsletters























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