none
After I upgrade from Managment Studio 18.0 to 18.1, I have an error in my select statements RRS feed

  • Question

  • I am trying to call a table function and it is a query that executes several Selects with union, and it take 0 seconds. I run the function from Managment Studio 17.9.1 and it works perfect.

    The error I have is : "The query has been canceled because the estimated cost of this query (28) exceeds the configured threshold of 3. Contact the system administrator.

    Managment Studio 18 and 18.1 comes with a lot of bugs!!!

    First with Managment Studio 18.1 was the problem of the Database Diagrams node missing, later when changing tabs the problem of accelerate hardware don't permit refresh the windows,  now queries don't run !!!


    Tuesday, June 25, 2019 7:10 PM

Answers

  • Check your QUERY_GOVERNOR_COST_LIMIT setting under Query-->Query Options-->Advanced. Make sure the value is set to zero.

    Database diagrams should be back in the SSMS 18.1 version. Do you not see the node?


    Dan Guzman, Data Platform MVP, http://www.dbdelta.com

    Tuesday, June 25, 2019 7:36 PM
    Moderator

All replies

  • Check your QUERY_GOVERNOR_COST_LIMIT setting under Query-->Query Options-->Advanced. Make sure the value is set to zero.

    Database diagrams should be back in the SSMS 18.1 version. Do you not see the node?


    Dan Guzman, Data Platform MVP, http://www.dbdelta.com

    Tuesday, June 25, 2019 7:36 PM
    Moderator
  • To clarify Dan's post: the message you get has nothing to do with SSMS, but this is a limitation enforced by the DBA through Resource Governor, a component in SQL Server.


    Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

    Tuesday, June 25, 2019 9:48 PM
    Moderator
  • Hi Carlos Cerda,

    The value of QUERY_GOVERNOR_COST_LIMIT is a numeric or integer value specifying the longest time in which a query can run. Specifying 0 (the default) for this option turns off the query governor, and all queries are allowed to run indefinitely.

    Best regards,
    Cathy ji

    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to  MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Wednesday, June 26, 2019 7:41 AM