How to do Availability Test for SQL Database Resource in Azure?
up vote
2
down vote
favorite
Am working on Log Analytics,Application Insights and alerts in Azure. Here,I can easily doing availability test for my Web Applications to know my application availability. Same as this, am trying to do availability test for SQL Database and Storage Accounts. With the help of metrics am able see availability of storage account, but in the case of SQL database am not able to do availability test. Is there any way to do Availability Test for SQL Database resource, If it is there Please suggest me to "How to do it"
azure azure-sql-database availability
add a comment |
up vote
2
down vote
favorite
Am working on Log Analytics,Application Insights and alerts in Azure. Here,I can easily doing availability test for my Web Applications to know my application availability. Same as this, am trying to do availability test for SQL Database and Storage Accounts. With the help of metrics am able see availability of storage account, but in the case of SQL database am not able to do availability test. Is there any way to do Availability Test for SQL Database resource, If it is there Please suggest me to "How to do it"
azure azure-sql-database availability
add a comment |
up vote
2
down vote
favorite
up vote
2
down vote
favorite
Am working on Log Analytics,Application Insights and alerts in Azure. Here,I can easily doing availability test for my Web Applications to know my application availability. Same as this, am trying to do availability test for SQL Database and Storage Accounts. With the help of metrics am able see availability of storage account, but in the case of SQL database am not able to do availability test. Is there any way to do Availability Test for SQL Database resource, If it is there Please suggest me to "How to do it"
azure azure-sql-database availability
Am working on Log Analytics,Application Insights and alerts in Azure. Here,I can easily doing availability test for my Web Applications to know my application availability. Same as this, am trying to do availability test for SQL Database and Storage Accounts. With the help of metrics am able see availability of storage account, but in the case of SQL database am not able to do availability test. Is there any way to do Availability Test for SQL Database resource, If it is there Please suggest me to "How to do it"
azure azure-sql-database availability
azure azure-sql-database availability
asked Nov 21 at 18:18
Mani
209115
209115
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
up vote
1
down vote
Availability Tests in Application Insights support Multi-step tests. With them it is possible to test REST APIs (with authentication flow or hardcoded tokens). SQL Azure supports REST API for CRUD (management) operations. If this is enough for availability for your case - it should work.
Another approach - stand up something simple (Azure Function?) which will run queries your business logic needs to check for availability. Then point Availability Tests in Application Insights to this Azure Function.
Availability Tests in Application Insights don't support DB protocols.
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
1
down vote
Availability Tests in Application Insights support Multi-step tests. With them it is possible to test REST APIs (with authentication flow or hardcoded tokens). SQL Azure supports REST API for CRUD (management) operations. If this is enough for availability for your case - it should work.
Another approach - stand up something simple (Azure Function?) which will run queries your business logic needs to check for availability. Then point Availability Tests in Application Insights to this Azure Function.
Availability Tests in Application Insights don't support DB protocols.
add a comment |
up vote
1
down vote
Availability Tests in Application Insights support Multi-step tests. With them it is possible to test REST APIs (with authentication flow or hardcoded tokens). SQL Azure supports REST API for CRUD (management) operations. If this is enough for availability for your case - it should work.
Another approach - stand up something simple (Azure Function?) which will run queries your business logic needs to check for availability. Then point Availability Tests in Application Insights to this Azure Function.
Availability Tests in Application Insights don't support DB protocols.
add a comment |
up vote
1
down vote
up vote
1
down vote
Availability Tests in Application Insights support Multi-step tests. With them it is possible to test REST APIs (with authentication flow or hardcoded tokens). SQL Azure supports REST API for CRUD (management) operations. If this is enough for availability for your case - it should work.
Another approach - stand up something simple (Azure Function?) which will run queries your business logic needs to check for availability. Then point Availability Tests in Application Insights to this Azure Function.
Availability Tests in Application Insights don't support DB protocols.
Availability Tests in Application Insights support Multi-step tests. With them it is possible to test REST APIs (with authentication flow or hardcoded tokens). SQL Azure supports REST API for CRUD (management) operations. If this is enough for availability for your case - it should work.
Another approach - stand up something simple (Azure Function?) which will run queries your business logic needs to check for availability. Then point Availability Tests in Application Insights to this Azure Function.
Availability Tests in Application Insights don't support DB protocols.
answered Nov 21 at 19:59
ZakiMa
1,623822
1,623822
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Some of your past answers have not been well-received, and you're in danger of being blocked from answering.
Please pay close attention to the following guidance:
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53418298%2fhow-to-do-availability-test-for-sql-database-resource-in-azure%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown