You need to manage the server workload by restricting resource-intensive applications You need to dynamically limit resource consumption
You need to gather more data to be able to determine which processes are being blocked and to identify the root cause
You need to ensure that all read activity against dbo.Salary is audited and written to the Windows Security Log