Mensys Online Shop

Inside Microsoft SQL Server 2005: Query Tuning and

Categorie:Algemeen - Boeken Van:Microsoft Press
Meer informatie:www.microsoft.com/le...Auteur(s):Kalen Delaney
Bladzijden:406Publicatie-jaar:2008

Discover how to:- Create a baseline and monitor workload by using System Monitor and DMVs;- Design, manipulate, and manage traces to isolate performance issues;- Audit user activity by using built-in default, black box, and Common Criteria traces;- Analyze query execution using scans and seeks, joins, aggregations, unions, and parallelism;- Generate efficient and cost-effective queries using cached plans or new plans;- Detect and resolve locking, blocking, and deadlocking concurrency  » Lees meer...

Inside Microsoft SQL Server 2005: Query Tuning and

Selecteer een of meer artikelen en klik dan op Bestellen. Aantallen kunnen op de volgende blz. gewijzigd worden.
Partnr.OmschrijvingEuro *Euro incl. BTW 
A63585 Inside Microsoft SQL Server 2005: Query Tuning and Optimization33.8735.90

Alle prijzen zijn in Euro excl. BTW (19%, voor boeken 6%) en excl. verzendkosten.
E-mail of bel 023 548 20 20 voor licenties, upgrades en andere vragen.

Discover how to:- Create a baseline and monitor workload by using System Monitor and DMVs;- Design, manipulate, and manage traces to isolate performance issues;- Audit user activity by using built-in default, black box, and Common Criteria traces;- Analyze query execution using scans and seeks, joins, aggregations, unions, and parallelism;- Generate efficient and cost-effective queries using cached plans or new plans;- Detect and resolve locking, blocking, and deadlocking concurrency issues;- Use best practices to diagnose and troubleshoot response time, throughput, and scalability issues.PLUS: Includes Transact-SQL code samples and on the Web.