First American Puts Microsoft SQL Server 2005 to the Test

Santa Ana, Calif. - The principal subsidiary of The First American Corp.--First American Title Insurance Co.--has formed a strategic alliance with Microsoft Corp., Redmond, Wash., for early testing of Microsoft SQL Server 2005 using First American's FAST Transaction System (FAST) database.FAST is an integrated title and escrow system that unifies disparate systems into a centralized database and is currently one of the largest SQL Server 2005 implementations with more than 4 terabytes of data. Microsoft encouraged First American's FAST development team to test SQL Server 2005 against one of the largest and most complex databases available. Using a version of FAST with all personal information removed, Microsoft was able to validate SQL Server 2005 and improve system capabilities, ensuring that the new release of SQL Server will be "FAST Certified" at the product launch on Nov. 7, 2005.

"We wanted to stress test SQL Server 2005 in some of the most challenging, data intensive environments possible," says Paul Flessner, senior vice president for SQL Server at Microsoft. "With more than 4 terabytes of data and over 850 million rows of information, FAST qualifies as one of the largest and most complex databases in the world."

"As a leader in not only title insurance but also in diversified business information, having the right back-end systems to support our business solutions is critical," says Larry Godec, senior vice president and CIO at First American Title Insurance Co. "Key to this is having all of this data readily accessible across multiple sites, managed from a single server. With the enormous size of FAST, very few systems are capable of handling this according to our needs."

First American originally deployed FAST in 2002 into a centralized database hosted on a 32-bit computer with 32 processors. With the rapid growth of the FAST database, CPU utilization soon surpassed 80%. The company upgraded its mission-critical FAST system to a 64-bit solution with Microsoft Windows Server 2003, Datacenter Edition and Microsoft SQL Server 2000 Enterprise Edition (64-bit), running on an HP Integrity Superdome with 32 Intel Itanium 64-bit processors. Today, the centrally hosted SQL Server database supports 15,000 users in 1,300 offices.

Source: The First American Corp.

For reprint and licensing requests for this article, click here.
Analytics Core systems Workforce management Policy adminstration Data and information management
MORE FROM DIGITAL INSURANCE