Post reply

I have installed Microsoft DynamicX, But I got something strange with stored procedure

  • July 8, 2010 at 10:21 pm

    #224686

    I have installed Microsoft DynamicX on the Server included Database

    MS SQL Server 2008 Enterprise. I do not know I was wrong in installation

    or indeed like this. After open Microsoft SQL Server Management Studio,

    I didn't see many stored procedure only just few stored procedure inside

    the list of stored procedures.

    So, do you think that the server application of Microsoft DynamicX is using

    query? If, yes... Why does the Microsoft does not used this feature to improve

    the performance of the product, or Microsoft has certain way/mechanism to

    isolate the stored procedure?

    I hope my imagination is wrong.

    Any direction, explanation or information is greatly appreciated.

  • July 9, 2010 at 12:57 am

    #1190637

    Dynamics AX keeps the business logic inside the app code and doesn't usually move it to the database with stored procedures.

    If you are concerned about AX performance, I suggest that you read this great guide:

    http://sqlcat.com/top10lists/archive/2010/05/20/top-tips-for-maximizing-the-performance-amp-scalability-of-dynamics-ax-2009-systems-on-sql-server-2008.aspx

    -- Gianluca Sartori

  • July 9, 2010 at 6:40 pm

    #1191082

    Thank you very much for your replies.

    I still curious about this issue, why does the Microsoft does not used the feature that have been create?

    Do you think that the microsoft team in this area do not want to other can see their script about every transaction?

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply