SQL Server Performance

Do and Don't

Discussion in 'SQL Server 2005 Replication' started by california6, Jul 3, 2007.

  1. california6 New Member

    I am planning to configure replication. I was wondering, what are replication Do's and Don'ts on a production environment? Is there standard replication performance related guide which list's, what we need to do here?

    Appreciated any input on this.

    Thanks,
    Cali
  2. dineshasanka Moderator

  3. california6 New Member

    Thanks for your email.

    I was looking more into, how to configure the distributer? What about memory consideration? what about other check marks which needs to keep in mind before implementing replication? Any standard replication setup guidelines? Common solutions for replication?

    These are the areas, i am looking into. If you have anything related to this, that will be great.

    Thanks,
    Cali
  4. Raulie New Member

    What type of replication are you planning to implement?

    Raulie



  5. california6 New Member

    Transactional replication.

    Please Note: My production database environment is a very busy system and users are doing inserts,update and deletes constantly. I.E every seconds there are tons of transactions running against this database. I am planning to implement replication for reporting purposes. Therefore before i implement, i want to know all the details and see, which one will best suit us.

    Thanks,
    Cali
  6. MohammedU New Member

    It depends on how much you want to replicate and how reliable your network etc...
    It is not advisable to replicate whole db for reporting unless there is no option...
    Do you really need upto the minute data for reporting? If not then there other ways better than replication...

    Read the following which will also apply to sql 2005...

    Transactional Replication Performance Tuning and Optimization
    http://www.microsoft.com/technet/prodtechnol/sql/2000/maintain/tranrepl.mspx

    Setting Up Transactional Replication with SQL Server 2005
    http://www.awprofessional.com/articles/article.asp?p=599700&seqNum=1&rl=1


    MohammedU.
    Microsoft SQL Server MVP
    Moderator
    SQL-Server-Performance.com

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

    ... also don't foreget to refer through SQL Server 2005 books online specific to changes in replication as compared to previous versions, also Dinesh's presentation covers most of it.

    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. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
  8. california6 New Member

    Thanks for the answer MohammedU and Satya. MohammedU my reporting data need's to be available in real time. is there better way to do this? My SQL Server version is 2000.

    I read about 2005 and one of the thing came to my mind was mirroring. Yes have my production database mirror and run snapshot's on this mirror copy. i believe, this would be a real time data. but since i am still with 2000, i need to look a better solution on 2000.

    Any comments?

    thanks,
    Cali
  9. MohammedU New Member

    Please post the question in relevent topic so that you get the correct reply...

    In 2000 replication is the best approach for realtime reporting...

    Note: you may be get into issue if the size of the tables are huge...and when you need to initialize the snapshot specially during the day...



    MohammedU.
    Microsoft SQL Server MVP
    Moderator
    SQL-Server-Performance.com

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

    Follow as referred by Mohammed to get information on your issue.

    YOu are correct that SQL 2005 offer various mix and match with dbmirroring and replication in this case, but before that you should look at the data feasibility & availability.

    quote:Originally posted by california6

    Thanks for the answer MohammedU and Satya. MohammedU my reporting data need's to be available in real time. is there better way to do this? My SQL Server version is 2000.

    I read about 2005 and one of the thing came to my mind was mirroring. Yes have my production database mirror and run snapshot's on this mirror copy. i believe, this would be a real time data. but since i am still with 2000, i need to look a better solution on 2000.

    Any comments?

    thanks,
    Cali

    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. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

Share This Page