Troubleshooting Performance Issues with SQL Server Agent
SQL Server Agent is the native job scheduler that DBAs often leverage to handle automating database backups, maintenance, and other functionality such as executing SSIS packages as part of a batch cycle. Some organizations even use SQL Server Agent for tasks that are not directly related to SQL Server. However, as powerful as it is, SQL Server Agent can have its share of issues that negatively impact the organization. In this webinar we'll take a look at how to troubleshoot SQL Server Agent issues. We'll demonstrate how to monitor and alert on performance with custom scripts, Extended Events and valuable PerfMon counters. We'll also cover how to look for other issues such as cases when a job can't start, when it never ends, and when jobs have the wrong security to perform what's expected. We will also learn about JAMS, which significantly saves time for Enterprise Job Management.
Tuesday, September 17, 2019
3:00:00 PM EDT | 7:00:00 PM UTC
Brian Kelley is an author, columnist, Certified Information Systems Auditor (CISA), and former Microsoft Data Platform (SQL Server) MVP (2009-2016) focusing primarily on SQL Server and Windows security. Brian currently serves as a data architect as well as an independent infrastructure/security architect concentrating on Active Directory, SQL Server, and Windows Server. He has served in a myriad of other positions including senior database administrator, data warehouse architect, web developer, incident response team lead, and project manager. Brian has spoken at 24 Hours of PASS, IT/Dev Connections, SQLConnections, the Techno Security and Forensics Investigation Conference, the IT GRC Forum, SyntaxCon, and at various SQL Saturdays, Code Camps, and user groups.
Workload Automation Expert and Support Engineer at HelpSystems
Louis is a seasoned workload automation and job scheduling specialist with extensive experience in solution identification, product implementation, user training, and enterprise planning. As an expert in JAMS and its integrations, he identifies and resolves workload automation deficiencies and improves the overall effectiveness and efficiency of daily operations for organizations worldwide. Louis co-authored the JAMS University training curriculum, and has written dozens of workload automation knowledge articles. Louis has presented workload automation topics at various technology community events including SQL Saturday, Ellucian Live, JDA Direct Commerce, Microsoft Tech Summit, and JD Edwards INFOCUS. Recent presentations include “SQL Automation – In the Cloud, On-Premise, and Hybrid” and “Workload Automation for JDA Direct Commerce”.
Register for this webinar:
Copyright (c) 2006-2018 Edgewood Solutions, LLC All rights reserved
Some names and products listed are the registered trademarks of their respective owners.