Category: Code

How to identify slow running queries in Sql Server

Recently, I was trying to pin point the queries in an application that were causing Sql Server to spike the CPU at 100%. This query was helpful in finding the top offenders. SELECT creation_time ,last_execution_time ,total_physical_reads ,total_logical_reads ,total_logical_writes ,execution_count ,total_worker_time ,total_elapsed_time ,total_elapsed_time / execution_count avg_elapsed_time ,SUBSTRING(st.text, (qs.statement_start_offset/2) + 1 ,((CASE statement_end_offset WHEN -1 THEN DATALENGTH(st.text) […]

Using MySQL with Entity Framework and ASP.NET MVC – Part II

I am going to wrap up this two part series on using MySQL with Entity Framework. Below is a link to the initial installment. Using MySQL with Entity Framework and ASP.NET MVC – Part I In Part I, we created a database schema in MySQL, generated a data model using Entity Framework, and wrapped the […]