SQL Server DBA Eve Q (Enhanced edition)

Original link: http://www.cnblogs.com/fygh/p/3288701.html

From the initial release of SQL Server DBA Eve asked for more than a year, you have some of the issues discussed more intense, to answer these questions need more solid SQL Server

Basic and certain practical experience, if you try to answer the questions, to find the relevant information, to discuss the right and wrong answer, this process of our knowledge learning, collation and reinforcement

It's all pretty good, after all this time, did you know anything about the first 30 questions? Is your knowledge constantly being updated and deepened? Now our new 30 asks again, compared to the

Before the 30 asked, this version of the design of the problem more in-depth, involving the underlying principle of more knowledge, added more subjective and open issues, may be some friends are more disgusted with this problem, but

It is this problem that often reflects your best consideration of the technical mastery of SQL Server and looks forward to your wonderful answers and discussions.

1. Talk about the difference between clustered index, nonclustered index, hash index and their merits and demerits, include covering index's function, relative to the advantage of composite index;

2. What is the structure of the log file, what is the difference between the data written to the log file and the data file, the reason why the log file cannot be shrunk, what the probable cause is, and how the log file is optimized;

3. What happens to SQL Server to read or write log files;

4. Describe the process and role of checkpoint, DBCC CheckDB, checksum;

5. The organizational structure of the database file, which pages are mainly included and what their respective roles are;

6. How to find Hotspot libraries, hotspot tables and the most frequently executed SQL, and the most resource-intensive SQL;

7. Why is memory important to SQL Server, what types of SQL Server caches are and what their respective roles are, how memory data is written to disk, and what adjustments and controls are generally

Methods of memory;

8. What are the problems that tempdb is prone to and how do you configure and use tempdb to keep it efficient and controllable;

9. What are your ways to access data across servers, and what are the pros and cons of each?

10. Talk about an UPDATE statement from the application side to the database side of the entire process of returning results;

11. Take SQLServer2008 as an example, the main difference between the Enterprise Edition and the standard, the enterprise version of the database can be restored to the standard version, 2008 can be restored to 2005, 32-bit machine database can directly

Attach or restore to a 64-bit database, say the reason;

12. A SQL Server servers, what are your most frequently configured configurations, say their respective roles;

13. Say that you have a sudden high CPU situation of SQL Server possible emergency measures and follow-up troubleshooting steps;

Windows log Report database file Auto-grow time exceeds 15s error, how do you analyze this problem, what are the response plans;

15. Talk about the mirror/replication problems you have encountered, how to solve them, and what factors will affect their performance;

16. If you want to explain the memory bottleneck of a database server, which indicators and which methods are the basis of your judgment;

17. Database detection corruption, talk about your possible ways and steps to repair;

18. One day you receive a normal operation of the database alarm, found that many indicators have risen more than one times, how you quickly analyze and locate possible problems;

19. What typical SQL performance problems have you encountered, how to find and deal with them;

20. Talk about the scenarios you might be taking when dealing with high-volume, frequently accessed tables, and what options are actually being made, and what are the more valuable areas;

21. Talk about your views on the application scenarios of partitioned tables, sub-tables, sub-libraries, problems solved and possible problems;

22. Describe the backup, restore scheme, RPO, RTO situation you are taking now, and analyze the problems that may exist.

23. Talk about all the data on a database server (including account number, job, etc.) migrating to another new server all possible methods and steps to describe the pros and cons of each;

24. What basic maintenance work do you do for the database, and what do you do with that?

25. If you have 10 times times the number and traffic of existing SQL Server servers, what are your countermeasures?

26. When maintaining a database, what tools do you use most often, what do they do, and what actions do you think that tools can greatly improve your productivity, you work for the database

what the automation does;

27. In terms of Windows and SQL Server itself, what do you think will affect the performance of the database and what are the countermeasures;

28. How do you assess the environment of the database, how to predict how long the database can be used, based on those circumstances to develop a procurement plan;

29. What are your ways to continuously improve your database operations and capabilities, which are the driving force to keep you moving forward;

30. As a senior DBA, how do you lead and train new people so that he can grow quickly.

SQL Server DBA Eve Q (Enhanced)