Transcript Microsoft`s Worldwide Marketing Database with Windows 2000

Microsoft’s Worldwide Marketing
Database with Windows 2000
Datacenter Server
Scaling Up to the Needs of the
Worldwide Marketing Database with
Windows 2000 Datacenter Server
Published December 2001
Agenda







Company Overview
Solution Overview
Products & Technology
Business Challenge
WWMDB Infrastructure
Solution
Using Windows 2000 Datacenter Server to
Fulfill Business Requirements
 Deploying the ODS on Windows 2000
Datacenter Server
 Future Plans
Company Overview
 Sales, Support and IT (US-SSIT)
 Responsible for all systems and system support
that sustain the Microsoft sales force and support
organizations
 500 people maintaining 1,800+ servers
comprising the sales and support tools
infrastructure
 Worldwide Marketing Database (WWMDB)
 Result of the migration of core Microsoft
marketing contact information from 3rd-party
vendor to an in-house application
 1.8TB Microsoft SQL Server 2000 -based system
 One of the largest, single-server SQL Server
2000 implementations in the world
Solution Overview
?
Situation





Separate and disparate customer database solutions.
Integration with a large number of heterogeneous applications.
Process 2 million records per day.
Decentralized business in 60 subsidiaries of various sizes
Solution

The Worldwide Marketing Database, one of the largest Microsoft SQL
Server 2000 systems in the world.
Benefits
!



Faster time to market (8 weeks).
Increased performance (53%).
Consolidated, up-to-date customer information from 54 sources into a
single 1.8 TB SQL Server system, one of the largest SQL Server systems in
the world.
Products and Technology
 Windows 2000 Datacenter
Server
 Microsoft SQL Server 2000
Business Challenge
 WWMDB (specifically the ODS) provides
Microsoft with a comprehensive view of each
of its customers
 Keeping up with customer information growth
presented several technical challenges due to
ODS processing lag
 Two separate reporting infrastructures, one
proprietary database application and a 3rd-party
application, ran on separate servers introducing a
significant degradation in performance
WWMDB Infrastructure
 Accepts input from 54 different sources
 Leverages two data consolidation, cleansing and
standardization tools
 Uses relational Operational Data Store (ODS)
for standardizing data in preparation for
perpetual storage
 Up to 18 concurrent jobs, 8 SQL Server load
jobs, and 12 SQL Server standardization jobs
required to support daily record loading
 Three databases (150 GB, 990 GB, and 530
GB)
Solution
 US-SSIT Managers explored
two solutions
 Six-month development effort to
revise and tune the applications
on existing systems to achieve
30% greater performance
 Implement Windows 2000
Datacenter Server/Unisys
ES7000 system solution
“We moved to the
Datacenter/ES7000
platform through
necessity; our older
systems did not have the
power to do the job. And
by making this move, we
have enough processing
power to both load our
current data sources and
support new initiatives and
marketing business that
require data to be cross
referenced with current
information.”
Jon Elliott
Director
US-SSIT Production
Microsoft Corporation
Using Windows 2000 Datacenter Server
to Fulfill Business Requirements
 Microsoft consolidates customer information from a vast assortment of internal
and external sources


All marketing data from contacts between customers and Microsoft is recorded in
WWMDB
Supporting Microsoft’s worldwide CRM database and DSS is a monumental task
 US-SSIT used available technology
 Implemented system running on 8-way and 4-way servers with 8GB of RAM
 Windows 2000 Datacenter Server allowed scaling through support for 32 processors
and 64 GB of RAM
 Current implementation runs on 16-way Unisys ES7000 with 32 GB of RAM leaving
room for further scaling
 Processes upwards of 2 million records per day, up from 500,000 previously
 Windows 98 and Windows 2000 registration processing was caught up in four
months after implementation, from a seven-month lag
 Provide up-to-date customer information from a single 1.8 TB SQL Server
system in a master database
Deploying the ODS on Windows
2000 Datacenter Server
 Increased SQL Server 2000 performance due to
linear performance scaling through 32
processors
 30% increase in transactional throughput
 Greater processing power and memory support
eliminates the need to send large amounts of
data across the network
“By consolidating both applications on a single 16-way server,
we are able to get an additional 22% increase in performance.”
Jon Elliott
Director, US-SSIT Production, Microsoft Corporation
Moving Forward on Windows
2000 Datacenter Server
“We moved to the
Datacenter/ES7000
platform through
necessity; our older
systems did not have the
power to keep pace with
our growth. By making
this move, we have
enough processing power
to both load our current
data sources, and support
new initiatives and
marketing business that
require data to be cross
referenced with current
information.”
Jon Elliott
Director
US-SSIT Production
Microsoft Corporation
 Separate the marketing
infrastructure from the customer
lookup infrastructure and have
two separate functions
performed on the
Datacenter/ES7000 server

Marketing information

Customer master for all internal
Microsoft applications
For More Information
 Additional IT Showcase white papers, case
studies, and presentations on ITG
deployments and best practices can be found
on
http://www.microsoft.com.
 Microsoft TechNet
http://www.microsoft.com/technet/itshowcase.
The information contained in this document represents the current view of
Microsoft Corporation on the issues discussed as of the date of
publication. Because Microsoft must respond to changing market
conditions, it should not be interpreted to be a commitment on the part of
Microsoft, and Microsoft cannot guarantee the accuracy of any
information presented after the date of publication.
This document is provided for informational purposes only.
MICROSOFT MAKES NO WARRANTIES, EXPRESS OR IMPLIED, IN THIS
DOCUMENT.
© 2001 Microsoft Corporation. All rights reserved.
This case study is for informational purposes only. MICROSOFT MAKES NO WARRANTIES, EXPRESS OR IMPLIED, IN THIS SUMMARY.
Microsoft, Active Directory, Windows and Windows NT are either registered trademarks or trademarks of Microsoft Corporation in the United
States and/or other countries. The names of actual companies and products mentioned herein may be the trademarks of their respective owners.