No Of Locks, No_Of_Blocks - Understand the values

nav_student
Member Posts: 175
Hi guys
Hi gys I run the SQL script from Styrk and I got this values regarding locks and blocks:
Objs
JobQueueEntry (No Of Locks:653485 No Of Blocks:544 and Block Wait Time:20715)
Sales Line$VSFIT$23 (No Of Locks:36564No Of Blocks:29 and Block Wait Time:82898)
Sales Line$VSFIT$38 (No Of Locks:71592 No Of Blocks:17 and Block Wait Time:43974)
Sales Line$VSFIT$18 (No Of Locks:179848 No Of Blocks:15 and Block Wait Time:27847)
Sales Line$VSFIT$15 (No Of Locks:1695017 No Of Blocks:5 and Block Wait Time:8596)
CustomizedTable$ (No Of Locks:671438910 No Of Blocks:3 and Block Wait Time:4634)
1st Question:
How can I identify the VSFIT$(Number)?
SQL - Database - Table - Indexes?
2nd Question
What are the values that I should concern? There is any reference?
Thanks for your help!
Hi gys I run the SQL script from Styrk and I got this values regarding locks and blocks:
Objs
JobQueueEntry (No Of Locks:653485 No Of Blocks:544 and Block Wait Time:20715)
Sales Line$VSFIT$23 (No Of Locks:36564No Of Blocks:29 and Block Wait Time:82898)
Sales Line$VSFIT$38 (No Of Locks:71592 No Of Blocks:17 and Block Wait Time:43974)
Sales Line$VSFIT$18 (No Of Locks:179848 No Of Blocks:15 and Block Wait Time:27847)
Sales Line$VSFIT$15 (No Of Locks:1695017 No Of Blocks:5 and Block Wait Time:8596)
CustomizedTable$ (No Of Locks:671438910 No Of Blocks:3 and Block Wait Time:4634)
1st Question:
How can I identify the VSFIT$(Number)?
SQL - Database - Table - Indexes?
2nd Question
What are the values that I should concern? There is any reference?
Thanks for your help!
0
Comments
-
All $VSFIT$s are views. If I see these in Stryk's locklist I will create a new index in this view and use all sum and countfields in "include" statement, this vill Speed up your system
Tips: Read J Stryk's book.
Regards
Christer in Stockholm, Sweden0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K 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
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions