CPU spikes on sql server - crm agent jobs?

We have noticed most of the same performance issues that are reported around 
here, but in trying to research a few of these I noticed the following 
strange behavior.  Every 10 minutes a sql agent runs a process for "stored 
procedure priming".  When this runs, the cpu on the server pegs at 100% for 
about 30 seconds. then back to 0% or so until the next firing  This is a 
almost brand new install and only 1 or 2 users hit it.  We have only begun to 
put data into it, so there isn't very much.  Seems odd to me that a 
frequently scheduled process would hit things that hard that often.

Has anybody out there noticed the same, or could someone go into sql and 
fire off that agent job and let me know if this is to be expected?  

Better yet, does anybody know what this process is actually supposed to do?

Thanks,

Keith
0
Utf
3/1/2006 10:41:22 PM
crm 35858 articles. 1 followers. Follow

1 Replies
549 Views

Similar Articles

[PageSpeed] 55

Yes, I have noticed that.  The purpose of that job is to help ensure that 
the procudures and functions used for the cascade logic are kept "compiled" 
and "fresh" in memory.  I'm not sure the 10 minute interval is needed though 
as that seems like overkill to me.  You should be able to safely extend the 
interval w/o problems.  Biggest risk is that if you make a schema change and 
publish, the procs are regenned.  Then, when someone needs to run them, they 
may hit a timeout since the intiial hit on that can be huge.

-- 

Matt Parks
MVP - Microsoft CRM


"Keith Ludeman" <Keith Ludeman@discussions.microsoft.com> wrote in message 
news:5526A365-6F63-4629-97E2-9CFFCC4EBCD3@microsoft.com...
We have noticed most of the same performance issues that are reported around
here, but in trying to research a few of these I noticed the following
strange behavior.  Every 10 minutes a sql agent runs a process for "stored
procedure priming".  When this runs, the cpu on the server pegs at 100% for
about 30 seconds. then back to 0% or so until the next firing  This is a
almost brand new install and only 1 or 2 users hit it.  We have only begun 
to
put data into it, so there isn't very much.  Seems odd to me that a
frequently scheduled process would hit things that hard that often.

Has anybody out there noticed the same, or could someone go into sql and
fire off that agent job and let me know if this is to be expected?

Better yet, does anybody know what this process is actually supposed to do?

Thanks,

Keith 


0
Matt
3/3/2006 5:56:24 AM
Reply:

Similar Artilces:

How do you change OWA to another server?
OWA is working on the exchange server through the website on the Exchange server. First, is it a good thing to have the Web Server for OWA on a different server from the Exchange server? And if so, how do you change it...? charlie On Wed, 20 Jul 2005 15:20:38 -0500, "charles kuchar" <charliekuchar@news.postalias> wrote: >OWA is working on the exchange server through the website on the Exchange >server. First, is it a good thing to have the Web Server for OWA on a >different server from the Exchange server? And if so, how do you change >it...? charlie ...

CRM Raid 5??????
I wonder if anyone out there can help me. I am looking to purchase the CRM Solution software from Microsoft, however I have a slight problem with the minimum requirements... I have 2 servers one running a SCSI Raid 1 setup and the other running a serial ATA Raid 5 setup. However the minimum requirements are for the server to run a SCSI Raid 5 set up... Will it run ok on either of the 2 set ups I have To my knowledge, there is no hard and fast rule as to our server RAID requirements. People run CRM on laptops and Virtual Machines for demo purposes all the time (typically with simple ...

Could not log on to CRM after upgrade from 1.2 02-01-06
I've upgradet successfuly the CRM server but after that I couldn't log on to the server with the old accounts,even with the domain administrator's account with wich the crm is installed.When i open the deployment manager\user maneger\my ou Iget the folowing error:"Object reference not set to an instance of an object" so I can't see or modify the old accounts.When I try to create a new account the setup indicates an error and tells that this account already exists.PLEASE HELP me log on to the CRM server or open the users from the Deployment Manager!!!Thanks in a...

antivirus on front end server
Dear all, If I want to setup a front end exchange server provided for OWA access and RPC over HTTP. There is no mailbox hold in FE server. Do I need to install the antivirus scanning program on the front end server? does it save? If the mail contains virus and come from FE server, it will be route to BE server if there is no virus scanning program installed in FE server, am I right? How the FE server handle the incoming mail, does the virus scan engine will scan all incoming mail traffice in FE server firest before pass it to BE server? Thanks for your help Patrick The FE server ...

GP 7.5 on win2k3 Terminal Server problems
Strange problem seems to limit number of users accessing Great Plains to 3... All eight users are logged on to the Terminal server fine. Yet only three at a time can access GP. Contractor who is doing the GP install says she has never seen anything like this. Another friend has said that in the past, he has seen a special post-install script that must be run for TS installs of GP, but the contractor says this is now redundant... SQL Server 2000 sp3 with *per CPU License*. Terminal server is a fresh install with no TS CALs installed yet, but the 90-day temp licenses should be fine for t...

Scheduling legacy DTS packages in SQL 2008 SP1
I have hundreds of DTS packages that I brought over from SQL2000 into a SQL 2008 Enterprise SP1 64 bit environment, on Windows 2008 R2 64 Bit. Our plan is to bring everything over as is, and convert to SSIS as time permits. I've run into a bit of a stumbling block hopefully someone out there can assist me with. I can run the dts package by running it at the command line via DTSRUN /S I can run the dts package by hand via the backward compatability design time components when I schedule a job to do DTSRUN as a cmdexec the job fails saying it cannot find the specified file, ...

Two Default SMTP Virtual Server?
configuration info: 1-Ek23 SP2 server (old); cluster E2k3 SP2 server (new) For give my ignorance (brain cloud), but how many default SMTP virt servers can a single organization have? I ask b/c we are about to migrate from our old server to a new cluster setup. Today I added the EVS to the SMTP Connector as a local bridgehead server, along side the old server. Everything seemed to work fine until I did a test failover and then my old server rebooted and generated this log entry: Event Type: Warning Event Source: USER32 Event Category: None Event ID: 1076 Date: 4/4/2007 Time: 12:52:31...

Outlook 2003 works with which versions of Exchange Server ?
If you have Outlook 2003 connecting to an Exchange Server, does it have to be Exchange 2003 or can it also work with Exchange 2000 and Exchange 5.5? It works with Exchange 5.5, 2000 and 2003. However, there are certain features (such as cached mode headers only and RPC over HTTP) that only work with Exchange 2003 and other features (such as compression of messages) that work better with Exchange 2003. -- Patricia Cardoza Outlook MVP www.cardozasolutions.com Author, Special Edition Using Microsoft Outlook 2003 ***Please post all replies to the newsgroups*** "Julian Milenbach"...

System Jobs for Matchcode update stuck in waiting status
System Jobs for Matchcode update stuck in waiting status. Does anyone know how to resolve this? It seems to be for Leads, Accounts, and Contacts. Also, does this affect workflows? -- Onetreeup The status waiting may indicate the workflow has run into an exception. To view this open the advanced find on the system jobs and add the columns message and error code to the view, this will give any additional information if available. This may help you to resolve the issue. -- Patrick Verbeeten (MCPD) Lead Developer Aviva IT Extended Entity and Plug-in browser: http://www.patrickverbeete...

renaming exchange server
I want to rename my exchange server, netbios name and dns name. I am thinking of setting up a new server, and moving the mailboxes over. but what do i do with the mx record? i would not be able to move everything over at one time. so the old server need to be up and running and still receiving mail while i move mailboxes over. currently my server dns is aaa.bbb.com, netbios name aaa123 it is receiving mail as aaa.bbb.com i want to setup a new server test.bbb.com mx record - aaa.bbb.com help "tony" <none@none.com> wrote in message news:OlYz9Vc5FHA.3592@TK2MSFTNG...

crm retreives no data every 15 minutes or so
Hi Everyone, Our CRM system is unable to pull any data every 15 minutes or so. I've checked the log file and in the corresponding times this error message appears. Event Type: Error Event Source: MSCRMSecurityService Event Category: None Event ID: 6148 Date: 11/3/2004 Time: 3:26:36 PM User: N/A Computer: ACD021 Description: Error: Some security descriptors could not be adjusted after a privilege change. -2147217871 (0x80040E31) Description: <could not load message> any ideas? Thanks in advance. Mark Try reenabling all disabled business units If that doesn't fix ...

Cant reach exchange server after Win2k reinstall
Crosspost : microsoft.public.outlook, microsoft.public.outlook.general [FU2] : microsoft.public.outlook Hi everyone, I'm getting an Outlook XP strange problem on some Win2K stations. Last friday, I used GPO in order to deploy SP4 on about 50 W2k stations. 3 of them didn't get the pack correctly and were stuck in reboot and reboot and so on....Just after the first progress bar (when you can hit F8 to get advanced start options) So, I re-install Win2k on itself on the 3 stations in order to get Win2K booting (Booting from CD and choosing R at the second step, when the installer look...

the server does not support the required HTTP methods 0x800CCC3E
I just started to get this error. ALso, I can not create more then 1 Homail account. When I do, only 1 account does Outlook pull & syn information from. Please help. What version of Outlook do you have? Outlook 2002 can only have one Hotmail account - Outlook 2003 allows multiple accounts. As to the error you're getting, you probably have a proxy server between you and Hotmail that doesn't understand the HTTP/DAV protocol used by Hotmail. Contact your network adminstrator (if the problem is occurring at work) or your ISP (if it happens at home) and ask them to upgrade to a pro...

Saving a File to SQL Server from Access 2003
I have an application written in Access 2003 using linked tables to SQL Server 2000. I need to code an Access form to upload files (i.e. .pdf, .doc, ..xls, .txt, etc.) to SQL Server and I've never done this before. Can someone please point me to some sample Access code that will take a file and save it to the (SQL Server) database? I also need to know how to retrieve it. Thank you! -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200707/1 "richxyz via AccessMonster.com" <u35439@uwe> wrote in news:75094d3835f16@...

Problems opening our Online CRM site
We have a subscription to MS CRM Online, and from just ONE of our computers, we cannot log into our site - the computer in question is Vista Business, with IE 7. After signing in using our Windows Live ID, 14 separate IE windows are opened, each of which say "Internet Explorere cannot open the Internet Site https:/<oursite>.crm.dynamics.com/default.aspx - Operation Aborted In Addition, there is ONE IE window with 13 Tabs, each of which are blank with a title bar of "Continue", and a final Tab titled "Sign In" that displays the Windows Live ID boxes with an err...

Event ID 5892 (on EXCH Server) HELP!!!
Situation: Vanilla install of CRM. Only problem was I could not send an email from CRM and received an error that was corrected by changin the permissions on my exchange server's "vsi 1" folder. But now, I get a 5892 error on each incoming and outgoing message saying it can't send to all servers. Mail sent through the web interface appear to go from the client, but never arrive. Email arriving never gets to the CRM server. Any ideas? Joseph Michaud Fixed it. Had to add the CRM server netbios name to the webpage host header. :) Whee! ...

CRM. Publish in a web a search form of knowledge Base from CRM
Exist any kind of integration or sample about how to integrate in a standard web, or web developed with Sharepoint, a form to allow the Company visitors to search into the Knowledge Base created in Dynamics CRM? ...

CRM as a prospecting tool
Hi, I'm in sales & my company wants me to use MS CRM, as apposed to Act or Gold Mine, as a prospecting tool. Any suggestions on how I can learn to do this? or any resources on training with the software would be appreciated. Garthdeb - I'm not really sure what you're asking - How you can you learn to use MS CRM as a prospecting tool or how does MS CRM compare to ACT! and/or Goldmine as a prostecting tool? Either way (as with everything) it depends on your needs ACT! is a relatively low cost (low functioning) contact manager and (as with Goldmine) is not really setup to ...

moving mailboxes in AD off of a crashed server
This is not a problem yet however I'm trying to plan for a disaster recovery scenario. We have 2 Exchange 2003 Standard servers running on Windows Server 2003 Standard servers (Each in separate locations) but are both are domain controllers for the same domain. What I'd like to be able to do in the case that server 1 goes down (i.e. major disaster...not something easily fixable) is move/create mailboxes on server 2 for all server 1 users. Obviously the move mailbox tool wouldn't work because server 1 wouldn't be available. There are only ~20 users that would have to be moved...

Problem regarding receiving mails in CRM
Hi Urgent help required regarding receiving mails in CRM. It would be great if someone can help regarding how a user can receive mail in CRM apart from receiving them in his Outlook. Rajat I suggest you do a search on the newsgroup. <sairajat@gmail.com> wrote in message news:1156502018.003147.182960@75g2000cwc.googlegroups.com... > Hi > > Urgent help required regarding receiving mails in CRM. It would be > great if someone can help regarding how a user can receive mail in CRM > apart from receiving them in his Outlook. > > Rajat > ...

How to get outlook 97 to work with an SMTP/POP email service, not MsMail, PostOffice/Exchange Server?
How do you get outlook 97 to simply work with an ordinary SMTP/POP server? I have Outlook Express working fine, with the settings for account name, pw, etc, already put in and it works great (my O/S is XP Home). When I installed Outlook 97 it wouldn't deliver or receive mail, saying, "No Transport Provider". When I try to add a "Service", it seems to only accept the Microsoft Mail Postoffice as the source/destination for email. There seems to be no way to tell it to use an SMTP/POP protocol service. Tom Download and install the Internet Mail Enhancement Pat...

CRM/Outlook credential caching
Hi; We run a hosted CRM service, and our customers connect over the internet using forms-based authentication (IFD/SPLA). So we've provided them with a domain user account in our hosted AD that has nothing to do with their internal domain at their office. The CRM for Outlook will cache their CRM credentails when they first launch the CRM for Outlook, and that works well. But if I am a user and I today decide to change my password for my CRM-domain account, the CRM for outlook will not ask me for my new password until tomorrow. So for the duration of today, I seem to be connecti...

CRM Installation Error #2
This is a multi-part message in MIME format. ------=_NextPart_000_0333_01C653DE.DE1E2340 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable I am trying to install CRM on a server and am getting the following = error: 09:35:17| Error| Install exception.System.Exception: Action = Microsoft.Crm.Setup.Server.ProvisionBusinessAction failed. ---> = System.Runtime.InteropServices.COMException (0x80044151): Exception from = HRESULT: 0x80044151. at = Microsoft.Crm.Platform.ComProxy.CBizOrganizationClass.IBizOrganization_Cr= eateRootBusiness(S...

Please help install SQL SRS CRM 4.0 on SBS 2003R2
Please help, how do I install and configure SQL 2005 WGE especially SRS on SBS 2003R2 for CRM 4.0 WGE? I'm just not finding any detailed information on SQL install/configuration. Please point me to any resources. thanks! On May 9, 3:56=A0am, Scroch <Scr...@discussions.microsoft.com> wrote: > Please help, how do I install and configure SQL 2005 WGE especially SRS on= > SBS 2003R2 for CRM 4.0 WGE? =A0I'm just not finding any detailed informati= on on > SQL install/configuration. =A0Please point me to any resources. > > thanks! It should be a case of putting t...

CRM 3.0 SBE
Does the CRM 3.0 SBE client comprise only outlook 2003 add ins and there is no stand-alone client? So far, I have seen add account forms. How do you maintain accounts? How do you list, delete or update them? How do I attach files to a case? Where do I maintain subjects? Thanks in advance CRM3.0 Outlook clients extend an existing install of Outlook. You should see a CRM menu, CRM toolbar and CRM related folders after installation. Use the latter to do most of what you ask. Some tasks (such as creating Subjects) must be performed using the Internet Explorer client. Think of the E...