Dell Microsoft SQL Server Microsoft SQL ServerTM SQL Server

Document Sample
Dell Microsoft SQL Server Microsoft SQL ServerTM SQL Server Powered By Docstoc
					 Dell




                                              Microsoft SQL Server 2005


                              Microsoft® SQL ServerTM
                                                         SQL Server 2005




                                     Todd Muirhead




  Microsoft SQL Server 2005
                              M      icrosoft SQL Server 2005 Service Pack 1 SP1



                                          DellTM PowerEdgeTM
                                         IT
www.dell.com/powersolutions




                                                      SQL Server 2005
                                                                                         Dell PowerEdge     SQL Server 2005
                              Dell                          Dell                                                                 SQL
                                                                                       Server 2005



                                                                     SQL Server 2005                         1
                                                                                                                        TCP/IP



                                         SQL Server
                                                                   SQL Server 2005




 74           POWER SOLUTIONS                                                                             www.dell.com.cn/powersolution
                                                                                                               Dell




                                                                                    Dell


                                                                                setc@dell.com
                                       SQL Server 2005




                                                                                                                              Dell/EMC CX
                                                                                                                              SQL Server


                                                                                                                      Dell/EMC CX
                                                                                  EMC MirrorView      SQL Server 2005
                                                    Dell
                 Dell PowerEdge                     SQL Server 2005               SQL Server 2005
                                      Dell/EMC                                                                        MOM 2005


                         2                                                    MOM               MOM
              Dell                                                 SQL                                                  MOM
Server 2005                                                  Microsoft                                                 Dell             Dell
                     ®                                                                     TM
Active Directory                     Microsoft Operations Manager             OpenManage               SQL Server
(MOM) 2005


    Dell/EMC CX3-80           CX700
               RAID-10
RAID-10                  Dell/EMC CX500
  RAID-5


                     SAN
  SQL Server 2005


  SAN




          SQL Server 2005
                                            EMC ®
MirrorViewTM                                             1. SQL Server 2005



     http://www.dell.com.cn/powersolution                                                                             POWER SOLUTIONS      75
Dell




                                                   1
                                    MOM


         SQL Server 2005 MOM

      SQL Server 2005 SP1                        SQL             MOM
                      18                                               3



             MOM



                                                            MOM



         MOM
                                              MOM
                           MOM                                MOM



           MOM                       MOM                 MOM
         MOM                                                                         3. SQL Server 2005 MOM
                           MOM Operator
                      SQL Server 2005 MOM                                                                             SQL Server Management Studio
                                                                                                   MOM Operator
                                                                                                               SQL Server 2005
                                                                                                     SQL

                                                                                        ALTER DATABASE database name SET PARTNER
                                                                                        FAILOVER


                                                                                                           MOM Administrator
                                                                                           4
                                                                                     SQL Server 2005                                               sqlcmd.
                                                                                  exe                                     SQL
                                                                                                                           MOM Operator
                                                                                         MOM



                                                                                                           MOM
                                                                                                           MOM


                                                                                                           5            MOM Administrator
     2. SQL Server 2005           Dell

1
              MOM      SQL Server                 2006 8 Dell Power Solutions Todd Muirhead              "Managing Microsoft SQL Server 2005 with Microsoft
    Operations Manager 2005 in a Dell Scalable Enterprise Architecture" www.dell.com/downloads/global/power/ps3q06-20060360-Muirhead.pdf



76          POWER SOLUTIONS                                                                                                     www.dell.com.cn/powersolution
                                                                                                                Dell




                                                                                                                                     2006     7
                                                                     Dell

                                                                                                                       2




                                                                                            Dell PowerEdge 2850
                                                                                       ®
                                                                       3.6 GHz Intel Xeon®                  8 GB RAM          QLogic QLA2340
                                                                                                       Microsoft Windows Server® 2003 Re-
                                                                     lease 2 (R2) Enterprise x64 Edition OS                 PowerEdge 6650

    4.                                           MOM Administrator

                                                                                                Dell/EMC
                                                                                                                                      15,000 rpm
                                                                              Dell/EMC CX3-80


                                                                     RAID-10                    LUM
                                                                             RAID-1 LUN
                                                                     RAID-10 LUN           10
                                                                                                RAID-1
                                                                     LUN       2


                                                                                           D e ll/EM C
                                                                     CX700                  LUN
                                                                       CX3-80                         10,
                                                                     000 rpm
                                                                                            10,000 rpm
    5.                                          MOM Administrator
                                                                              Dell/EMC CX500
                                                                                                      RAID-5                     LUM
                                                                     RAID-1 LUN                   RAID-5 LUN      5                          RAID-

                         Alert                                       1 LUN         2
                                                                       CX3-80

         MOM Operator
                                                                                                                 Dell DVD Store
                                                                       linux.dell.com/dvdstore                         Dell DVD Store

         SQL Server 2005                                                               DVD                                                    DVD
                                                                     Store




2




         http://www.dell.com.cn/powersolution                                                                              POWER SOLUTIONS        77
Dell




                                                                                                                             DVD
                                                                   Store




                                                                           SQL Server 2005

  6. SQL Server 2005                                               Microsoft SQL Server 2005 SP1
                                                                                                         SQL Server         MOM
                                                                   2005     Dell OpenManage
                                   DVD Store                 100
GB          2000,000,000               6000,000,000
                            DVD Store


                                                                   Todd Muirhead       Dell
                                        1     10             DVD           Todd   North Texas
Store                                                                        Microsoft Certified Systems Engineer + Internet
                                                                    MCSE+I



                                                              No
Recovery


           1    10



     6


         LUN                       6     6


               CX700        CX500
                           CX700            CX500



           CX500 RAID-5
                                             CX700 RAID-10




78       POWER SOLUTIONS                                                                               www.dell.com.cn/powersolution