SQL Server Performance

Page splitting & CPU IO issues how to handle

Discussion in 'The Lighter Side of Being a DBA' started by ranjandba, Jan 16, 2006.

  1. ranjandba New Member

    1.a.How to handle the more page splitting issues?
    b.In execution plan if IO cost and CPU cost is high what action we can take ?

    2.How many instances we can install in SQLServer 2000 & in Yukon?
    any pointers to answer the above questions also welcome. i could not get the satisfactory answer so did put in forum.
  2. Luis Martin Moderator

    1) With tuning and/or more memory.
    2) Tuning, find better indexes.
    3) 16 in 2000.



    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.



  3. mmarovic Active Member

    1. a. Improving index design, choosing smaller fill-factor, improving process data inserts/updates data.
    1. b. Trace to identify offending queries, then tune queries and index design. You can also upgrade cpu, add more cpus, relocate data and/or log files, use better raid configuration, add more data, log files etc.
  4. satya Moderator

    http://www.sql-server-performance.com/oltp_performance.asp
    http://www.sql-server-performance.com/mr_indexing.asp
    http://msdn.microsoft.com/library/techart/msdn_sql7perftune.htm (though it is SQL 7 it should help for 2000 also)

    http://www.sqljunkies.com/Article/7F8518F9-FDAA-4FF3-8FC5-25E8946C8D0C.scuk is a good article to tackle high cpu issues & IO performance.

    As referred by Luis you can have 1 default instance and 15 named instances.

    BTW, are you attempting for any interview?

    Satya SKJ
    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.
  5. ranjandba New Member

    1 question is not yet answered is - The no of instances in YUKON, any idea guys?<br /><br />u r guess is correct satya <img src='/community/emoticons/emotion-1.gif' alt=':)' /> - i'm preparing for some interviews..<br />
  6. satya Moderator

    Say it SQL Server 2005 than YUKON, as it was deceased a while ago.
    PLease take time to visit this website for complete information on performance & tuning in addition to Books Online.

    SQL Server 2005 supports up to 50 SQL Server instances on a single server or processor, but only one instance can be the default instance; all others must be named instances. A computer can run multiple instances of SQL Server concurrently, and each instance runs independently of other instances.



    Satya SKJ
    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.
  7. mmarovic Active Member

    Why is this thread in "The Lighter Side of Being a DBA" forum?
  8. Luis Martin Moderator

    Because we have not 2000 and 2005 in one forum?


    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.



  9. FrankKalis Moderator

    <blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by ranjandba</i><br /><br />1 question is not yet answered is - The no of instances in YUKON, any idea guys?<br /><br />u r guess is correct satya <img src='/community/emoticons/emotion-1.gif' alt=':)' /> - i'm preparing for some interviews..<br /><br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br />Come on! As this is for an interview, one might expect you to do a little bit of work on your own. What about consulting the SQL Server 2005 BOL? [<img src='/community/emoticons/emotion-5.gif' alt=';)' />]<br /><br />I also agree that this is a strange place for this topic.<br /><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 />
  10. satya Moderator

    Why is this thread in "The Lighter Side of Being a DBA" forum?
    I have moved it to here as the topic is really concerned about an Interview, that is something I felt a lighter side of it than a technical one.

    Satya SKJ
    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.

Share This Page