Specifications
| Publisher | Microsoft Press,U.S. |
| ISBN 13 | 9780735621961 |
| ISBN 10 | 0735621969 |
| Book Description | Dig into the internals of tuning and optimization features in sql server 2005-with insights from leading sql server experts. This in-depth guide delivers best practices, pragmatic advice, and code samples to help you enable efficient, effective queries-and optimize database performance.<Br /> <br />discover how to:<br /> <br />create a baseline and monitor workload by using system monitor and dmvs design, manipulate, and manage traces to isolate database 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<br /> <br />plus-includes transact-sql code samples and on the web</p> |
| Language | English |
| Author | Kalen Delaney |
| Number of Pages | 448 |
Query Tuning And Optimization: Inside Microsoft (r) Sql Server 2005 Paperback English by Kalen Delaney
Added to cart
Cart Total SAR 0.00
