You were recently hired as a database administrator for CSU-Global Campus. Durin

Question

You were recently hired as a database administrator for CSU-Global Campus. During grade reporting, CSG-Global cannot afford to have any downtime. You have been asked to develop a plan for monitoring SQL Server databases.

Address these aspects of the project in your discussion post:

Develop a prioritized list of daily tasks in the order in which they should be performed to monitor the database.

Identify and explain tasks that you can automate.

Explain the benefits of establishing a baseline to benchmark the performance of SQL Server.

Provide clear, concise, focused, and well-documented responses

Explanation / Answer

The benefits will be :

Daily Tasks Automate Priority Task To Do Yes / No 1 Database availability A quick view of the database whether the database is Up or Down , viewing Active sessions and CPU status. Yes 2 Alert Check Running a script as it helps to automate warning alerts and look into it Yes 3 Performance Self-Diagnostics Collecting information about the database states, processes,logs, filesystem and database and various others Yes 4 Viewing Metrics and Thresholds All Metrics page, displaying some of the metrics and Setting thresholds No 5 Setting up Notification You can optionally direct Enterprise Manager to provide notification when events that require your intervention arises No 6 Responding to Alerts and Clearing those Clear an alert such as Generic Alert Log Error, Every Open Alert or Purge Every Alert No 7 Responding to Performance Findings Finding of SQL statements consuming significant database time were found, with an impact of 76.53% and recommended summary of SQL Tuning, SQL Access or Memory etc. No 8 Database availability again Even if the processes are available, the login to the database will either hang or show another error, so actually logging into the database and a simple select will show if access to the database is available. No

Related Questions

Navigate

• Browse (All)
• Browse Y
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.