Comments
Sort by recent activity
Hi,
I vote from me for support of AS.NET Core 1.0.0 and Entity Framework Core 1.0.0. Just starting work on using Core RTM and profiling would be very helpful. / comments
Hi,
I vote from me for support of AS.NET Core 1.0.0 and Entity Framework Core 1.0.0. Just starting work on using Core RTM and profiling would be very helpful.
Thanks Anu,
Just thought I should post on here in case anyone has a similar problem.
The first problem with SqlCompare was my mistake. I needed to type '(localdb)mssqllocaldb' into the server dropdown as it won't find the localdb server itself. I thought it did but it doesn't.
The second error with the SSMS Add-in is a real bug and RedGate are looking at it. Because I saw this bug I kind of assumed that SqlCompare was broken too, which it isn't.
I hope that helps anyone moving to a new machine. / comments
Thanks Anu,
Just thought I should post on here in case anyone has a similar problem.
The first problem with SqlCompare was my mistake. I needed to type '(localdb)mssqllocaldb' into the server dropd...
Hi sallgeud,
I have been talking directly with RedGate via their support desk. It does look like there is something funny going on with async timings and they are working on it.
On the logging the database access it seems that isn't supported in async mode currently.
Jon / comments
Hi sallgeud,
I have been talking directly with RedGate via their support desk. It does look like there is something funny going on with async timings and they are working on it.
On the logging the ...
Hi Alex,
Sorry in the delay in getting back to you but I had other work I needed to press on with.
I have looked at your suggestions and the documentation. I am definitely have View->Async Mode ticked and the advanced setting has 'Profile with Async awareness' ticked. I also swapped to wall-clock timing, ms.
Problem is I still have the same problem, i.e.
1) The Time to await reads as 75,897 ms (for instance) for the call to the Detail view, but Chrome developer said the call finished in 30 ms (Load was 308ms)
2) I don't get any database calls listed in ANTS view, i.e. if i select 'Database calls' in the View dropdown list is says 'No SQL queries were recorded ... etc.'
The application is an MVC5 web app running the action below. The GetRenderLabelGroupAsync method which has a couple of database calls, both using Async. public async Task<ActionResult> Details(int labelGroupId, IGenericActionsDbContext db)
{
var status = await RenderSetupDto.GetRenderLabelGroupAsync(db, labelGroupId, false);
if (status.IsValid)
return View(status.Result);
//else error, so set status and return to index page
TempData["Status"] = status;
return RedirectToAction("Index");
}
I have Isolated the call by leaving plenty of time before and after it. Also, as I said in my last post, I took the trouble to convert it all to sync and ANTS worked perfectly.
What on earth am I doing wrong? / comments
Hi Alex,
Sorry in the delay in getting back to you but I had other work I needed to press on with.
I have looked at your suggestions and the documentation. I am definitely have View->Async Mode tic...
Hi Alex,
Thanks for getting back to me and sorry for the delay my end - on a project at the moment so have to fit this in at the weekend.
Firstly I have taken screenshots but there doesn't seem to be any way to attach them to a post. If you go to my web site at http://www.thereformedprogrammer.net/ (didn't want to put my email in post!) and send me your email I can email you the screenshots.
Anyway, onto your questions:
1) The timings in ANTs are wall-clock milliseconds and are typically > 10,000ms . The chrome timing are from the developer tools->Network page and the time I have quoted is the total time that Chrome was waiting for the page, typically 50ms (note: the page contains all the database accesses - none are done by Ajax at the moment).
2) I turned off "Adjust timings to compensate for overhead added by the profiler" advanced option and it made no difference to the timings.
3) I turned off the "Profile with Async awareness" option and I still could not see the database accesses. I also tried turning off Async Mode in the the View, but that did not reveal the database access either.
So, no joy there at all. / comments
Hi Alex,
Thanks for getting back to me and sorry for the delay my end - on a project at the moment so have to fit this in at the weekend.
Firstly I have taken screenshots but there doesn't seem to ...
Further to this post I took the trouble to change a specific part of the MVC code to NOT use async. When I did that then a) the timings were sensible and b) I could see the database accesses. Going back to async gave wrong timing and no access to database calls. / comments
Further to this post I took the trouble to change a specific part of the MVC code to NOT use async. When I did that then a) the timings were sensible and b) I could see the database accesses. Going...