Hi,

I have a requirement where Azure Cloud Service brings back facebook posts (500 posts at the max) in one call and updates a SQL Server database. There could be 10 such service calls / sql updates in a minute. Would updating the database directly via the Azure Cloud Service be the right way to go about it?

Hi,

  I dont see any issues with sending update query from PAAS role.
  Can you briefly explain the exact setup/scenario.
  Are you using SQL Azure, if yes you can check this link for Database Tiers and performance levels.
 
Regards,
Nithin Rathnakar

Hi,

  I dont see any issues with sending update query from PAAS role.
  Can you briefly explain the exact setup/scenario.
  Are you using SQL Azure, if yes you can check this link for Database Tiers and performance levels.
 
Regards,
Nithin Rathnakar

• Marked as answer by Nithin.RathnakarMicrosoft contingent staff, Moderator 12 hours 57 minutes ago

Hi,

  I dont see any issues with sending update query from PAAS role.
  Can you briefly explain the exact setup/scenario.
  Are you using SQL Azure, if yes you can check this link for Database Tiers and performance levels.
 
Regards,
Nithin Rathnakar

• Marked as answer by Nithin.RathnakarMicrosoft contingent staff, Moderator Sunday, May 31, 2015 6:21 PM

Hi,

  I dont see any issues with sending update query from PAAS role.
  Can you briefly explain the exact setup/scenario.
  Are you using SQL Azure, if yes you can check this link for Database Tiers and performance levels.
 
Regards,
Nithin Rathnakar

• Marked as answer by Nithin.RathnakarMicrosoft contingent staff, Moderator Sunday, May 31, 2015 6:21 PM

Thanks. I don't have a SQL "Azure" database, it is a regular SQL Server on