The DBA Fundamentals VG offers training and support to individuals interested in a solid DBA foundation.

Event Display
Meeting Detail

Tue, Sep 18 2018 16:00 UTC


Linux Fundamentals for SQL Server DBAs

RSVP: None

Linux Fundamentals for SQL Server DBAs

Most of the Fortune 1000 companies leverage Linux for their 7/24 mission-critical enterprise server platform and Enterprise Linux has become the standard de facto for reliability and scalability. Today, more and more companies are considering Linux as their new operating system (OS) for SQL Server; and in today's economy to be an effective database administrator, DBAs and Architects must possess extensive OS and database expertise. In this session, learn how to install and configure SQL Server on Red Hat 7 Enterprise Linux and SUSE Enterprise Server (SLES v12) on bare metal servers and in virtualized infrastructures. We will discuss the top 10 Linux commands that every SQL Server DBA needs to know as you transition from Microsoft to the world of Red Hat and SUSE; with a closer look at the different file system types that are available and which one you should choose. Leveraging real-life experiences and techniques as a certified Linux veteran for over 16 years, I will also share my top tips that you need to know to configure a Linux environment worthy to run SQL Server: 1. Install required RPMs to install SQL Server * Manage and interrogate RPMs * Review RPM dependencies * Setup a local YUM repository 2. Set appropriate kernel and network parameters, shell limits, and file limits for SQL Server 3. Configure transparent hugepages 4. Determine and implement the right I/O Scheduler 5. Configure NTP for the server 6. Bond network interface * Enable jumbo frames 7. Configuring NFS 8. Setup correct partition alignment 9. Centralize System Logging 10. Simplify DNS 11. Setup up ssh equivalence between Linux servers 12. Configure swap setting


Charles Kim is an Oracle ACE Director, VMware vExpert, Oracle Certified DBA, Certified Exadata Implementation Specialist, Certified SharePlex Administrator, and a Certified RAC Expert. Charles specializes in RAC, Exadata, Cloud, and Virtualization and author of 10 books:

Back to Top
cage-aids
cage-aids
cage-aids
cage-aids