Seagate ST43401N/ND Technical Information download pdf (Page 135)

Migrating to Sybase Adaptive Server Enterprise 11.5 B-17

Adaptive Server Enterprise 11.5 SQL Server Infrastructure Worksheets

SQL Server Conﬁguration

Document general information about the SQL Server conﬁguration.

Table B-17: SQL Server conﬁguration

General Conﬁguration

Home directory:

Components, release and ﬁx levels:

Locations/names of scripts to rebuild database environment:

sp_conﬁgure conﬁguration values:

buildmaster conﬁguration values:

1 2 ... 130 131 132 133 134 135 136 137 138 139 140 ... 171 172

Migrating to Sybase® 1
Table of Contents 5
A. The Cyrano Migration Pack 9
E. Migration Plan Checklist 12
List of Tables 13
Introduction and Guide to 15
Resources 1 15
Chapter Title Contents 16
Technical Information Library 18
Migration Web Page 19
Migration Courses 19
Sybase Press Books 20
Third-Party Books 20
Consulting Services 20
Third-Party Tools 21
If You Need Help 21
Analyze: Documenting Business 23
Requirements 2 23
Acme Brokerage Company 24
System Architecture 24
Availability Requirements 25
Database Change Metrics 25
Maintenance Procedures 26
Service Level Requirements 27
Current Performance Metrics 28
• Vendor issues 30
Analyze: Documenting Your 31
Environment 3 31
CPU Resources per Machine 32
Disk Conﬁguration 32
Network Conﬁguration 34
Tape Conﬁguration 34
Physical Memory Utilization 35
Software Conﬁguration 36
Sybase Conﬁguration 37
SQL Server Objects 40
If You Don’t Have Scripts 41
Ready to Migrate 4 43
Parallel With Replication 45
Cutover Without Replication 47
Phased Cutover 49
Write a Migration Plan 50
Update Hardware Resources 51
Create Migration Scripts 52
Implement: Making Required 55
Application Changes 5 55
Datatype Changes 57
Table 5-3: Datatype hierarchy 59
Name Hierarchy 59
Subquery Processing Changes 62
NULL Algodata Infosystems 64
NULL New Age Books 67
Binnet & Hardley 67
Algodata Infosystems 67
250 no rows returned 68
Enterprise 11.5 73
Login and Password Changes 82
RUN File Renamed 83
New create table Permission 84
New Backup Server 85
Last Chance Threshold 85
Reference Supplement 86
Conﬁguration Interface 88
Old Name New Name 89
Databases Online / Ofﬂine 90
Increased Memory Requirements 92
Figure 6-1: Areas of memory 93
4.x 125% 96
10.x 50% 96
11.0.x 25% 96
Optional Space Considerations 98
Test: Ensuring Stability and 101
Performance 7 101
Make Backups 102
Summary of Testing Techniques 104
• Production load capture 105
Writing Performance Scripts 106
Test Cycle: Summary of Tests 109
Stage Purpose Best Technique 110
Pre-Upgrade Single-User Tests 111
Pre-Upgrade Multi-User Tests 111
Test System Upgrade 112
Post-Upgrade Multi-User Tests 113
The Cyrano Migration Pack A 115
For More Information 117
A-4 The Cyrano Migration Pack 118
Worksheets for Your Current 119
Environment B 119
Backup and Restore Procedures 121
Database Dump Details 122
Data Architecture Worksheet 124
Transaction Proﬁle 126
Host Conﬁguration 127
Record CPU resources: 128
Physical Memory Usage 129
Operating System Conﬁguration 134
Detail the operating system 134
SQL Server Conﬁguration 135
Table B-18: dbcc output 136
Usage MB 2K Pages Bytes 136
Database Devices 137
Databases and Segments 138
Dump Devices 139
Migration Approach Outline 141
In This Appendix 145
Sample Task List Template 145
Migration Analysis 146
Migration Preparation 147
Migration Quality Assurance 151
Set Up Replication Server 154
Run Regression Test Suites 154
Perform Final Steps 156
Staged Cutover Task Overview 161
Migration Plan Checklist E 163
Logical Support Architecture 165
Migration Strategy Design 165
E-4 Migration Plan Checklist 166

Comments to this Manuals

No comments

Seagate ST43401N/ND Technical Information Page 135

Comments to this Manuals