Performance Troubleshooting made easy with PAL

2010

TL; DR

If you've ever needed to review large Performance Monitor (PerfMon) logs and find problems quickly - you'll know how time consuming it can be to identify problems. Performance Analysis for Logs (PAL) is a great tool to quickly highlight performance problems - taking the leg-work out of PerfMon log analysis.

Session Details

Performance troubleshooting is a key aspect of any operational DBA's role and identifying performance bottlenecks quickly enables faster problem resolution. PAL helps identify problems quickly by processing large log files and providing a colour-coded report highlighting problem areas. Here's a summary of the session:

Performance troubleshooting
- Troubleshooting methodology
- Data capture
Using Performance Analysis for Logs (PAL)
- Analysing PerfMon log files
- Tuning thresholds
- Working with theshold templates
Post-analysis steps
- Establish a baseline
- Next steps for troubleshooting

3 things you'll get out of this session

Justin Langford's previous sessions

5 Mistakes in Cloud Data Migration

We're fortunate in seeing tons of customers migrate to the cloud - this session covers major

Azure: Maxmise your bang for Buck

Considerations in how you buy Azure to provide maximum bang for buck

Serverless data solutions-what are they and when to use?

Azure introduces a range of new services for transaction processing and analytics solutions which mean we don’t need to deploy virtual machines. This session provides insight into how we see customers deploying evergreen and futureproof solutions.

Hybrid Data Solutions-how to have you cake and eat it!

We live in a cloud first World, but many organisation still run largely on-premise. This session covers how these organisations can begin their journey and leverage Azure data services.

Get started with troubleshooting SQL Server

This session present key tools, methodology and approach for troubleshooting SQL Server. Performance and availability of the database engine has a direct impact on user experience of applications.

DR with the Worlds largest data center

This session will look at providing cost effective DR capability with Azure.

Using Windows Azure to provide SQL Server Disaster Recovery

This session provides an architectural blueprint to deploying disaster recovery solutions combining on-premise and Windows Azure cloud technologies. The session looks at a design pattern to solve a long standing and often expensive issue of DR.

Hadoop, Big Data and SQL Server

There has been rapid development in the capabilities of SQL Server to support big data and hadoop following introduction of the HDInsight Service and HDInsight Server. This session covers SQL Server capability and integration points.

Notes from the field: Cross-team Performance Troubleshooting

This session will be presented jointly by Justin Langford and Gavin Payne . The focus of the session is the approach to a cross-team Performance Troubleshooting engagement where multiple stakeholders were involved.

Notes from the field: High Performance storage for SQL Server

This session provides an overview of a recent customer engagement to investigate storage performance problems and evaluate potential solutions. The session include details on measuring performance of the existing storage solution, profiling SQL Server disk IO activity and tools to simulate load and evaluate performance.