Monitoring Linux Performance for the SQL Server Admin

Target Audience:

Windows SQL Administrators looking to learn performance monitoring techniques for Linux systems.

Abstract:

So you’re a SQL Server administrator and you just installed SQL Server on Linux. It’s a whole new world. Don’t fear, it’s just an operating system. It has all the same components Windows has and in this session we’ll show you that. We will look at the Linux operating system architecture and show you where to look for the performance data you’re used to! Further we’ll dive into SQLPAL and how it architecture and internals enables high performance for your SQL Server. By the end of this session you’ll be ready to go back to the office and have a solid understanding of performance monitoring Linux systems and SQL on Linux. We’ll look at the core system components of CPU, Disk, Memory and Networking monitoring techniques for each and look some of the new tools available including new DMVs and DBFS.

Why I Want to Present This Session:

As SQL on Linux matures and performance numbers are coming out it’s becoming a serious consideration for your data platform. With years of experience, scaling and monitoring Linux systems, I can show you want you need to look for when you’re experiencing a performance issue.

Additional Resources:

http://www.centinosystems.com/blog/

The following two tabs change content below.
Meet Anthony Nocentino, Enterprise Architect, Founder and President of Centino Systems, Pluralsight Author, Corporate Problem Solver and a voracious student of the latest computer science technology. Anthony is only satisfied when he finds the right technology resolution for his client’s business need.  Business today thrives on data – from the C-Suite to the information worker.  Anthony specializes in all things related to data – database systems, virtualization, system and network design and performance engineering.  He designs solutions, deploys the technology and provides expertise on business system performance, architecture and security.    Anthony has a Masters in Computer Science and is working towards a PhD focusing on high performance/low latency data access algorithms on solid state disks.  Anthony is interested in engaging with anyone who strives to understand how data drives business decisions.  He seeks to work with technologists he can teach as he solves the bigger business problems faced by today’s enterprises.
Previous Post
Open Source PowerShell Core on Linux and Mac
Next Post
[PRECON] Introduction to R

3 Comments. Leave new

This is one of those sessions where the title really lays out the audience perfectly. It sounds plain in the way that “Watch Brent Tune Queries” sounds plain, but it works perfectly.

It’s also one of those sessions where you don’t have to explain prerequisites or set the right level – everybody’s coming in with the same basic knowledge, which is near zero.

The only thing I can think to say is that some folks (not me) think exclamation marks should be used really sparingly, like when death is involved. I disagree! However, two in a row might be a little much. But I’m reaching. I’m reaching, I tell you!

Reply

This looks good, all of that top/iostat/etc stuff can seem like black magic to someone coming from a Windows admin background.

Reply

Leave a Reply

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

Fill out this field
Fill out this field
Please enter a valid email address.

Menu