SQL Server Performance

Certification on Performance Tuning???

Discussion in 'SQL Server 2000 Certification [Archive]' started by ramkumar.mu, May 18, 2006.

  1. ramkumar.mu New Member

    Is there any separate certification on Performance Tuning for SQL Server 2000. Also please lemme know the exams available for SQL Server 2000.

    Thanks,
    Ram

    "It is easy to write code for a spec and walk in water, provided, both are freezed..."
  2. satya Moderator

  3. Luis Martin Moderator

    As far I know, no.


    Luis Martin
    Moderator
    SQL-Server-Performance.com

    Although nature commences with reason and ends in experience it is necessary for us to do the opposite, that is to commence with experience and from this to proceed to investigate the reason.
    Leonardo Da Vinci

    Nunca esperes el reconocimiento de tus hijos, eso ocurrirá luego de tu muerte


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



  4. ramkumar.mu New Member

    Looks like an exam for DBAs.


    quote:Originally posted by satya

    On SQL 2000 70028 http://www.microsoft.com/learning/exams/70-028.asp] covers bits & pieces of Performance topic. I believe there is no dedicated certification on this topic.

    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.

    Thanks,
    Ram

    "It is easy to write code for a spec and walk in water, provided, both are freezed..."
  5. FrankKalis Moderator

    As long as there so many people lacking the basic knowledge, a Performance Tuning cert would be overkill. Apart from this, Performance Tuning can hardly be generalised. Pretty much of it depends on a specific environment.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    http://www.insidesql.de
    Heute schon gebloggt?http://www.insidesql.de/blogs
    Ich unterstuetze PASS Deutschland e.V. http://www.sqlpass.de)
  6. alica New Member

  7. satya Moderator

    [<img src='/community/emoticons/emotion-1.gif' alt=':)' />] Perf.tuning is an integral part for a DBA [<img src='/community/emoticons/emotion-4.gif' alt=':p' />].<br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by ramkumar.mu</i><br /><br />Looks like an exam for DBAs.<br /><br /><blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by satya</i><br /><br />On SQL 2000 70028 <a target="_blank" href=http://www.microsoft.com/learning/exams/70-028.asp]>http://www.microsoft.com/learning/exams/70-028.asp]</a> covers bits & pieces of Performance topic. I believe there is no dedicated certification on this topic.<br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Contributing Editor & Forums Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided “AS IS” with no rights for the sake of <i>knowledge sharing.</i></font id="size1"></font id="teal"></center><br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br />Thanks,<br />Ram<br /><br />"It is easy to write code for a spec and walk in water, provided, both are freezed..."<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote">
  8. FrankKalis Moderator

    <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><br /> Perf.tuning is an integral part for a DBA .<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />True enough! However, the first one to be concerned with performance and tuning should be the developer. [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]<br /><br />--<br />Frank Kalis<br />Microsoft SQL Server MVP<br /<a target="_blank" href=http://www.insidesql.de>http://www.insidesql.de</a><br />Heute schon gebloggt?<a target="_blank" href=http://www.insidesql.de/blogs>http://www.insidesql.de/blogs</a><br />Ich unterstuetze PASS Deutschland e.V. <a target="_blank" href=http://www.sqlpass.de>http://www.sqlpass.de</a>)
  9. satya Moderator

    How many (developers) would take care or even think about it?
    I don't think not many as long as they are based as Dev.DBA as well. The main aim for a Developer is to work his code and don't care about other processess that might bring systems down.

    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.
  10. FrankKalis Moderator

    quote:
    The main aim for a Developer is to work his code and don't care about other processess that might bring systems down
    I agree that developers need to take care of their deadlines and might therefore produce only suboptimal working code and leave it to the "specialists" to tweak and tune that. But I really don't think that this is the way it should be.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    http://www.insidesql.de
    Heute schon gebloggt?http://www.insidesql.de/blogs
    Ich unterstuetze PASS Deutschland e.V. http://www.sqlpass.de)
  11. satya Moderator

    I mean the Developer will only concerned if the query is performing poorly, so then the consideration of using relevant hints and fine tuning will come in to the picture.

    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.
  12. ramkumar.mu New Member

    OK... is there any certification for SQL DBAs???

    Thanks,
    Ram

    "It is easy to write code for a spec and walk in water, provided, both are freezed..."
  13. jony New Member

    right now i have no much time to explain but u can check it from self exam engine,
    i hope u ll find it good to help u

Share This Page