tags:

views:

25

answers:

1
Q: 

SQL Data consuming - SharePoint 2007 Timer job

Which is the most SQL data consuming SharePoint 2007 timer job except the crawling?

+1  A: 

I guess it depends... for us it has been the "Database Statistics" job. It put a real hurt on our performance and we ended up disabling. Not to say that we do not do a database statistics update, we just had our DBA write one that is better tuned for our enviornment.

Below is a list of all OOB SharePoint timer jobs

http://technet.microsoft.com/en-us/library/cc678870.aspx

JD  2010-02-26 20:29:43
Talking about database statistics, take a note from a link you provided: "If you have not installed Windows SharePoint Services 3.0 with SP2, the job updates the query optimization statistics by performing a full scan of key tables every time that it runs, which can be resource-intensive."Maybe that's solved :)
Janis Veinbergs  2010-03-01 08:40:17

related questions

Upgrading Sharepoint 3.0 to SQL 2005 Backend?
Webpart registration error in event log
Sharepoint COMException 0x81020037
Transactional Design Pattern
Deploying InfoPath forms to different SharePoint servers
Profiling/Optimizing (Sharepoint 2007) Web Parts
Retreiving the PC Name of a Client? (Windows Auth)
What's the best way to report errors from a SharePoint workflow?
How to get out parameters working in SharePoint workflows
Editing User Profile w/ Forms Authentication
WSS/MOSS Book
Creating a development environment for SharePoint.
Sharepoint Wikis
Have you used a wiki in your project or group?
Can I copy files to a Network Place from a script or the command line?
How do you deploy your SharePoint solutions?
SharePoint WSS 3.0 Integration with Mac OSX (either Safari or Firefox)
SharePoint - Connection String dialog box during FeatureActivated event
How can I improve the edit-compile-test loop when developing a SharePoint workflow?
Best ajax library for Sharepoint
Alternative Hostname for an IIS web site for internal access only
How to reference to multiple version assembly
MOSS SSP problem - Failed database logons from deleted SSP
Sharepoint: executing stsadm from a timer job + SHAREPOINT\System rights
Can ASP.NET AJAX partial rendering work inside a SharePoint 2007 application page?