Home | Amazing | Today | Tags | Publishers | Years | Account | Search 
Troubleshooting SQL Server - A Guide for the Accidental DBA

Buy
I've spent much of the last six years of my working life trying to help people solve SQL Server-related performance problems, either hands-on, at client sites in my capacity as a consultant, or on various online community forums, answering people's questions.

Over that time I've been exposed to a few weird and wonderful SQL Server issues but, mainly, have seen the same problems, and the same confusions, crop up time and again. It was only a matter of time before I leapt to the foolhardy conclusion that I ought to write a book to explain what the most common problems were, why they occurred, and to offer sensible, practical solutions, aimed squarely at removing the root cause of the issue, rather than simply "papering over the cracks."

It turned out to be a much more daunting task than I imagined, for a number of reasons. Firstly, this is, by its very nature, a fairly broad-ranging book, covering topics stretching from CPU issues, to memory management, to missing indexes, and full transaction logs. Secondly, it is amazing how complex some of the simplest topics become when you try to put them down in text. Thirdly, technology changes rapidly, and the troubleshooter, and the advice he or she offers, must adapt accordingly. There were several cases in the writing of this book, where either a technology change meant I had to go back and adapt my original advice, or where my own opinion of the content and troubleshooting methodologies had evolved to the point where certain sections had to be completely rewritten.

Despite the occasionally bumpy road, what I hope I've achieved is a book that covers clearly and concisely the most common problems associated with the currently supported versions of SQL Server, namely SQL Server 2005, 2008, and 2008 R2. The first chapter explains my basic approach to performance troubleshooting, and the tools I use. It stresses, in particular, how rare it is that a problem can be diagnosed by looking at just a single data point.
(HTML tags aren't allowed.)

Let's Eat: Sustainable Food for a Hungry Planet (Orca Footprints)
Let's Eat: Sustainable Food for a Hungry Planet (Orca Footprints)

All the food you eat, whether it's an apple or a steak or a chocolate-coated cricket, has a story. Let's Eat uncovers the secret lives of our groceries, exploring alternative—and sometimes bizarre—farm technology and touring gardens up high on corporate rooftops and down low in military-style bunkers beneath city...

Professional Scrum Development with Microsoft Visual Studio 2012
Professional Scrum Development with Microsoft Visual Studio 2012
By 2001, the software industry was in trouble—more projects were failing than succeeding.

Customers began demanding contracts with penalties, and increasingly sending work offshore. Some software developers, though, had increasing success with a development process known as
...
Asterisk Hacking
Asterisk Hacking
Asterisk hacking shows readers about a hacking technique they may not be aware of. It teaches the secrets the bad guys already know about stealing personal information through the most common, seemingly innocuous, highway into computer networks: the phone system. The book also comes with an Asterisk Live CD (SLAST) containing all...

Introducing Autodesk 3ds Max 2011 (Autodesk Official Training Guide: Essential)
Introducing Autodesk 3ds Max 2011 (Autodesk Official Training Guide: Essential)

An Autodesk Official Training Guide to 3ds Max 2011

3ds Max is a popular 3D animation-and-effects software used in movies, visual effects, games, cartoons, short films, commercials, and other animation. However, it also presents a number of challenges to newcomers. This introduction to the latest version breaks down the...

CompTIA Linux+ Certification Study Guide (2009 Exam): Exam XK0-003
CompTIA Linux+ Certification Study Guide (2009 Exam): Exam XK0-003

CompTIA's Linux+ certification is a globally-recognized, vendor neutral exam. The Linux+ exam (XK1-003) is a substantive revision with updates on applications, networking, and security. Our new study guide is aligned to cover all of the material of the updated 2009 exam with special attention to the new topics including troubleshooting...

Sukhoi Su-27: Famous Russian Aircraft
Sukhoi Su-27: Famous Russian Aircraft
In the late 1960s, the Soviet Union became aware that the U.S. was developing a new generation of jet fighters that had an exceptional range, heavy armor, and great agility in the air. These U.S. aircraft, the F-14 Tomcat, F-15 Eagle, F-16 Fighting Hornet, and F/A-18 Hornet dominated U.S. air power for three decades. In the context of the Cold War,...
©2021 LearnIT (support@pdfchm.net) - Privacy Policy