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.

 

 

 

Looking for the best essay writer? Click below to have a customized paper written as per your requirements.