Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 263 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
Understanding Blocks & Deadlocks – Theory and Practice
Luc_VanDyck
Member, Moderator, Administrator Posts: 3,633
Session title: Understanding Blocks & Deadlocks – Theory and Practice
Date: Friday, 28 september 2012
Time: 11:00 - 12:30
Level: 300 - Advanced, 400 - Expert
Speaker: Jörg Stryk
Session description:
Blocks and Deadlocks are a major issue in NAV/SQL systems; causing decreased performance and poor user experience. This session will explain the locking mechanisms with Dynamics NAV and SQL Server and how they could be properly used. Further it will be demonstrated how blocks & deadlocks could be easily monitored and analyzed to get clues about the problem’s origin and to find appropriate solutions.
Some practical examples will highlight common problems and give inspiration for practicable solutions.
Use this thread to post your questions, comments or things you would like to see in this session at the conference.
Date: Friday, 28 september 2012
Time: 11:00 - 12:30
Level: 300 - Advanced, 400 - Expert
Speaker: Jörg Stryk
Session description:
Blocks and Deadlocks are a major issue in NAV/SQL systems; causing decreased performance and poor user experience. This session will explain the locking mechanisms with Dynamics NAV and SQL Server and how they could be properly used. Further it will be demonstrated how blocks & deadlocks could be easily monitored and analyzed to get clues about the problem’s origin and to find appropriate solutions.
Some practical examples will highlight common problems and give inspiration for practicable solutions.
Use this thread to post your questions, comments or things you would like to see in this session at the conference.
No support using PM or e-mail - Please use this forum. BC TechDays 2024: 13 & 14 June 2024, Antwerp (Belgium)
0
Comments
I guess we'll have plenty of time for :?: & :!: during (or actually after) that session, so please feel to post your questions (or wishes!) here so I could preprare something!
Looking forward to meeting you in Antwerp
Cheers,
Jörg
NAV/SQL Performance Optimization & Troubleshooting
STRYK System Improvement
The Blog - The Book - The Tool
NAV/SQL Performance Optimization & Troubleshooting
STRYK System Improvement
The Blog - The Book - The Tool
Heard your talk in NAV Techdays at antwerp. Can you tell me where I can download the presentation slides? I did not take down the notes on that day, can want to recall on some tips you presented on optimisation.
cheers.
In short time you should find the slides and the session-recording here on MIBUSO!
NAV/SQL Performance Optimization & Troubleshooting
STRYK System Improvement
The Blog - The Book - The Tool