Saturday, May 20, 2023

What is Server Virtualization

New state-of-the-art and powerful technology was conceptualized in the late 1960s and early 1970s by IBM. It provides the facility to utilize server resources as much as possible or we can say, maximum utilization of server resources. Using this concept, we can create multiple virtual servers on one server.    


There are mainly four types of server virtualization: 

1. Full-Virtualization:- Full virtualization is the most common type of server virtualization and is also known as hardware virtualization. This virtualization provides the facility to create & run multiple virtual machines (VMs) on a single server. Each and every VM works individually & runs on its own operating system (OS) and required software.

In this virtualization, the system uses a hypervisor to manage and allocate physical resources between virtual machines. Physical resources mean CPU, memory, storage, etc. Hypervisor communicates between the virtual machines.

Using full virtualization, we can get very good isolation between Virtual Machines. This helps each VMs to run independently and securely. We can use this type of virtualization in complex applications and different operating systems.

Advantages of Full-Virtualization
1. Complete OS and Application Isolation - provides strong isolation between VMs.
2. It supports a wide range of operating systems. 
3. Hardware Independence
4. Resource Optimization
5. Easy Scalability

Disadvantages of Full-Virtualization
1. Performance Overhead
2. Limited Performance for Certain Workloads

Applications of Full-Virtualization
1. Widely used for server consolidation. Allows to run multiple virtual servers on a single machine.
2. Development and Testing Environments.
3. To run legacy applications on modern infrastructure.
4. Use at the time of Disaster Recovery and Business Continuity.

Friday, May 19, 2023

SQL Server on Apple Mac

Install SQL Server on Apple Mac

If you want to use MS SQL Server on an Apple Mac machine, installing SQL Server on Mac using Virtualization Technology is possible.

As we know, MS SQL Server was designed for Windows machines, but we can install & use powerful RDBMS on Mac machines.

A few prerequisites are given below for our reference, which we need to ensure before proceeding with SQL Server Installation on a Mac machine:

1. System:- Apple Mac machine.

2. Sufficient Disk Space: Sufficient disk space is required to store the Windows operating system and SQL Server installation files on the Mac machine.

3. Virtualization Software: Virtualization software is also needed to run SQL Servers like Parallels Desktop, VMware Fusion, VirtualBox, etc.

4. OS Installation Media:- We require Windows operating system installation media with required licenses.

5. SQL Server Installation Media:- Installation Media of SQL Server is also needed to proceed with the installation. 

Wednesday, May 17, 2023

DBCC Commands in Microsoft SQL Server - DBA should know - Part - 4

In this part of the article, we'll try to explain DBCC commands which are related to Information.

1) DBCC INPUTBUFFER

Introduction:
One of the most important & highly used DBCC commands is "DBCC INPUTBUFFER" by database administrators to know the last SQL query executed by a particular session. This command helps during troubleshooting query execution-related issues.

Usage:
This command gives the most recent SQL statement executed by a particular session in the SQL Server.

Syntax:
DBCC INPUTBUFFER (SessionID);

Example:
DBCC INPUTBUFFER (55);

DBCC INPUTBUFFER

Benefits:
a) Troubleshooting and Diagnostics:
It helps us to catch the exact SQL statement run by a particular session. Very helpful command and helps during troubleshooting and diagnosing issues and identifying problematic queries, resources utilized by the query, etc.

b) Performance Optimization:
This command helps to identify inefficient queries, optimize execution plans, and enhance the performance of the database.

Conclusion:
By utilizing DBCC INPUTBUFFER command, we can easily troubleshoot issues, and enhance performance and security in the environment.


 




Featured Post

Use DBCC SQLPerf (logspace)

 Use DBCC SQLPerf (logspace) to monitor and optimize database performance in SQL Server. Let's Explore: Let's Explore: https://mades...

Popular Posts