1、Upgrade ArchitectureHow Unified Install EvolvedTools help migrationSQL ServerComprehensive, Integrated Data PlatformEliminating business latencyMicrosoft BI ArchitectureMicrosoft Business Solutions Financial AnalyticsSQL ServerRelational EngineOffice SystemBusiness Intelligence And Reporting User Pr

2、ofiles5-10% of users15-25% of users65-80% of usersSQL Server Reporting ServicesSQL Server Analysis ServicesQ4Q1Q2Q3Time DimensionProducts DimensionDallasDenverChicagoRegion DimensionApplesCherriesGrapesAtlantaSales FactMelonsOLAP QueriesAbout ScorecardsIncrease customerconfidence in our advice% of c

3、ustomers surveyed who rate us as their topsource of advice 65% #190% #1 or #2Website Resource CenterConsultative SellingTraining ProgramObjectivesKPIsTargetsInitiativesWindows And SFU ArchitectureUNIX And Windows Interoperability FileSystemSecurityDirectoryReference ArchitectureWhat it looks like Wr

4、ite-Ahead LoggingLDataLogServerCacheSequential writesChangeChangeChangeChangeLog5 Rows AffectedAfter the log entries are made and the locks are releasedTransaction Recovery & Checkpoints TransactionsAction Requiredif restart recoveryNoneCheckpointSystem FailureRoll forwardRoll backRoll forwardRo

5、ll backLDL/DL/DLLTimeReport ExecutionAnd DeliveryReport SourcesDeliveryChannelsSecurityServicesOutput FormatsReporting Services ArchitectureReport ServerData ProcessingRenderingSecurityDeliveryReport ProcessingProgrammatic InterfacesWeb UIMicrosoft OfficeCustom ApplicationsReport Server DatabaseBrow

6、serReporting Server & CatalogReport ServerNT Service (Scheduling / Delivery):Scheduled requests (subscriptions & snapshots)Delivery (e-mail / fileshare)ASP.NET Web Service (Report Processing):Services report requests Execute, process, render reportManage sessionsReport definitionsData source

7、sUsers, policies and rolesReport snapshots & historyReportServerTempDB:ReportServer: Session data Cached reportsClientReport AuthorUserIIS Report ManagerReport ServerDeployment (Local Catalog)SMTPReport DesignerVisual Studio .NETReport Server CatalogMSSQLUserDeployment (Remote Catalog)Report Server CatalogSMTPIIS Report ManagerReport ServerMSSQLUserDeployment (Clustered Web Farm)Clustered Web Farm - Virtual Report ServerMSRSSMTPIIS Report ManagerReport ServerReport Server CatalogMSSQLMSRSIIS Report ManagerReport ServerReport Server CatalogMSSQLFailover ClusterProcessIslandsConnectedPr