Welcome!

SDN Journal Authors: Elizabeth White, Yeshim Deniz, Liz McMillan, Pat Romanski, TJ Randall

News Feed Item

New Book on Professional SQL Server 2005 Performance Tuning Approaches the Subject From a Different Perspective

New Book on Professional SQL Server 2005 Performance Tuning Approaches the Subject From a Different Perspective

Research and Markets (http://www.researchandmarkets.com/reports/c85071) has announced the addition of Professional SQL Server 2005 Performance Tuning to their offering.

This book approaches Performance tuning from a new perspective. It shows readers how to find performance problems, rather than assuming they already know what the problem is. As such there is more emphasis on diagnostics than in any competitive books. This book also takes a new approach in that we will discuss the limitations imposed on performance tuning by the different stages of a project's life cycle, and help the reader understand how this alters the performance tuning process.

We begin by covering aspects of general end-to-end application tuning (not specific to SQL Server), but then very quickly move to SQL Server specifics, starting with the high level stuff like the basic server resource counters for CPU, memory, and IO, then trying to find the slow queries by looking at SQL Wait types, and using Profiler to find long running, or blocked, or otherwise poorly performing queries. We then move on to demonstrate how to "fix" the performance of those poorly performing queries.

We also cover the different approaches the DBA might take depending on where the target system is in its lifecycle. This includes the things you can do with an application at the early stages of design (e.g., change pretty much anything from the schema on up, including specifying different hardware). We then cover the very different approach when working with a system running in production (mostly index tuning, some server config, limited T-SQL tuning, no schema changes).

Covered in this Report:

Part I: Finding Bottlenecks when Something’s Wrong.

Chapter 1: Performance Tuning.

Chapter 2: Monitoring Server Resources with System Monitor.

Chapter 3: Monitoring SQL Server Resources with System Monitor.

Chapter 4: SQL ServerWait Types.

Chapter 5: Finding Problem Queries with SQL Profiler.

Part II: Removing Bottlenecks with Tuning.

Chapter 6: Choosing and Configuring Hardware.

Chapter 7: Tuning SQL Server Configuration.

Chapter 8: Tuning the Schema.

Chapter 9: Tuning T-SQL.

Part III: Preventative Measures and Baselining Performance with Tools.

Chapter 10: Capturing, Measuring, and Replaying a Workload Using SQL Profiler.

Chapter 11: Tuning Indexes.

Chapter 12: How Fast and Robust Is Your Storage?

Chapter 13: SQL Server 2005 Performance Dashboard Reports.

Part IV: Roadmap to Server Performance.

Chapter 14: Best Practices for Designing for Performance from the Start.

Chapter 15: Successful Deployment Strategies.

For more information visit http://www.researchandmarkets.com/reports/c85071.

More Stories By Business Wire

Copyright © 2009 Business Wire. All rights reserved. Republication or redistribution of Business Wire content is expressly prohibited without the prior written consent of Business Wire. Business Wire shall not be liable for any errors or delays in the content, or for any actions taken in reliance thereon.

CloudEXPO Stories
Digital Transformation and Disruption, Amazon Style - What You Can Learn. Chris Kocher is a co-founder of Grey Heron, a management and strategic marketing consulting firm. He has 25+ years in both strategic and hands-on operating experience helping executives and investors build revenues and shareholder value. He has consulted with over 130 companies on innovating with new business models, product strategies and monetization. Chris has held management positions at HP and Symantec in addition to advisory roles at startups. He has worked extensively on monetization, SAAS, IoT, ecosystems, partnerships and accelerating growth in new business initiatives.
Whenever a new technology hits the high points of hype, everyone starts talking about it like it will solve all their business problems. Blockchain is one of those technologies. According to Gartner's latest report on the hype cycle of emerging technologies, blockchain has just passed the peak of their hype cycle curve. If you read the news articles about it, one would think it has taken over the technology world. No disruptive technology is without its challenges and potential impediments that frequently get lost in the hype. The panel will discuss their perspective on what they see as they key challenges and/or impediments to adoption, and how they see those issues could be resolved or mitigated.
Lori MacVittie is a subject matter expert on emerging technology responsible for outbound evangelism across F5's entire product suite. MacVittie has extensive development and technical architecture experience in both high-tech and enterprise organizations, in addition to network and systems administration expertise. Prior to joining F5, MacVittie was an award-winning technology editor at Network Computing Magazine where she evaluated and tested application-focused technologies including app security and encryption-related solutions. She holds a B.S. in Information and Computing Science from the University of Wisconsin at Green Bay, and an M.S. in Computer Science from Nova Southeastern University, and is an O'Reilly author.
Dynatrace is an application performance management software company with products for the information technology departments and digital business owners of medium and large businesses. Building the Future of Monitoring with Artificial Intelligence. Today we can collect lots and lots of performance data. We build beautiful dashboards and even have fancy query languages to access and transform the data. Still performance data is a secret language only a couple of people understand. The more business becomes digital the more stakeholders are interested in this data including how it relates to business. Some of these people have never used a monitoring tool before. They have a question on their mind like "How is my application doing" but no idea how to get a proper answer.
Having been in the web hosting industry since 2002, dhosting has gained a great deal of experience while working on a wide range of projects. This experience has enabled the company to develop our amazing new product, which they are now excited to present! Among dHosting's greatest achievements, they can include the development of their own hosting panel, the building of their fully redundant server system, and the creation of dhHosting's unique product, Dynamic Edge.