×

Capital Area SQL Server User Group

Date/Time: Monday, October 13, 2025 5:30 PM to 7:30 PM EDT
Location: Rensselaer County Regional Chamber of Commerce 90 4th St #200 · Troy, NY

View Event: SQL Server Detective: Investigating Logs and Traces for Optimal Performance

Your role as a DBA is crucial, as a pivotal figure in the realm of Microsoft SQL Server. Your ability to monitor and analyze your server’s performance and troubleshoot issues is essential, and it’s what keeps the system running smoothly. One of the most effective ways to do this is by utilizing the built-in data collection, which records a wealth of information.

This session will delve into six collections (Logs and traces) that can provide valuable insights into your server’s configuration, health, and performance. By the end of this session, you will be equipped with practical knowledge that will empower you to handle any SQL Server issue confidently.

• Default trace
• SQL Error log
• SQL Agent Error log
• System_health
• AlwaysOn_health
• Telemetry xEvents

I will show you each one’s default location, retention, and content captured. We will discuss how to access and interpret these logs and demonstrate how they can be used to identify and diagnose issues such as failed logins and deadlocks, the health of the Windows cluster and availability group, and schema changes. By effectively utilizing the SQL Blackbox, you can ensure the smooth operation of your server and maintain the highest performance and reliability.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.



profile for SqlWorldWide on Stack Exchange, a network of free, community-driven Q&A sites

Kubernetes Learning Path

50-days from zero to
hero with Kubernetes

Download eBook