Windows Management Framework WMF overview
Windows Management Framework WMF is a Windows-based, cross-server architecture for the consistency management interface. It contains the following features:
Windows PowerShell
Windows PowerShell Desired State Configuration (DSC)
Windows PowerShell Integrated Script Environment (ISE)
Windows Remote Management (WinRM)
Windows Management Instrumentation (WMI)
Windows PowerShell Web Services (Management OData IIS Extension)
Software Inventory Logging (SIL)
Server Manager CIM Provider
Windows Remote Management Architecture
650) this.width=650; "title=" clip_image002 "style=" Margin:0px;background-image:none; "border=" 0 "alt=" clip_image002 "Src=" http://s3.51cto.com/wyfs02/M02/06/27/wKiom1myW5ChOx2aAADEbURKgk0839.jpg "height=" 541 "/>
650) this.width=650; "title=" clip_image004 "style=" Margin:0px;background-image:none; "border=" 0 "alt=" clip_image004 "Src=" http://s3.51cto.com/wyfs02/M02/A4/D8/wKioL1myW2_w-vYBAAC0HrCeINA807.jpg "height=" 399 "/>
Windows Management Instrumentation Architecture
650) this.width=650; "title=" clip_image006 "style=" Margin:0px;background-image:none; "border=" 0 "alt=" clip_image006 "Src=" http://s3.51cto.com/wyfs02/M01/06/27/wKiom1myW5LxfPh5AADg3npn27c266.jpg "height=" 479 "/>
650) this.width=650; "title=" clip_image008 "style=" Margin:0px;background-image:none; "border=" 0 "alt=" clip_image008 "Src=" Http://s3.51cto.com/wyfs02/M00/A4/D8/wKioL1myW3GwghmUAAHZ-DWBL0A208.png "height=" 379 "/>
For DBAs, WMI can be used to monitor the following two aspects:
1. Create a SQL Server Agent alert using WMI Provider for Server events.
2. Use PowerShell to subscribe to events generated by WMI.
Windows PowerShell Desired State Configuration
DSC is a customizable platform for system configuration, deployment, and management.
Some background of DSC
A new configuration management tool is created to manage platforms, applications, and the infrastructure above the cloud to ensure that the cloud runs under high availability. The demand for these new tools and infrastructures comes from cloud-scale growth, rapid updates, and complexity. However, existing tools are limited to Windows-only support.
Windows PowerShell expected state configuration (DSC) provides a configuration platform that is built into Windows, based on the public standard. DSC has the flexibility, stability, and consistency to function at each stage of the deployment cycle (development, test, pre-release, and release), as well as when scaling out, which is what the cloud computing environment needs.
What is DSC?
On-premises and on the cloud, DSC will give you a powerful and easy way to manage your Windows infrastructure. It is implemented by introducing a very simple syntax declaration into the PowerShell language, and a built-in engine to receive and apply these configurations. You use this new declarative syntax to declare an expected state of your environment, and then distribute it to each of the target nodes that make up your environment. After the configuration has been delivered and applied, it can be used to correct configuration deviations when the configuration is biased, or only to report configuration deviations to you, letting you know what's going on.
PowerShell provides two modes: Push mode and Pull mode
While most of the tools support both modes, there are some tools like push mode, such as ansible, and some tools like pull mode, such as puppet and chef. There is a lot of debate about these two models. Push mode is simpler and easier to control: it does not need to install any specific software on the target node, and the configuration is triggered when the user requests it. Pull mode is more scalable and supports rich metadata: the target node completes its own configuration work, asynchronously, and pulls the server to centrally store the metadata for each target node state.
650) this.width=650; "title=" clip_image010 "style=" Margin:0px;background-image:none; "border=" 0 "alt=" clip_image010 "Src=" http://s3.51cto.com/wyfs02/M00/A4/D8/wKioL1myW3Ly9lQOAADKIbMYKho111.jpg "height=" 315 "/>
650) this.width=650; "title=" clip_image012 "style=" Background-image:none; "border=" 0 "alt=" clip_image012 "src=" http ://s3.51cto.com/wyfs02/m02/06/27/wkiom1myw5sjmgvxaadcshxtcx4140.jpg "height=" 318 "/>
For DBAs, you can deploy databases and manage databases through DSC.
Reference:
Https://docs.microsoft.com/zh-cn/powershell/wmf/readme
Https://msdn.microsoft.com/en-us/library/aa384464.aspx
Https://msdn.microsoft.com/en-us/library/aa394553.aspx
Https://docs.microsoft.com/en-us/powershell/dsc/overview
https://www.red-gate.com/simple-talk/sysadmin/powershell/powershell-desired-state-configuration-the-basics/
Http://www.pstips.net/monitor-event.html
https://docs.microsoft.com/en-us/sql/relational-databases/wmi-provider-server-events/ Wmi-provider-for-server-events-concepts
This article is from the SQL Server deep Dive blog, so be sure to keep this source http://ultrasql.blog.51cto.com/9591438/1963767
Windows Management Framework WMF overview