In my SP2010 Environment, once procedure "proc_ECM_GetChangeTime" which is keep on running in every 1 minute. As result my SQL server CPU consumption become very high due to this.

Any one why it is running so frequently and how to stop it?

Hi,

Proc_ECM_GetChangeTime stores procedures referenced which return ChangeTime value. If you stop it, Managed Metadata Service would be unable to get a date time value, which may cause some issues.

How did you configure SQL server? Here is an article about how to configure the storage and Microsoft SQL Server database tier in a Microsoft SharePoint Server 2010 environment, I suggest you refer to:

https://technet.microsoft.com/en-us/library/cc298801(v=office.14).aspx

Best Regards,

Dean Wang

If we stop this what will be the impact for my SharePoint application and metadata. I have dedicated SQL server for managed metadata store and I have already followed guideline as mentioned in the link

Hi,

The proc_ECM_GetChangeTime stored procedure is called to get the latest time anything within a term store partition, group or term set has changed. If term set identifier is not NULL, the latest time anything within the specified term set within the specified term store partition or affecting all partitions was changed is retrieved. Otherwise, if group identifier is not NULL, the latest time anything within the specified group within the specified term store partition or affecting all partitions was changed is retrieved. Otherwise, the latest time anything within the specified term store partition or affecting all partitions was changed is retrieved.

More information about Enterprise Metadata Service Database Schema you can refer to the PDF file:

http://hackipedia.org/Protocols/Microsoft%20Windows/UNSORTED/MS-EMMSTORE%20Enterprise%20Metadata%20Service%20Database%20Schema%20%28v20110608%29.pdf

If you stop the procedure, Managed metadata update would be affected and go wrong.

I suggest you reduce the procedure running times, which means you can adjust the frequency of Taxonomy Update Scheduler Timer Job.

https://davidfrette.wordpress.com/2010/05/26/taxonomy-update-scheduler%C2%A0timer%C2%A0job/

Best Regards,

Dean Wang