Description
- Imagine you are a DBA for a mid-sized company with twelve (12) SQL database servers. Suppose you were asked to implement the simplest and most cost-effective form of high-availability method. Recommend a solution for the provided situation and provide a rationale for your response.
- As a DBA, you need to account for all of the server downtime and react to the unforeseen occurrences. Imagine you are responsible for maintaining the availability of twelve (12) database servers. Review the Microsoft Developer Network articles titled, “Database Mirroring (SQL Server)” located at http://msdn.microsoft.com/en-us/library/ms189852.aspx, and “AlwaysOn Availability Groups (SQL Server)” located at http://msdn.microsoft.com/en-us/library/hh510230.aspx. Then, recommend the service that you would most likely use, and provide a rationale for your response.
This is a discussion post questions and only requires 2 paragragphs
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.
Explanation & Answer
Hey, I am through with the question. Please find the correct answer in the attached word file.
1
Running head: High Availability
High Availability
Name
Course
Institution
Date
High Availability
2
Imagine you are a DBA for a mid-sized company with twelve (12) SQL database servers.
Suppose you were asked to implement the simplest and most cost-effective form of highavailability method.
The most cost-effective form of high-availability is the clustering of the SQL servers.
When clustering SQL Servers, the 12 SQL servers’ instances will be installed into a Windows
Failover Cluster which uses shared storage. This shared storage is usually on a Storage Area
Network (SAN). System and user databases will be required to be on the shared storage, the
mom...
Completion Status:
100%
Review
Review
Anonymous
Just what I needed…Fantastic!
Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Most Popular Content
King Abdulaziz University Awk Command in Text Processing Program
Q1- Using the awk utility, filter out the following output to solely show the size and mount point. Show all of your comma ...
King Abdulaziz University Awk Command in Text Processing Program
Q1- Using the awk utility, filter out the following output to solely show the size and mount point. Show all of your commands in a snapshot.-bash-4.2$ df -hFilesystem Size Used Avail Capacity Mounted on/dev/wd0a 1008M 130M 828M 14% //dev/wd0d 1008M 8.6M 949M 1% /suid/dev/wd0e 63.0G 29.8G 30.1G 50% /usr/dev/wd0f 19.7G 16.0G 2.7G 85% /var/dev/wd0g 3.9G 500K 3.7G 0% /tmpQ2 Modify the script below using the following instructions. Show all of your commands and output in a snapshot.a) Adjust the thresholds to get some results. Hint: lower the value of 99, 95, 90, etc. For example, the Docker login has 25% capacity of some directories.b) Instead of the e-mail (like jdoe@comcast.net), echo a message into a file. # Platform: Not Platform Dependent#space= df -k | awk '{print $5}' | tr -d '%'if [ ${space} -gt 99 ]then mailx -s "Warning" jdoe@comcast.netDisk space has reached 99%elif [ ${space} -gt 95} ]then mailx -s "Warning" jdoe@comcast.netDisk space has reached 95%elif [ ${space} -gt 90 ]then mailx -s "Warning" jdoe@comcast.netDisk space has reached 90%elseecho "disk fine"fiQ3You have a UNIX file named “food” with the following information. Show all of your commands and output in a snapshot.cat foodThe menu contains pork.Using the sed command, change the pork to fish.
CISY2320 Saint Mary’s Visual Basic Assignment
This is an Visual Basic Assignment comprising only 2 questions. I would like you to accomplish this assignment within 10 h ...
CISY2320 Saint Mary’s Visual Basic Assignment
This is an Visual Basic Assignment comprising only 2 questions. I would like you to accomplish this assignment within 10 hours. It shouldn't take a long time to do this. I prefer to offer a high price for this assignment. You just need to send me the cover page and the printouts of the source codes.
Java Programming Code Computer Science Worksheet
Add additional information to the student class below such as name, address, major, and contact information along with all ...
Java Programming Code Computer Science Worksheet
Add additional information to the student class below such as name, address, major, and contact information along with all the getters and setters (methods) needed to access all data. Submit your code along with a sample run of your program. Comment all your code. Cite any sources of information you use. Write a note on the process of completing the assignment in a Microsoft Word document.// ShowStudent.java// client to test the Student classclass ShowStudent{public static void main (String args[]){Student pupil = new Student(); // We need a new student named pupilpupil.setIDnumber(234); // We are setting pupil's ID number to 234pupil.setPoints(47); // We are setting pupil's points to 47pupil.setHours(15); // We are setting pupil's hours to 15pupil.showIDnumber(); // We are showing pupil's ID numberpupil.showPoints(); // We are showing pupil's pointspupil.showHours(); // We are showing pupil's hourseSystem.out.println("The grade point average is " +pupil.getGradePoint()); // we are calculating pupil's GPA}}class Student // this is the student class{// the private data membersprivate int idNumber;private int hours;private int points;// Constructor creates a new studentStudent(){idNumber = 9999; // a max IDpoints = 12; // starting out assuming 12 pointshours = 3; // starting out assuming 3 hours}// end of constructor// the public get and set methods fro pulil specific informationpublic void setIDnumber(int number) // pass in a number{idNumber = number; // assign the number}public int getIDnumber() // return a student ID{return idNumber;}public void setHours(int number) // pass in a number{hours = number; // assign the number to hours}public int getHours() // return the student's hours{return hours;}public void setPoints(int number) // pass in a number{points = number; // assign number to points}public int getPoints() // return the points{return points;}// methods to display the fieldspublic void showIDnumber(){System.out.println("ID Number is: " + idNumber);}public void showHours(){System.out.println("Credit Hours: " + hours);}public void showPoints(){System.out.println("Points Earned: " + points);}public double getGradePoint() // calculate the GPA with internal data{return (points * 1.0 / hours);// simple integer division will truncate the decimal places}}Submission Details:Create the code and sample run files.Write the process of completing the assignment in a Microsoft Word document.
Application of the Compute Energy Function Project
This question is two parts midterm and a final. I have completed the midterm part and the final is based on the midterm. Y ...
Application of the Compute Energy Function Project
This question is two parts midterm and a final. I have completed the midterm part and the final is based on the midterm. You will need to review the midterm solution and make changes to make it solve the final.MIDTERM QUESTION: (This question is solved and the solution is attached)On March 16th, 2021, CNBC reported that the Solar Energy Industries Association and Wood Mackenzie found that the solar industry added a record 19.2 gigawatts of new capacity during 2020, a 43% jump from 2019. This drastic increase in the use of solar panel technology is creating ample opportunities for engineers to evaluate the cost and efficiency of residential and commercial solar power systems.1. Write a function named computeEnergy that takes in as input the number of panels and computes the amount of energy produced in a typical day. The amount of energy produced by a panel depends on the time of day and can be modeled by the mathematical formula below (a picture of the formula is attached), where t is an array of values from 1 to 24 hours.2. After your computeEnergy function calculates how much energy is produced per day, it should call another user-defined function named weatherVariance. The weatherVariance function should create a 24x7 dimension matrix of random numbers between 0.8 and 1. This represents 24 hours of varying weather conditions that affect the solar production of the panel for seven days. Using matrix multiplication with the appropriate dimensions, (you will need to create another 24x7 matrix containing a week's worth of daily energy production), multiply the energy production by the weather variance matrix element-wise to simulate weather.3. The data for the weekly energy usage by the home is provided (I will send a link to download this file). (we will use this see if we produce enough energy). In your main function, define a variable to store the number of solar panels. Keep track of the total energy produced by the solar panel(s) in a week, starting with one panel. After the week, if the generated solar energy is less than the energy usage of the home, then increase the number of panels by one, run the computeEnergy function again, compare with the energy used and decide if more panels need to be added. This should be done in a while loop. The usage data is formatted in a 24x7 dimension matrix, corresponding to seven days worth of 24 hours of hourly energy use in kilo-Watt-hours.4. Produce a 4x2 subplot of solar energy produced and used per day for the week. The eighth plot should be the daily difference between energy produced and energy used for the week. Label all plots appropriately.5. Report to the user how many panels are required to fulfill the energy needs for the home.FINAL QUESTION: (You will need to modify the midterm solution to make it solve this question)IntroductionTo build upon the Solar Energy Midterm Project, we will be synthesizing what we have learned in the previous modules to develop an electrical engineering software tool for a typical residential home in Southern California.Guidelines and DeliverablesAs usual, create a script, include a comment at the top explaining the purpose of the script, your name, and the date it was created. The goal of this project is to estimate the daily energy production over a week of a typical residential solar panel, compare it to the energy usage of a home and determine how many solar panels are required to fulfill the energy needs of the residence.1. For the midterm project, your computeEnergy function took in as input the number of panels and computed the amount of energy produced in a typical day. The amount of energy produced by a panel depends on the time of day and can be modeled by the mathematical formula below, where t is an array of values from 1 to 24 hours.f(t)=e−(t−12)21.52π√f(t)=e−(t−12)21.52π (I have attached a picture of this equation so you can see it better)Update computeEnergy( ) to perform this task symbolically. Use the built in integral function, int( ) to find the kilo-Watt-hours produced in a day. Plot your integral function from 0 to 24 hours.2. From the midterm project, you wrote code to calculate how many panels would be required to fulfill the energy needs for a home. Suppose an inverter device is needed for each panel in the array and is connected in parallel to one power source. The video below shows how to use linear algebra in MATLAB to solve for the current in each branch containing an inverter. Write a function called findCurrents( ) that takes in as input the number of panels you computed in the midterm project and returns a vector of currents in each branch. Let the source voltage, Vs, be 100V and the value of each resistance be 1500 ohms. Video: How to solve a system of linear equations corresponding to circuit currents in MATLAB (Links to an external site.)Turn-in InstructionsYou will need to submit .m files for each function you define. Each .m file should include your name and function description in the comments.
Optimizing Pseudocodes, programming homework help
Optimizing PseudocodesIn this assignment, you will study how pseudocodes can be optimized to improve their efficiency.Ther ...
Optimizing Pseudocodes, programming homework help
Optimizing PseudocodesIn this assignment, you will study how pseudocodes can be optimized to improve their efficiency.There are two parts to this assignment:In Part 1, you will complete Programming Project 4 from your course textbook Alice 3 in Action with Java.In Part 2, you will complete Programming Project 5 from your course textbook Alice 3 in Action with Java.Part 1: Alice TutorialComplete the following tasks:Programming Project 4 from your textbook Alice 3 in Action with Java.Create a “springtime” scene that runs for a minute or so, starting with an empty field but ending with the field covered with flowers. The flowers should “grow” out of the ground as your scene plays. Make your program as short as possible by storing the flowers in an array.Submit the saved Alice World file.Support your responses with appropriate reasoning.Part 2: Lists and Arrays in AliceFrom the textbook Alice 3 in Action with Java, complete Programming Project 5.Proceed as in Programming Project 4, but use random-number generation to make the flowers appear in a different order or pattern every time your program is run.Based upon the Programming Project 4, how well would the program work if it did not utilize an array for the flowers? How do the arrays help?Does the development of the array in Programming Project 4 effect the development of the Programming Project 5? Does it make it easier or harder to modify?Submission DetailsName your document SU_ITS2104_W4_A2_Pate_C.doc.Name the Alice World file from Part 1 as SU_ITS2104_W4_A2_P1_Pate_C.a2w.Name the Alice World file from Part 2 as SU_ITS2104_W4_A2_P2_Pate_C.a2w.
Similar Content
INT 100 Ashford University Purchase Requirements of a Laptop Discussion
In each response, you will take the role of the manager and determine if you would approve this purchase request. Analyze ...
Concepts concerning Mortality Presentation Assignment
net net net net net net net net ...
Cloud Computing
Choose a case study or story of a cloud sourcing event or project. Find an article online. Then do a brief analysis of the...
Angmering Raceway Car Jumping simulation with Graphical User Interface(GUI)
HI! you will find all the details in the pdf file that uploaded. Please if you know how to do it perfectly choose this tas...
CSCI 2521 Columbus State Community College Sentence into a Morse Code Program
allow a user to enter sentence and then output the sentence into Morse Code. I am using visual studio 2019 and I need it ...
C++ Linked list part 2 of temperature queries
Start with the code you completed for Part 1.Your program should receive the names of the input files as command line argu...
2.
1a) "Julia is a just-in-time compiled language rather than an interpreted language." Answer: In an interpreted language li...
Python Dictionary
In python, a dictionary is a form of data type that is a collection of unordered, changeable and indexed data values. Unli...
Document 3 St
The double data type is represented by double-precision 64-bit IEEE 754 floating point. Public access modifier is used to ...
Related Tags
Book Guides
Get 24/7
Homework help
Our tutors provide high quality explanations & answers.
Post question
Most Popular Content
King Abdulaziz University Awk Command in Text Processing Program
Q1- Using the awk utility, filter out the following output to solely show the size and mount point. Show all of your comma ...
King Abdulaziz University Awk Command in Text Processing Program
Q1- Using the awk utility, filter out the following output to solely show the size and mount point. Show all of your commands in a snapshot.-bash-4.2$ df -hFilesystem Size Used Avail Capacity Mounted on/dev/wd0a 1008M 130M 828M 14% //dev/wd0d 1008M 8.6M 949M 1% /suid/dev/wd0e 63.0G 29.8G 30.1G 50% /usr/dev/wd0f 19.7G 16.0G 2.7G 85% /var/dev/wd0g 3.9G 500K 3.7G 0% /tmpQ2 Modify the script below using the following instructions. Show all of your commands and output in a snapshot.a) Adjust the thresholds to get some results. Hint: lower the value of 99, 95, 90, etc. For example, the Docker login has 25% capacity of some directories.b) Instead of the e-mail (like jdoe@comcast.net), echo a message into a file. # Platform: Not Platform Dependent#space= df -k | awk '{print $5}' | tr -d '%'if [ ${space} -gt 99 ]then mailx -s "Warning" jdoe@comcast.netDisk space has reached 99%elif [ ${space} -gt 95} ]then mailx -s "Warning" jdoe@comcast.netDisk space has reached 95%elif [ ${space} -gt 90 ]then mailx -s "Warning" jdoe@comcast.netDisk space has reached 90%elseecho "disk fine"fiQ3You have a UNIX file named “food” with the following information. Show all of your commands and output in a snapshot.cat foodThe menu contains pork.Using the sed command, change the pork to fish.
CISY2320 Saint Mary’s Visual Basic Assignment
This is an Visual Basic Assignment comprising only 2 questions. I would like you to accomplish this assignment within 10 h ...
CISY2320 Saint Mary’s Visual Basic Assignment
This is an Visual Basic Assignment comprising only 2 questions. I would like you to accomplish this assignment within 10 hours. It shouldn't take a long time to do this. I prefer to offer a high price for this assignment. You just need to send me the cover page and the printouts of the source codes.
Java Programming Code Computer Science Worksheet
Add additional information to the student class below such as name, address, major, and contact information along with all ...
Java Programming Code Computer Science Worksheet
Add additional information to the student class below such as name, address, major, and contact information along with all the getters and setters (methods) needed to access all data. Submit your code along with a sample run of your program. Comment all your code. Cite any sources of information you use. Write a note on the process of completing the assignment in a Microsoft Word document.// ShowStudent.java// client to test the Student classclass ShowStudent{public static void main (String args[]){Student pupil = new Student(); // We need a new student named pupilpupil.setIDnumber(234); // We are setting pupil's ID number to 234pupil.setPoints(47); // We are setting pupil's points to 47pupil.setHours(15); // We are setting pupil's hours to 15pupil.showIDnumber(); // We are showing pupil's ID numberpupil.showPoints(); // We are showing pupil's pointspupil.showHours(); // We are showing pupil's hourseSystem.out.println("The grade point average is " +pupil.getGradePoint()); // we are calculating pupil's GPA}}class Student // this is the student class{// the private data membersprivate int idNumber;private int hours;private int points;// Constructor creates a new studentStudent(){idNumber = 9999; // a max IDpoints = 12; // starting out assuming 12 pointshours = 3; // starting out assuming 3 hours}// end of constructor// the public get and set methods fro pulil specific informationpublic void setIDnumber(int number) // pass in a number{idNumber = number; // assign the number}public int getIDnumber() // return a student ID{return idNumber;}public void setHours(int number) // pass in a number{hours = number; // assign the number to hours}public int getHours() // return the student's hours{return hours;}public void setPoints(int number) // pass in a number{points = number; // assign number to points}public int getPoints() // return the points{return points;}// methods to display the fieldspublic void showIDnumber(){System.out.println("ID Number is: " + idNumber);}public void showHours(){System.out.println("Credit Hours: " + hours);}public void showPoints(){System.out.println("Points Earned: " + points);}public double getGradePoint() // calculate the GPA with internal data{return (points * 1.0 / hours);// simple integer division will truncate the decimal places}}Submission Details:Create the code and sample run files.Write the process of completing the assignment in a Microsoft Word document.
Application of the Compute Energy Function Project
This question is two parts midterm and a final. I have completed the midterm part and the final is based on the midterm. Y ...
Application of the Compute Energy Function Project
This question is two parts midterm and a final. I have completed the midterm part and the final is based on the midterm. You will need to review the midterm solution and make changes to make it solve the final.MIDTERM QUESTION: (This question is solved and the solution is attached)On March 16th, 2021, CNBC reported that the Solar Energy Industries Association and Wood Mackenzie found that the solar industry added a record 19.2 gigawatts of new capacity during 2020, a 43% jump from 2019. This drastic increase in the use of solar panel technology is creating ample opportunities for engineers to evaluate the cost and efficiency of residential and commercial solar power systems.1. Write a function named computeEnergy that takes in as input the number of panels and computes the amount of energy produced in a typical day. The amount of energy produced by a panel depends on the time of day and can be modeled by the mathematical formula below (a picture of the formula is attached), where t is an array of values from 1 to 24 hours.2. After your computeEnergy function calculates how much energy is produced per day, it should call another user-defined function named weatherVariance. The weatherVariance function should create a 24x7 dimension matrix of random numbers between 0.8 and 1. This represents 24 hours of varying weather conditions that affect the solar production of the panel for seven days. Using matrix multiplication with the appropriate dimensions, (you will need to create another 24x7 matrix containing a week's worth of daily energy production), multiply the energy production by the weather variance matrix element-wise to simulate weather.3. The data for the weekly energy usage by the home is provided (I will send a link to download this file). (we will use this see if we produce enough energy). In your main function, define a variable to store the number of solar panels. Keep track of the total energy produced by the solar panel(s) in a week, starting with one panel. After the week, if the generated solar energy is less than the energy usage of the home, then increase the number of panels by one, run the computeEnergy function again, compare with the energy used and decide if more panels need to be added. This should be done in a while loop. The usage data is formatted in a 24x7 dimension matrix, corresponding to seven days worth of 24 hours of hourly energy use in kilo-Watt-hours.4. Produce a 4x2 subplot of solar energy produced and used per day for the week. The eighth plot should be the daily difference between energy produced and energy used for the week. Label all plots appropriately.5. Report to the user how many panels are required to fulfill the energy needs for the home.FINAL QUESTION: (You will need to modify the midterm solution to make it solve this question)IntroductionTo build upon the Solar Energy Midterm Project, we will be synthesizing what we have learned in the previous modules to develop an electrical engineering software tool for a typical residential home in Southern California.Guidelines and DeliverablesAs usual, create a script, include a comment at the top explaining the purpose of the script, your name, and the date it was created. The goal of this project is to estimate the daily energy production over a week of a typical residential solar panel, compare it to the energy usage of a home and determine how many solar panels are required to fulfill the energy needs of the residence.1. For the midterm project, your computeEnergy function took in as input the number of panels and computed the amount of energy produced in a typical day. The amount of energy produced by a panel depends on the time of day and can be modeled by the mathematical formula below, where t is an array of values from 1 to 24 hours.f(t)=e−(t−12)21.52π√f(t)=e−(t−12)21.52π (I have attached a picture of this equation so you can see it better)Update computeEnergy( ) to perform this task symbolically. Use the built in integral function, int( ) to find the kilo-Watt-hours produced in a day. Plot your integral function from 0 to 24 hours.2. From the midterm project, you wrote code to calculate how many panels would be required to fulfill the energy needs for a home. Suppose an inverter device is needed for each panel in the array and is connected in parallel to one power source. The video below shows how to use linear algebra in MATLAB to solve for the current in each branch containing an inverter. Write a function called findCurrents( ) that takes in as input the number of panels you computed in the midterm project and returns a vector of currents in each branch. Let the source voltage, Vs, be 100V and the value of each resistance be 1500 ohms. Video: How to solve a system of linear equations corresponding to circuit currents in MATLAB (Links to an external site.)Turn-in InstructionsYou will need to submit .m files for each function you define. Each .m file should include your name and function description in the comments.
Optimizing Pseudocodes, programming homework help
Optimizing PseudocodesIn this assignment, you will study how pseudocodes can be optimized to improve their efficiency.Ther ...
Optimizing Pseudocodes, programming homework help
Optimizing PseudocodesIn this assignment, you will study how pseudocodes can be optimized to improve their efficiency.There are two parts to this assignment:In Part 1, you will complete Programming Project 4 from your course textbook Alice 3 in Action with Java.In Part 2, you will complete Programming Project 5 from your course textbook Alice 3 in Action with Java.Part 1: Alice TutorialComplete the following tasks:Programming Project 4 from your textbook Alice 3 in Action with Java.Create a “springtime” scene that runs for a minute or so, starting with an empty field but ending with the field covered with flowers. The flowers should “grow” out of the ground as your scene plays. Make your program as short as possible by storing the flowers in an array.Submit the saved Alice World file.Support your responses with appropriate reasoning.Part 2: Lists and Arrays in AliceFrom the textbook Alice 3 in Action with Java, complete Programming Project 5.Proceed as in Programming Project 4, but use random-number generation to make the flowers appear in a different order or pattern every time your program is run.Based upon the Programming Project 4, how well would the program work if it did not utilize an array for the flowers? How do the arrays help?Does the development of the array in Programming Project 4 effect the development of the Programming Project 5? Does it make it easier or harder to modify?Submission DetailsName your document SU_ITS2104_W4_A2_Pate_C.doc.Name the Alice World file from Part 1 as SU_ITS2104_W4_A2_P1_Pate_C.a2w.Name the Alice World file from Part 2 as SU_ITS2104_W4_A2_P2_Pate_C.a2w.
Earn money selling
your Study Documents
