Identify user running "big" process

EuropaCuisson
Member Posts: 13
Hello,
We use BC (april19 version)
Sometime, we see a big usage of CPU for the server process.
Probably because a user launch a big process (big report, posting lots, ...)
How is it possible to identify this user ?
In old (2009 and before) version, we can do that at sql side.
But with 3-tiers ?
Active session table don't display any info about running task.
Thx
We use BC (april19 version)
Sometime, we see a big usage of CPU for the server process.
Probably because a user launch a big process (big report, posting lots, ...)
How is it possible to identify this user ?
In old (2009 and before) version, we can do that at sql side.
But with 3-tiers ?
Active session table don't display any info about running task.
Thx
0
Answers
-
Well you can do this in a couple of ways depending on the code the uses are using.
If the uses is causing locks you can eanble database locks in your service tier, and run the page Database locks.
For help, do not use PM, use forum instead, perhaps other people have the same question, or better answers.0
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