Will Running SQL Profiler slow down performance of Production Serv
  Home FAQ Contact Sign in
microsoft.public.sqlserver.tools only
 
Advanced search
POPULAR GROUPS

more...

microsoft ... sqlserver.tools Profile…
 Up
Will Running SQL Profiler slow down performance of Production Serv         


Author: DB
Date: Sep 1, 2007 12:06

Will running SQL Profiler 2000 slow down the performance of my production
server - even if I run it on a different box? The production server has many
transactions occurring during the day and I am worried that profiling it will
slow it down too much.

--
DB
1 Comment
Re: Will Running SQL Profiler slow down performance of Production Serv         


Author: Adam Machanic
Date: Sep 1, 2007 14:31

Asked and answered in .server. Please refrain from multiposting!

--

Adam Machanic
SQL Server MVP - http://sqlblog.com

Author, "Expert SQL Server 2005 Development"
http://www.apress.com/book/bookDisplay.html?bID=10220

"DB" discussions.microsoft.com> wrote in message
news:EFBA733A-E036-458B-AA5B-C14DBEF83173@microsoft.com...
> Will running SQL Profiler 2000 slow down the performance of my production
> server - even if I run it on a different box? The production server has
> many
> transactions occurring during the day and I am worried that profiling it
> will
> slow it down too much.
>
> --
> DB
no comments