Hello @Jaya Prakash - Thanks for reaching out.
You can use Azure Monitoring for that and also create alerts and use them based on performance counters (CPU / memory, etc)
You can use it directly through the Azure Portal, or connect using c# for example.
Also there is a new product Azure SQL Analytics that is still in preview can also be used for cloud monitoring.
Take a look at this doc for more info : Azure SQL Monitoring
Hope this helps.
If the above response helped, Please feel free to "Accept as Answer" so it can be beneficial to the community.