- ptg 54 CHAPTER 3 Examples of SQL Server Implementations. - Database Tier. - SAP DB SQL Server 2008. - FIGURE 3.1 SAP multitier architecture with SQL Server as the database layer.. - Of these, more than 23,000 SAP application installations worldwide are running with SQL Server as the RDBMS. - In fact, this $11.5 billion company uses its own software for its internal ERP purposes completely deployed on the Microsoft SQL Server platform.. - Client/Presentation Tier—This tier supports SAP graphic user interfaces (GUIs) such as SAP GUI, SAP WebGUI, and other products that connect to the SAP NetWeaver Application Server using one of the supported interfaces. - Application Tier—This tier can contain multiple SAP NetWeaver Application Server. - Database Tier—This tier supports the SAP database, including the SAP Business Suite or R/3 and other SAP applications hosted on SQL Server. - Each SAP application process establishes two connections to SQL Server (as shown in Figure 3.2). - SAP DB SQL Server 2008 Database Tier. - SQL Server 2008. - ASPProd2 SQL Server 2008 (physical). - SQL Server 2008 (physical) Quorum Disk Q:. - FIGURE 3.3 An e-commerce Internet application with a SQL Server database tier.. - We featured this ERP application because SAP has proven to the world how rock solid SQL Server is and that the smallest company to companies as large as SAP itself can safely and confidently deploy on SQL Server without hesitation.. - This web-facing application is built on JRUN but features SQL Server at the database layer, as shown in Figure 3.3.. - CHAPTER 3 Examples of SQL Server Implementations. - uptime with rolling updates at both the operating system and SQL Server levels. - The OLTP database on SQL Server is approximately 10TB and utilizes log shipping to create a reason- ably current disaster recovery (DR) copy (that has never been utilized. - Each physical server in the cluster is a Dell 8 CPU server with 256GB RAM on SQL Server 2008 Enterprise editions on Windows 2003 Advanced Servers. - The last example, describes a hybrid distributed reporting system that, uses multiple SQL Server technologies such as data replication, database mirroring, and database snapshots to get the most out of a complex healthcare industry application environment.. - This allows the user to ask questions such as “What were net sales for North America for a particular month for a specific computer product?” SQL Server Integration Services (SSIS) packages populate this data warehouse and conformed dimensions on a daily basis with deltas (new data changes only). - ptg 58 CHAPTER 3 Examples of SQL Server Implementations. - This SQL Server instance is isolated from the OLTP application where the data is sourced.. - ptg 60 CHAPTER 3 Examples of SQL Server Implementations. - SQL Server 2008 Mirror Server Principal. - SQL Server 2008 Principal. - FIGURE 3.6 Hybrid SQL Server reporting configuration.. - To satisfy this point-in-time, noncritical reporting need, the health organization leveraged SQL Server database mirroring from the replicated SQL Server Health Provider DB. - This configura- tion has been extremely stable since the SQL Server 2005 deployment.. - This chapter described some truly interesting SQL Server–based implementations. - These examples reflect how major software vendors such as SAP have utilized SQL Server as the core of their ERP data tier, how Internet-based companies rely on SQL Server to host their e-commerce applications, and how SQL Server can be used to fulfill various decision support and business intelligence needs of major corporations. - The next chapter delves into the functionality of the SQL Server Management Studio environment.. - SQL Server Management Studio. - S QL Server Management Studio (SSMS) is an integrated application that provides access to most of the graphical tools you can use to perform administrative and develop- ment tasks on SQL Server 2008. - SSMS was introduced with SQL Server 2005 and replaced the Enterprise Manager, Query Analyzer, and Analysis Manager that were available in SQL Server 2000. - SSMS is a complicated tool that provides an entry point to almost all of SQL Server’s functionality. - The aim of this chapter is to give a basic overview of SSMS while touching on the features that are new to SQL Server 2008. - SSMS is loaded with new features in SQL Server 2008. - This tool was introduced in SQL Server 2005, and it brought quite a bit of change with it. - There is also quite a bit of change with SQL Server 2008, but the basic look-and-feel of the application remains much the same as it was in SQL Server 2005.. - The standout features in the SQL Server 2008 SSMS include four new features geared toward the administrator and
Xem thử không khả dụng, vui lòng xem tại trang nguồn hoặc xem
Tóm tắt