Allocating system resources

lubost
lubost Member Posts: 633
We have a problem, that during some batches (Adjustation, Comprimation etc.) system allocates whole server resources and any other user cann't do anything.
Is it way to control the amount of resources allocated on server for some batches? We are using SQL server.

Comments

  • Waldo
    Waldo Member Posts: 3,412
    Are you running the client with the batches on the same machine as the server?
    Are users running through terminal services and therefore running on the same server?

    Actually, the question is: can you tell us more about your infrastructure?

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog
  • David_Singleton
    David_Singleton Member Posts: 5,479
    It really depends on what Batch processes you are talking about. Its important to understand the Dynamics NAV version principle, to know what is happening at the server. Basically though committed transactions are being written to the disk, in the order that they were committed. This is happening through the commit cache. Of course whilst this is happening, you could have other processes reading data, they can read etiehr from commit cache normal cache or the Drives, so it matters only that the data has been committed.

    For this reason, some precesses can be modified to share the server resources, some can't. A good example is the Batch Post invoices routine. This routine grabs a sales order or un-posted invoice, posts it, and then commits the data, then grabs the next order to post. After the commit, and before the next get, you can insert a wait, and whilst the client is waiting, other tasks can commit data.

    But if you have a routine that needs to run from start to finish, and is writing data to the disk but can not commit till the end, then you can't really do too much. If you put a wait in there, you will allow other users read access to data, but others need to write, so it may not have any big advantages.
    David Singleton
  • lubost
    lubost Member Posts: 633
    Thank you guys,
    As I read in your reply - solution can be founded only in our own batches - do COMMITs (if they are possible) in appropriate places in program sequence.

    Topic can be marked as solved.
  • kine
    kine Member Posts: 12,562
    lubost wrote:
    Topic can be marked as solved.

    This is on you. You just needs to put the [SOLVED] prefix into first post subject... 8)
    Kamil Sacek
    MVP - Dynamics NAV
    My BLOG
    NAVERTICA a.s.
  • David_Singleton
    David_Singleton Member Posts: 5,479
    lubost wrote:
    ...
    - do COMMITs (if they are possible) in appropriate places in program sequence.
    ...

    And of course, use COMMIT only if you are absolutely 100% certain what you are doing.
    David Singleton
  • Waldo
    Waldo Member Posts: 3,412
    lubost wrote:
    ...
    - do COMMITs (if they are possible) in appropriate places in program sequence.
    ...

    And of course, use COMMIT only if you are absolutely 100% certain what you are doing.
    Actually, only when you're 200%, absolutely, very very ... etc etc ... sure :wink:

    Eric Wauters
    MVP - Microsoft Dynamics NAV
    My blog