SQL Server Performance

Suggestions for the New DBA

Discussion in 'Getting Started' started by dfairchild, May 3, 2007.

  1. dfairchild New Member

    I have recently accepted a position as the DBA for a mid-sized company with several SQL Servers (7 thru 2005) along with numerous disparate applications (Excel, Access etc.) that use data from the SQL Servers. This is definitely a loaded question, but what are the major considerations and areas I need to immediately focus on and learn about in order to get a strong grasp of the 'state' that my servers and databases are currently in. I have a pretty good good idea of what I need to concentrate on but was hoping to use this forum as a way to guarantee I haven't left any gaps in the discovery phase/checklist of this position. Your useful insights, thoughts, suggestions and gotchas would be greatly appreciated.
  2. MohammedU New Member

    1. First ask document all the servers info and its importance and connecting application...
    2. Check the server and database configuration which can changed to improve performance...
    3. Talk to the manager about priorities...
    4. Check the database maintenance jobs and its output/statsus...
    5. Collect perfmon/trace data and analyse to optimizations...
    ....


    MohammedU.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  3. dfairchild New Member

    Many thanks!
  4. Luis Martin Moderator

    3.1 Talk to the users about mayors problems.


    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.



  5. dfairchild New Member

    mayors problems?
  6. xiebo2010cx Member

    Major / primary / key

    ------------------
    Bug explorer/finder/seeker/locator
    ------------------
  7. dfairchild New Member

    o okay ...the light bulb finally went on....I get it! Good suggestion.
  8. FrankKalis Moderator

    Another main (and probably the single most important ) task of a DBA not mentioned yet is the Backup and Restore process. Get an overview of that, check that everything is running smoothly. If it doesn't exist yet, create a desaster recovery plan, check with all involved persons, departments, and managers their degree of data loss tolerance and have that written down and agreed upon. Get very quick in the position where you can perform restore a database to its most recent state! This might cover your a** one day. [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />And in any case of uncertainty where you can't find the right information immediately, search for the information here or post a question.<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>
  9. jezemine New Member

    This is a bit self serving perhaps, but I'll post it anyway. [:I]

    SqlSpec is a shareware app I wrote might help you get up to speed on how all your newly inherited databases are put together, discovery, etc.

    If you are an MVP/MCT/ACE then you can get a free NFR license. same deal if you work for a charity or open source project.

    http://sql-server-performance.com/forum/topic.asp?TOPIC_ID=21143

    www.elsasoft.org
  10. MohammedU New Member

    <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by jezemine</i><br /><br />This is a bit self serving perhaps, but I'll post it anyway. [:I]<br /><br />SqlSpec is a shareware app I wrote might help you get up to speed on how all your newly inherited databases are put together, discovery, etc. <br /><br />If you are an MVP/MCT/ACE then you can get a free NFR license. same deal if you work for a charity or open source project.<br /> <br /<a target="_blank" href=http://sql-server-performance.com/forum/topic.asp?TOPIC_ID=21143>http://sql-server-performance.com/forum/topic.asp?TOPIC_ID=21143</a><br /><br /><hr noshade size="1">www.elsasoft.org <br /><br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br />Only MVPs/MCTs?[<img src='/community/emoticons/emotion-6.gif' alt=':(' />]<br />Not for the users who server the community?[<img src='/community/emoticons/emotion-5.gif' alt=';)' />]<br /><br />MohammedU.<br />Moderator<br />SQL-Server-Performance.com<br /><br />All postings are provided “AS IS” with no warranties for accuracy.<br />
  11. FrankKalis Moderator

    Have you read the thread Jesse mentioned? He has something about 6,000 posts here. So, I guess you have to wait about only 2 months before you are eligible. [<img src='/community/emoticons/emotion-2.gif' alt=':D' />]<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>
  12. jezemine New Member

    <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by MohammedU</i><br />Only MVPs/MCTs?[<img src='/community/emoticons/emotion-6.gif' alt=':(' />]<br />Not for the users who server the community?[<img src='/community/emoticons/emotion-5.gif' alt=';)' />]<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br />Mohammed, you certainly qualify, you are a machine around here! <br /><br />Mail me if you want one. First read this though:<a target="_blank" href=http://www.elsasoft.org/mvp.htm>http://www.elsasoft.org/mvp.htm</a><br /><br />Jesse<br /><br /><hr noshade size="1">www.elsasoft.org <br />
  13. satya Moderator

    Guys
    Can we please stick to the topic discussion and please take up relevant Elasoft discussion on the original thread.
    THanks.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

Share This Page