Questions tagged [escalation]
21 questions
0
votes
0 answers
Lock escalation on update statement that uses a primary key
I inherited a database that seems to have a LOT of lock escalation going on. I ran a trace and it's full of escalation events.
Some of it is caused by things like BULK INSERTS. I can understand how that causes an issue with locking.
There are some…
Mulciber Coder
- 127
- 9
0
votes
0 answers
Billing Escalation within current Time Window (accounting for previous Time Window)
I have a requirement to bill for the isoweeks of occupation in the previous month. The weeks are tiered such that...
(tier1) week1 = 23
(tier2) week2 = 28
(tier3) week3 = 35
(tier4) week4+ = 46
I have provided a sample of the table…
Minyun
- 35
- 4
0
votes
1 answer
Does disabling lock escalation put more stress on the data mdf?
We have a large multi-use application suffering from OBJECT and PAGE blocks on a number of tables. We are unable to reconsider the design, but need to reduce blocks that affect performance on client machines.
I have been considering disabling lock…
cloudsafe
- 2,444
- 1
- 8
- 24
0
votes
0 answers
Escalation Engineer vs Software Developer
I'm currently considering a position as a escalation engineer in one of the big sofware companies (Microsoft, Apple, Google, etc), in which I'd ultimately like to work on product development, but I'm afraid going straight for that kind of a job…
andy8383
- 1
0
votes
1 answer
Maximo 7.6 - Conditionally approving labor transactions with automation script and escalation
Thanks in advance.
We have a Maximo automation script (python) that approves all labor transactions when it runs from a scheduled escalation. "mbo.approveLaborTransaction()" is the entire script. No problems with the automation script or the…
RyanE
- 71
- 7
-1
votes
2 answers
I s it safe to set Everyone group access at file level in system folder on windows?
Is it obvious that giving access to Everyone with full permissions on folders in the C:\ProgramData is not safe and can lead to privilege escalation.
My question is how is the situation for text files? Is it still dangerous?
Is it obvious that…
lookzadeh
- 19
- 4