begin process at 2012 02 17 07:13:36
  Trouver un code source :
 
dans
 


Professional SQL Server 2005 Performance Tuning


Professional SQL Server 2005 Performance Tuning

Prix public : 45,74 €

Commander
Prix exceptionnel Eyrolles :
43,45€


Auteur(s) :
D. hinson
H. ji
S. wort
C. bolton
J. langford
J. jin
P. mestemaker
A. sen

Editeur : Wrox Press
Date de parution : 01/01/2008
ISBN : 0-470-17639-3
EAN : 9780470176399

Synopsis

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 projects 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).


Commander ce livre au prix de 45,74 € 43,45 €

Classé sous : Performance, Server, Sql, Tuning, Different



Commentaires des membres à propos du livre :
Professional SQL Server 2005 Performance Tuning

Aucun commentaire pour le moment.

Donnez votre avis sur ce livre

  Vous avez lu ce livre ? votre avis nous interresse :



Nos sponsors


Sondage...

Comparez les prix

CalendriCode

Février 2012
LMMJVSD
  12345
6789101112
13141516171819
20212223242526
272829    

Consulter la suite du CalendriCode

Photothèque

 
Développement réalisé par Nicolas SOREL (Nix) avec l'aide de : Cyril DURAND et Emmanuel (EBArtSoft), Merci à Vincent pour ses précieux conseils.
CodeS-SourceS.com© Toute reproduction même partielle est interdite sauf accord écrit du Webmaster
CodeS-SourceS.com© est une marque déposée tous droits réservés

Google Coop CodeS-SourceS Google Coop CodeS-SourceS
Temps d'éxécution de la page : 0,718 sec (3)

Nous contacter | Annoncer sur CodeS-SourceS | Mentions légales