Perth Microsoft Data and Analytics User Group

Event

Next Meeting: Wed, Feb 24 2016

Know what your machines are doing besides SQL Server - WMI, WQL, and PoSH

Language: English
Event Type: In-Person
Online Meeting URL: None
RSVPURL: https://www.eventbrite.com/e/pssug-know-what-your-machines-are-doing-besides-sql-server-wmi-wql-and-posh-michael-bourgon-tickets-21511381120

There's far more happening on your Windows servers than just SQL Server, and looking at ERRORLOG won't show you the whole story: other applications stealing your memory, OS issues, hardware errors, and more. We'll start by looking at different ways to collect Event Logs. From there we'll delve into WMI and WQL, which allow us to query servers (remotely or locally) to get information such as performance statistics, System and Event Logs, and even changes within SQL Server. We'll finish it off with two immediately-usable implementations you can set up on Monday.

When

iCal
UTC : Wed, Feb 24 2016 09:00 - 11:00
Event Time : Wed, Feb 24 2016 17:00 - 19:00 (UTC+08:00) Perth
Your Local Time: Wed, Feb 24 2016 09:00 - 11:00

Where

Level 3, 100 St George's Terrace
Perth , WA

Direction: None

Featured Presentation

Know what your machines are doing besides SQL Server - WMI, WQL, and PoSH

Speaker: Michael Bourgon, Database Technical Lead

Summary: There's far more happening on your Windows servers than just SQL Server, and looking at ERRORLOG won't show you the whole story: other applications stealing your memory, OS issues, hardware errors, and more. We'll start by looking at different ways to collect Event Logs. From there we'll delve into WMI and WQL, which allow us to query servers (remotely or locally) to get information such as performance statistics, System and Event Logs, and even changes within SQL Server. We'll finish it off with two immediately-usable implementations you can set up on Monday.

About Michael: Michael Bourgon started his IT career by performing tech support and managing Sybase databases on Unix starting in 1995, before moving to SQL Server 7... continuing all the way to SQL Server 2017. His focus on automation has led him to such diverse topics as Service Broker, WMI, Table Partitioning, Shell scripting, In-Memory Tables, and Powershell. He's currently a senior DBA with a large healthcare company, dealing with millions of transactions of day and managing hundreds of servers. In his spare time he rides a bicycle, reads science fiction, blogs about SQL Server and Baking, and tries to raise his daughter to be a geek, too.

Attachments

PASSChapterLogo100.jpg 

PASS provides the Perth SQL Server User Group with this website and other resources.

Microsoft provides us with a venue in which to host our meetings once a month.

OnCall DBA provides us with complimentary refreshments each month.

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids