web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics SL (Archived) / Latency problems betwe...
Microsoft Dynamics SL (Archived)

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

(0) ShareShare
ReportReport
Posted on by BDIAZ 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

I have the same question (0)
  • Adam Leonard Profile Picture
    Adam Leonard 2,151 on at

    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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics SL (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans