Cargando…

SQL server DMVs in action : better queries with dynamic management views /

Every action in SQL Server - queries, updates, whatever - leaves a set of tiny footprints; SQL Server records all that valuable data and makes it visible through Dynamic Management Views, or DMVs. A DBA or developer can use this incredibly detailed information to significantly improve the performanc...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Stirk, Ian W.
Formato: Electrónico eBook
Idioma:Inglés
Publicado: Shelter Island, NY : Manning Publications, Ã2011.
Temas:
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)

MARC

LEADER 00000cam a2200000Ia 4500
001 OR_ocn748597928
003 OCoLC
005 20231017213018.0
006 m o d
007 cr unu||||||||
008 110831s2011 nyua o 001 0 eng d
010 |a  2011275507 
040 |a UMI  |b eng  |e pn  |c UMI  |d COO  |d HEBIS  |d C6I  |d OCLCQ  |d DEBSZ  |d OCLCF  |d OCLCQ  |d CEF  |d AU@  |d WYU  |d UAB  |d OCLCQ  |d VT2  |d CNCEN  |d OCLCQ  |d LDP  |d HS0  |d INARC  |d OCLCO  |d OCLCQ 
016 7 |a 015691481  |2 Uk 
019 |a 1064110579  |a 1103281953  |a 1129331475  |a 1156925923  |a 1180318182  |a 1202552798  |a 1240532411  |a 1285843194 
020 |z 9781935182733 
020 |z 1935182730 
029 1 |a DEBSZ  |b 368478963 
029 1 |a GBVCP  |b 785432949 
029 1 |a HEBIS  |b 291545947 
029 1 |a AU@  |b 000067101962 
035 |a (OCoLC)748597928  |z (OCoLC)1064110579  |z (OCoLC)1103281953  |z (OCoLC)1129331475  |z (OCoLC)1156925923  |z (OCoLC)1180318182  |z (OCoLC)1202552798  |z (OCoLC)1240532411  |z (OCoLC)1285843194 
037 |a CL0500000108  |b Safari Books Online 
050 4 |a QA76.73.S67  |b S75 2011 
082 0 4 |a 005.7585  |2 22 
049 |a UAMI 
100 1 |a Stirk, Ian W. 
245 1 0 |a SQL server DMVs in action :  |b better queries with dynamic management views /  |c Ian W. Stirk. 
260 |a Shelter Island, NY :  |b Manning Publications,  |c Ã2011. 
300 |a 1 online resource (xxvi, 325 pages) :  |b illustrations 
336 |a text  |b txt  |2 rdacontent 
337 |a computer  |b c  |2 rdamedia 
338 |a online resource  |b cr  |2 rdacarrier 
588 0 |a Print version record. 
505 0 |a The Dynamic Management Views gold mine -- Common patterns -- DMV discovery -- Index DMVs -- Improving poor query performance -- Further query improvements -- Operating system DMVs -- Common language runtime DMVs -- Resolving transaction issues -- Database-level DMVs -- The self-healing database -- Useful scripts. 
520 |a Every action in SQL Server - queries, updates, whatever - leaves a set of tiny footprints; SQL Server records all that valuable data and makes it visible through Dynamic Management Views, or DMVs. A DBA or developer can use this incredibly detailed information to significantly improve the performance of queries and better understand what's really going on inside a SQL Server system SQL Server DMVs in Action is a practical guide that shows how to obtain, interpret, and act on the information captured by DMVs to keep SQL Server in top shape. The 100+ samples provided in this book will help readers master DMVs and also give them a tested, working, and instantly reusable SQL code library. 
546 |a English. 
590 |a O'Reilly  |b O'Reilly Online Learning: Academic/Public Library Edition 
650 0 |a SQL (Computer program language) 
650 6 |a SQL (Langage de programmation) 
650 7 |a SQL (Computer program language)  |2 fast  |0 (OCoLC)fst01102869 
650 7 |a Engineering & Applied Sciences.  |2 hilcc 
650 7 |a Computer Science.  |2 hilcc 
776 0 8 |i Print version:  |a Stirk, Ian W.  |t SQL server DMVs in action.  |d Shelter Island, NY : Manning Publications, 2011  |z 9781935182733  |w (OCoLC)676727503 
856 4 0 |u https://learning.oreilly.com/library/view/~/9781935182733/?ar  |z Texto completo (Requiere registro previo con correo institucional) 
938 |a YBP Library Services  |b YANK  |n 302272775 
938 |a Internet Archive  |b INAR  |n sqlserverdmvsina0000stir 
994 |a 92  |b IZTAP