Muutke küpsiste eelistusi

Sybase Database Administrator's Handbook [Kõva köide]

  • Formaat: Hardback, 520 pages, kõrgus x laius x paksus: 242x180x28 mm, kaal: 1056 g
  • Ilmumisaeg: 06-Dec-1995
  • Kirjastus: Prentice Hall
  • ISBN-10: 0133574776
  • ISBN-13: 9780133574777
Teised raamatud teemal:
  • Kõva köide
  • Hind: 66,03 €*
  • * saadame teile pakkumise kasutatud raamatule, mille hind võib erineda kodulehel olevast hinnast
  • See raamat on trükist otsas, kuid me saadame teile pakkumise kasutatud raamatule.
  • Kogus:
  • Lisa ostukorvi
  • Tasuta tarne
  • Lisa soovinimekirja
Sybase Database Administrator's Handbook
  • Formaat: Hardback, 520 pages, kõrgus x laius x paksus: 242x180x28 mm, kaal: 1056 g
  • Ilmumisaeg: 06-Dec-1995
  • Kirjastus: Prentice Hall
  • ISBN-10: 0133574776
  • ISBN-13: 9780133574777
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9780133574777.html
Märksõnad:
A guide to the decisions and procedures faced in moving from a single Sybase SQL server to a multi-server environment, for users familiar with the Sybase SQL Server 4.9x or System 10 on a UNIX operating system. Information is also included for users who are upgrading to System 11. It shows how to assess the organization's needs to design a multi-server system; offers practical advice for managing the transition and its impact on both computers and personnel; and provides post-transition advice on day-to-day operations, including installation, scripts, performance tuning, and utilities, as well as disaster recovery. Annotation copyright Book News, Inc. Portland, Or.

This is the first book that shows Sybase database administrators exactly how to manage complex multi- SQL Server environments. Helps you plan and document your server environment. Shows how to plan databa sesegments, lay out disks, controllers and disk partitions for optimal performance and reliability. Presents detailed procedures for day-to-day system maintenance, monitoring, and optimization. Presents upgrade strategies. Shows proven methods for database recovery, and how to troubleshoot communications problems among Sybase SQL servers. For Sybase database administrators, IS management, organizations that must train database administrators, IS management, other technical staff supporting or working with Sybase SQL, and for students of computer science and databases.

1. Standard Server and Server. Machine Environment. You Are Not Alone Anymore. The Multiserver Environment. Why You Should Have a Standard Configuration. Standard for Overall Environment. Standard Configuration for All Server and DBA Machines. Standard Configuration for Servers.
2. Replication Server. Overview. What Replication Server Does. What Replication Server Doesnt Do. Example of the Process of Replicating Data. Configuration Issues. Installing Replication Server. Creating a Subscription. Users and Passwords. How Replication Server Links with SQL Servers. Affects on Existing and New Applications. Capacity Planning. Administration Using Replication Server Manager. Failure Modes. Function Strings.
3. Installation of SQL Server from Scratch. Preparing for Installation. Sybconfig for SQL Server. Sybinit for SQL Server System. Post sybconfig (sybinit for System 10). Sybconfig (sybinit for System 10) Errors.
4. Physical Server Design. Physical Disks. Raw Partitions vs. File Systems. SQL Server Logical Disk Devices. Disk Partitioning. Disk Controllers. Initializing Server Devices. Final Notes on disk init. Database Segments. Mirroring Server Devices. How to Layout the Devices and Segments of a Server. Summary.
5. Documenting a Server. The Servermap and Why You Need. Generating Servermap for Existing SQL Server. Generating Servermap for New SQL Server. Server Configuration. Database Usage and Relative Importance. Server Health. Server Machine Configuration. The Database System.
6. Physical Database Implementation. Transaction Log on Separate Server Device. Transaction Log Not on Separate Device. Sizing the Transaction Log. Placing a Database on Disks and Controllers. Placing Databases on Disks and Controllers. Mirroring Priorities. Why You Should Be Hesitant to Add Database Space.
7. The master Database Is Special. The master Database and Master Device. Sizing the Master Device. The logsegment of the master Database. Master Device Name and Mirroring. Master Device and disk init. Master Device and Default Server Disk Devices. Loading a Database Dump of the master Database. Moving Master Device to the Larger Partition. Clearing Server Configuration in master Database.
8. SQL Server Recovery. Recovery Planning Revolves Around the Cost of Downtime. The Database is Nothing without the Transaction Log. Recovery Is Transaction Based. Standby Server Strategies. Master Database Is Not for Users. The Use of dbcc. Mirroring. Archiving. More Server Devices Are Better. Recovery Notes. Database Dumps. Transaction Log Dumps. Logical Dumps and DataTools SQL BackTrack. Recovery Matrix.
9. Performance and Tuning. Theory Is Nice. What You Can Do in the Real World. Indexes and Queries. Spreading Segments Over Server Devices. Spreading Individual Tables. Archiving. Decision Support Server. Standard Set of Application Transactions. SQL Monitor. SQL Server Performance Tools. Application-Transparent Server Tuning. Preventing Downtime. Servermap and Performance and Tuning.
10. Capacity Planning. The Overall Database System. The Individual Server. Real-World Example. Capacity Planning for the Database System.
11. Operational Details of SQL Server. Interfaces File. Communication Among Servers. Creating Stored Procedure from SQL Script or defncopy Output. What sysusages Means. Reading the Errorlog. Impacts of Creating a New Database. Modifying System Tables Manually. bcp Command. Full Transaction Log or Other Segment (1105 Error).
12. Database Administration Versus Database System Size. Small Database Systems. Large Database Systems. Very Large Database Systems. Summary.
13. Upgrading SQL Server. Installation Guide, Release Notes, and EBF Cover Letter. Sybase Technical Support. Risks of the Upgrade Process. EBF Upgrades. Version Upgrades. Preparing to Upgrade 4.9.x to System. Upgrading 4.9.x to System
10. Post Upgrade 4.9.x to System
10. Actual Upgrade Output 4.9.x to System
10. Regressing from Failed System 10 Upgrade. Dependencies.
14. Transitioning to System
10. System 10 Changes to SQL Server. Transition to System 10 Wont Happen All at Once. SQL Server Upgrade Dependencies. Changes that Affect Existing Applications. Changes that Affect DBA. Compatibility with Other Sybase Products. Server Login Passwords. Server Login `sa versus Server Logins with sa_role. Backup Server.
15. Scripts. Dump Database Transaction Log (dumplog). Dump Databases for SQL Server 4.9.x (dumpdb). Load Databases for SQL Server 4.9.x (loaddb). Update statistics on All Tables (update_statistics_all_tables). Dump Commands to Recreate Databases (dump_db_create). Run dbcc Checks (checkdb). Dump Data from System Tables (dump_systables). Create Stored Procedure to Generate Database Creation Script (p_dbcreate). Create Stored Procedure to Check Mirrors (p_mirror). Create Stored Procedure to Output Device Space (p_devspace). Create Stored Procedure to Output All Segments on Devices (p_servermap). Dump Databases for SQL Server System 10 (dumpdb_sys10_tape_disk). Load Databases for SQL Server System 10 (loaddb_sys10). Server Startup Script RUN_
16. Recommended Reading. SQL Server Books. SQL Books. Database Design/Tuning Books. UNIX Books. System Administration Books. Data Modeling Books. Magazines. General. Index.