CODEWITHSUNDEEP
sql-serverasp.net-mvcperformanceasp.net-mvc-4
Vitalii
Vitalii

Reputation: 11071

How to check ASP.NET MVC4 application performance?

I'm new in asp.net mvc4 and need some advices.

At my project some images are stored and load from SQL 2008 server. Everything is ok and they loads fast from there till user authorizes. After it images become load twice slower.

Why does this appear? I use only one database (shared hosting restrictions) and one user connects to it. I have two connections to DB. First for entity framewors and other for simple authorization. Maybe this is a problem?

   connectionStrings
add name="AuthorizationConnection" providerName="System.Data.SqlClient" connectionString="data source=**********;initial catalog=*****;persist security info=True;user id=SQLUser;password=*********;" /
add name="AMKEntities" connectionString="metadata=res://*/Models.AMKDBEntities.csdl|res://*/Models.AMKDBEntities.ssdl|res://*/Models.AMKDBEntities.msl;provider=System.Data.SqlClient;provider connection string="data source=**********;initial catalog=*****;persist security info=True;user id=SQLUser;password=**********;MultipleActiveResultSets=True;App=EntityFramework"" providerName="System.Data.EntityClient" /
/connectionStrings

Also from all images what are being loaded only 4-6 images from about 30 loads with delay (all images are category images with the same dimensions about 10Kb). But these 4-6 images from 30 seems selected randomly. Each page refresh only 20% loads slow. Other loads immediately.

Upvotes: 2

Views: 433

Answers (1)

Jack
Jack

Reputation: 2650

Try Miniprofiler, it's easy to use and this is what Stackoverflow uses to profile their site.

Here is the link:

http://miniprofiler.com/

Upvotes: 3

Related Questions