Sybase database administrator's handbook:
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Buch |
| Sprache: | Undetermined |
| Veröffentlicht: |
Upper Saddle River, NJ
Prentice Hall
1996
|
| Schlagworte: | |
| Online-Zugang: | Inhaltsverzeichnis |
| Beschreibung: | XXIV, 607 S. graph. Darst. |
| ISBN: | 0133574776 |
Internformat
MARC
| LEADER | 00000nam a2200000 c 4500 | ||
|---|---|---|---|
| 001 | BV026179236 | ||
| 003 | DE-604 | ||
| 005 | 20110228 | ||
| 007 | t | ||
| 008 | 110326s1996 d||| |||| 00||| und d | ||
| 020 | |a 0133574776 |9 0-13-357477-6 | ||
| 035 | |a (OCoLC)832583119 | ||
| 035 | |a (DE-599)BVBBV026179236 | ||
| 040 | |a DE-604 |b ger |e rakwb | ||
| 041 | |a und | ||
| 049 | |a DE-188 | ||
| 082 | 0 | |a 005.758 | |
| 100 | 1 | |a Hitchcock, Brian |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Sybase database administrator's handbook |c Brian Hitchcock |
| 264 | 1 | |a Upper Saddle River, NJ |b Prentice Hall |c 1996 | |
| 300 | |a XXIV, 607 S. |b graph. Darst. | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 650 | 0 | 7 | |a SYBASE |0 (DE-588)4395043-7 |2 gnd |9 rswk-swf |
| 689 | 0 | 0 | |a SYBASE |0 (DE-588)4395043-7 |D s |
| 689 | 0 | |5 DE-188 | |
| 856 | 4 | 2 | |m HEBIS Datenaustausch |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=021763918&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-021763918 | ||
Datensatz im Suchindex
| _version_ | 1804144634594590720 |
|---|---|
| adam_text | Sybase® Database
Administrator s Handbook
Brian Hitchcock
For book and bookstore information
http://www prenhall com
Prentice Hall PTR, Upper Saddle River, NJ 07458
Table of Contents
Preface ix
Purpose ix
Who Is This Book For? x
What You Need to Know to Use This Book x
What You Will Learn From This Book x
Conventions xii
Terms xiv
Versions of SQL Server xv
SQL Server System 11 xv
Versions of Replication Server xx
Acknowledgments xxi
Chapter 1
Standard Server and Server Machine Environment 1
You Are Not Alone Anymore 1
The Multiserver Environment 6
Why You Should Have a Standard Configuration 10
Standard for Overall Environment 10
Standard Configuration for All Server and DBA Machines 16
Standard Configuration for Servers 31
Chapter 2
Replication Server 47
Overview 48
What Replication Server Does 50
What Replication Server Doesn t Do 53
Example of the Process of Replicating Data 57
Configuration Issues 57
Installing Replication Server 58
Creating a Subscription 61
Users and Passwords 63
How Replication Server Links with SQL Servers 64
Affects on Existing and New Applications 65
Capacity Planning 66
, iii
Sybase Database Administrator s Handbook
Administration Using Replication Server Manager - 67
Failure Modes 70
Function Strings 71
Chapter 3
Installation of SQL Server from Scratch 73
Preparing for Installation 74
sybconfig for SQL Server 49x 87
sybinit for SQL Server System 10 102
Post sybconfig (sybinit for System 10) 131
sybconfig (sybinit for System 10) Errors 139
Chapter 4
Physical Server Design 143
Physical Disks 144
Raw Partitions vs File Systems 146
SQL Server Logical Disk Devices 147
Disk Partitioning , 148
Disk Controllers • 154
Initializing Server Devices 159
Database Segments 169
Mirroring Server Devices 183
How to Layout the Devices and Segments of a Server 206
Summary ; 208
Chapter 5
Documenting a Server 209
The Servermap and Why You Need It 210
Generating Servermap for Existing SQL Server 212
Generating Servermap for New SQL Server 225
Server Configuration 227
Database Usage and Relative Importance 236
Server Health 236
Server Machine Configuration 239
The Database System 241
IV
Table of Contents
Chapter 6
Physical Database Implementation 245
Transaction Log on Separate Server Device 245
Transaction Log Not on Separate Device 247
Sizing the Transaction Log 248
Placing a Database on Disks and Controllers 254
Placing Databases on Disks and Controllers 255
Mirroring Priorities 257
Why You Should Be Hesitant to Add Database Space 259
Chapter 7
The master Database Is Special 261
The master Database and Master Device 261
Sizing the Master Device 262
The logsegment of the master Database 264
Master Device Name and Mirroring : 264
Master Device and disk init 266
Master Device and Default Server Disk Devices 267
Loading a Database Dump of the master Database 269
Moving Master Device to the Larger Partition 269
Clearing Server Configuration in master Database 273
Chapter 8
SQL Server Recovery 275
Recovery Planning Revolves Around the Cost of Downtime 276
The Database is Nothing without the Transaction Log 277
Recovery Is Transaction Based 290
Standby Server Strategies 290
master Database Is Not for Users 298
The Use of dbcc 299
Mirroring 306
Archiving 308
More Server Devices Are Better 310
Recovery Notes ? 310
Database Dumps 312
Transaction Log Dumps 315
Logical Dumps and DataTools SQL BackTrack 317
Recovery Matrix 321
Sybase Database Administrator s Handbook
Chapter 9
Performance and Tuning 329
Theory Is Nice 330
What You Can Do in the Real World 331
Indexes and Queries 334
Spreading Segments Over Server Devices 338
Spreading Individual Tables 340
Archiving 340
Decision Support Server 342
Standard Set of Application Transactions 346
SQL Monitor 347
SQL Server Performance Tools 350
Application-Transparent Server Tuning 352
Preventing Downtime 356
Servermap and Performance and Tuning 356
Chapter 10
Capacity Planning 359
The Overall Database System 360
The Individual Server 364
Real-World Example • 372
Capacity Planning for the Database System 390
Chapter 11
Operational Details of SQL Server 391
Interfaces File 391
Communication Among Servers 396
Creating Stored Procedure from SQL Script or defncopy Output 400
What sysusages Means 400
Reading the Errorlog 409
Impacts of Creating a New Database 417
Modifying System Tables Manually 417
bcp Command 418
Full Transaction Log or Other Segment (1105 Error) 419
VI
Table of Contents
Chapter 12
Database Administration Versus Database System Size 425
Small Database Systems 426
Large Database Systems 427
Very Large Database Systems 432
Summary 433
Chapter 13
Upgrading SQL Server 435
Installation Guide, Release Notes, and EBF Cover Letter 436
Sybase Technical Support 436
Risks of the Upgrade Process 437
EBF Upgrades 438
Version Upgrades 441
Preparing to Upgrade 49x to System 10 442
Upgrading 49x to System 10 455
Post Upgrade 49x to System 10 461
Actual Upgrade Output 49x to System 10 466
Regressing from Failed System 10 Upgrade 490
Dependencies 493
Chapter 14
Transitiohing to System 10 495
System 10 Changes to SQL Server 495
Transition to System 10 Won t Happen All at Once 497
SQL Server Upgrade Dependencies 497
Changes that Affect Existing Applications 500
Changes that Affect DBA 501
Compatibility with Other Sybase Products • 505
Server Login Passwords 506
Server Login sa versus Server Logins with sa_role 507
Backup Server 508
VII
Sybase Database Administrator s Handbook
Chapter 15
Scripts : 511
Dump Database Transaction Log (dumplog) 512
Dump Databases for SQL Server 49x (dumpdb) 516
Load Databases for SQL Server 49x (loaddb) 520
update statistics on All Tables (update_statistics _all_tables) 525
Dump Commands to Recreate Databases (dump_db_create) 528
Run dbcc Checks (checkdb) 531
Dump Data from System Tables (dump_systables) 532
Create Stored Procedure to Generate Database Creation Script (p_dbcreate) 535
Create Stored Procedure to Check Mirrors (p_mirror) 538
Create Stored Procedure to Output Device Space (p_devspace) 539
Create Stored Procedure to Output All Segments on Devices (p_servermap) 541
Dump Databases for SQL Server System 10 (dumpdb_sys10_tape_disk) 544
Load Databases for SQL Server System 10 (Ioaddb_sys10) 549
Server Startup Script RUN_ se/vername 549
Chapter 16
Recommended Reading , 555
SQL Server Books 556
SQL Books 558
Database Design/Tuning Books 559
UNIX Books 560
System Administration Books 560
Data Modeling Books 561
• Magazines 561
General , 562
Index 563
|
| any_adam_object | 1 |
| author | Hitchcock, Brian |
| author_facet | Hitchcock, Brian |
| author_role | aut |
| author_sort | Hitchcock, Brian |
| author_variant | b h bh |
| building | Verbundindex |
| bvnumber | BV026179236 |
| ctrlnum | (OCoLC)832583119 (DE-599)BVBBV026179236 |
| dewey-full | 005.758 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.758 |
| dewey-search | 005.758 |
| dewey-sort | 15.758 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>01124nam a2200313 c 4500</leader><controlfield tag="001">BV026179236</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20110228 </controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">110326s1996 d||| |||| 00||| und d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0133574776</subfield><subfield code="9">0-13-357477-6</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)832583119</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV026179236</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rakwb</subfield></datafield><datafield tag="041" ind1=" " ind2=" "><subfield code="a">und</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-188</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.758</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Hitchcock, Brian</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Sybase database administrator's handbook</subfield><subfield code="c">Brian Hitchcock</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Upper Saddle River, NJ</subfield><subfield code="b">Prentice Hall</subfield><subfield code="c">1996</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XXIV, 607 S.</subfield><subfield code="b">graph. Darst.</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">nc</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">SYBASE</subfield><subfield code="0">(DE-588)4395043-7</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">SYBASE</subfield><subfield code="0">(DE-588)4395043-7</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-188</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">HEBIS Datenaustausch</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=021763918&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-021763918</subfield></datafield></record></collection> |
| id | DE-604.BV026179236 |
| illustrated | Illustrated |
| indexdate | 2024-07-09T23:06:41Z |
| institution | BVB |
| isbn | 0133574776 |
| language | Undetermined |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-021763918 |
| oclc_num | 832583119 |
| open_access_boolean | |
| owner | DE-188 |
| owner_facet | DE-188 |
| physical | XXIV, 607 S. graph. Darst. |
| publishDate | 1996 |
| publishDateSearch | 1996 |
| publishDateSort | 1996 |
| publisher | Prentice Hall |
| record_format | marc |
| spelling | Hitchcock, Brian Verfasser aut Sybase database administrator's handbook Brian Hitchcock Upper Saddle River, NJ Prentice Hall 1996 XXIV, 607 S. graph. Darst. txt rdacontent n rdamedia nc rdacarrier SYBASE (DE-588)4395043-7 gnd rswk-swf SYBASE (DE-588)4395043-7 s DE-188 HEBIS Datenaustausch application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=021763918&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis |
| spellingShingle | Hitchcock, Brian Sybase database administrator's handbook SYBASE (DE-588)4395043-7 gnd |
| subject_GND | (DE-588)4395043-7 |
| title | Sybase database administrator's handbook |
| title_auth | Sybase database administrator's handbook |
| title_exact_search | Sybase database administrator's handbook |
| title_full | Sybase database administrator's handbook Brian Hitchcock |
| title_fullStr | Sybase database administrator's handbook Brian Hitchcock |
| title_full_unstemmed | Sybase database administrator's handbook Brian Hitchcock |
| title_short | Sybase database administrator's handbook |
| title_sort | sybase database administrator s handbook |
| topic | SYBASE (DE-588)4395043-7 gnd |
| topic_facet | SYBASE |
| url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=021763918&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT hitchcockbrian sybasedatabaseadministratorshandbook |