Leveraging SQL Server Profiler's Replayable Trace Functionality

Guardado en:

Detalles Bibliográficos
Publicado en:	SQL Server Magazine vol. 13, no. 11 (Nov 2011), p. 21-24
Autor principal:	Brown, Lori
Publicado:	Informa
Materias:	Servers Structured Query Language-SQL Back up systems Databases
Acceso en línea:	Citation/Abstract Full Text Full Text - PDF
Etiquetas:	Agregar Etiqueta Sin Etiquetas, Sea el primero en etiquetar este registro!

Descripción
Resumen:	Because there are differences in the trace script generated by newer versions of SQL Server, it's best to use the server-side trace script generated by your production SQL Server instance. [...] you should avoid using the duration counter in the SQL trace because it will produce inconsistent values. [...] you need to cleanse parameters from queries so that queries can be grouped.
ISSN:	1522-2187 2165-3291
Fuente:	Advanced Technologies & Aerospace Database