none
DPM SQL Performance - Agent to Server Communication? RRS feed

  • Question

  • Hi All,

    Lately the SQL server that hosts our DPM database has been having performance isssues.

    In particular I've noticed that there is a spike in activity every 30 mins for a 5 min window.

    There is an SQL agent job that runs at this specific time interval and at the same time the dpmra service on all dpm client computers starts and then ends.

    Does anyone else have this issue or know what this SQL agent job is doing?

    Also, how is the agent to server communication initiated and handled in dpm?

    Cheers,

    • Moved by Parag Agrawal Wednesday, August 4, 2010 10:08 AM Agent management refresh issues. (From:Data Protection Manager)
    Wednesday, August 4, 2010 5:44 AM

All replies

  • It runs a agent refresh job every 30 minutes to check the agent status of the PS. This should not cause any perf issues. 

    thanks,

    Parag

    This posting is provided "AS IS" with no warranties, and confers no rights.

    Wednesday, August 4, 2010 10:06 AM
  • Hi Parag,

    This is definately causing performance issues! Every time the job runs the CPU runs at 100% for 5 minutes.

    Server specs are:

    Windows 2008 R2 64 bit (Virtual Machine)

    2 x Intel Xeon E5430 @ 2.66GHz, 8GB RAM

    SQL Server 2008 - Version 10.0.2531.0

    No other databases or services are located on the server.

    Any ideas why this is happening?

    Wednesday, August 4, 2010 11:14 PM
  • Hi,

    can you please give us the following details:

    1. How many production servers this DPM has?
    2. DPM Version.


    -- Thanks Chandraneel Chakka[MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.
    Tuesday, October 12, 2010 11:13 AM
  • How do i know what job is the agent refresh job?

     

    Jim

    Tuesday, October 12, 2010 12:49 PM
  • select

     

    ScheduleId from tbl_SCH_ScheduleDefinition where JobDefinitionId in (select JobDefinitionId from tbl_JM_TaskDefinition where TaskDefinitionId in (select distinct TaskDefinitionID from tbl_TE_TaskTrail where VerbID = '53603503-C4C8-4D0E-8F1E-D2F3868E51E3'))

    Please run the above query to get a guid and the sql server agent job which has this guid is the agent refresh job.

    But before you jump in can you answer us the information I asked earlier,

    1. How many production servers this DPM has?
    2. DPM Version.


    -- Thanks Chandraneel Chakka[MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.
    Wednesday, October 13, 2010 4:38 AM
  • I am running the RTM build of DPM 2010.  This DMP servers is protecting 28 servers.


    Jim
    Wednesday, October 13, 2010 12:03 PM
  • 28 servers are good enough number to have DPM as a physical machine. Can you please either make this a physical machine or dedicate some CPU towards this virtual machine. On virtual machines the CPU allotment is also dependent on the load at the host, so please also measure what are the other guest that are lying on this host and what kind of workloads they have?

     


    -- Thanks Chandraneel Chakka[MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.
    Thursday, October 14, 2010 10:59 AM
  • I am running a physical machine. It is a Dell PE2850 with 2x Dual core CPU's and 4gig of RAM.
    Jim
    Thursday, October 14, 2010 5:00 PM
  • When i ran the sql script about it game me 5 rows.  i noticed that there is a IsDeleted column.  All but 1 row have the IsDeleted column set as 1.  I am assuming the row that has the IsDeleted set to 0 is the job that i am looking for, correct

     

    Jim


    Jim
    Thursday, October 14, 2010 5:18 PM
  • Correct. you are right
    -- Thanks Chandraneel Chakka[MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.
    Friday, October 15, 2010 8:46 AM
  • Just after midnight i got the followin event error.  Now my schedule change has been reverted back to the default.  I do i keep the schedule changed to my setting?

     

    The description for Event ID 955 from source MSDPM cannot be found. Either the component that raises this event is not installed on your local computer or the installation is corrupted. You can install or repair the component on the local computer.

    If the event originated on another computer, the display information had to be saved with the event.

    The following information was included with the event:

    The consistency check resulted in the following changes to SQL Server Agent schedules: Schedules added: 0 Schedules removed: 0 Schedules updated: 1.

    Problem Details:

    <ConsistencyCheck><__System><ID>26</ID><Seq>146787</Seq><TimeCreated>10/15/2010 4:23:36 AM</TimeCreated><Source>SchedulerImpl.cs</Source><Line>719</Line><HasError>True</HasError></__System><Tags><JobSchedule /></Tags></ConsistencyCheck>

     

    the message resource is present but the message is not found in the string/message table

     

    Thanks,
    Jim


    Jim
    Friday, October 15, 2010 12:42 PM
  • Your schedule for the 30-min job will be reset any time you perform either a new agent installation or uninstallation.
    -- Thanks Chandraneel Chakka[MSFT] This posting is provided "AS IS" with no warranties, and confers no rights.
    Tuesday, October 19, 2010 7:56 AM
  • We have running 4 DPM servers at this moment, and two of them are causing the same issue as described above. every 30min de server hangs for like 5min (SQL process up to 100%)

    HARDWARE: Dell R710 1x Quad Core, 24GB of memory

    Only the job found with the sql query is reset back to 30min every night at 12.30am

    isn't there a solution which can solve this permanently?!

    Michel

    Tuesday, July 26, 2011 6:16 AM