InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
How Do You Improve The Performance Of A Sql Azure Database? |
|
Answer» We can tune a SQL Azure database using INFORMATION available from execution plan and statistics of a query. We could use SQL Azure Dynamic Management views to monitor and manage SQL Azure database. Also, SQL Azure performance is AFFECTED by network latency and BANDWIDTH. CONSIDERING this, code in APPLICATION topology gives the best performance. We can tune a SQL Azure database using information available from execution plan and statistics of a query. We could use SQL Azure Dynamic Management views to monitor and manage SQL Azure database. Also, SQL Azure performance is affected by network latency and bandwidth. Considering this, code in application topology gives the best performance. |
|