Performance and Stress tests

Hi out there
I am trying to create a uniform test-environment which I can move from one
hw platform to another. I have found ostress.exe and read80trace.exe as a
usefull tool for this. Are there some out there which has written some either
stress-scripts for these tools to stress a sql-database, so that I can see
how to do it (sorry to admit it but I am a wizard into sql)
regards /thomas iwang
Hi
MS has some tools, follow the link from:
http://msmvps.com/epprecht/archive/2.../24/10591.aspx
Regards
Mike
"Thomas Iwang" wrote:

> Hi out there
> I am trying to create a uniform test-environment which I can move from one
> hw platform to another. I have found ostress.exe and read80trace.exe as a
> usefull tool for this. Are there some out there which has written some either
> stress-scripts for these tools to stress a sql-database, so that I can see
> how to do it (sorry to admit it but I am a wizard into sql)
> regards /thomas iwang
|||Hi,
If you want to stress io subsystem sqliostress is a nice stress tool. First
you don't need to install sql server to use sqliostress, and if you have
problems with your io subsytem you can catch them before going into
production. (We catch some serious problems with the fibre channel adapter
cards etc.. thanks to sqliostress)
If you like to stress test your application, we use ACT which is available
with Visual Studio if i'm not wrong..
And there used to be a tool in resource kit which is called Database Hammer..
Hope this helps..
"Thomas Iwang" wrote:

> Hi out there
> I am trying to create a uniform test-environment which I can move from one
> hw platform to another. I have found ostress.exe and read80trace.exe as a
> usefull tool for this. Are there some out there which has written some either
> stress-scripts for these tools to stress a sql-database, so that I can see
> how to do it (sorry to admit it but I am a wizard into sql)
> regards /thomas iwang

Performance and Stress tests

Hi out there
I am trying to create a uniform test-environment which I can move from one
hw platform to another. I have found ostress.exe and read80trace.exe as a
usefull tool for this. Are there some out there which has written some eithe
r
stress-scripts for these tools to stress a sql-database, so that I can see
how to do it (sorry to admit it but I am a wizard into sql)
regards /thomas iwangHi
MS has some tools, follow the link from:
http://msmvps.com/epprecht/archive/...7/24/10591.aspx
Regards
Mike
"Thomas Iwang" wrote:

> Hi out there
> I am trying to create a uniform test-environment which I can move from one
> hw platform to another. I have found ostress.exe and read80trace.exe as a
> usefull tool for this. Are there some out there which has written some eit
her
> stress-scripts for these tools to stress a sql-database, so that I can see
> how to do it (sorry to admit it but I am a wizard into sql)
> regards /thomas iwang|||Hi,
If you want to stress io subsystem sqliostress is a nice stress tool. First
you don't need to install sql server to use sqliostress, and if you have
problems with your io subsytem you can catch them before going into
production. (We catch some serious problems with the fibre channel adapter
cards etc.. thanks to sqliostress)
If you like to stress test your application, we use ACT which is available
with Visual Studio if i'm not wrong..
And there used to be a tool in resource kit which is called Database Hammer.
.
Hope this helps..
"Thomas Iwang" wrote:

> Hi out there
> I am trying to create a uniform test-environment which I can move from one
> hw platform to another. I have found ostress.exe and read80trace.exe as a
> usefull tool for this. Are there some out there which has written some eit
her
> stress-scripts for these tools to stress a sql-database, so that I can see
> how to do it (sorry to admit it but I am a wizard into sql)
> regards /thomas iwang

Performance and Stress tests

Hi out there
I am trying to create a uniform test-environment which I can move from one
hw platform to another. I have found ostress.exe and read80trace.exe as a
usefull tool for this. Are there some out there which has written some either
stress-scripts for these tools to stress a sql-database, so that I can see
how to do it (sorry to admit it but I am a wizard into sql)
regards /thomas iwangHi
MS has some tools, follow the link from:
http://msmvps.com/epprecht/archive/2004/07/24/10591.aspx
Regards
Mike
"Thomas Iwang" wrote:
> Hi out there
> I am trying to create a uniform test-environment which I can move from one
> hw platform to another. I have found ostress.exe and read80trace.exe as a
> usefull tool for this. Are there some out there which has written some either
> stress-scripts for these tools to stress a sql-database, so that I can see
> how to do it (sorry to admit it but I am a wizard into sql)
> regards /thomas iwang|||Hi,
If you want to stress io subsystem sqliostress is a nice stress tool. First
you don't need to install sql server to use sqliostress, and if you have
problems with your io subsytem you can catch them before going into
production. (We catch some serious problems with the fibre channel adapter
cards etc.. thanks to sqliostress)
If you like to stress test your application, we use ACT which is available
with Visual Studio if i'm not wrong..
And there used to be a tool in resource kit which is called Database Hammer..
Hope this helps..
"Thomas Iwang" wrote:
> Hi out there
> I am trying to create a uniform test-environment which I can move from one
> hw platform to another. I have found ostress.exe and read80trace.exe as a
> usefull tool for this. Are there some out there which has written some either
> stress-scripts for these tools to stress a sql-database, so that I can see
> how to do it (sorry to admit it but I am a wizard into sql)
> regards /thomas iwang

perfmon.exe doesn't have sqlserver object...

I am trying to use Windows Performance monitor to find
trouble areas of our sql server. When I run perfmon.exe I
do not have a SQLServer object from which I can select
counters. If this is a sql server how do I add the
sqlserver object to perfmon?Tim,
there are many posibilities here.
Have a look at these articles, each of which detail reasons why the SQL
performance monitor counters may be missing and how to fix them:
http://support.microsoft.com/defaul...kb;en-us;227662
http://support.microsoft.com/defaul...kb;en-us;246328
http://www.extremeexperts.com/sql/f...erCounters.aspx
HTH,
Paul Ibison

perfmon.exe doesn't have sqlserver object...

I am trying to use Windows Performance monitor to find
trouble areas of our sql server. When I run perfmon.exe I
do not have a SQLServer object from which I can select
counters. If this is a sql server how do I add the
sqlserver object to perfmon?Tim,
there are many posibilities here.
Have a look at these articles, each of which detail reasons why the SQL
performance monitor counters may be missing and how to fix them:
http://support.microsoft.com/default.aspx?scid=kb;en-us;227662
http://support.microsoft.com/default.aspx?scid=kb;en-us;246328
http://www.extremeexperts.com/sql/faq/EnablingPerCounters.aspx
HTH,
Paul Ibison

Perfmon.exe doesn't have SQLserver object...

I am trying to use Windows Performance monitor to find
trouble areas of our sql server. When I run perfmon.exe I
do not have a SQLServer object from which I can select
counters. If this is a sql server how do I add the
sqlserver object to perfmon?
"Tim" <anonymous@.discussions.microsoft.com> wrote in message
news:1c53b01c4524b$06f48710$a401280a@.phx.gbl...
> I am trying to use Windows Performance monitor to find
> trouble areas of our sql server. When I run perfmon.exe I
> do not have a SQLServer object from which I can select
> counters. If this is a sql server how do I add the
> sqlserver object to perfmon?
If you are talking about SQL Server 2000, you may want to re-apply SP3a.
Failing this step, you may want to give this a read
http://support.microsoft.com/default...&Product=sql2k
Steve

perfmon.exe doesn't have sqlserver object...

I am trying to use Windows Performance monitor to find
trouble areas of our sql server. When I run perfmon.exe I
do not have a SQLServer object from which I can select
counters. If this is a sql server how do I add the
sqlserver object to perfmon?
Tim,
there are many posibilities here.
Have a look at these articles, each of which detail reasons why the SQL
performance monitor counters may be missing and how to fix them:
http://support.microsoft.com/default...b;en-us;227662
http://support.microsoft.com/default...b;en-us;246328
http://www.extremeexperts.com/sql/fa...rCounters.aspx
HTH,
Paul Ibison

perfmon tools

Hi,
I want to use perfmon.exe tools provided by win2000 to monitor performance
of SQL server, but it is strange, i cannot find SQL related counter from
drop-down performance object list. it is used to be there, but i can't find
it anymore, does someone know the reason?
I know I probably post this msg on Windows newsgroup, but i use it to
monitor SQL and I do SQL related jobs.
Thanks for your help in advance.
Jack
The following issue may apply to what you are seeing:
FIX: "Performance monitor shared memory setup failed: -1"
error message when you start SQL Server
http://support.microsoft.com/?id=812915
-Sue
On Mon, 6 Dec 2004 16:29:00 +0800, "Jack Hwang"
<jack_hc@.hotmail.com> wrote:

>Hi,
>I want to use perfmon.exe tools provided by win2000 to monitor performance
>of SQL server, but it is strange, i cannot find SQL related counter from
>drop-down performance object list. it is used to be there, but i can't find
>it anymore, does someone know the reason?
>I know I probably post this msg on Windows newsgroup, but i use it to
>monitor SQL and I do SQL related jobs.
>Thanks for your help in advance.
>Jack
>

perfmon tools

Hi,
I want to use perfmon.exe tools provided by win2000 to monitor performance
of SQL server, but it is strange, i cannot find SQL related counter from
drop-down performance object list. it is used to be there, but i can't find
it anymore, does someone know the reason?
I know I probably post this msg on Windows newsgroup, but i use it to
monitor SQL and I do SQL related jobs.
Thanks for your help in advance.
JackThe following issue may apply to what you are seeing:
FIX: "Performance monitor shared memory setup failed: -1"
error message when you start SQL Server
http://support.microsoft.com/?id=812915
-Sue
On Mon, 6 Dec 2004 16:29:00 +0800, "Jack Hwang"
<jack_hc@.hotmail.com> wrote:
>Hi,
>I want to use perfmon.exe tools provided by win2000 to monitor performance
>of SQL server, but it is strange, i cannot find SQL related counter from
>drop-down performance object list. it is used to be there, but i can't find
>it anymore, does someone know the reason?
>I know I probably post this msg on Windows newsgroup, but i use it to
>monitor SQL and I do SQL related jobs.
>Thanks for your help in advance.
>Jack
>