احصل على 5% رصيد مسترجع باستخدام بطاقة بنك المشرق نون الائتمانية. اشترك الآن. قدّم الحين
شريك لنون منذ
4+ سنينالناشر | Microsoft Press,U.S. |
رقم الكتاب المعياري الدولي 13 | 9780735621961 |
رقم الكتاب المعياري الدولي 10 | 0735621969 |
اللغة | الإنجليزية |
وصف الكتاب | 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> |
عدد الصفحات | 448 |
Query Tuning And Optimization: Inside Microsoft (r) Sql Server 2005 Paperback English by Kalen Delaney