DRAG DROP
You administer a Microsoft SQL Server 2012 server.
A variety of issues occur from time to time in the production environment. You need to identify the
appropriate tool for each issue.
Which tool or tools should you use? (To answer, drag the appropriate tool or tools to the correct
issue or issues in the answer area. Each tool may be used once, more than once, or not at all. You
may need to drag the split bar between panes or scroll to view content.)
Answer: 
From up to down:
– Performance Monitor (https://www.mssqltips.com/sqlservertutorial/283/performance-monitor/)
– sys.dm_exec_requests (https://msdn.microsoft.com/it-it/library/ms177648(v=sql.110).aspx)
– DBCC CHECKDB (https://msdn.microsoft.com/it-it/library/ms176064(v=sql.110).aspx)
– Job history (https://www.mssqltips.com/sqlservertip/2850/querying-sql-server-agent-job-history-data/)
– SQL Server error log (https://sqlserver-help.com/2011/06/26/help-where-is-sql-server-errorlog/)
0
0