COMP 4677 Project 1

You work for artificial 'ABC Retail' company as Database Administrator/Architect. Company operates

worldwide and have several data centers. You are tasked to come with proposal for the new SQL Server

installation. Following are requirements that you should take in account:

-

Number of employees/users: 3000

-

Operational time: 24 hours/day, 7 days/week

-

Potential database size: 600GB

-

Yearly database growth: 200GB

-

Monthly data change: 400GB

-

Users profile:

o

Different regional settings

o

Different time zones

o

Different OS

Windows 7

Windows 8

Windows 10

Linux

Apple/Mac

Your assignment have two parts, planning and practical installation.

Planning

Documentation should include detailed specifications with explanation, as well as resources used, for

each:

-

Host server

o

HW

Processor

Number of cores

Memory

Underlying disk devices (RAID selection)

o

SW

OS, including SP level

OS Edition

Disk drive line up

o

SQL Server

Version

Edition

Disk drive/folder allocation for data and log files

Server configuration option