1. Isolate long-running queries. 2. Identify the cause of long-running queries.refer the below links, https://msdn.microsoft.com/en-us/library/ff650689.aspx http://www.codeproject.com/Articles/34372/Top-steps-to-optimize-data-access-in-SQL-Server