2 paragraphs for each of the questions is enough. They are all related Need it 1

Question

2 paragraphs for each of the questions is enough. They are all related Need it 1 hour.

1.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.

2.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.

Explanation / Answer

Q1) 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

Backing up Databases and Transaction Log Files:- The process of creating a backup by copying data records from a SQL Server database, or log records from its transaction log. A copy of data that can be used to restore and recover the data after a failure. Backups of a databasecan also be used to restore a copy the database to a new location. So the DBA can either do this manually by exporting the Table/Schema from source to destination or have an automated task to accomplish this

Server Daily Health Check - DBA can develop a way to improve their morning routine of checking the health of each SQL Server. This daily task would typically take about an hour for the DBA to complete. The DBA can then find out couple of information like:-

1.       What is the uptime of each SQL Server?

2.       What is the status of each database?

3.       What is the status of each Availability Group?

4.       What is the backup status of each database?

5.       What is the available disk space?

6.       Are there any SQL Agent failed jobs in the last 24 hours?

7.       What errors appeared in the SQL errorlog in the last 24 hours?

Index maintenance - performance improvements can be achieved with index maintenance. If done at regular intervals, it can free the server to focus on other requests rather than losing time scanning for fragmented indexes.

Q2) 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.

MemoryAvailable MBytes - The Available MBytes Memory counter helps me know if server memory is an issue. I can set Max Server Memory settings in SQL Server, which will help SQL Server share the memory nicely with the Windows OS, but there may be other processes on the server besides SQL Server. Capturing this counter allows me to know if other processes are taking memory SQL Server needs to perform well.

SystemProcessor Queue Length - The Processor Queue Length counter tells you the number of threads that are waiting for time on the system processor. If this number is greater than 0, that means that there are more requests per core than the system can handle, and this can be a cause for significant performance issues. I once had a client that had a month-end process that had to be run during the business day, which would take 2.5 to 3 hours to run; when it ran, performance for everyone else on that system would be horribly slow.

Please let me know in case of any clarifications required. Thanks!

Related Questions

Navigate

• Browse (All)
• Browse 2
• Subjects

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