Imagen de Portada

A Three-Legged SQL Server Management Approach

Guardado en:
Publicado en:Database Trends and Applications vol. 30, no. 5 (Oct/Nov 2016), p. 18.
Autor principal: Lord, Steve
Publicado:
Information Today, Inc.
Materias:
Servers
Relational data bases
Software upgrading
Big Data
Computer centers
Workloads
Product development
Databases
Acceso en línea:Citation/Abstract
Full Text
Full Text - PDF
Etiquetas: Agregar Etiqueta
Sin Etiquetas, Sea el primero en etiquetar este registro!
Resumen:At a minimum, administrators should check the SQL Server availability, critical maintenance jobs such as backups, and essential capacity issues on a regular basis. 2.Create Standards for Database Administrators-Remember, SQL Server is a relational database management system (RDBMS) designed for the enterprise environment; a single SQL Server can contain thousands of separate databases. SQL Server Centralized Management Server is a central, single database that holds a list of managed servers. Because this server is able to gather metadata from your other database servers, it improves oversight and reporting activities exponentially; it allows companies to create a single consolidated report on job status, saving significant time compared to analyzing separate reports from each system.
ISSN:1547-9897
1089-019X
1525-4976
Fuente:ABI/INFORM Trade & Industry