Seagate ST43401N/ND Guida di Installazione Pagina 57
- Pagina / 146
- Indice
- SEGNALIBRI
Valutato. / 5. Basato su recensioni clienti
CHAPTER 5 Implement: Making Required Application Changes
49
This trace flag is well-documented in
New Functionality in 11.9.2 at
http://manuals.sybase.com:80/onlinebooks/group-
as/asg1192e/asefun92/@Generic__BookView
and the sections on query tuning
in the
Performance and Tuning Guide at
http://manuals.sybase.com:80/onlinebooks/group-
as/asg1200e/aseperf/@Generic__BookView
.
Syntax for Trace Flag
302
When using trace flag (302) to see optimizer information, use trace flag 3604
to send output to the client. (You can use trace flag 3605 to send output to the
errorlog, but this is not recommended.) The syntax looks like this:
dbcc traceon (3604,302)
Trace flag 302 output has been divided into the following “blocks” of related
information:
• The Table Information Block
• The Base Cost Block
•The Clause Block
• The Column Block
• The Index Selection Block
• The Best Access Block
The following is an example of trace flag 302 output:
*******************************
Beginning selection of qualifying indexes for table
’lineitem’,
varno = 0, objectid 240003886.
The table (Datarows) has 600572 rows, 44308 pages,
The table’s Data Page Cluster Ratio 0.999990
Table scan cost is 600572 rows, 44489 pages,
using no data prefetch (size 2K I/O),
in data cache ’default data cache’ (cacheid 0) with MRU
replacement
Selecting best index for the SEARCH CLAUSE:
lineitem.l_partkey = 2000
lineitem.l_orderkey > 10000
Estimated selectivity for l_orderkey,
selectivity = 0.983249, upper limit = 1.000000.
Estimated selectivity for l_partkey,
selectivity = 0.000052, upper limit = 0.052686.
Estimating selectivity of index ’lineitem_lorder’,
- Migrating to Adaptive Server 1
- Enterprise 12.5 1
- 34982-01-1250-01 2
- Oct 2001 2
- Contents 3
- Introduction and Guide to 9
- Resources 9
- Other Sources of Information 11
- Migration Web Page 13
- Consulting Services 13
- If You Need Help 14
- Requirements 15
- Diagramming the System 16
- Availability Requirements 17
- Database Change Metrics 18
- Maintenance Procedures 18
- Service Level Requirements 19
- Current Performance Metrics 20
- Analyze: Documenting Your 23
- General Server Hardware 24
- CPU Resources per Machine 24
- Disk Configuration 24
- Physical Memory Utilization 26
- Software Configuration 27
- Sybase Configuration 28
- General Information 29
- Adaptive Server Objects 31
- Query Sybase System Tables 32
- Use System Stored Procedures 32
- Use Sybase Tools 32
- Ready to Migrate 33
- Review the Upgrade Process 34
- Determine Migration Approach 36
- Parallel With Replication 37
- Cutover Without Replication 39
- Phased Cutover 41
- Write a Migration Plan 43
- Update Hardware Resources 44
- Products 45
- Create Migration Scripts 46
- Implement: Making Required 47
- Application Changes 47
- If Your Version is 11.5 48
- Changes to Error Checking 50
- Changes in Error Numbers 51
- New and Changed Statistics 54
- Aggregate Optimization 56
- Costing Large I/O 56
- The optdiag Utility 56
- Trace Flag 302 56
- ANSI Joins 58
- 12.0 Query Processing Changes 60
- 50 Tables in a Query 61
- Abstract Query Plans 61
- Increased Optimization Time 62
- Changes to Transact-SQL 63
- New Reserved Words 64
- Change in Truncation Behavior 66
- Administration Changes 69
- Implement: Making Database 69
- Optimizer Changes 71
- Trace Flag 326 72
- Documentation Changes 73
- Backup Server 73
- Network Connections 74
- File Descriptors 74
- Non-Rewinding Tapes 74
- Starting Backup Server 74
- Dump Format 75
- Changes to dbids 76
- CIS Proxy Databases 77
- The sybsyntax Utility 77
- Changes to Documentation 78
- System Database Sizes 78
- Changes to System Tables 79
- New Database and Table Limits 80
- Configuration Parameters 82
- 86016 (84K) - 64-bit 83
- Increased Memory 84
- Test: Ensuring Stability and 87
- Performance 87
- Make Backups 88
- Summary of Testing Techniques 91
- Writing Performance Scripts 93
- General Error Handling 94
- Deadlock Handling 94
- Result Handling 95
- Time Measurement 95
- Runtime Data Generation 95
- Test Cycle: Summary of Tests 96
- Pre-Upgrade Single-User Tests 97
- Pre-Upgrade Multi-User Tests 98
- Test System Upgrade 99
- Post-Upgrade Multi-User Tests 99
- Untimed Benchmarks 100
- Timed Benchmarks 100
- Worksheets for Your Current 101
- Environment 101
- Backup and Restore Procedures 102
- Database Dump Details 103
- Data Architecture Worksheet 105
- Transaction Profile 107
- Host Configuration 109
- Physical Memory Usage 110
- Disk I/O Configuration 111
- Network Configuration 113
- Tape Configuration 114
- Adaptive Server Configuration 115
- Database Devices 116
- Databases and Segments 117
- Dump Devices 118
- Sample Migration Task Lists 119
- Migration Analysis 120
- Gather Business Requirements 121
- Develop Migration Strategy 121
- Migration Preparation 122
- Create Target Environment 123
- Perform Server Migration 124
- Perform Database Migration 124
- Perform Data Migration 124
- Perform Application Migration 124
- Upgrade Adaptive Server 125
- Complete Migration 125
- Migration Quality Assurance 126
- Perform User Acceptance Tests 127
- Set Up Replication Server 129
- Run Regression Test Suites 129
- Upgrade Server B (Shadow) 130
- Other Testing 131
- Perform Final Steps 132
- Staged Cutover Task Overview 137
- Migration Issue Checklists 139
- Logical Support Architecture 141
- Migration Strategy Design 142
- Pre-Upgrade Checklist 143
- .cfg) file 145
Prodotti e manuali riguardandi Software di database Seagate ST43401N/ND
(172 pagine)© 2020, manymanuals.it. Tutti i diritti riservati | 0.040 s |
Manymanuals.com
Manymanuals.de
Manymanuals.fr
Manymanuals.it
Manymanuals.pl
Manymanuals.cz
Manymanuals.es
Manymanuals-pt.com
Commenti su questo manuale