Cargando…
Microsoft SQL Server 2012 Performance Tuning Cookbook : 80 Recipes to Help You Tune SQL Server 2012 and Achieve Optimal Performance /
Over 80 recipes to help you tune SQL Server 2012 and achieve optimal performance.
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Otros Autores: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Birmingham :
Packt Pub.,
2012.
|
| Colección: | Enterprise : professional expertise distilled.
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
MARC
| LEADER | 00000cam a2200000Ia 4500 | ||
|---|---|---|---|
| 001 | OR_ocn808340926 | ||
| 003 | OCoLC | ||
| 005 | 20231017213018.0 | ||
| 006 | m o d | ||
| 007 | cr cnu---unuuu | ||
| 008 | 120803s2012 enka o 000 0 eng d | ||
| 040 | |a E7B |b eng |e pn |c E7B |d N$T |d OCLCQ |d UMI |d COO |d DEBSZ |d YDXCP |d OCLCQ |d DKDLA |d EBLCP |d OCLCQ |d OCLCF |d OCLCQ |d NKT |d OCLCQ |d OCLCO |d AZK |d AGLDB |d MOR |d PIFAG |d ZCU |d MERUC |d OCLCQ |d JBG |d OCLCQ |d U3W |d COH |d STF |d WRM |d OCLCQ |d VTS |d CEF |d NRAMU |d ICG |d NLE |d INT |d AU@ |d OCLCQ |d OCLCO |d UKMGB |d OCLCQ |d OCLCO |d A6Q |d DKC |d OCLCQ |d UKAHL |d OCLCQ |d OCLCO |d UKCRE |d VLY |d AJS |d NLW |d LVT |d OCLCO |d OCLCQ | ||
| 015 | |a GBB747738 |2 bnb | ||
| 016 | 7 | |a 018015029 |2 Uk | |
| 019 | |a 822335921 |a 823244916 |a 961586654 |a 962600544 |a 974766187 |a 974856241 |a 981868878 |a 991584566 |a 1005639292 |a 1018084705 |a 1042323173 |a 1044320509 |a 1049134338 |a 1053515274 |a 1056423770 |a 1058504474 |a 1060874806 |a 1063713428 |a 1083557624 |a 1087032727 |a 1153483506 |a 1162219688 |a 1282978745 |a 1297234887 |a 1297616317 |a 1302266189 | ||
| 020 | |a 9781849685757 |q (electronic bk.) | ||
| 020 | |a 1849685754 |q (electronic bk.) | ||
| 020 | |a 9781849685757 |q (e-book) | ||
| 020 | |a 1849685746 | ||
| 020 | |a 9781849685740 | ||
| 020 | |z 9781849685740 | ||
| 020 | |a 1283519682 | ||
| 020 | |a 9781283519687 | ||
| 020 | |a 9786613832139 | ||
| 020 | |a 6613832138 | ||
| 029 | 1 | |a AU@ |b 000050347755 | |
| 029 | 1 | |a AU@ |b 000059711050 | |
| 029 | 1 | |a CHNEW |b 000619474 | |
| 029 | 1 | |a DEBBG |b BV040903454 | |
| 029 | 1 | |a DEBBG |b BV043104777 | |
| 029 | 1 | |a DEBBG |b BV044167737 | |
| 029 | 1 | |a DEBSZ |b 381395162 | |
| 029 | 1 | |a DEBSZ |b 397368747 | |
| 029 | 1 | |a DEBSZ |b 421372168 | |
| 029 | 1 | |a NZ1 |b 15196186 | |
| 029 | 1 | |a UKMGB |b 018015029 | |
| 029 | 1 | |a AU@ |b 000067103109 | |
| 029 | 1 | |a DKDLA |b 820120-katalog:999933768005765 | |
| 035 | |a (OCoLC)808340926 |z (OCoLC)822335921 |z (OCoLC)823244916 |z (OCoLC)961586654 |z (OCoLC)962600544 |z (OCoLC)974766187 |z (OCoLC)974856241 |z (OCoLC)981868878 |z (OCoLC)991584566 |z (OCoLC)1005639292 |z (OCoLC)1018084705 |z (OCoLC)1042323173 |z (OCoLC)1044320509 |z (OCoLC)1049134338 |z (OCoLC)1053515274 |z (OCoLC)1056423770 |z (OCoLC)1058504474 |z (OCoLC)1060874806 |z (OCoLC)1063713428 |z (OCoLC)1083557624 |z (OCoLC)1087032727 |z (OCoLC)1153483506 |z (OCoLC)1162219688 |z (OCoLC)1282978745 |z (OCoLC)1297234887 |z (OCoLC)1297616317 |z (OCoLC)1302266189 | ||
| 037 | |a CL0500000177 |b Safari Books Online | ||
| 050 | 4 | |a QA76.9.C55 |b S53 2012eb | |
| 072 | 7 | |a COM |x 066000 |2 bisacsh | |
| 082 | 0 | 4 | |a 005.3/76 |2 23 |
| 049 | |a UAMI | ||
| 100 | 1 | |a Shah, Ritesh. | |
| 245 | 1 | 0 | |a Microsoft SQL Server 2012 Performance Tuning Cookbook : |b 80 Recipes to Help You Tune SQL Server 2012 and Achieve Optimal Performance / |c Ritesh Shah, Bihag Thaker. |
| 260 | |a Birmingham : |b Packt Pub., |c 2012. | ||
| 300 | |a 1 online resource (iv, 460 pages) : |b color illustrations | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 347 | |a data file |2 rda | ||
| 490 | 1 | |a Enterprise : professional expertise distilled | |
| 505 | 0 | |a Microsoft SQL Server 2012 Performance Tuning Cookbook; Microsoft SQL Server 2012 Performance Tuning Cookbook; Credits; About the Authors; Acknowledgement; Acknowledgement; About the Reviewers; www.PacktPub.com; Support files, eBooks, discount offers and more; Why Subscribe?; Free Access for Packt account holders; Instant Updates on New Packt Books; Preface; What this book covers; What you need for this book; Who this book is for; Conventions; Reader feedback; Customer support; Downloading the example code; Errata; Piracy; Questions; 1. Mastering SQL Trace Using Profiler; Introduction. | |
| 505 | 8 | |a Creating a trace or workloadGetting ready; How to do it ... ; How it works ... ; There's more ... ; Some background of SQL Trace; SQL Trace terms and concepts; SQL Trace; SQL Server Profiler; Event; Event class; Event category; Data column; Trace; Trace properties and Trace definition; Filter; Trace file; Trace table; Trace template; Architecture of SQL Trace; Trace and workload; Commonly-used event classes; Commonly-used data columns; Filtering events; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Detecting slow running and expensive queries; Getting ready; How to do it ... | |
| 505 | 8 | |a How it works ... There's more ... ; Trace templates; Creating trace with system stored procedures; Getting ready; How to do it ... ; How it works ... ; 2. Tuning with Database Engine Tuning Advisor; Introduction; Analyzing queries using Database Engine Tuning Advisor; Getting ready; How to do it ... ; How it works ... ; Running Database Engine Tuning Advisor for workload; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Executing Database Tuning Advisor from command prompt; Getting ready; How to do it ... ; How it works ... ; There's more ... | |
| 505 | 8 | |a 3. System Statistical Functions, Stored Procedures, and the DBCC SQLPERF CommandIntroduction; Monitoring system health using system statistical functions; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Monitoring with system stored procedure; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Monitoring log space usage statistics with DBCC command; Getting ready; How to do it ... ; How it works ... ; There's more ... ; 4. Resource Monitor and Performance Monitor; Introduction; Monitoring of server performance; Getting ready; How to do it ... ; How it works ... | |
| 505 | 8 | |a There's more ... Monitoring CPU usage; Getting ready; How to do it ... ; How it works ... ; Monitoring memory (RAM) usage; Getting ready; How to do it ... ; How it works ... ; 5. Monitoring with Execution Plans; Introduction; Working with estimated execution plan; Getting ready; How to do it ... ; How it works ... ; Working with actual execution plan; Getting ready; How to do it ... ; How it works ... ; There's more ... ; Monitoring performance of a query by SET SHOWPLAN_XML; Getting ready; How to do it ... ; How it works ... ; Monitoring performance of a query by SET STATISTICS XML; Getting ready; How to do it ... | |
| 520 | |a Over 80 recipes to help you tune SQL Server 2012 and achieve optimal performance. | ||
| 546 | |a English. | ||
| 506 | 1 | |a Legal Deposit; |c Only available on premises controlled by the deposit library and to one user at any one time; |e The Legal Deposit Libraries (Non-Print Works) Regulations (UK). |5 WlAbNL | |
| 540 | |a Restricted: Printing from this resource is governed by The Legal Deposit Libraries (Non-Print Works) Regulations (UK) and UK copyright law currently in force. |5 WlAbNL | ||
| 590 | |a eBooks on EBSCOhost |b EBSCO eBook Subscription Academic Collection - Worldwide | ||
| 590 | |a O'Reilly |b O'Reilly Online Learning: Academic/Public Library Edition | ||
| 630 | 0 | 0 | |a SQL server. |
| 630 | 0 | 7 | |a SQL server. |2 blmlsh |
| 630 | 0 | 7 | |a SQL server. |2 fast |0 (OCoLC)fst01376937 |
| 650 | 0 | |a Client/server computing. | |
| 650 | 6 | |a Architecture client-serveur (Informatique) | |
| 650 | 7 | |a COMPUTERS |x Enterprise Applications |x Collaboration Software. |2 bisacsh | |
| 650 | 7 | |a Client/server computing. |2 fast |0 (OCoLC)fst00864205 | |
| 700 | 1 | |a Thaker, Bihag. | |
| 776 | 0 | 8 | |i Print version: |a Shah, Ritesh. |t Microsoft SQL Server 2012 Performance Tuning Cookbook. |d Birmingham : Packt Publishing, ©2012 |z 9781849685740 |
| 830 | 0 | |a Enterprise : professional expertise distilled. | |
| 856 | 4 | 0 | |u https://learning.oreilly.com/library/view/~/9781849685740/?ar |z Texto completo (Requiere registro previo con correo institucional) |
| 938 | |a Askews and Holts Library Services |b ASKH |n AH26944263 | ||
| 938 | |a EBL - Ebook Library |b EBLB |n EBL995551 | ||
| 938 | |a ebrary |b EBRY |n ebr10583709 | ||
| 938 | |a EBSCOhost |b EBSC |n 473297 | ||
| 938 | |a YBP Library Services |b YANK |n 9458664 | ||
| 994 | |a 92 |b IZTAP | ||