1. Community Tip: Please Give Thanks to Those Sharing Their Knowledge.
    If you receive helpful answer on this forum, please show thanks to the poster by clicking "LIKE" link for the answer that you found helpful.
  2. Community Tip: Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING)
    Click the link above to access ADSM.ORG Acceptable Use Policy and forum rules which should be observed when using this website. Violators may be banned from this website. This notice will disappear after you have made at least 3 posts.

Opinion on TDP schedules

Discussion in 'Microsoft SQL Server' started by etchingsj, Apr 22, 2009.

  1. etchingsj

    etchingsj ADSM.ORG Member

    Joined:
    Feb 5, 2008
    Messages:
    243
    Likes Received:
    7
    Occupation:
    Sustaining Engineer
    Location:
    Lost Wages NV
    I have recently inherited an SQL server 8x Win 2003R2 with 29 TDP services running as every database is defined as a node. Each service is using 12 mb (more or less) to run.
    When running the TDP GUI a backup can be run on the whole server in under 10 minutes.
    Would it have made more sense to have had just one schedule ie: this SQL server would be one node and not 30.

    Can anybody weigh in on this?

    We plan to deprecate this server in the future and I was wondering which is the better configuration method and why.

    Thanks in advance,
     
  2.  

Share This Page