Allocating system resources
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.
Is it way to control the amount of resources allocated on server for some batches? We are using SQL server.
0
Comments
-
-
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 Singleton0 -
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.0 -
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)0 -
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 Singleton0 -
Actually, only when you're 200%, absolutely, very very ... etc etc ... sureDavid Singleton wrote: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.
0
Categories
- All Categories
- 75 General
- 75 Announcements
- 66.7K Microsoft Dynamics NAV
- 18.8K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 610 NAV Courses, Exams & Certification
- 1.9K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 251 Dynamics CRM
- 103 Dynamics GP
- 6 Dynamics SL
- 1.5K Other
- 991 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 28 Design Patterns (General & Best Practices)
- Architectural Patterns
- 9 Design Patterns
- 4 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1K General Chat
- 1.6K Website
- 77 Testing
- 1.2K Download section
- 23 How Tos section
- 249 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions


