...Please refrain from multiposting! -- Adam Machanic SQL Server MVP - http://sqlblog.com Author, "Expert SQL Server 2005 Development" http://www.apress.com/book/bookDisplay...microsoft.com... Will running SQL Profiler 2000 slow down the performance of my production server - even if I run it on a different box? ...I am worried that profiling it will slow it down too much. ...

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

... is approximately 380MB, and is running my CPU at a very ...> times.  In other versions of SQL, you can throttle the memory ... the Outlook 2007 experience because performance is horrible.  Please help! Thanks, ...but no BCM, that experiences similar slow downs with the connection to ... having BCM in the profile make the slowness when editing emails ...

... is approximately 380MB, and is running my CPU at a very ...> times.  In other versions of SQL, you can throttle the memory ... the Outlook 2007 experience because performance is horrible.  Please help! Thanks, ...but no BCM, that experiences similar slow downs with the connection to ... having BCM in the profile make the slowness when editing emails ...

...sqlserver is approximately 380MB, and is running my CPU at a very ... times. In other versions of SQL, you can throttle the memory ... the Outlook 2007 experience because performance is horrible. Please help! Thanks,... no BCM, that experiences similar slow downs with the connection to ... having BCM in the profile make the slowness when editing emails ...

...sqlserver is approximately 380MB, and is running my CPU at a very ... times. In other versions of SQL, you can throttle the memory ... the Outlook 2007 experience because performance is horrible. Please help! Thanks,... no BCM, that experiences similar slow downs with the connection to ... having BCM in the profile make the slowness when editing emails ...

... writes: Not too familiar with SQL Profiler in SQL2000 sp4. Our ... slow response time for one database in particular. I've run ...My initial approach to find performance hogs is usually to trace ...suspicious, I try to narrow down exactly where the problem is...period, it's better to run the trace server-side and...script for it. -- Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se...

... MS Dynamics AX and a SQL 2005 DB. Now the project...and suddenly the processes were running at a nice speed... Now...later, we still have some slow operations, but I can't...the SELECT statements, but may slow down the INSERT and UPDATE...with the tuning template in SQL Profiler, and in about 15...in the sales table is performing slow, so as this is...m quite a newbie in SQL Administration, so I'll be...

...is not disk activity that is slowing you down. If you say that the CPU...the most time. That will dramatically narrow down the issues. -- Andrew J. Kelly SQL MVP Solid Quality Mentors "Helmut Woess" ...schrieb Ed Murphy: At least run Profiler during a run, looking for when each stored... Maybe the (in XP integrated) performance monitor shows not the reality, ...

... depends on what version of SQL Server. 2000: DBCC SQLPERF(WAITSTATS)... at the moment (have to run). Shouldn't be too hard ... some search, though... -- Tibor Karaszi, SQL Server MVP http://www.karaszi....disk activity that is slowing you down. If you say that...the server is waiting and profiler to see which statements in...time. That will dramatically narrow down the issues. You are right...