sql2005培训资料09.ppt
- 【下载声明】
1. 本站全部试题类文档,若标题没写含答案,则无答案;标题注明含答案的文档,主观题也可能无答案。请谨慎下单,一旦售出,不予退换。
2. 本站全部PPT文档均不含视频和音频,PPT中出现的音频或视频标识(或文字)仅表示流程,实际无音频或视频文件。请谨慎下单,一旦售出,不予退换。
3. 本页资料《sql2005培训资料09.ppt》由用户(三亚风情)主动上传,其收益全归该用户。163文库仅提供信息存储空间,仅对该用户上传内容的表现方式做保护处理,对上传内容本身不做任何修改或编辑。 若此文所含内容侵犯了您的版权或隐私,请立即通知163文库(点击联系客服),我们立即给予删除!
4. 请根据预览情况,自愿下载本文。本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。
5. 本站所有资源如无特殊说明,都需要本地电脑安装OFFICE2007及以上版本和PDF阅读器,压缩文件请下载最新的WinRAR软件解压。
- 配套讲稿:
如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
- 特殊限制:
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
- 关 键 词:
- sql2005 培训资料 09
- 资源描述:
-
1、Module 9:SQL Server 2005 Replication第1页,共19页。OverviewOverview of Replication EnhancementsNew Types of ReplicationConfiguring Replication第2页,共19页。Lesson:Overview of Replication EnhancementsUser Interface EnhancementsReplication ManagementPerformance and ScalabilityReplication MonitorOther Enhancement
2、s第3页,共19页。User Interface EnhancementsReplication wizards40%fewer pagesImproved default values and auto-detectionLess branchingNew Subscription WizardReplaces the Push Subscription Wizard and Pull Subscription WizardAllows you to define multiple subscriptions with different properties at the same tim
3、e第4页,共19页。Replication ManagementInitializing a subscriberBackup and restoreCopying a databaseDynamic snapshotsResuming snapshot transfersReplicating DDL statementsAllowing anonymous subscriptions for all publications第5页,共19页。Performance and ScalabilityPrecomputed partitionsUpdates to unique keysTran
4、sactional parallelism independent agent option used by defaultDownload only articles to reduce change tracking metadataReduced contention on reporting subscribersUse snapshot isolation levelUse snapshots第6页,共19页。Replication MonitorIndependent from SQL Server Management StudioPassive monitoringDefine
5、 acceptable performance figuresMinimize monitoring impactMerge replicationArticle level statisticsUpload and download statisticsTransactional replication real-time monitoring with tracer tokens第7页,共19页。Other EnhancementsMerge replication concurrency enhancements guaranteed delivery of logical record
6、sProgramming changes release of RMOReplication of more types of objects.NET UDTsAssemblies第8页,共19页。Lesson:New Types of ReplicationHeterogeneous ReplicationPeer-to-Peer Transactional ReplicationHTTP Replication第9页,共19页。Heterogeneous ReplicationUse Oracle v8 and later databases as the publisher in a r
展开阅读全文