Does anyone know of any utility to stress test a database without causing
more overhead to the performance?

I have a database that suspectingly is running slow or is  being accused of
running slow. I am not sure if it is the web servers, the web application or
the database.

I cannot run profiler because it is a production db and it causes the
performance to degrade whenever I try to examine it.

I was wondering if anyone knew of any third party utility that analyzes the
database performance and illustrate the problem areas if exists or if it is
other sources, such as the web server or application.

I need something that does not that increase adminstrative tasks and easy to
understand by any support person.

We are running SQL Server 2000 SP4 on Windows 2003 Ent.

This will also help analyze the database prior to migrating to the 2005
version to see where improvement are needed.

For disk I/O stress, see if this helps:
http://support.microsoft.com/kb/231619/

On Thu, 3 Aug 2006 11:48:02 -0700, SAM <S**@discussions.microsoft.com>
wrote:
If you create profiles by command instead of using the profiler
utility, they impact performance much less.

It is rather messy, though.

And of course, filter what you can just batch and rpc complete,
roughly the fields in the standard template, and if you filter by
duration > 0, you cut volume by 80%.

Josh

NEWSEQUINTIALID()
Slow Stored Procedure Execution
Interesting Question
Join??????
sp_recompile for user defined functions