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

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
Otros Autores: Stirk, Ian W., author (author)
Formato: Libro electrónico
Idioma:Inglés
Publicado: Shelter Island, New York : Manning [2011]
Edición:1st edition
Materias:
SQL (Computer program language)
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009628056406719
Tabla de Contenidos:
  • 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

Ejemplares similares