Monthly Archives: June 2017

Useful queries when troubleshooting performance issues in SQL Server

Here are the some of the queries which are very useful when troubleshooting performance issues in SQL Server. This query will return actual execution plan of a given stored procedure. select o.object_id, s.plan_handle, h.query_planfrom sys.objects oinner join sys.dm_exec_procedure_stats s on

Posted in RDMS Tagged with:

HttpCompileException error when browsing web application

If you setup a new web application on new application server, you may encounter following error when you browse your web application.  If you look at the error message, it says that it could not write to output

Posted in Microsoft Technology Tagged with: