TAILIEUCHUNG - Hướng dẫn học Microsoft SQL Server 2008 part 96

Tham khảo tài liệu 'hướng dẫn học microsoft sql server 2008 part 96', công nghệ thông tin, cơ sở dữ liệu phục vụ nhu cầu học tập, nghiên cứu và làm việc hiệu quả | Part VI Enterprise Data Management Server will not execute it. By default the query governor cost limit option is set to 0. This value allows all queries to execute no matter how long they will take. The query governor cost limit option will not abort queries with an estimated duration of less than the limit but a longer actual duration. In Management Studio the query governor cost limit configuration option can be set by typing the limit in the Use query governor to prevent long-running queries box in the Server Properties Connections tab refer to Figure 39-8 . The following code sets the query governor cost limit to 300 seconds for the entire server EXEC sp_configure show advanced options 1 RECONFIGURE EXEC sp_configure query governor cost limit 300 RECONFIGURE In code the query governor can also be changed for the current connection. The following code overrides the currently configured query governor cost limit value for the current connection and sets it to 15 seconds SET QUERY_GOVERNOR_COST_LIMIT 15 running queries. The query governor cost limit option can be used to stop long-running queries before they start thereby helping to prevent system resources from being consumed by these long- Remote access The remote access option allows running local stored procedures from remote servers or remote stored procedures from the local server. By default the remote access option is enabled. ÏJOvë The remote access option applies only to servers added using sp_addserver and is included for backward compatibility. Using this feature is not recommended as it will be removed in the next version of Microsoft SQL Server. Use the sp_addlinkedserver feature instead. To disallow remote access uncheck the Allow remote connections to this server check box in Management Studio in the Server Properties Connections tab refer to Figure 39-8 or set the remote access option to 0 in code EXEC sp_configure remote access 0 RECONFIGURE The SQT Server service must be restarted in order for