SQL Server misunderstanding 30th talk about the 22nd day resource regulators can regulate io_mssql

Source: Internet
Author: User
Myth #22: Resource regulators can control IO
Error
The resource Governor is unable to control Io, and the next version of SQL Server is expected to support regulatory IO, which is useful for reducing the performance impact of scan operations on large tables.
The feature resource Governor in the following list also cannot complete:

  • Control buffer pool memory, the memory governor can only control the memory of the execution plan, but the cached data pages in buffer pool are not regulated
  • Multiple instances can be used as a logical entity for resource control. This is not possible, for multiple instances of resource regulation can only be implemented through the Windows Server Resource Governor, on which the resource Governor is set on each instance
  • Allows the resource governor to monitor the use of resources, alerting when thresholds are exceeded

Don't be wrong, I am not saying that the resource regulator is not good, but added the above function will be better.
One of my friends, also the project manager of SQL MVP Aaron Bertrand and SQL team, wrote a white paper on this: Using the Resource Governor.
Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.