Welcome!

Machine Learning Authors: Zakia Bouachraoui, Yeshim Deniz, Elizabeth White, Pat Romanski, Liz McMillan

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
Andrew Keys is Co-Founder of ConsenSys Enterprise. He comes to ConsenSys Enterprise with capital markets, technology and entrepreneurial experience. Previously, he worked for UBS investment bank in equities analysis. Later, he was responsible for the creation and distribution of life settlement products to hedge funds and investment banks. After, he co-founded a revenue cycle management company where he learned about Bitcoin and eventually Ethereal. Andrew's role at ConsenSys Enterprise is a multi-faceted approach of strategy and enterprise business development. Andrew graduated from Loyola University in Maryland and University of Auckland with degrees in economics and international finance.
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.
In today's always-on world, customer expectations have changed. Competitive differentiation is delivered through rapid software innovations, the ability to respond to issues quickly and by releasing high-quality code with minimal interruptions. DevOps isn't some far off goal; it's methodologies and practices are a response to this demand. The demand to go faster. The demand for more uptime. The demand to innovate. In this keynote, we will cover the Nutanix Developer Stack. Built from the foundation of software-defined infrastructure, Nutanix has rapidly expanded into full application lifecycle management across any infrastructure or cloud .Join us as we delve into how the Nutanix Developer Stack makes it easy to build hybrid cloud applications by weaving DBaaS, micro segmentation, event driven lifecycle operations, and both financial and cloud governance together into a single unified st...
SAP is the world leader in enterprise applications in terms of software and software-related service revenue. Based on market capitalization, we are the world's third largest independent software manufacturer. Harness the power of your data and accelerate trusted outcome-driven innovation by developing intelligent and live solutions for real-time decisions and actions on a single data copy. Support next-generation transactional and analytical processing with a broad set of advanced analytics - run securely across hybrid and multicloud environments.
Cloud-enabled transformation has evolved from cost saving measure to business innovation strategy -- one that combines the cloud with cognitive capabilities to drive market disruption. Learn how you can achieve the insight and agility you need to gain a competitive advantage. Industry-acclaimed CTO and cloud expert, Shankar Kalyana presents. Only the most exceptional IBMers are appointed with the rare distinction of IBM Fellow, the highest technical honor in the company. Shankar has also received the prestigious Outstanding Technical Achievement Award three times - an accomplishment befitting only the most innovative thinkers. Shankar Kalyana is among the most respected strategists in the global technology industry. As CTO, with over 32 years of IT experience, Mr. Kalyana has architected, designed, developed, and implemented custom and packaged software solutions across a vast spectrum o...