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:
SQL (Computer program language)
SQL (Langage de programmation)
Engineering & Applied Sciences.
Computer Science.
Acceso en línea:Texto completo (Requiere registro previo con correo institucional)
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