Answer To: 7/13/2021 Optional Lab 4 https://utah.instructure.com/courses/692156/assignments/ XXXXXXXXXX/15...
Karthi answered on Aug 11 2021
1. How many virtual processors and how much RAM do you require and why?
Windows 7 will require more than 1 GB. Windows 8 and 10 will require more than 2 GB. So, it would be better if you could get a system with 8 GB RAM to use 2-3 VM. It depends on the OS as well. Some Linux requires 1 GB and others may require 2-4. So, it depends on what you want to run and where you hold the VMs. Intel i3, Intel i5, Intel i7, Intel i9 can all handle more than the number of VMs but with only a small processing function. Otherwise, the servers exist. Get at least 8 GB if you are looking for a smooth job.
2. The exact disk layout you wish to have - For each:
Disk type – SSD
Scenario - IO-intensive workloads such as SAP HANA, top tier databases (for example, SQL, Oracle), and other transaction-heavy workloads.
Max disk size - 65,536 gibibyte (GiB)
Max throughput - 2,000 MB/s
Max IOPS - 160,000
a. What is the purpose of the given LUN or Volume?
The sensible unit number (LUN), when introduced on the host, shows as a mounting volume of the same volume as the 'fraction' made by the controller, which hides any remaining volume in that RAID group. Any remaining volume can be 'cut' to an additional reasonable number (LUN) as required. Ultra-disks bring high throughput, high IOPS, and low disk storage capacity of Azure IaaS VMs. Other additional benefits of ultra-disks include the ability to dramatically change disk performance, as well as your operating loads, without the need to restart your virtual machine (VM). Ultra-discs are suitable for data performance uploads such as SAP HANA, high data, and heavy workloads. Ultra-disks can only be used as data disks. We recommend using premium SSDs as OS disks.
b. How large will the LUN or Volume be? Why did you choose this size?
There is a certain combination of FlexVol volume and file or LUN configuration that you can use, depending on your application and administrative requirements. Understanding the benefits and costs of these combinations can help you determine the right volume and combination for your LUN configuration.
The following combination of volume suspension and LUN is recommended:
Specified files or LUNs have a larger volume offer
Non-storage files or LUNs have a limited volume offer
Specified files or LUNs have a thick volume provision
You can apply a small SCSI supply to your LUN by combining any of these configuration combinations.
Specified files or LUNs have a larger volume offer
Benefits:
· All writing functions within space-reserved files are guaranteed; they will not fail because of insufficient space.
· There are no limits to the efficiency of storage and data protection technology in volume.
· Less space is reserved ahead of a given volume, and a good writing guarantee is still provided.
· There are no limits to the efficiency of storage and data protection technology in volume.
· Space is only shared as it is used.
·
Costs and Limitations:
· Adequate space should be set aside for pre-assembled to support a given maximum volume.
· A space equal to twice the size of LUN is allocated from volume during LUN creation.
· Non-storage files or LUNs have a limited volume offer
· Writing tasks are not guaranteed; may fail if the volume runs out of free space.
· You must manage the free space of the component successfully to prevent the merger expiring the free space.
· Specified files or LUNs have a thick volume provision
· Writing tasks may fail with this option.
· You can reduce this risk by properly measuring the free space in volume by comparing data fluctuations.
· You cannot rely on data storage protection such as Snapshot copies and FlexClone and LUN files.
· You cannot use the ONTAP storage capacity that cannot be automatically removed, including extraction, compression, and ODX / Copy Offload.
c. What kind of storage would you like the LUN or Volume to be stored on?
Volumes contain file systems in the NAS environment and LUNs in the SAN area. LUN (sensible unit number) is the identifier of a device called the intelligent unit referred to in the SAN law. LUNs are the ultimate basic unit in SAN configuration. The Windows host detects LUNs on your storage system as virtual disks.
d. What RAID Level would you like the LUN or Volume to be stored on?
RAID 5 is the most common RAID configuration for enterprise servers and enterprise NAS devices. This level of RAID provides better performance than mirror installation and error tolerance. With RAID 5, data and unity (which is additional data used for retrieval) has lines on three or more disks.
1. How does this differ from your setup and why is your setup better than this setup?
When providing an ultra-disk, you can independently adjust the volume and performance of the disk. Ultra-discs come in a limited number of sizes, ranging from 4 GiB to 64 TiB, and include a flexible performance model that allows you to independently configure IOPS and pass.
Some key skills for ultra-disks are:
· Disk Capacity: Ultra disk capacity ranges from 4 GiB to 64 TiB.
· Disk IOPS: Ultra Disks support 300 IOPS limits IOPS / GiB, up to 160 K IOPS per disk. To fulfill the IOPS you have provided, make sure that the selected Disk IOPS is below the VM IOPS limit. The guaranteed minimum of IOPS per disk is 1 IOPS / GiB, with a basic value of 100 IOPS. For example, if you had a 4 GiB disk, you would have 100 IOPS, instead of 8 IOPS.
· Disc Disk: For ultra-disks, the single disk access limit is 256 KiB / s for each given IOPS, up to 2000 MBps per disk (where MBps = 10 ^ 6 Bytes per second). The minimum guaranteed per disk is 4KiB / s for each given IOPS, with a minimum basic 1 MBps.
· Ultra-disks support optimizing disk signal performance (IOPS and login) during bootback without removing the disk from the virtual machine. Once the disk size enhancement function is removed from the disk, it can take up to an hour for the change to take effect. There is a performance limit to increase the working size within a 24-hour window. The performance-enhancing function may fail due to a lack of performance bandwidth.
2. What are some of the dangers of using this setup as opposed to yours?
Standard SSDs offer disk explosions. Disk explosion provides better tolerance to unexpected changes in IO patterns. You can make better use of OS disk boot and applications with spiky traffic.
3. Use the answers from above to craft an email to the IT Manager where you professionally explain why this configuration may not work well for the database you are creating.
The SQL Server Database Engine runs on the Windows operating system, which also uses the underlying program resources. These resources have a significant impact on the performance of the app and the data system. The functionality of any database system depends on four system resources:
Central processing unit (CPU)
Memory
Disk I / O
Network
CPU, as well as memory, is a key factor in marking computer speed. It is also the key to program performance, as it manages other system resources and performs all applications. Perform user processes and interact with other applications in your system. CPU problems can occur when an application and user applications make too many applications on it. In general, the more CPU power available to your computer, the better the overall system may work.
Database Engine is powerful and gets memory as needed. Performance problems related to memory can only occur if they are not sufficient to perform the required task. When this happens, most memory pages are written to the page file. (The page file view is explained in more detail later in this chapter.) If the process of writing a page file occurs more often, the operation of the system may slow down. Therefore, like the CPU rule, the more memory available on your computer, the better the system will perform.
There are two problems with disk I / O: disk speed and disk transfer rate. Disk speed determines how fast read and write tasks are performed on disk. Disk transfer rate determines how much data can be written to disk during a unit of time (usually measured in seconds). Obviously, the faster the disk, the more data is processed. Also, multiple disks are usually better than a single disk where multiple users use the data system at the same time. (In this case, data availability tends to spread to multiple disks, thus improving the performance of the entire system.)
With customer / server configuration, the database system sometimes works poorly when there is a lot of customer communication. In that case, the amount of data that needs to be transferred to a network may exceed the network capacity. To avoid such restrictions, the following general recommendations should be noted:
If the data server sends any lines to the app, only the required lines by the app should be sent.
If a long-lasting user application works firmly on the client side, move it to the server side (using it as a saved process, for example).
All these program resources depend on each other. This means that performance issues on one device may cause performance problems on other resources. Similarly, improvements related to a single source can significantly increase the performance of other (or all) resources.
For example:
If you increase the number of CPUs, each CPU can share the load evenly so it can adjust the disk I / O bottleneck. On the other hand, improper use of the CPU is often the result of heavy already existing disk I / O and / or memory.
The more memory is available, the more likely it is to find the required page with the app (rather than reading the page to disk), which leads to getting the functionality. In contrast, reading from a disk drive instead of drawing from very fast memory slows the system down a lot, especially when there are many similar processes.
The following sections describe detailed I / O and memory.
Disk I / O
One purpose of a database is to store, retrieve, and modify data. Therefore, Database Engine, like any other database system, has to do a lot of disk work. In contrast to other system resources, the disk system has two moving parts: the disk itself and the disk head. Disk rotation and disk head movement require a lot of time; therefore, disk read and write two of the most expensive functions performed by a database system. (For example, disk access is slower than memory access.)
Database Engine stores data on 8KB pages. The RAM cache is also separated by 8KB pages. The system reads data by page units. Readings occur not only in data recovery, but also in any conversion operations such as UPDATE and DELETE because the database system must read data before it can be converted.
If the required page is in cache, it will be read by memory. This I / O function is called logical I / O or logical reading. When not in memory, the page is read from disk to disk storage. This I / O function is called physical I / O or physical reading. Cache has been stolen because Web Engine uses a single-memory memory format. Therefore, more users can access the same page. Logical writing occurs when data is converted to temporary cache. Similarly, physical writing occurs when a page is written from a cache to a disk. Therefore, logical writing tasks can be performed on a single page before being written to disk.
Web Engine has a few things that have a big impact on performance because they make the most of I / O resources:
Read in advance
Test site
1. What conclusions can you draw from the first page shown here?
Motherboard
Why is it important to know about motherboards? If the CPU is the brain of your server, the motherboard is the computer board of your computer and acts as the heart and soul of your system. Contains the basic components of your computer architecture, including your RAM (L1, L2, L3 cache), your external connectors (PCIe), input / output ports, socket, and other important components.
Every computer, whether desktop or business has a motherboard, and its role is to facilitate communication between the various elements that reside within its domain; store and retrieve data, and perform the calculations needed to support software applications. Among the elements is the CPU.
Parts
Throughout this document, you will learn the references to the various critical elements that make up your server, and one of the most important is Clock Speed.
Clock speed is measured in gigahertz (GHz) and the measurement method is very simple, if the value goes up, the unit is faster. Your processor will calculate statistics continuously and will process billions of bits of data per second. If you use powerful apps, you can expect the best response with high clock speed.
Cores
A multi-core processor is a computer processor in a single integrated circuit with two or more different processing units called cores, each reading and executing system instructions. Having the speed of multiple cores will increase your processing power. You may already be using the Intel core on your home computer.
Previous generation cores are embedded in the same core before large tech companies like Intel replicate dual-core (Core i3), then quad-core (Core i5), and then six to eight (Core i7) and now we have a multi-threaded core (Core i9 - eighteen characters, with 35 threads). In a multimedia application, the threads share one or more window resources, including computer units, CPU caches, and lookaside buffer (TLB).
That is why in the past, we at the end of the century (2000) can remember when the system crashed, the whole...