SQL Server in Professional Services

See how companies are using SQL Server to run their most demanding applications, make better decisions, and get faster results. Read more SQL Server 2005 case studies. Or, search the Microsoft Case Studies site to find examples that are relevant to your business.

High Volume Transactions (10K+TPS)

Brandimensions

Affinity Systems, a Microsoft® Certified Partner, developed a system for Brandimensions that monitors the Internet to track and help protect brands. Rather than using an Oracle database, the solution relies on Microsoft SQL Server™ 2005. the Brandimensions database holds approximately 64 billion links mapped for 8 billion URLs and 210 million Web sites—more than 8 terabytes of data. It maintains 7,000-10,000 transactions per second and crawls 750 million Web pages each month. The solution is designed to crawl up to 2 billion sites per month with minimal cost increases and no software changes.

RedPrairie

Based in Milwaukee, Wisconsin, RedPrairie has been helping companies better manage their warehouses for more than 30 years. Although about 95 percent of its customers used to deploy RedPrairie solutions using the UNIX operating system, the trend has reversed in recent years with now more than 70 percent asking for solutions running on Microsoft® Windows Server® 2003 operating system. RedPrairie needed to ensure that even its global customers—processing some 500,000 order lines per day—could run their warehouse management solutions using Microsoft SQL Server™ 2005 Enterprise Edition (64-bit) database. The company tested SQL Server 2005 and found it could support loads of more than 550,000 order lines per hour, it was executing up to 11,000 Transaction SQL (T-SQL) statements per second.