Maintenance and Support Requirements

  • rosspm1

    Grasshopper

    Points: 22

    We are a small company with an IT staff of 2 network people and 3 developers and are deciding to move our flat file based legacy apps into the SQLserver world. I need a method to determine what my DBA support and maintenance requirments will be. What are the metrics that determine this?

  • Steve Jones - SSC Editor

    SSC Guru

    Points: 720983

    Not sure what you mean. Do you mean that you need to know what you need to know? Or what you need to hire someone (temp or perm) to do?

    You need someone to install and configure SQL Server and the app connectivity. You need someone to manage backups and restores.

    You may need someone to handle data coversions.

    It really depends on what you need and your post isn't that clear.

    Steve Jones

    steve@dkranch.net

  • rosspm1

    Grasshopper

    Points: 22

    OK, assume I have consultants design and congigure the data base and develop the apps and turn it over for us to maintain. Will I need to hire or train a full time DBA? What will determine this? The number of programs, tables, files,etc.? What kind of normal maintenance is needed and how often to insure good performance? Weekly, monthly, yearly?? Would it make sense to bring in consultants periodically to do this?

    What I am trying to determine is what will be the effect on my staffing because of this new environment

  • Antares686

    SSC Guru

    Points: 125444

    Well there are a lot of factors to your questions, and then how many questions do you need answered is another. I suggest grab a good book on SQL (or have someone else do it) or send to classes or hire someone with knowledge. To me you really need someone around with some knowledge to make sure you conver all the points you need, but to get that knowledge isn't hard and finding the right book(s) can be fairly inexpensive. But to finalize if you have some concerns to make sure it is cared for properly you better get someone with experience (either as a consultant until someone you have can learn or full time). We can answer questions but depending on the criticality of this data you need someone (or two to be fair) on site dedicated to it.

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply