Query execution are longer sometimes RRS feed

  • Question

  • There is a SQL instance for which Application team reported SQL queries are timing out in application because of 30 seconds threshold set in application.

    The queries are executing all days and complete execution within few seconds as expectations. Some times the queries are taking more than 30 seconds for ex: SQL query timeout once in two hours.

    Could you please help?
    Tuesday, October 30, 2018 9:14 AM


All replies