Multiple (over 150 ESTABLISHED) CrmAsynService connections to the database server

(0) Share

Report

Posted on by bernhards

423

How many "CrmAsyncService.exe" connections to the CRM Database-Server (on-premise) are normal? Our server has 150+ ESTABLISHED connections to the database server:

I already checked our plugin code for open SqlConnections but all are IDisposable (used with using).

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Radu Chiribelea 6,667 on at

Like (1)

Report
Copy link

Link copied!

Hello,

I would personally collect a CRM Platform trace at a Verbose level and have a look at the call stack and see where this roots.

Are you accessing the CRM DB directly from the Plug-in? Why not get the data via the CRM Web Service?

Regards,

Radu

Was this reply helpful? Yes No
bernhards 423 on at

Like (0)

Report
Copy link

Link copied!

Hi Radu, ^^

Ok, I just turned it on for a short time and now I have a bunch of files. But for what keyword could I search? (I tried the server db IP, the hostname and sql.)

All of the new plugins are using the web service but there is some legacy code dll that got migrated from the old crm 2011 system and it can be used by some old plugins. Since I am only one crm guy I had no time to investigate it. It can be that some of this old code opens a db connection and did not close it after that.

What confuses me it that I thought the async service would only handle the email synchronisation?

Something else is that we are still using Exchange 2010 Sp2...

Thanks,

Bernhard

Was this reply helpful? Yes No
Suggested answer

Kokulan 18,054 on at

Like (0)

Report
Copy link

Link copied!

I think it could be that you have loads of workflows or system jobs running in async. Its perfectly normal for CrmAsyncService to execute loads of concurrent sql queries. The fact that the Process ID is same, not much to worry about in my view.

Check the System Jobs or Process Sessions to see if there jobs running

If you do want to check log files, its hard to go through the file as it logs a lot, you can use the trace reader

www.xrmtoolbox.com/.../MscrmTools.CrmTraceReader

Was this reply helpful? Yes No
Radu Chiribelea 6,667 on at

Like (0)

Report
Copy link

Link copied!

Hi Bernhard,

As mentioned above - the Async Service handles other asynchronous tasks besides Server Side Synchronization for emails, appointments and tasks. For a full list you can check docs.microsoft.com/.../asyncoperation under OperationType.

Regarding the traces, you can use the trace parser tool and filter them based on Platform.Sql events - there you could see the generated queries and narrow down to a specific plugin.

However if you have many plugins or workflows triggered and which are set to run asynchronously + server side synchronization i don't think you should have any issues - unless the connections to the SQL DB were started outside the CRM WebService context.

Regards,

Radu

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

The new plugins are using web services but there is some legacy code dll , that got migrated from old crm, However if you have many plugins or workflows triggered and which are set to run asynchronously.

Was this reply helpful? Yes No