Methodology Mind-Set and Management Processes (Discussion Question)

profilelilb05
  • Imagine you are a DBA who manages fifteen (15) SQL servers. Determine three (3) tasks that could automate the process of maintaining a SQL server by creating a job. Outline how the three (3) tasks would affect performance and justify creating them as a job.
  • Users are complaining that it is taking longer to process their query results. You decide to create a performance monitor to determine the status of the SQL server. Outline three (3) performance counters that could be used, and justify the reasoning for using each.
    • 10 years ago
    • 5
    Answer(1)

    Purchase the answer to view it

    blurred-text
    NOT RATED
    • attachment
      maintaining_an_sql_server.docx