Customer Engagement & Dynamics CRM Forum

Expand all | Collapse all

Data Export Service

  • 1.  Data Export Service

    Posted 30 days ago
    Hi all

    Slightly strange question that I hope someone may be able to help with.

    Recently we have noticed a significant degradation of service when running SQL queries against our Azure DB holding CRM data from the export service.  Looking at the system usage, we can see a number of queries that appear to be making the DB run at 100% available resources.  These appear to be merge queries for certain entities.  Does anyone here know whether this is normal?

    Your responses gratefully received!

    Regards

    Matt

    ------------------------------
    Matthew Vizor
    Shelter
    London
    ------------------------------
    The first step toward cloud success. - Migrate from CRM to D365 with expert guidance from Microsoft. I'm Ready


  • 2.  RE: Data Export Service

    GOLD CONTRIBUTOR
    Posted 22 days ago
    If it's just an Azure DB, can you scale it up to handle better if you're seeing performance issues?

    Further more, have you seen the TSQL endpoint that is on the verge of launching? That may make your issue redundant!

    ------------------------------
    Matt Beard
    Senior Software Engineer
    Data8
    ------------------------------

    The first step toward cloud success. - Migrate from CRM to D365 with expert guidance from Microsoft. I'm Ready


If you've found this thread useful, dive deeper into User Group community content by role