Topic:
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:
- Install required RPMs to install SQL Server
- Manage and interrogate RPMs
- Review RPM dependencies
- Setup a local YUM repository
- Set appropriate kernel and network parameters, shell limits, and file limits for SQL Server
- Configure transparent hugepages
- Determine and implement the right I/O Scheduler
- Configure NTP for the server
- Bond network interface
- Enable jumbo frames
- Configuring NFS
- Setup correct partition alignment
- Centralize System Logging
- Simplify DNS
- Setup up ssh equivalence between Linux servers
- Configure swap setting
Speaker:
Charles Kim, Owner and Founder Viscosity North America
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.