SQL Server

1
SQL Server? ??? ??? ?? ??
- ?? ?? ??? ???

• ??? ?? ????
• Quest Software??? ??
• Eland World

2
Agenda

• Quest Software ??
• ??? ??? ?? DBA? ??
• Quest Software? ??
• E-land World ??
• E-land World SQL Server ?? ??
• E-land World ?? ??

3
Our strategy has led to strength and leadership

• Consistent annual growth
• 389 M in 04 Revenues
• Nasdaq QSFT
• 2,500 employees
• Customers
• 18,000 worldwide
• 75 of the Fortune 500

Analysts rank us 1
projected
M USD
Distributed Database Management Facilities
Software IDC, 2005
Strong industry partnerships
4
Award Winning Solutions for SQL Server
5
??? ??? ?? DBA ??

• DBA need an economical, robust solution to their
  ever growing data content.
• Reduction in the time to backup databases
• Reduction in the time to restore databases
• Reduction in the amount of disk storage used
• Reduction in the amount of tape media used
• Reduction in the amount of Network Bandwidth used
• Adds the Security of Secret Key Encryption to all
  backup files.
• Multiple tools to manage complex, multi-vendor
  database environment
• Maintaining multiple servers with less people -
  less time less experience
• Firefighting application outages, slow response,
  and space requirements

6
Customers like you
7

• ??? ??
• .Net Advisor
• SQL Specialist Group
• DBA, SAP BC / Eland World

8
Agenda

• ?? ??
• ??? ??
• ?? (?? ??)
• ????
• LiteSpeed? ??? ??
• LiteSpeed ?? ?? ?? ??
• LiteSpeed ??
• ??
• ?? ??

9
?? ??

• ??? ?? ???? ??
• 2001OUTLET, NEWCORE OUTLET, NC ???, KIM's CLUB
• ? ?? 1?8000? ?
• ?? ? 24
• ???? 3

10
??? ??
User Interface
Enterprise Portal (SAP EP 6.0)
ERP (SAP R/3 4.7 64bit)
DW (SAP BW 3.5 64bit)
CRM (SAP CRM 4.0)
KMS
HR System
SAP Solution Manager
Legacy
Backend System

Exchange Infra
SAP XI (planned)
11
??(?? ??)

• ???? Data ??
• ????(???, ????)
• ?? ??
• ??? ?????? ?? ??
• ?? ???? ? ???
• ????
• ??? ??
• ?? / ?? Speed, Size, Verification, Cost
• ?? ?? ??? SQL LiteSpeed

12
?? ??

• ????
• Full Backup Weekly
• Differential Backup Daily
• Transaction Log Backup Hourly
• ???? 2-Step Backup
• Step 1 DB Backup to Disk (LiteSpeed)
• Step 2 File Backup Disk to Tape (Veritas
  Backup Exact)

13
Step 1 - DB to Disk
ERP System
DW System
CRM System
1
1
1
Others
Backup System
1
14
Step 2 - Disk to Tape
2
2
3
15
LiteSpeed? ??? ??
ERP System
DW System
CRM System
16
LiteSpeed? ??? ??

• Assistant

17
LiteSpeed? ??? ??

• Query

18
LiteSpeed?? ?? ?? ??

• ?? ??
• ERP System 1.5 TB ? 255 GB (83)
• DW System 1.1 TB ? 240 GB (78)
• CRM System 46 GB ? 17 GB (63)
• ?? ??
• ??? ?? ? ?? ?? 75 ??
• ?? ??
• ERP System 1?? 40?
• DW System 1?? 25?
• CRM System 20?

19
LiteSpeed ??

• Backup Restore
• SQL ???? ???? ?? ??? ?? ??
• Table ?? Backup Restore
• ?? ??
• DB Migration
• ?) SQL Server 32 bit ? 64 bit 64bit ??????
  ????? ?? ??
• Log shipping ?? ?
• ?) ?? ?? ?? ? Target Server? ??? ??

20
??

• Tool ?? ? ?? ???
• ?? ???? ??? ???? ???
• ??? DB ??
• ??(????)
• ???? ?? ????
• SQL trace? ?? ?? ?? sp_trace_create,
  inputbuffer ??
• ?? ??
• SQL statements
• Configuration
• De-fragmentation
• ?? ? ?? ?? SQL Server 2005? ? ?? ??

21
?? ??

• ?? ???? ????
• SAP R/3, BW Performance Tuning
• Data Archiving
• ?? ??? ?? ????
• ?? ??? ????
• SQL Server ?????
• SAP R/3, BW ??? SQL Server 2000(64bit) ?
  2005(64bit)
• SQL Server 2005 ?? ??(Table Partitioning ?)
• SAP XI ??
• SAP System Upgrade
• R/3 WAS620 ? WAS700 , EP 6.0 sp2 ? Netweaver04 SR1

22
LiteSpeed
95 ?? 50 ?? ?? ? ?? Plus - ???(Encryption) -
Object Level ?? - Double Click Restore - Backup
Attached Files

• LiteSpeed ???? http//support.quest.com

23
Quest Central
24

?????.