lind-peinture » Computers » High Performance SQL Server DBA: Tuning Optimization Secrets (IT In-Focus)

eBook High Performance SQL Server DBA: Tuning Optimization Secrets (IT In-Focus) ePub

by Donald Burleson,Robin Schumacher

Donald Burleson Robin Schumacher Programming English

eBook High Performance SQL Server DBA: Tuning Optimization Secrets (IT In-Focus) ePub

Author: Donald Burleson,Robin Schumacher
Language: English
ISBN: 0976157365
ISBN13: 978-0976157366
Publisher: Rampant Techpress (December 1, 2005)
Pages: 240
Category: Programming
Subcategory: Computers
Rating: 4.5
Votes: 331
Formats: doc mobi docx lit
ePub file: 1650 kb
Fb2 file: 1748 kb

Download ePub Download Fb2

If you're a SQL Server DBA who wants to get proactive and organized with performance monitoring and tuning. Extremely disappointed in this book. Based on the listed publish date (May, 2014), I assumed that it was up to date with current SQL Server technology

If you're a SQL Server DBA who wants to get proactive and organized with performance monitoring and tuning. Based on the listed publish date (May, 2014), I assumed that it was up to date with current SQL Server technology. This is simply not the case. The book reads as if the content and scripts were written prior to the release of SQL Server 2005, which involved a significant change in the platform. While some of the concepts still apply and the scripts may work in new versions, they are antiquated and do not reflect current best practices for collecting the information.

Donald K. Burleson, Robin Schumacher.

book by Robin Schumacher. A guide to troubleshooting and correcting SQL Server performance problems, this book provides a methodology for use in analyzing any SQL Server database. Donald K. SQL Server Tuning Scripts: Performance Optimization Secrets. Oracle Performance Troubleshooting: With Dictionary Internals SQL & Tuning Scripts (Oracle In-Focus series).

Explore Further: Topics Discussed in This Paper. Anemia, Diamond-Blackfan. Microsoft SQL Server.

Start by marking High Performance SQL Server DBA: Tuning . A guide to troubleshooting and correcting SQL Server performance problems, this book provides a methodology for use in analyzing any SQL Server database

Start by marking High Performance SQL Server DBA: Tuning & Optimization Secrets as Want to Read: Want to Read savin. ant to Read. The most recent advances in SQL Server8i and 9i are covered to make a SQL Server database run as fast as possible.

Items related to High Performance SQL Server DBA: Tuning .

Items related to High Performance SQL Server DBA: Tuning & Optimization. Robin Schumacher High Performance SQL Server DBA: Tuning & Optimization Secrets (IT In-Focus). Robin has more than 14 years of experience in database administration, development, monitoring, and tuning with Oracle, DB2, Teradata, Sybase, and Microsoft SQL Server.

Not a member of Pastebin yet?

by Donald K. ISBN 9780982306178 (978-823061-7-8) Softcover, Rampant Techpress, 2010.

Oracle Performance Troubleshooting: With Dictionary Internals SQL & Tuning Scripts (Oracle In-Focus series). ISBN 9780972751346 (978-727513-4-6) Softcover, Rampant Techpress, 2003. by Donald K.

If you're a SQL Server DBA who wants to get proactive and organized with performance monitoring and tuning, then this book is for you. Written by a widely read DBA and SQL Server internals expert, Robin Schumacher offers real-world advice, an easy to follow performance strategy, and lots of SQL diagnostics scripts in a superb book that shows how to quickly diagnose and optimize SQL Server performance problems.

Are you sure you want to remove High Performance SQL Server DBA from your list? There's no description for this book yet.

Oracle High-Performance SQL Tuning (Paperback). Burleson (author). This expert resource explains how to view the internal execution plan of any SQL statement and change it to improve the performance of the statement. You'll get details on Oracle's optimizer modes, SQL extensions, the STATSPACK utility, and a wealth of methods for tuning Oracle SQL statements Added to basket. Querying Microsoft ® SQL Server ® 2012.

A guide to troubleshooting and correcting SQL Server performance problems, this book provides a methodology for use in analyzing any SQL Server database. The most recent advances in SQL Server8i and 9i are covered to make a SQL Server database run as fast as possible. Properly using ratio-based and bottleneck analysis, designing a fast-running database from the ground up, and establishing methods for making storage and reorganization problems a thing of the past are demonstrated. Also presented are new techniques for monitoring and optimizing memory usage and improved methods for uncovering session-related bottlenecks.

Stick

If you're looking for a book about how important good design is (no real suggestions on implementing a good design, just a long talk on how important it is), or a book that covers the basics of performance problem diagnosis, this is the book for you.

If, however, you're actually looking for a book that delivers on what the title of this one promises, keep shopping.

Stylish Monkey

I'm about 50% of the way through this book. I found the first few sections unnecessary but still interesting reading.

There are many SQL scripts referenced by this book and they are only available online (no printed version or CD). Unfortunately, I've had to edit almost every one before I could use it. The problems are various e.g. (1) SQL Server's conformance to ANSI SQL and the way outer joins are written, to (2) they just plain don't work e.g. a temporary 2-column table is populated with the results of a stored procedure that returns 3 columns. This shows me that nobody has actually run the scripts on SQL Server 2005 and that is worrying. I know that once a book is published there is little that can be done until the next edition but the scripts are available online and can (should!) be updated. I also understand that the book was written using a beta version of SQL Server and so changes are to be expected. Again though, the online scripts should be updated. When I am reading a book that says, "Includes SQL Server 2005" on the front cover, I want to believe that the additional information is well thought out and not just bundled in with other text.

The section on page splits seems like it could be important but it's less than one page long and it doesn't tell you how to interpret your findings.

The jury is still out wrt how useful this book actually is but I should have a better impression once I have gone through all the remaining sections.

Wishamac

The author sums it up on page 58:

"The books that fly off the shelfs in the technical bookstores are the ones that promise hidden tips on accelerating the performance of database systems"

That's exactly what this book promises "Tuning & Optimization secrets" and exactly what it fails to provide!

The first 100 pages are "fluff". I was looking for tuning and optimization information not a lecture on why physical design is important. If things like "denormalization isn't always bad" and "indexes are often good" are old news to you, skip this book.

If you are looking for useful optimization and tuning information, look elsewhere.

Nikok

If the book description is so wrong, how good could the book be? SQL Server versions are not 8i and 9i, maybe 8 & 9 depending how you reference, but 2000 and 2005 are more common version descriptions. 8i and 9i are Oracle versions, not SQL Server. The cover has SQL2005, that is how I could tell it was MS SQL Server. Combine the sloppy book description with other comments, I'll pass.

Book Description

"The most recent advances in SQL Server8i and 9i are covered to make a SQL Server database run as fast as possible."

Gardataur

As the editor for this book, I became familiar with all of the parallel concepts between SQL server and Oracle. Schumacher is expert in both SQL Server and Oracle, and seeing "how SQL Server does it", was very valuable in understanding the concepts within both RDBMS engines.

The code depot of scripts are also helpful because that are plug-and-play and Robin explains how to interpret their output.

Vrion

I was 1/2 sold when I read in the introduction that the book wasn't to be a 700-page doorstop. After reading the whole book, now I'm totally sold. Clear, concise, and easy to apply. Acts like a reference manual on steroids for my day-to-day needs. Gave me some good best practices advice, too. Art work is a little strange, but the content is spot on.

Goltizuru

I've read Schumacher's Oracle book as well as his articles, and now he's taken that same style over to SQL Server. I've only had this book for a short time, but it's already paid for itself (more than once). His writing style is easy to follow and the code snippets are excellent.