One: How the data is stored:
1. Data files:. mdf or. ndf
2. log file:. ldf
Two: The work steps of the transaction log:
1. Data modification is emitted by the application (cached in buffer)
2. The data page is in the buffer buffer, or read into the buffers cache and modify
3. Modify the transaction log that is recorded on disk
4. The checkpoint is written to the database
Three: Manual Performance collection Items
Key aspects of the system to collect
1.windows BPA with SQL Server BPA
2. Performance counter benchmark analysis and profiler
3. dynamic management view Query
Key aspects of the system to monitor
1. Disk, memory, CPU, Nic
2.Windows, SQL seerver other services for software
3. Virtual memory, auditing, existing database configuration
Memory Bottleneck Analysis
Group to follow these three:
Memory Bottleneck Solution Ideas:
SQL Server Bottleneck Analysis:
Solution Ideas:
1. Optimizer statements
2. Optimizing Indexes
3. Optimize Concurrent access
SQL Server performance optimization (i)