Methodology Mind-Set and Management Processes (Discussion Question)
- Imagine you are a DBA who manages fifteen (15) SQL servers. Determine three tasks that could automate the process of maintaining a SQL server by creating a job. Outline how the three 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 performance counters that could be used, and justify the reasoning for using each.