Content area

Abstract

Translate

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.

Details

Subject
Servers;
Structured Query Language-SQL;
Back up systems;
Databases
Title
Leveraging SQL Server Profiler's Replayable Trace Functionality
Author
Brown, Lori
Publication title
SQL Server Magazine; Loveland
Volume
13
Issue
11
Pages
21-24
Number of pages
4
Publication year
2011
Publication date
Nov 2011
Section
FEATURE
Publisher
Informa
Place of publication
Loveland
Country of publication
United States
Publication subject
Computers--Computer Programming, Computers--Data Base Management
ISSN
15222187
Source type
Magazine
Language of publication
English
Document type
Feature
Document feature
Diagrams; Tables; Graphs
ProQuest document ID
904554810
Document URL
https://www.proquest.com/magazines/leveraging-sql-server-profilers-replayable-trace/docview/904554810/se-2?accountid=208611
Copyright
Copyright Penton Business Media, Inc. and Penton Media, Inc. Nov 2011
Last updated
2023-08-23
Database
ProQuest One Academic