SQL Server Performance

dba interview questions

Discussion in 'The Lighter Side of Being a DBA' started by joanne, Nov 28, 2006.

  1. joanne New Member

    Last week last I passed an interview for a junior dba sql server job and the dba asked me these questions.

    1.You#%92ve been given the task of automating a refresh of a sql server database on a test server with a copy of the live database from the production server? How would you go about doing this? What database options would you change on the test server to reduce management tasks in the test environment?
    2.List the top 5 SQL Agent alerts you would configure on a server and why you feel they are important
    3.If you were given the task of designing a new database server for a highly transactional database that supports a large number of users.


    Describe how you would configure it.
    OS configuration,
    disk configuration,
    RAID Controllers,
    Database Locations on controllers,
    pagefile, etc…
    Please be detailed.


    Which would be your answers for these questions?

    Thanks very much for your help


    joanne, Nov 28, 2006
    #2

  2. Luis Martin Moderator

    Joannne,

    Is not the policy of that forum to answer your home works.

    But, you can search your questions in our forum an I'm sure you will find most of them.



    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All in Love is Fair
    Stevie Wonder


    All postings are provided “AS IS” with no warranties for accuracy.



    Luis Martin, Nov 28, 2006
    #2

  3. MohammedU New Member

    When you are entering in this field ... better to spend more and more time on seaching and reading...so that you learn and understand more...

    Google the terms in your posting you get plenty of information.

    Good luck.


    Mohammed U.
    MohammedU, Nov 28, 2006
    #2

  4. Madhivanan Moderator

    Home work and interview questions are not generally answered in the forums
    Do google search

    Madhivanan

    Failing to plan is Planning to fail
    Madhivanan, Nov 28, 2006
    #2

  5. FrankKalis Moderator

    What about a Quid pro quo scenario?<br />You tell us, what you have answered and we discuss that? [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />--<br />Frank Kalis<br />Moderator<br />Microsoft SQL Server MVP<br />Webmaster:<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a>
    FrankKalis, Nov 28, 2006
    #2

  6. satya Moderator

    I second Luis's suggestion, rather than taking shortcuts you better work it out on your own interest. Do not get us wrong for this answer, it helps in future for you to tackle any issue with a pro-active approach.

    quote:Originally posted by LuisMartin

    Joannne,

    Is not the policy of that forum to answer your home works.

    But, you can search your questions in our forum an I'm sure you will find most of them.



    Luis Martin
    Moderator
    SQL-Server-Performance.com

    All in Love is Fair
    Stevie Wonder


    All postings are provided “AS IS” with no warranties for accuracy.





    Satya SKJ
    Microsoft SQL Server MVP
    Contributing Editor & Forums Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing.
    satya, Nov 29, 2006
    #2

Share This Page