Home Forums SQL Server 2005 SQL Server 2005 Performance Tuning A stored procedure that usually runs fast ran for a long time yesterday RE: A stored procedure that usually runs fast ran for a long time yesterday

  • July 29, 2015 at 5:18 am

    #1815663

    Thanks for the reply sir. I googled on how to identify queries which are doing parallel scans but did not find. Could you please let me know how to identify those queries. Also, how much should i set cost threshold?