Prev: Problem prefixing object with dbo. when using system stored procedures
Next: ADO Command parameterized queries
From: sloan on 15 Jul 2008 10:17

I currently have Sql Server 2005 Standard Edition.

I have a few legacy Sql Server 2000 Standard Edition databases as well.

...

I have implemented the Sql Server 2005 Performance Dashboard Reports as
well. Those have helped some.

...

I am looking for suggestions on tools which can artificially stress a
database, and capture results, you know the drill.


I have coded up a mini application which calls my BAL DotNet assemblies to
stress the overall system as well. Basically, it creates threads and sends
in lots of work requests.


Money isn't the issue. Something that works and works well is.

...

PS
I've been trying to push to get 2005 Enterprise Edition as well, so if there
is something in Enterprise which is not in Standards, please point that out.

Thanks.


From: Bob on 15 Jul 2008 10:43
Light-weight and free: ostress from Microsoft. Google it.


"sloan" wrote:

>
> I currently have Sql Server 2005 Standard Edition.
>
> I have a few legacy Sql Server 2000 Standard Edition databases as well.
>
> ...
>
> I have implemented the Sql Server 2005 Performance Dashboard Reports as
> well. Those have helped some.
>
> ...
>
> I am looking for suggestions on tools which can artificially stress a
> database, and capture results, you know the drill.
>
>
> I have coded up a mini application which calls my BAL DotNet assemblies to
> stress the overall system as well. Basically, it creates threads and sends
> in lots of work requests.
>
>
> Money isn't the issue. Something that works and works well is.
>
> ...
>
> PS
> I've been trying to push to get 2005 Enterprise Edition as well, so if there
> is something in Enterprise which is not in Standards, please point that out.
>
> Thanks.
>
>
>
From: Eric Russell on 15 Jul 2008 12:38
As for stress testing the database server specifically, SQL Profiler has a
feature to replay trace logs. For example, the trace can be captured on a
production server and replayed on a development server.
http://blogs.msdn.com/sqlprogrammability/archive/2008/06/26/use-sql-server-replay-tools-to-reproduce-and-resolve-customer-issues.aspx


"sloan" wrote:

>
> I currently have Sql Server 2005 Standard Edition.
>
> I have a few legacy Sql Server 2000 Standard Edition databases as well.
>
> ...
>
> I have implemented the Sql Server 2005 Performance Dashboard Reports as
> well. Those have helped some.
>
> ...
>
> I am looking for suggestions on tools which can artificially stress a
> database, and capture results, you know the drill.
>
>
> I have coded up a mini application which calls my BAL DotNet assemblies to
> stress the overall system as well. Basically, it creates threads and sends
> in lots of work requests.
>
>
> Money isn't the issue. Something that works and works well is.
>
> ...
>
> PS
> I've been trying to push to get 2005 Enterprise Edition as well, so if there
> is something in Enterprise which is not in Standards, please point that out.
>
> Thanks.
>
>
>
From: SQL Menace on 15 Jul 2008 12:45
What about the Database Hammer tool from the SQL Server 2000 Resource
Kit.
Is that still useful?


Denis The SQL Menace
http://www.lessthandot.com/
http://sqlservercode.blogspot.com
http://sqlblog.com/blogs/denis_gobo/default.aspx




On Jul 15, 12:38 pm, Eric Russell
<EricRuss...(a)discussions.microsoft.com> wrote:
> As for stress testing the database server specifically, SQL Profiler has a
> feature to replay trace logs. For example, the trace can be captured on a
> production server and replayed on a development server.http://blogs.msdn.com/sqlprogrammability/archive/2008/06/26/use-sql-s...
>
>
>
> "sloan" wrote:
>
> > I currently have Sql Server 2005 Standard Edition.
>
> > I have a few legacy Sql Server 2000 Standard Edition databases as well.
>
> > ...
>
> > I have implemented the Sql Server 2005 Performance Dashboard Reports as
> > well.  Those have helped some.
>
> > ...
>
> > I am looking for suggestions on tools which can artificially stress a
> > database, and capture results, you know the drill.
>
> > I have coded up a mini application which calls my BAL DotNet assemblies to
> > stress the overall system as well.  Basically, it creates threads and sends
> > in lots of work requests.
>
> > Money isn't the issue.  Something that works and works well is.
>
> > ...
>
> > PS
> > I've been trying to push to get 2005 Enterprise Edition as well, so if there
> > is something in Enterprise which is not in Standards, please point that out.
>
> > Thanks.- Hide quoted text -
>
> - Show quoted text -

From: Plamen Ratchev on 15 Jul 2008 12:50
The SQL Load Test tool can generate unit tests for the Visual Studio Load
Test using a Profiler trace:

http://www.codeplex.com/SQLLoadTest

HTH,

Plamen Ratchev
http://www.SQLStudio.com

 |  Next  |  Last
Pages: 1 2
Prev: Problem prefixing object with dbo. when using system stored procedures
Next: ADO Command parameterized queries