Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics SL forum
Unanswered

Application Server Log Table Is Huge

Posted on by 750

We use App Server to run mostly reports and a few screen processes at designated times each day. We do not use e-mails, or quick send, or anything else at this time.

Between 4 countries, we have roughly 170 jobs that run through App Server each day on 5 different App Server accounts. What we are finding is that our App Server Log table (AppSrvLog) is logging something every few seconds, even when jobs should be finished. It looks like we have some redundant entries and I'm not sure why these are happening. Below is an example of what is showing up in the tables:

App Server job for Post Transactions is set to run on the hour, every hour, daily.

3120699 30185 SAAPPSERVER                                     11/09/2013  12:00:31 AM  30185 Post Transactions    Retrieved Request From Queue                                                                                                                         0x00000000035BEB55

3120704 30185 SAAPPSERVER                                     11/09/2013  12:00:40 AM  30185 Post Transactions    Request Started                                                                                                                                     0x00000000035BEB5C

3120707 30185 SAAPPSERVER                                     11/09/2013  12:00:49 AM  30185 Post Transactions    End of Request                                                                                                                                       0x00000000035BEB62

3120714 30185 SAAPPSERVER                                     11/09/2013  12:01:01 AM  30185 Post Transactions    Updating request status                                                                                                                             0x00000000035BEB6B

3120718 30185 SAAPPSERVER                                     11/09/2013  12:01:10 AM  30185 Post Transactions    Retrieved Request From Queue                                                                                                                         0x00000000035BEB72

3120722 30185 SAAPPSERVER                                     11/09/2013  12:01:19 AM  30185 Post Transactions    Request Started                                                                                                                                     0x00000000035BEB79

3120726 30185 SAAPPSERVER                                     11/09/2013  12:01:27 AM  30185 Post Transactions    End of Request                                                                                                                                       0x00000000035BEB7E

3120732 30185 SAAPPSERVER                                     11/09/2013  12:01:38 AM  30185 Post Transactions    Updating request status                                                                                                                             0x00000000035BEB86

These requests continue in the same order from 12:01:38am for another 388 lines and go past 1:00am. Exactly the same 4 lines over and over and over again.

We expect to see at least 4 lines each time the job runs and when the job is completed, we believe this should sit idle until the next scheduled process starts. Is this incorrect?

Since the beginning of November we have logged 524904 records to this table and our table is becoming severely bloated. There is a process that we can see that runs a simple select * from AppSrvLog and it takes a very long time to load (we aren't sure what is calling it yet, but this seems to be happening all day).

I have checked the App Server settings for each account and cannot find anything regarding a summary or detail of logging types. Entries are set to be retained between 30 and 60 days before deleting old log files.

Is there some way that we can limit the amount of log entries into this table? Having almost 400 lines per job seems a bit excessive.

Any help is appreciated.

Thanks!

-Jenny

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Application Server Log Table Is Huge

    Hi Jenny,

    Having the Application Server log stay at the larger number of records can cause performance issues. The repeating of the request might be caused by a performance issue. You may want to go into each application server and set the Log Management to be 2000-3000 entries or less (it really depends on the hardware the application server is running on and what other programs use the machine).

    For a normal request should have between 20 - 30 lines in the application server log (a lot of it depends on the request type).

    The application server takes a lot of resources, please make sure that the machine has enough CPU power and RAM.

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

Anton Venter – Community Spotlight

Kudos to our October Community Star of the month!

Announcing Our 2024 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 290,570 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 228,683 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans