Research and Markets: New Book on Professional SQL Server 2005 Performance Tuning Approaches the Subject from a Different Perspective

M2 PRESSWIRE-March 6, 2008-Research and Markets: New Book on Professional SQL Server 2005 Performance Tuning Approaches the Subject from a Different Perspective (C)1994-2008 M2 COMMUNICATIONS LTD We begin by covering aspects of general end-to-end application tuning (not specific to SQL Server), but...

Full description

Saved in:
Bibliographic Details
Published inM2 Presswire
Format Newsletter
LanguageEnglish
Published Coventry Normans Media Ltd 05.03.2008
Subjects
Servers
Online AccessGet full text

Cover

More Information
Summary:M2 PRESSWIRE-March 6, 2008-Research and Markets: New Book on Professional SQL Server 2005 Performance Tuning Approaches the Subject from a Different Perspective (C)1994-2008 M2 COMMUNICATIONS LTD 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. ((M2 Communications Ltd disclaims all liability for information provided within M2 PressWIRE. Data supplied by named party/parties. Further information on M2 PressWIRE can be obtained at http://www.presswire.net on the world wide web. Inquiries to info@m2.com)).