Skip to main content

Notifications

Microsoft Dynamics SL (Archived)

Latency problems between client computers and Solomon 7.0 on a virtual server. Please HELP!!

Posted on by 30

Dear experts,
I assume I'm not the only one in this situation. I want to know if any of you are using Solomon 7.0 on a virtual server (Windows server 2008 64bit) if so have you experienced any latency issues between the client computers and Solomon? If so how did you fix the problem?

This is my scenario; we used to run Solomon with SQL 2008 on a windows server 2003 (32bit) the server hosting Solomon was a physical box. A month ago, we moved our Solomon to a virtual server which is a Windows server 2008 (64bit), 20GB RAM. And since we did the move, we noticed that we have latency issues between our client computers and our Solomon. BTW, our client computers are running Windows7Pro and they are 32bit.

When the client computers in the Accounting Dept. are running reports it takes a long time for the reports to run, the situation becomes much worse when they try to run multiple reports at the same time.  I checked the user’s path and it is pointing to the right folder. I also checked their permissions and all of the users have full control to the Solomon folder.

The only thing that calls my attention is that if the user runs the report directly from the server, there are no latency problems.

So, I’m running out of ideas, has anybody experience my problem? If so, could you please share the solution?

Thanks in advance.

*This post is locked for comments

  • Adam Leonard Profile Picture
    Adam Leonard 2,151 on at
    Re: Latency problems between client computers and Solomon 7.0 on a virtual server. Please HELP!!

    Hi,

    I would recommend using this KB article to run a SQL trace of the slow report running:

    967955

    How to use SQL Profiler in SQL Server 2008 and SQL Server 2008 R2 to trace database events in Microsoft Dynamics SL

    mbs.microsoft.com/.../KBDisplay.aspx

    Open the trace and take a look.  Look at the process that is actually running (2nd column over) but pay close attention to the Reads, Writes, and Duration columns.  These are in milliseconds so 1000 = 1 second.  Look for any process taking 10,000ms (10 seconds) or greater.

    If you can find a specific process taking quite some time, post back here.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,253 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,188 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans