Infant Arockiaraj gives people an idea of where to look:
Based on our extensive experience with customers using SQL on Linux, we have compiled a guide outlining fundamental troubleshooting steps and available tools to assist in resolving SQL on Linux issues. This guide aims to make it easier for SQL DBAs who have primarily worked on Windows operating systems over the years.
In this article, we will normalize three checks in Linux that we typically perform in Windows to start troubleshooting issues with SQL Server:
- System logs
- SQL Server logs
- Task Manager
Note: The screenshots in the below examples are taken from RHEL and Ubuntu machines, and while the Linux flavors are different, the commands are similar in both environments.
Click through to learn more about these steps and where you can find the files..