Search between a Gas Station

Azure SQL DB causing connection time out for stored procedures We have hosted our database in Azure and are running stored procedures on this DB. The stored procedures had been running fine till last week but suddenly started giving error connection timeout. Our database size is 14 GB and the stored procedures in general return 2k to 20k records and we are using the S3 pricing tier (50 DTU) of Azure DB. What I found interesting was the first time the stored procedure is executed, it takes a lot of time 2 - 3 mins and this is causing the timeout. The later executions are fast (maybe it caches the execution plan). Also when I run on the same DB with the same number of records on a machine with the config of 8gb ram, Win10 it runs in 15 seconds . This is my stored procedure: CREATE PROCEDURE [dbo].[PRSP] @CompanyID INT, @fromDate DATETIME, @toDate DATETIME, @ListMailboxId as MailboxIds Readonly, @ListConversationType as ConversationTypes Readonly AS BEGIN ...

Cannot export Azure SQL database When I try to export my database via the 'Export' button in the Azure portal, I get the following error: Error encountered during the service operation. Could not extract package from specified database. The element DataSyncEncryptionKey_8d263adb59574052847134070b69d73d is not supported in Microsoft Azure SQL Database v12. Though I did at one point try the DataSync service, I never ended up using it and am certainly not using it now. I regret even trying this service because it created schemas in my database that I do not know how to remove completely. Now, it seems that these schemas are preventing me from exporting my database. At the very least, it would be nice to resolve this error. However, it would be better if I could remove all traces of the DataSync service. Please note that I have already used the script in the accepted solution to this question: How to remove SQL Azure Data Sync objects manually. That removed the DataSync schema bu...