NOTES

Document Sample
NOTES Powered By Docstoc
					                                                                                 CAPITAL IMPROVEMENT PROGRAM
                                                                      City of Missoula CIP Project Request Form FY 2008-2012

                                   Program Category:                                  Project Title:                                                                          07 Project #       08 Project #

                                   Community Service                                   LeftHand                                                                                                     CS-07




                                                                                     Description and justification of project and funding sources:
                         Implement a LeftHand Networks iSCSI SAN for large scale data storage and redundancy. Data storage demands are growing beyond current capacity. City departments such as
                         Engineering, City Clerk and Police are implementing projects that will require a large volume of digital storage space. Currently all our data storage is on directly attached storage
                         devices. This means we have to backup non contiguous data storage extending backup times, requiring multiple backup agent licenses, multiple backup jobs and inefficiencies in
                         data recovery operations. We currently only have one form of offsite storage which is tape and no offsite redundancy in hardware. With the implementation of this system we would
                         migrate data from direct attached storage to a pooled storage space. This would allow consolidation. We would also be able to take snapshots in time on the data that would allow
                         much closer to real time recovery of lost or corrupt data. This plan also calls for a mirrored system in the basement of the Council Building. The data would be replicated real time
                         to that system. If the system in City Hall were to be lost we could fail over to the system in the basement of the Council Building and have the data back online very quickly.




                                                   Is this equipment prioritized on an equipment replacement schedule?                                           Yes               No                 NA
                                                                                                                                                                  X



                                                                                                Are there any site requirements:
                         Yes we would need a small footprint in the basement of the Council Chambers to build a cage and install a rack suitable for housing the LeftHand storage.




                                                                                       How is this project going to be funded:
                                                                                                                                                                                                Funded in Prior
                                     Funding Source                      Accounting Code                 FY 08               FY 09          FY 10              FY 11             FY 12              Years
         REVENUE




                         MRA                                                                                   985               1,027
                         Parking                                                                               739                 770
                         Wastewater                                                                          1,477               1,540
                         Building                                                                            2,339               2,438
                         General Fund                                                                       37,546              39,140
                                                                                                            43,085              44,915                -                -                  -                 -


                                                                                       How is this project going to be spent:
                                                                                                                                                                                                Spent in Prior
                                     Budgeted Funds                      Accounting Code                 FY 08               FY 09          FY 10              FY 11             FY 12             Years
                         A. Land Cost
         EXPENSE




                         B. Construction Cost
                         C. Contingencies (10% of B)
                         D. Design & Engineering (15% of B)
                         E. Percent for Art (1% of B)
                         F. Equipment Costs                                                                 43,085              44,915
                         G. Other
                                                                                                            43,085              44,915                -                -                  -                 -




                                                                     Does this project have any additional impact on the operating budget:
                                                                                                                                                                                                Spent in Prior
OPERATING BUDGET COSTS




                                     Expense Object                      Accounting Code                 FY 08               FY 09          FY 10              FY 11             FY 12             Years
                         Personnel
                         Supplies
                         Purchased Services                                                                                      6,600              6,600           6,600               6,600
                         Fixed Charges
                         Capital Outlay
                         Debt Service
                                                                                                                 -               6,600              6,600           6,600               6,600               -


                         Description of additional operating budget impact:




                                                                                                                                                                               Preparer's
                                  Responsible Person:               Responsible Department:            Date Submitted to Finance           Today's Date and Time                 Initials         Total Score

                                        David Boring                             IT                              2/15/2007                      3/4/2012 16:52                    DWB                           37


                                                                                          FOR ACCOUNTING USE ONLY:
                                                                                      How is this project going to be budgeted:
Budgeted Funds   Accounting Code   FY 08   FY 09   FY 10   FY 11   FY 12
 Don't forget to spell
check your document
 when you are done!
                                                                    CAPITAL IMPROVEMENT PROGRAM
                                                                                         Project Rating
                                                                          (See C.I.P. Instructions For Explanation of Criteria)
 Program Category:                          Project Title:                                                                                                                           08 Project #

 Community Service                           LeftHand                                                                                                                                  CS-07

               Qualitative Analysis                     Yes          No                                                            Comments
1. Is the project necessary to meet federal,
state, or local legal requirements? This cri-
terion includes projects mandated by Court
Order to meet requirements of law or other                           x
requirements. Of special concern is that the
project be accessible to the handicapped.


2. Is the project necessary to fulfill a con-
tractual requirement? This criterion includes
Federal or State grants which require local                          x
participation. Indicate the Grant name and
number in the comment column.


3. Is this project urgently required? Will de-
lay result in curtailment of an essential ser-
vice? This statement should be checked
"Yes" only if an emergency is clearly indi-                          x
cated; otherwise, answer "No". If "Yes",
be sure to give full justification.


4. Does the project provide for and/or im-
prove public health and/or public safety?
This criterion should be answered "No" un-
less public health and/or safety can be                              x
shown to be an urgent or critical factor.


                                                        Raw
              Quantitative Analysis                    Score                                                                                                                            Total
                                                       Range                                                    Comments                                                    Weight      Score
                                                        (0-3)
5. Does the project result in maximum                                This storage would be initially allocated to GIS maps, Police Video and some records
benefit to the community from the                            1       management. This is a technology that would be built upon to house databases for mission critical          5               5
investment dollar?                                                   applications such a financials, permitting, asset management.


                                                        (0-3)
6. Does the project require speedy
                                                                     The decision point here is between adding/changing out servers with larger storage ahead of end
implementation in order to assure its                        3       of life or starting the migration to shared storage in this iSCSI SAN configuration.                       4               12
maximum effectiveness?


                                                        (0-3)
7. Does the project conserve energy,
cultural or natural resources, or reduce                        -                                                                                                               3                -
pollution?


                                                        (0-2)
8. Does the project improve or expand
                                                                     GIS, records retention/records management and now life in a police car for court evidence are
upon essential City services where such                      2                                                                                                                  4               8
                                                                     integral to the City mission as a public service organization. We also feel this takes a step in the
services are recognized and accepted as                              right direction for disaster recovery and business continuity planning.
being necessary and effective?


                                                        (0-3)
9. Does the project specifically relate to the                        IT is tasked with providing the technologies required by the various service organizations within
City's strategic planning priorities or other                3       the enterprise to meet their strategic and operational goals. We have grown to a point that we feel        4               12
plans?                                                               we must start migrating storage into scalable solutions that larger Cities have gone to before us.


                                                                                                                                                            Total Score                         37
       08 Project #      Project Title:

         CS-07             LeftHand




Date                  Author              Notes
        2/15/2007              DWB        Initial writeup and submittal




Date                  Author              Notes




Date                  Author              Notes
Date   Author   Notes




Date   Author   Notes




Date   Author   Notes




Date   Author   Notes
Date   Author   Notes




Date   Author   Notes




Date   Author   Notes
Date   Author   Notes




Date   Author   Notes




Date   Author   Notes
Date   Author   Notes




Date   Author   Notes




Date   Author   Notes
Date   Author   Notes




Date   Author   Notes




Date   Author   Notes
Date   Author   Notes




Date   Author   Notes




Date   Author   Notes
Date   Author   Notes




Date   Author   Notes




Date   Author   Notes
Date   Author   Notes




Date   Author   Notes




Date   Author   Notes
Date   Author   Notes




Date   Author   Notes




Date   Author   Notes
Date   Author   Notes




Date   Author   Notes
Qty            Desc                                   Part No
           6   NSM 160-2000-A                         N-160-2000-A
           2   CISCO 24 port 3560 Catalyst Switches
           1   Cage
           1   Rack 37 inch deep
           1   Training                               SVC INS 1 3 NSM
SUM


1st Year
           3 NSM 160-2000-A                           N-160-2000-A
           1 CISCO 24 port 3560 Catalyst Switches
           1 Training                                 SVC INS 1 3 NSM
SUM

2nd Year
           3   NSM 160-2000-A                         N-160-2000-A
           1   CISCO 24 port 3560 Catalyst Switches
           1   Cage
           1   Rack 37 inch deep
Unit Price Total Price
$12,795.00 $76,770.00
 $2,200.00    $4,400.00
 $1,500.00    $1,500.00
 $2,830.00    $2,830.00
 $2,500.00    $2,500.00
            $88,000.00



$12,795.00   $38,385.00
 $2,200.00    $2,200.00
 $2,500.00    $2,500.00
             $43,085.00


$12,795.00   $38,385.00
 $2,200.00    $2,200.00
 $1,500.00    $1,500.00
 $2,830.00    $2,830.00
             $44,915.00
Server Name Total Space Gigabytes Space Used Gigabytes    Percent Used
Appsrvnt2                        80                    54         67.50%
ArcIMS                           34                   8.5         25.00%
Attyserver                      262                    40         15.27%
Engserver                       261                  176          67.43%
SDEServer                       470                  220          46.81%
Fax                              59                     7         11.86%
Fileserver1                     261                  202          77.39%
Fireserver                      327                     2          0.61%
MailFrontEnd                     24                     2          8.33%
Mailserver                      225                    13          5.78%
MslaCrtserver                   261                    10          3.83%
Navserver                        58                     4          6.90%
Parkingserver                    58                    16         27.59%
Parksserver                     410                  139          33.90%
Permitserver                    182                    32         17.58%
Policeserver                     56                     5          8.93%
Rdpserver                        73                     3          4.11%
SMSserver                       327                    17          5.20%
Sqlserver1                      230                    90         39.13%
SQLsrvnt2                       164                    96         58.54%
Termserver2                      55                   8.5         15.45%
Termsrv2                          5                   3.1         62.00%
Webserver1                      200                    39         19.50%
This chart shows the difficulty we
have allocating disk space when we
have direct attached storage instead
of pooled storage that the Left Hand
IQSAN would allow. The list is an
inventory of our servers and disk
space usage. You can see that we
have islands of space that cannot be
used across the applications.
Gain 1 - Left Hand allows snapshots of the Data. You
can make these as often as you like. A good strategy
would be twice a day. With our current backups we
get some files each night, some once a week. So if
the file is deleted or changed incorrectly between
backups no recovery is possible. With the snapshots
we could recover in 4 hour increments


Gain 2 - To restore a file with our present technology
we have to find the tape which sometimes is not in
the library and we have to order from Storage
Solutions. We have to mount the tape, maybe
catalogue it then restore the file. This can take up to
a day or two. With the snapshots many cases would
just be a matter of minutes to restore the corrupt or
missing files.

Gain 3 - Each server needs a backup agent to be
backed up. Backing up each server costs 36 X $86 =
$3096 annually. Lefthand would reduce this count we
estimate by 15 for a cost savings of $1806 annually
after storage consolidation




Gain 4 - Because we backup the snapshot of the data
we can backup at anytime without affecting
production data. The backup uses a different network
than the production network so the impacts due to
congestion between the users accessing the files and
the backup software accessing the files is eliminated.
The backup operation also is against the Left Hand
CPUs and not the application servers CPUs. This is
different than the technology we use today because
currently the application servers processing power is
used to both backup data and service users at the
same time during the day.
With the Left Hand solution we could
build a real time Disaster Recover Site
or a Hot Site depending on where we
locate the second set of Left Hand
storage units. Left Hand has the
ability to replicate data async over
slow links or write authoritative
blocks of data between sites on high
speed Gigabit links. In a disaster this
would give us an ability to get some if
not all services online much quicker
than would be possible today. The
data would be available for use it
would just be a matter of switching
over the secondary site the primary
data source.
Management of both a local and
remote site can be managed
centrally. This would be efficient
for the IT department because if
say our remote site was Fire 5 to
do the replication, backups and
restores would not require a
onsite visit.


Scalability - These units are self
contained modules. So in the
future when we need more
storage we just add a unit. They
scale in both storage and
processing power because each
unit is self contained. This is
advantageous because you do not
loose performance with more data
taking the same amount of
processors, here the processor
count goes up with the storage.

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:11
posted:3/5/2012
language:
pages:22