skip to content
Troubleshooting SQL server : a guide for the accidental DBA Preview this item
ClosePreview this item
Checking...

Troubleshooting SQL server : a guide for the accidental DBA

Author: Jonathan Kehayias; Ted Krueger; Gail Shaw
Publisher: [Cambridge, U.K.] : Red Gate Books, ©2011.
Series: High performance SQL server.
Edition/Format:   eBook : Document : EnglishView all editions and formats
Summary:
This book describes, diagnoses, and solves the most common problems with SQL Server 2005, 2008, and 2008 R2. The authors explain a basic approach to troubleshooting and the essential tools. They explore areas in which problems arise with regularity: high disk I/O (RAID misconfiguration, inadequate I/O throughput, poor workload distribution, SAN issues, disk partition misalignment); high CPU usage (insufficient  Read more...
Rating:

(not yet rated) 0 with reviews - Be the first.

Subjects
More like this

Find a copy online

Links to this item

Find a copy in the library

&AllPage.SpinnerRetrieving; Finding libraries that hold this item...

Details

Genre/Form: Electronic books
Material Type: Document, Internet resource
Document Type: Internet Resource, Computer File
All Authors / Contributors: Jonathan Kehayias; Ted Krueger; Gail Shaw
ISBN: 1906434786 9781906434786
OCLC Number: 797965956
Description: 1 online resource (346 pages) : illustrations.
Series Title: High performance SQL server.
Responsibility: Jonathan Kehayias and Ted Krueger ; technical review by Gail Shaw.

Abstract:

This book describes, diagnoses, and solves the most common problems with SQL Server 2005, 2008, and 2008 R2. The authors explain a basic approach to troubleshooting and the essential tools. They explore areas in which problems arise with regularity: high disk I/O (RAID misconfiguration, inadequate I/O throughput, poor workload distribution, SAN issues, disk partition misalignment); high CPU usage (insufficient memory, poorly written queries, inadequate indexing, inappropriate configuration option settings); memory mismanagement; missing indexes; blocking (caused mainly by poorly designed databases that lack proper keys and indexing, and applications that apply needlessly restrictive transaction isolation levels); deadlocking (Bookmark Lookup, Serializable Range Scan, Cascading Constraint); full transaction logs (lack of log backups, hefty index maintenance operations, long running transaction, problems with replication and mirroring environments); and accidentally-lost data. Finally, the authors discuss diagnosing tools such as the Performance Monitor, Dynamic Management Views, and server-side tracing. --

Reviews

User-contributed reviews
Retrieving GoodReads reviews...
Retrieving DOGObooks reviews...

Tags

Be the first.

Similar Items

Confirm this request

You may have already requested this item. Please select Ok if you would like to proceed with this request anyway.

Linked Data


Primary Entity

<http://www.worldcat.org/oclc/797965956> # Troubleshooting SQL server : a guide for the accidental DBA
    a schema:MediaObject, schema:CreativeWork, schema:Book ;
    library:oclcnum "797965956" ;
    library:placeOfPublication <http://id.loc.gov/vocabulary/countries/enk> ;
    library:placeOfPublication <http://experiment.worldcat.org/entity/work/data/1122827851#Place/cambridge_u_k> ; # Cambridge, U.K.
    schema:about <http://id.worldcat.org/fast/864205> ; # Client/server computing
    schema:about <http://dewey.info/class/004.36/e23/> ;
    schema:about <http://id.worldcat.org/fast/888037> ; # Database management
    schema:about <http://experiment.worldcat.org/entity/work/data/1122827851#CreativeWork/sql_server> ; # SQL server.
    schema:about <http://id.worldcat.org/fast/1376937> ; # SQL server.
    schema:bookFormat schema:EBook ;
    schema:contributor <http://viaf.org/viaf/270106930> ; # Ted Krueger
    schema:contributor <http://viaf.org/viaf/94151302877548661306> ; # Gail Shaw
    schema:copyrightYear "2011" ;
    schema:creator <http://viaf.org/viaf/305942207> ; # Jonathan Kehayias
    schema:datePublished "2011" ;
    schema:description "This book describes, diagnoses, and solves the most common problems with SQL Server 2005, 2008, and 2008 R2. The authors explain a basic approach to troubleshooting and the essential tools. They explore areas in which problems arise with regularity: high disk I/O (RAID misconfiguration, inadequate I/O throughput, poor workload distribution, SAN issues, disk partition misalignment); high CPU usage (insufficient memory, poorly written queries, inadequate indexing, inappropriate configuration option settings); memory mismanagement; missing indexes; blocking (caused mainly by poorly designed databases that lack proper keys and indexing, and applications that apply needlessly restrictive transaction isolation levels); deadlocking (Bookmark Lookup, Serializable Range Scan, Cascading Constraint); full transaction logs (lack of log backups, hefty index maintenance operations, long running transaction, problems with replication and mirroring environments); and accidentally-lost data. Finally, the authors discuss diagnosing tools such as the Performance Monitor, Dynamic Management Views, and server-side tracing. --"@en ;
    schema:exampleOfWork <http://worldcat.org/entity/work/id/1122827851> ;
    schema:genre "Electronic books"@en ;
    schema:inLanguage "en" ;
    schema:isPartOf <http://experiment.worldcat.org/entity/work/data/1122827851#Series/high_performance_sql_server> ; # High performance SQL server.
    schema:name "Troubleshooting SQL server : a guide for the accidental DBA"@en ;
    schema:productID "797965956" ;
    schema:publication <http://www.worldcat.org/title/-/oclc/797965956#PublicationEvent/cambridge_u_k_red_gate_books_2011> ;
    schema:publisher <http://experiment.worldcat.org/entity/work/data/1122827851#Agent/red_gate_books> ; # Red Gate Books
    schema:url <http://proquest.safaribooksonline.com/9781906434786> ;
    schema:url <http://proquest.tech.safaribooksonline.de/9781906434786> ;
    schema:url <http://www.books24x7.com/marc.asp?bookid=69807> ;
    schema:url <http://proxy.library.carleton.ca/login?url=http://proquest.safaribooksonline.com/?uiCode=carleton&xmlId=9781906434786> ;
    schema:workExample <http://worldcat.org/isbn/9781906434786> ;
    wdrs:describedby <http://www.worldcat.org/title/-/oclc/797965956> ;
    .


Related Entities

<http://experiment.worldcat.org/entity/work/data/1122827851#Agent/red_gate_books> # Red Gate Books
    a bgn:Agent ;
    schema:name "Red Gate Books" ;
    .

<http://experiment.worldcat.org/entity/work/data/1122827851#Place/cambridge_u_k> # Cambridge, U.K.
    a schema:Place ;
    schema:name "Cambridge, U.K." ;
    .

<http://experiment.worldcat.org/entity/work/data/1122827851#Series/high_performance_sql_server> # High performance SQL server.
    a bgn:PublicationSeries ;
    schema:hasPart <http://www.worldcat.org/oclc/797965956> ; # Troubleshooting SQL server : a guide for the accidental DBA
    schema:name "High performance SQL server." ;
    schema:name "High performance SQL server" ;
    .

<http://id.worldcat.org/fast/1376937> # SQL server.
    a schema:CreativeWork ;
    schema:name "SQL server." ;
    .

<http://id.worldcat.org/fast/864205> # Client/server computing
    a schema:Intangible ;
    schema:name "Client/server computing"@en ;
    .

<http://id.worldcat.org/fast/888037> # Database management
    a schema:Intangible ;
    schema:name "Database management"@en ;
    .

<http://viaf.org/viaf/270106930> # Ted Krueger
    a schema:Person ;
    schema:familyName "Krueger" ;
    schema:givenName "Ted" ;
    schema:name "Ted Krueger" ;
    .

<http://viaf.org/viaf/305942207> # Jonathan Kehayias
    a schema:Person ;
    schema:familyName "Kehayias" ;
    schema:givenName "Jonathan" ;
    schema:name "Jonathan Kehayias" ;
    .

<http://viaf.org/viaf/94151302877548661306> # Gail Shaw
    a schema:Person ;
    schema:familyName "Shaw" ;
    schema:givenName "Gail" ;
    schema:name "Gail Shaw" ;
    .

<http://worldcat.org/isbn/9781906434786>
    a schema:ProductModel ;
    schema:isbn "1906434786" ;
    schema:isbn "9781906434786" ;
    .


Content-negotiable representations

Close Window

Please sign in to WorldCat 

Don't have an account? You can easily create a free account.