TAILIEUCHUNG - The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P89

The Real MTCS SQL Server 2008 Exam 70/432 Prep Kit- P89: Congratulations on your journey to become certified in SQL Server 2008. This book will help prepare you for your exam and give you a practical view of working with SQL Server 2008. | 422 Chapter 9 Managing Replication The distribution database plays a vital role in replication therefore for better performance it is recommended to have it in a separate database server instance. This will reduce publisher loading however by separating distributor databases overall network traffic will increase. The snapshot agent bulk copies data from publisher to the distributor. When scheduling the snapshot agent try to schedule it when the CPU is idle and during low production periods. You have the option of scheduling replication for continuous instead to improve the performance try to schedule it at a regular intervals. Though you have the option of replication text ntext varchar max nvarchar max FileStream and image data types it is recommended to avoid replicating these data fields because these data types require more storage space. As specified before pull subscription will move the processing to subscriber from distributor. Sometimes you may use articles with filtered rows. In that case it will be better to include indexes for those fields to improve the performance. Monitoring In case replication failed you need to take prompt actions as it would lead to critical issues. To avoid these issues you need to monitor your replication. To monitor replication there are three options with SQL Server 2008. Replication Monitor Replication monitor is separated monitoring which can run directly by executing in Program Files Microsoft SQL Server 100 Tools Binn folder. New Noteworthy. V Replication Monitor Features In Replication Monitor grids you can select which columns to view sort by multiple columns and filter rows in the grid based on column values Continuec Managing Replication Chapter 9 423 to improve the usability of replication monitor. Right-click a grid and then select Choose Columns to Show Sort Filter or Clear Filter. Filter settings are specific to each grid. Column selection and sorting are applied to all grids of the same type such as

• Cơ sở dữ liệu
• cơ sở dữ liệu MySQL
• database SQL
• thiết kế CSDL quan hệ
• Kiến trúc hệ quản trị CSDL
• đặc tính cơ sở dữ liệu
• bảo mật cơ sở dữ liệu
• Cơ sở dữ liệu
• Hệ quản trị cơ sở dữ liệu MySQL
• Quản trị cơ sở dữ liệu
• Làm việc với MySQL
• Giới thiệu về MySQL
• Bài giảng Phần mềm nguồn mở
• Phần mềm nguồn mở
• Hệ quản trị cơ sở dữ liệu
• Lịch sử phát triển MySQL
• Kiến trúc MySQL
• MySQL Command Line
• MySQL Query Browser
• giáo trình cơ sở dữ liệu
• lý thuyết cơ sở dữ liệu
• bái giảng cơ sở dữ liệu
• tài liệu cơ sở dữ liệu
• Kết nối với MySQL
• Truy xuất cơ sở dữ liệu
• Quản lý dữ liệu
• Kết nối cơ sở dữ liệu
• Cập nhật dữ liệu
• Kích hoạt dữ liệu
• cơ sở dữ liệu sql server
• MySQL cơ bản