Blog Archives

SQL Server Tips

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:

Ads