Imagen de Portada

Improving SQL Server Performance

Guardado en:
Publicado en:Informatica Economica vol. 14, no. 2 (2010), p. 55-60
Autor principal: Mercioiu, Nicolae
Otros Autores: Vladucu, Victor
Publicado:
INFOREC Association
Materias:
Studies
Structured Query Language-SQL
Optimization
Client server computing
Queries
Values
Servers
Optimization techniques
Acceso en línea:Citation/Abstract
Full Text
Full Text - PDF
Etiquetas: Agregar Etiqueta
Sin Etiquetas, Sea el primero en etiquetar este registro!
Resumen:With the development of client server technology and multilayer architectures the systems efficiency issue has been increasingly discussed. Lacking knowledge in optimization methods and tools offered by DBMS's, database administrators and developers of applications based on Microsoft technologies cannot optimally design and service performing systems. In this article we review the objectives that should be considered (in order) to improve performance of SQL Server instances and we describe the techniques used to optimize queries. Also, we explain and illustrate the new optimization features offered by SQL Server 2008. [PUBLICATION ABSTRACT]
ISSN:1453-1305
1842-8088
Fuente:ABI/INFORM Global