In the previous tutorial, we went through how to setup “External Network” to access the internet on Hyper-v client machine. Now, we will explore how to create Internal and Private virtual switches and what is the use of them. A virtual switch is also bound to the host server even though it does not correspond to a […]
SQL RPM package details On CentOs System
Read more
You have already explored the installation of SQL Server and SQL Server tools on CentOs. In this post, we will see what all the packages and files get installed during the SQL Server installation on Linux (CentOs) using rpm package manager but before let’s first understand; What is RPM? RPM originally stands for Red Hat Package Manager. […]
Main File Directory Structure of SQL Server on Linux
Read more
During the exploration of the SQL Debian package, we discussed what all the files get installed at which location on Linux machine. However, there are some important folders and files which I would say to remember when you are working on Linux machine. You may find them helpful, if you want to troubleshoot some issue or want to […]
Uninstall SQL Server Tools on Ubuntu System
Read more
If you remember, Installing SQL Server on Linux does not install SQL Server tools by default. You have to install it separately. The same way when you uninstall SQL Server, it won’t uninstall mssql-tools, you have to uninstall separately. In the previous blog post, we discuss how to uninstall mssql-server on Ubuntu System. Here, we […]
Uninstall SQL Server on Ubuntu System
Read more
There are scenarios where you want to uninstall the SQL Server vNext CTP1. This blog describes how to uninstall Microsoft SQL Server on Ubuntu system. It will completely remove Microsoft SQL Server along with repository, data directories, and binary of the SQL Engine. Note: During uninstall mssql-server package, it does not remove all the files […]
Tempdb Contention
Read more
The tempdb’s use as a temporary area space to create and delete temporary objects. The heavy usage of tempdb can lead to latch contention on the pages required to allocate or deallocate. In this blog, we’ll be covering what is tempdb contention and how quickly you can check the tempdb contention issue on your server. What […]
SQL Server Package Installation Requirements on Ubuntu, RHEL, & Docker
Read more
This blog provides a walkthrough of SQL Server Package Installation requirement for Ubuntu, RHEL & Docker. When you are going to install SQL Server vNext CTP1, you make sure that you are meeting the package installation requirement as per Operating System. Requirements for package installation on Ubuntu Ubuntu 16.04 Minimum of 3.25 GB of RAM […]
Capturing Current Workload of SQL Server – Part2
Read more
In the first part of the capturing current workload of SQL Server blog, I talked about first two steps. Where we created the table “CurrentlyRunningQueries_Snapshot_History” in the first step and wrote the script to capture workload for a live system in the second step. Now, we are going to create and schedule a job which […]
An in-depth look at mssql-server.service file on SQL Server on Linux
Read more
In previous blogs, we discuss how to Stop, Start, View, and Enable or Disable SQL Server Service on Linux. Here, we will be discussing mssql-server.service file and will also be talking about dumping the ELF binary file “/opt/mssql/bin/sqlservr” to see – it calls what all the sfp files. The mssql-server.service is a configuration file. It […]
top or htop to check the health of SQL Server on Linux
Read more
Being a Windows user, your first place to check the health of SQL Server is Windows task manager. Since Microsoft has launched SQL Server on Linux operating system, you might be wondering how to check the health of SQL Server on Linux machine now. You can use classical Linux task manager by running the “top” […]