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 […]
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 […]
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 […]
Configure Networking for Hyper-V Virtual Machines
Read more
In this tutorial, I am going to discuss “External Network” connectivity. The External Network allows you to access the internet on your virtual machine. When you setup the external network, the virtual switch is connected to a physical network adapter (Ethernet or Wi-Fi) which provides connectivity between the physical network, the Hyper-V host, and the virtual machine. Setting […]
SQL Server on Linux Installation – Part1 – Create Virtual Machine
Read more
The series of this blog provide you a complete walkthrough of SQL Server on Linux installation processes. It includes the creation of Hyper-V virtual machine, Installation of Ubuntu Server, Installation of SQL Server and SQL Server Tools on the Linux machine. The first part of the “SQL Server on Linux Installation” blog will talk about […]
Capturing Current Workload of SQL Server – Part1
Read more
We often get a complaint from our client or application team that this particular query sometimes performs worst or at this specific time, the whole system performs very poorly. And, they want you to find the cause of performance issue. To start with basic performance troubleshooting, you need historical data which can tell you what […]
Verifying SQL Server Instance workload
Read more
As a DBA, you might be supporting different-different clients. Basically, you would be dealing with thousand of SQL Servers, and it is tough to remember which SQL Server is having what kind of workload – OLTP or DSS (aka DW). If your client reports to you performance issue on one of the SQL Servers instance, […]
The Secret of the Database Boot Page#9 – Part1
Read more
Recently, I presented on SQL Server database “Boot Page” at Singapore SQL Pass Chapter user group. It was a great knowledge sharing experience, and It motivated me to share the knowledge to a wider audience. So, I will be blogging all the part of the demos with all possible details so that you enjoy the […]