This assignment assumes that you completed the hybrid activity in Lesson 1. If you have not done that, you will need to complete it before doing this assignment. Open a new Word document and place your name and the course number at the top. Save the document. Use labeled screenshots to document completion of each step below. Use your INFO4410_HW instance of SQL Server. 1) Download the AdventureWorks database file from the Microsoft SQL Server websiteLinks to an external site.. Be sure to get the OLTP database file, not the data warehouse or the lightweight database. Using SQL Server Management Studio, restore the AdventureWorks database into your HW instance. There are instructions on the Microsoft site linked above. Display the list of databases in your instance to demonstrate that AdventureWorks was attached correctly.

2) Identify the operating system of the server that your instance is running on.

3) Set the instance to log both successful and failed login attempts.

4) Set the instance so that it will use at least 2GB of RAM for Server Memory.

5)Set the instance so that if a query from a remote connection runs for more than one minute, it is timed out.

6) Set the instance so that if a user enters a date value as '6/12/53', it will be interpreted as June 12th, 2053, rather than as June 12th, 1953. If a user enters a date value as '11/2/54', this date should be interpreted as November 2nd, 1954, not November 2nd, 2054.

7) Set the instance's server agent to log errors, warnings and information notifications. (Hint: You'll need to configure the Error Logs under SQL Agent).

8) Make an alert on your instance that would occur if the AdventureWorks database's active transactions ever exceed 30 at any given time. You do not need to configure Database Mail so that it would actually send, just create the alert.

9) Enable the Resource Governor and ensure that your default resource pool can use no more than 80% of your CPU and no more than 65% of your RAM.

10) View your current server log and identify how long your instance has been running. That is, what is the date when the instance was last started?

Be sure that you have clearly labeled all of your screen shots to correspond with the steps above. Submit your Word document to Canvas under Assignment #1.

PreviousNext

Download the AdventureWorks database file from the: https://docs.microsoft.com/en-us/sql/samples/adventureworks-install-configure?view=sql-server-ver15&tabs=ssms