Howdy, Stranger!
It looks like you're new here. If you want to get involved, click one of these buttons!
Quick Links
Categories
- 67.7K All Categories
- 73 General
- 73 Announcements
- 61.9K Microsoft Dynamics NAV
- 14.9K NAV Three Tier
- 37.9K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.3K Navision Financials
- 112 Navision DOS
- 843 Navision e-Commerce
- 726 NAV Tips & Tricks
- 760 NAV Dutch speaking only
- 600 NAV Courses, Exams & Certification
- 1.9K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 209 Dynamics CRM
- 98 Dynamics GP
- 7 Dynamics SL
- 1.4K Other
- 960 SQL General
- 372 SQL Performance
- 29 SQL Tips & Tricks
- 23 Design Patterns (General & Best Practices)
- Architectural Patterns
- 7 Design Patterns
- 3 Implementation Patterns
- 39 3rd Party Products, Services & Events
- 1.5K General
- 952 General Chat
- 1.6K Website
- 76 Testing
- 1.2K Download section
- 23 How Tos section
- 250 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
How to control blocks and performance on SQL?
Administrator
Posts: 2,425Member, Moderator, Administrator
How to control blocks and performance on SQL?
http://www.mibuso.com/howtoinfo.asp?FileID=19
Discuss this How To here.
http://www.mibuso.com/howtoinfo.asp?FileID=19
Discuss this How To here.
0
Comments
Thank you for this useful tool.
I have download this tool, but when I click button Show Active Sessions, it result error :
How to solve this error so I can open the Show Active Sessions ?
Thank you.
Johanna
Use the SEARCH,Luke! || No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
NAV TechDays 2019: 21 & 22 November 2019, Antwerp (Belgium)
Thank you for your reply. I have run form 60150 then clicked the button "Show Active Sessions" and got the error result "This program must be run from form 60150:SQL Session Performance".. How to solve this error? Thank you.
Johanna
This logs in a temptable the records where a session uses too much resources (see the fields on the form). If no logs are made, you get that error.
To have some logs easily, do this:
"Log Active Sessions"=true
"Log only blocks"=false
"Beep on heavy *"=1
Open another session (if no other session is working) and do something in there.
After some moments, you will be able to open the form and see some records.
Use the SEARCH,Luke! || No PM,please use the forum. || May the <SOLVED>-attribute be in your title!
NAV TechDays 2019: 21 & 22 November 2019, Antwerp (Belgium)
I have tried your directions and it has worked. Now I can access "Show Active Sessions" from SQL Server Performance. Thank you so much. :thumbsup:
Johanna