Home All Groups Group Topic Archive Search About

Will Running SQL Profiler slow down performance of Production Serv

Author
1 Sep 2007 7:06 PM
DB
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

Author
1 Sep 2007 9:31 PM
Adam Machanic
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



Show quote
"DB" <D*@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

AddThis Social Bookmark Button