1. Forum Rules (PLEASE CLICK HERE TO READ BEFORE POSTING) Click the link 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 message will disappear after you have made at least 12 posts. Thank you for your cooperation.

Opinion on TDP schedules

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

  1. etchingsj

    etchingsj 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