Professional SQL Server 2008 Internals and Troubleshooting
-
Author:
-
Subject:
-
Published by:John Wiley & Sons Inc (US)
-
Published:18/12/2009
-
Price:$89.99
- < Buy this book >
A hands-on resource for SQL Server 2008 troubleshooting methods and tools
SQL Server administrators need to ensure that SQL Server remains running 24/7. Authored by leading SQL Server experts and MVPs, this book provides in-depth coverage of best practices based on a deep understanding of the internals of both SQL Server and the Windows operating system.
You'll get a thorough look at the SQL Server database architecture and internals as well as Windows OS internals so that you can approach troubleshooting with a solid grasp of the total processing environment. Armed with this comprehensive understanding, readers will then learn how to use a suite of tools for troubleshooting performance problems whether they originate on the database server or operating system side.
- Shows how to develop a methodology for troubleshooting based on a thorough understanding of SQL Server 2008 and Windows OS internals
- Covers mastering specific troubleshooting tools and interpreting their output so that you can quickly identify and resolve any performance issue
- Details all the free and proprietary tools that allow you to analyze and determine the source of a system-wide performance problem
- Examines how it is critical for both SQL Server and Windows technologies to run smoothly in order to ensure effective SQL Server performance
This practical guide will help you pro-actively monitor and avoid SQL Server problems.
Biography
Christian Bolton is coauthor of Professional SQL Server 2005 Performance Tuning and Technical Director for Coeo Ltd.
Justin Langford is coauthor of Professional SQL Server 2005 Performance Tuning and leads the Managed Support team for Coeo Ltd.
Brent Ozar is a SQL Server expert for Quest Software.
James Rowland-Jones is an advisory consultant for EMC Consulting.
Steven Wort is a developer in the Windows Division at Microsoft.
- CCDB2 / DBA Technical Consultant - Finance company - Melbourne CBD - DB2VIC
- FTSenior .Net Developer - Mobility/Portal SolutionsNSW
- FTMobile Portal Architect - .Net TechnologiesNSW
- FTAccount Manager - Strategic Enterprise DevelopmentNSW
- CCDigital Business Analyst - Agile/ScrumNSW
- FTDigital Account ManagerNSW
- FTDigital Account ManagerNSW
- FTSupport Consultant - Global Vendor - $55-75,000NSW
- FTTechnical Operations ManagerNSW
iAsset is a channel management ecosystem that automates all major aspects of the entire sales,marketing and service process, including data tracking, integrated learning, knowledge management and product lifecycle management.
What is Wireless 2.0
The challenges and the Practical Approach to a ‘Wi-Fi that works’ Creating “Wi-Fi that works”, even with minimal requirements, is a tall order given the breadth of client and application types that must perform well over the wireless infrastructure, but when adding in the speed and complexity of 802.11n, a variety of demanding applications, high-density environments, and tricky deployment scenarios, controller-based vendors cannot live up to their promises of Ethernet-like determinism. This whitepaper defines what a Wireless 2.0 network is, and the importance of a controller-less architecture for performance, reliability, scalability, security, and flexibility. Download this now
HiveManager Online: Less Dollars, More Sense
Today’s de facto standard controller-based Wi-Fi infrastructure model is just too complicated, too expensive, and too unreliable. It’s common for enterprise and mid-market network operators alike to get caught in a crossroads of compromises involving costs, complexity, features, and reliability.









