Hey there :) 

On a webshop im support we been running on this umbraco installation for almost 3 years, its been upgraded a few times until we hit last 4.x. Then i looked at upgrading to 6.x and tried to 6.2.4, but apprantly when its an azure bound sql it gets hit by this error:

http://issues.umbraco.org/issue/U4-5673

So i figured out that i could run on a 6.1.6. Ive copied down a db, upgraded, got a good clean installation up and running. Locally, there is no errors thrown and it running like a charm. Then when im migrating to azure SQL(of course using the migrate tool). Now i see pages take about 25sec on loading and a ton of these on the log :

2014-12-15 07:57:18,935 [27] INFO  Umbraco.Core.Persistence.UmbracoDatabase - [Thread 13]    at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   at System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   at System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   at System.Data.SqlClient.SqlDataReader.get_MetaData()
   at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString)
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, SqlDataReader ds)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean asyncWrite)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   at System.Data.Common.DbCommand.ExecuteReader(CommandBehavior behavior)
   at StackExchange.Profiling.Data.ProfiledDbCommand.ExecuteDbDataReader(CommandBehavior behavior) in c:\Code\github\SamSaffron\MiniProfiler\StackExchange.Profiling\Data\ProfiledDbCommand.cs:line 235

And if i look in the mini profiler i see that its this call taking up all the time(which i think is just looking up a node):

<ExecuteReaderWithRetry>b__3 ExecuteAction ExecuteReaderWithRetry ExecuteReaderWithRetry ExecuteReaderWithRetry MoveNext Fetch GetByVersion GetByVersion setupNode getMediaDo <GetMedia>b__0 GetCacheItem GetCacheItem GetCacheItem GetCacheItem GetCacheItem GetCacheItem GetMedia LoadCustomPropertyNotFoundInExamine GetProperty GetProperty TryGetMember Execute ExecutePageHierarchy ExecutePageHierarchy ExecutePageHierarchy ExecutePageHierarchy ExecuteRazor Execute loadMacroScript renderMacro CreateChildControls OnInit ProcessRequest
DECLARE @0 nvarchar(40) = N'3d4bad19-163a-4675-bbfd-001349a501fc';

SELECT *
FROM [cmsContentVersion]
INNER JOIN [cmsContent]
ON [cmsContentVersion].[ContentId] = [cmsContent].[nodeId]
INNER JOIN [umbracoNode]
ON [cmsContent].[nodeId] = [umbracoNode].[id]
WHERE ([umbracoNode].[nodeObjectType] = 'b796f64c-1f99-4ffb-b886-4bf4bc011a9c')
AND (cmsContentVersion.VersionId = @0)
ORDER BY [cmsContentVersion].[VersionDate] DESC   

Cannot see why this is acting up, first i thought something was wrong in the db, tried to recopy and upgrade again, but now im loosing abit of hope and cannot figure it out. Been sinking quite some hours into it.

Anyone who can help or have seen anything like this?