HomeMy WebLinkAboutRFP - P 858Administrative Services
rurcnasing vivision
Request for Proposal P•858
DEMONSTRATION OUTLINE
Please follow the outline when demonstrating your product. At the end of the outline, you will
have an opportunity to demonstrate any features and functions that weren't mentioned in the
outline and set your product apart from the competition.
If you have any questions concerning the outline, please contact Michelle McDonough at
mmcdonouah(afcaov com or (970)221-6369.
Part I — Company History
Please talk briefly about your company history, products and philosophies concerning Database
Management Tools.
Part II — Architecture Diagram
So there some context on where things will be loaded and running and the communication that
will be taking place, please provide an Architecture Diagram that shows Servers required for
your Products, clients, monitoring agents, communication standards. Do the servers need to
be dedicated to your product? Include any minimum requirements on the servers or clients.
Please use the grid below that describes the City of Fort Collins environment.
Please describe any future plans to support other platforms and databases. Do you plan on
supporting open sources databases like MySQL or Postegres in the future?
The City of Fort Collins is looking at replatforming some of their current databases, how does
that work for licensing, do we get full credit for the one that was already purchased when
switching to another platform?
Please discuss any plans for web based monitoring if you don't already have it and what web
application server are being looked at for the future. Currently the City's standard is Apache
with the server side programming being done in PHP.
Vendor Products
Please include the following
DB Oracle
DB MS SQL
OS HP-UX
OS NT 4.0
OS W2k
products for the servers listed in the grid:
DB Control for JDE and Internet Server
215 North Mason Street • 2nd Floor • P.O. Box 580 • Fort Collins, CO 80522.0580 • (970) 221-6775 • FAX (970) 221-6707
City of Fort Collins Production Database Environment
Please use the following revised information for providing information.
Server
Server 1
Application
JDE
Operating
S stem
HP-UX 11.0
#
Processors
2
Database
And Version
Oracle 8.1.6
Managed
Instances
1
# of
DBAs
4
Server 2
DTS
HP-UX 11.0
1
Oracle 8.1.6
1
4
Server 3
Sire
HP-UX 11.0
1
Oracle 8.1.7
1
4
Server 4
Intranet
HP-UX 11.0
1
Oracle 9.0.1
1
4
Server 5
Pinnacle
MS NT 4.0
1--Oracle
7.3
1
2
Server 6
Fleet
MS NT 4.0
--1---Oracle
7.4
1
2
Server 7
Internet
MS NT 4.0
1
Oracle 8.1.6
1
2
Server 8
Sales Tax
MS NT 4.0
1
SQL Server 7
2
Server 9
Centennial
MS NT 4.0
1
SQL Server 2000
--2-
-2- 11 /22/02
Part III — Features and Functions
Monitoring
Please demonstrate the following:
o Database processes running
o Number of transactions per second
o Number of transactions committed
o Number of queries executed
o Number of changes to the redo log file
0 Used database file space below a user -defined threshold
o Operating system disk space free
o Operating system disk space used
0 Number of active users
o Number of inactive users
o Caches
o SGA for Oracle
o Identification of alert log errors
Performance
Please demonstrate how your product identifies the following:
o Delays caused by redo log space requests
0 Locks blocking other sessions, indicating tables and users
0 Transactions that must wait on rollback segments for completion
o Other waits
0 1/0 bottlenecks on database files
o NT
Disk
• CPU
• Memory
o Unix
Disk
• CPU
• Memory
o 'Bad" SQL Queries
o Database fragmentation or needed reorganization of tablespaces
- 3 - 11/22/02