webcast signup header

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.

Webcast Date

Tuesday, September 17, 2019
3:00:00 PM EDT | 7:00:00 PM UTC

Speaker(s)

presenter 1
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.

presenter 2

Louis Diaz-Delgado
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”.


Sponsored by

sponsor logo


Register for this webinar:

First Name*


Last Name*


Business Email*


Organization*


Org Address*


Org City*


Org State


Org Postal Code*


Org Country*


Org Phone*


Industry*


Job Title*


# of SQL Servers*


Organization Size*


SMS reminder
carrier: number: (5551234567)


Save My Details

Register me for these webinars too:

 
SQL Server on AWS Cloud: One Customer's Journey and Experience
Thursday, September 19, 2019 - 1:00:00 PM EDT
Speaker(s): Dave Bermingham and Tom Staab - Sponsor: SIOS

 
Keep SQL Server’s Always On Running Smoothly
Tuesday, September 24, 2019 - 3:00:00 PM EDT
Speaker(s): Rey Rios - Sponsor: IDERA

 
Improving SQL Server Queries by Reading and Understanding Execution Plans
Thursday, October 03, 2019 - 1:00:00 PM EDT
Speaker(s): K. Brian Kelley - Sponsor: Quest

Signup for our newsletter

I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.


 

 


Copyright (c) 2006-2018 Edgewood Solutions, LLC All rights reserved
Some names and products listed are the registered trademarks of their respective owners.