1 / 13

Hey PowerShell E venting, Can Y ou N otify M e ?

Explore how WMI and WQL can enhance event monitoring in SQL Server to create a sophisticated notification system. Learn to trigger alerts based on specific events and conditions, from server downtime to critical thresholds. Leverage the power of Windows Management Instrumentation for precise event tracking. Stay informed with real-time alerts for various scenarios, such as database mirroring status or suspect pages. Enhance your IT monitoring capabilities with practical examples and guidelines. Dive deeper into event query language to streamline your monitoring processes effectively.

haviva-barnett
Download Presentation

Hey PowerShell E venting, Can Y ou N otify M e ?

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Hey PowerShell Eventing, Can You Notify Me ? Laerte Junior @laertesqldba www.shellyourexperience.wordpress.com http://www.simple-talk.com/author/laerte-junior/ http://sqlpsx.codeplex.com/

  2. Brazil

  3. My Skills • I Know a Bit of PowerShell (3 years) • I DO like to play with SQL Server (12 years) • BETTER COFFE MAKER FROM BRAZIL (30 years)

  4. Notification System • Your Bank send a SMS about a transaction • Your car warning you when something wrong happens • Your body alerts you when something is not right

  5. DARKNESS

  6. WMI • WMI is an acronym for Windows Management Instrumentation • Registry, File and Disk systems, Services and processes, Printers ,Networking, IIS, Performance Counters • WMI Provider For Server Events • The WMI Provider for Server Events lets you use the Windows Management Instrumentation (WMI) to monitor events in SQL Server.

  7. Windows Management Instrumentation Query Language • SQL ANSI with WMI-Specific Extensions • SELECT{ event_property [ ,...n ] | * } FROM event_type WHERE where_condition EVENT QUERY LANGUAGE SELECT <Propertie-List> FROM <Event-Class Name> <WITHIN Seconds> WHERE <Instace-State> ISA '<Wmi-Class Name>' "select * from __InstanceModificationEvent within 5 where TargetInstance ISA 'Win32_Service' and TargetInstance.Name='MSSQLSERVER' and TargetInstance.State='Stopped‘”

  8. THE BEAUTY OF WQL • WQL for WMI/WMI SQL • WQL For Event Query

  9. DEMO

  10. WMI/WQL – EVENT QUERY • Show a Balloon tip (SQL Server Stops) • Alert CPU Threshold • Alert SQL Server Process CPU Threshold • Alert Free Disk Space WMI/WQL – Server Events • Monitoring Database Mirroring • Monitoring Database Suspect Pages • Mointoring Database Options (eventlog)

  11. What is The Ideia ? Server 1 Register The Event Monitoring Server Trigger The Event Write in EventLog Server 2 Register The Event Trigger The Event Write in EventLog Trigger The Event Send Email

  12. Coming up… • #SQLBITS

More Related