Databases Reference
In-Depth Information
Table 5-4
Local or Remote
File Options
Comments
1
Start a Profiler
trace from
the
same server you
are monitoring
.
1. Do not save data to files.
2. Save trace data to the local file
system or a file share, but do not
select the
Server processes SQL
Server trace data
option.
This option provides a simple trace
environment for developing and
troubleshooting database
applications on a non-production and
low-load server.
This configuration is convenient to
calibrate a very small trace or verify
your trace configurations
.
2
Start a Profiler
trace from
the
same server you
are monitoring
.
Save trace data to the local system
or a file share, and select the
Server
processes SQL Server
trace data
option.
Pros: SQL Profiler is guaranteed to
collect all configured trace events.
Cons: This option adds extra overhead
to the monitored server.
3
Start a Profiler
trace from
a
remote server or
workstation
.
1. Do not save data to files.
2. Save trace data to the remote file
system or a file share, but do not
select the ''
Server processes SQL
Server trace data
'' option.
Pros: Low overhead on monitored
SQL Server.
Cons: On a busy monitored SQL
Server, the Profiler may lose
event data.
4
Start a Profiler
trace from
a
remote server or
workstation
.
Save trace data to the monitored
SQL server by selecting the
Server
processes SQL Server
trace data
option.
Pros: SQL Profiler is guaranteed to
collect all configured trace events. The
Profiler load is on the remote node.
Cons: The monitored SQL Server has
to send one event stream to the Profiler
GUI and the other event stream to the
local file system. If you have to use
Profiler to trace on a busy production
server without missing events, then
consider this configuration.
Table 5-5
Baseline Type
Timeframe
Frequency
Purpose
Peak Hours
10:00 am to
11:00 am
Weekly
Captures daily high transaction volumes
during a weekday.
24-Hour
A full 24 hours Monthly
Captures core database transition
distributions over 24 hours on the 15
th
of
the month.
Seasonal Events A full 24 hours Holiday shopping
season, managerial
reporting season
Captures seasonal high-transaction
volumes over a 24-hour timeframe during
the season.
Search WWH ::
Custom Search