none
Multiple timer jobs executing upon new database RRS feed

  • Question

  • Hi

    In order to reduce database sizes I have created new site colletions in new databases. This has caused oob timer jobs and custom timer jobs to execute multiple times.

    Should I not be creating seperate databases and now that i have will I run into performance issues as multiple jobs are running?

    Is this something to be concerned about?

    Thanks

    Wednesday, December 11, 2013 11:26 AM

Answers

  • its depend on the situation, if your first site collection really grow too much i.e more than 100Gb then you can move this site into own DB....But if you site size are ver limited then i think 1 db is enough. 

    as size limit from MSFT from 200GB to 4 TB depending on situation.

    http://technet.microsoft.com/en-us/library/cc262787(v=office.14).aspx#ContentDB

    the jobs you mentioned, i think will not cause too much noise on the farm, as they will finish in less than 30 sec.


    Please remember to mark your question as answered &Vote helpful,if this solves/helps your problem. ****************************************************************************************** Thanks -WS MCITP(SharePoint 2010, 2013) Blog: http://wscheema.com/blog

    Thursday, December 12, 2013 2:15 PM
    Moderator

All replies

  • Hi,

    According to your post, my understanding is that creating new site colletions in new databases caused oob timer jobs and custom timer jobs to execute multiple times.

    It is caused by that the client have many Content Databases on the web application that the Timer Job was associated with.

    The timer job was doing what it needed to do based on how it had been developed.

    Remember every Site Collection (SPSite) has a property that gives you the Content Database, and every time a Timer Job is called (targeting a Content Database) the Content Database GUID for which it is running is passed in… use it for validation.

    In addtion, to reduce database sizes, please refer to:Database maintenance for SharePoint 2010 Products

    More information:

    SharePoint Timer Jobs Running Multiple Times: http://blog.rafelo.com/2009/04/10/sharepoint-timer-jobs-running-multiple-times/

    Best Regards,

    Linda Li


    Linda Li
    TechNet Community Support

    Thursday, December 12, 2013 3:51 AM
  • usually this issue occurred with custom Time Jobs,you can locked it down to run only once. check this post:

    http://bhandariasb.wordpress.com/2013/08/07/how-to-prevent-sharepoint-timer-jobs-from-running-multiple-times/

    http://gowrisharepoint.blogspot.com/2012/11/sharepoint-custom-timer-job-running.html

    one thing, did you notice if any OOTB timer job execute multiple time,  could you please give the reference of the JObs?


    Please remember to mark your question as answered &Vote helpful,if this solves/helps your problem. ****************************************************************************************** Thanks -WS MCITP(SharePoint 2010, 2013) Blog: http://wscheema.com/blog

    Thursday, December 12, 2013 4:48 AM
    Moderator
  • Hi

    I read somewhere that creating seperate databases for site collections is good practice. Is this not true?

    I also have custom Timer jobs, which I've reprogrammed to run on Job (jobName, webapp, null, SPJobLockType.Job) which has worked.

    There are several oob timer that runs per DB :

    Scheduled Unpublish
    Scheduled Approval
    Variations Propagate Site Job Definition
    Immediate Alerts
    Solution Resource Usage Log Processing
    Storage Metrics Processing

    Thursday, December 12, 2013 1:34 PM
  • its depend on the situation, if your first site collection really grow too much i.e more than 100Gb then you can move this site into own DB....But if you site size are ver limited then i think 1 db is enough. 

    as size limit from MSFT from 200GB to 4 TB depending on situation.

    http://technet.microsoft.com/en-us/library/cc262787(v=office.14).aspx#ContentDB

    the jobs you mentioned, i think will not cause too much noise on the farm, as they will finish in less than 30 sec.


    Please remember to mark your question as answered &Vote helpful,if this solves/helps your problem. ****************************************************************************************** Thanks -WS MCITP(SharePoint 2010, 2013) Blog: http://wscheema.com/blog

    Thursday, December 12, 2013 2:15 PM
    Moderator