InterviewSolution
| 1. |
When Does A Workload On Sql Azure Get Throttled? |
|
Answer» When database reaches its maximum size UPDATE /insert /create operations get throttled. Also there are policies in place that does not allow to a workload to EXPLOIT a shared physical server. In other words, the policies make sure that all workload get a fair SHARE of shared physical server. Now, a workload can get soft throttled that means that the workload has crossed the safety threshold. A workload can also GOT hard throttled which means that a SQL Azure machine is out of resources and it does not accept new connections. We can KNOW more about what happened by decoding reason codes. When database reaches its maximum size update /insert /create operations get throttled. Also there are policies in place that does not allow to a workload to exploit a shared physical server. In other words, the policies make sure that all workload get a fair share of shared physical server. Now, a workload can get soft throttled that means that the workload has crossed the safety threshold. A workload can also got hard throttled which means that a SQL Azure machine is out of resources and it does not accept new connections. We can know more about what happened by decoding reason codes. |
|