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) / Brand new to Dynamics ...
Microsoft Dynamics SL (Archived)

Brand new to Dynamics SL 7.0

(0) ShareShare
ReportReport
Posted on by Community Member

I Just inherited a Dynamics SL 7.0  (7.05.50502.00) environment.     

I'm a DBA.   Please, don't run off in terror,  i understand more than just plan caches.  

I'm also their (surprise!) application support. 

They are running the app locally on their desktops, there are 4 users, against a underutilized app and db server.    

When they do things in the app, they'll see slowness.

Tabbing out of the 'Amount' field in the Voucher and Adjustment Screen.

Printing checks totally locks up the PC til its done and runs for 15 to 30 minutes to process a few dozen.

They are on SP4 for dynamics as well.  i do not know how/if they are running any patches or CU's after SP4.

What i'm hoping to find out (beyond, the fact its OLD) is how to support it better and maybe give them some fixes for speed?     They aren't new issues either.   I'm the new guy that they passed the issues, and since this isn't my first rodeo, i asked how long has this been happening.    

Thanks all, and Hi.






*This post is locked for comments

I have the same question (0)
  • Community Member Profile Picture
    Community Member on at

    This may not help or be your issue but I have found that certain Dynamics screens are affected by the size of the transaction log file.  By truncating the size of the log file in those cases, these screens run faster.  Since you are a DBA, I suspect you know how to truncate transaction logs but, if not, let me know.

    I only have remaining SL 7 client and they are not experiencing slow performance with those screens.  The have a maintenance plan running that truncates the transaction log once a month.  Then again, they do not have a large transaction volume either.

  • Suggested answer
    Butch Adams Profile Picture
    Butch Adams 4,763 on at

    Here's a good place to start with the care and feeding of your SL database: support.microsoft.com/.../en-us

    SL opens a connection to the DB for every screen that it opens. The clients need to have excellent connectivity to the DB.

    Update Statistics and Reindexing on a regular basis can help as well if your users input a lot of data.

  • Community Member Profile Picture
    Community Member on at

    In my experience, a lot of Dynamics SL slowness problems are simply symptoms of network infrastructure problems.  Cable problems, bad NIC, routers, you name it.  But a couple of (non-Database) things you could try:

    1. Turn of customizations in customization Manager (Set customization level to standard) and see how the screens work. If the screen has a customization it will have an asterisk (*) next to it's name. 

    2.  Temporarily turn off virus protection and see how it runs.

    3.  On the check printing, redirect the printing to a file and see if it still locks up and takes forever.  If it works ok make sure your printer drivers are up to date.

    Has this problem been discussed with your reseller?

  • Community Member Profile Picture
    Community Member on at

    In support, we often suggest running the trace template (support has modified) while a slow processing is running.  SQL2008r2 template is found under KB 967955.

  • Community Member Profile Picture
    Community Member on at

    That was very helpful.

    NamedPipes is disabled on SQL and Client.

    Auto CREATE Statistics is also off on the SQL server.

    is create stats off a recommended setting?

  • Community Member Profile Picture
    Community Member on at

    What is the CustomerSource, PartnerSource stuff.   I'm not aware of any of the clubs just yet.

    I can't download the template as i don't have the right account.

  • Community Member Profile Picture
    Community Member on at

    Hi,

    we tried printing to a file,  was just as slow.  in fact, they do that regularly, and then manually print the file (they like to have a copy)

  • Community Member Profile Picture
    Community Member on at

    CustomerSource is the MS website that allows Dynamics Customers access to software updates, the knowledgebase, etc.  Lots of info.  Your Reseller should be able to tell you who is set up as an administrator for your company, who can then add you.  Or the reseller can add you themselves.  Partnersource is the same thing for Dynamics Resellers but with info about our customers.

  • Community Member Profile Picture
    Community Member on at

    Hi ramblemn   do you have a cash manager module?

    Check the cashsumd y cachavgd tables orer by period and check thant you dont have a future period on the database.

    If you have this is the problem... tell me if you have transaction on future period.

  • Community Member Profile Picture
    Community Member on at

    Hi,

    There are no future periods in CashAvgD or CashSumD.  but there are 34500 records in CashSumD, dating back to 200701 and 4100 records in CashAvgD dating back to 200701

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