How to Collect and Investigate Performance Data to Solve SQL Server Workload Crimes with Foglight SQL PI
Sponsored by: Dell
April 15, 2015
On-Demand Webinar
In the first part of this webcast Michael Otey, senior contributing editor for Windows IT Pro and SQL Server Pro discusses the importance of performance monitoring and creating performance baselines for your business critical SQL Server systems. You’ll see how performance baselines can help you monitor your SQL Server performance and perform capacity planning as well as to more quickly troubleshoot performance problems. Then you’ll learn about some of the most important Windows Server and SQL Server performance metrics that you should track.
Next, you’ll see how to investigate and resolve SQL Server performance issues when you join Dell experts Robert Wijnbelt and Kevin Selinger. You’ll learn how to apply real-time and historical performance monitoring to both virtualized and non-virtualized databases. Plus, you’ll see how to get fast, accurate and detailed SQL workload analytics within a flexible monitoring platform. Our experts will also show you how to monitor thousands of instances within a single download-and-go installation, while gaining deep-dive operational and workload data collection and retention.
Discover how you can solve SQL Server performance crimes with Foglight’s SQL PI!
Fast workload analytics with historical session data
Easy navigation through performance metrics
Forensic-level analysis of real-time and historical data
Deep-dive Lock Analysis and TempDB Analysis
Change tracking for database configuration, objects, execution plan and system configuration to quickly see the impact on database performance
Register Now!
If you have already registered, click here to access
Presenters
Michael Otey, senior contributing editor for Windows IT Pro and SQL Server Pro, is president of TECA, a software-development and consulting company in Portland, Oregon. Michael has covered the topic of virtualization extensively for Windows IT Pro, having written several features articles showing how to take advantage of virtualization in the enterprise as well as reviewing all of the major virtualization products. He also previously served as technical director for Windows IT Pro and SQL Server Pro. Email him at [email protected] Follow Michael on Google+ and Twitter.
Robert Wijnbelt is a Senior Product Manager at Dell Software. With over 18 years experience in the application performance and infrastructure management markets, Robert has lead the design, development, and sales of Dell’s market leading monitoring solution, Foglight. During his career at Dell as well as prior, Robert was involved in Consultative sales for Enterprise solutions to Industry leaders in healthcare, financial services, retail and technology, collaborating with upper and C-level management to define the optimal solutions to address their respective companies’ complex problems. He holds a master’s degree in computer science from the University of Twente in the Netherlands.
Kevin Selinger, Systems Consultant will Dell Software Group for the past 11 years. Prior to that I have worked in the Presales role as a pre-sale engineer for the past 20 plus years supporting solution from Mainframe Operations, Client Support Solutions to Database Performance and Administration.
About the Author
You May Also Like