Tuesday, March 27, 2012

Database Hammer & Stress testing

Hello all
I am trying to stress test an SQL2000 server running on Windows 2003.
I am using the reskit utility database hammer.
The utility creates a table with 10,000,000 rows in it fine but when I try
to use the query/update part of the tool(procmaster.exe), it fails and I get
an error: 'Problem encountered during processing -2147217913'.
There is plenty of space in my log and data files etc.
Does anybody know what might be going on?
Thanks in advance.
Jane
PS I have also left a copy of this post in the sqlserver tools group.Hi
Sounds something like:
http://support.microsoft.com/default.aspx?scid=kb;en-us;265166
You may want to run profiler to see where it is having problems.
John
"Jane Reynolds" <nospam@.please.com> wrote in message
news:%23i9J6wU1EHA.2676@.TK2MSFTNGP12.phx.gbl...
> Hello all
> I am trying to stress test an SQL2000 server running on Windows 2003.
> I am using the reskit utility database hammer.
> The utility creates a table with 10,000,000 rows in it fine but when I try
> to use the query/update part of the tool(procmaster.exe), it fails and I
> get an error: 'Problem encountered during processing -2147217913'.
> There is plenty of space in my log and data files etc.
> Does anybody know what might be going on?
> Thanks in advance.
> Jane
> PS I have also left a copy of this post in the sqlserver tools group.
>|||Thanks
It looks like it is a code problem iin the utility then. I have done some
more research and found that there is a bug in the code. I don't know VB
though to try to edit it so will have to think of something else.
Jane
"John Bell" <jbellnewsposts@.hotmail.com> wrote in message
news:%23ZiKizV1EHA.1404@.TK2MSFTNGP11.phx.gbl...
> Hi
> Sounds something like:
> http://support.microsoft.com/default.aspx?scid=kb;en-us;265166
> You may want to run profiler to see where it is having problems.
> John
> "Jane Reynolds" <nospam@.please.com> wrote in message
> news:%23i9J6wU1EHA.2676@.TK2MSFTNGP12.phx.gbl...
>> Hello all
>> I am trying to stress test an SQL2000 server running on Windows 2003.
>> I am using the reskit utility database hammer.
>> The utility creates a table with 10,000,000 rows in it fine but when I
>> try to use the query/update part of the tool(procmaster.exe), it fails
>> and I get an error: 'Problem encountered during processing -2147217913'.
>> There is plenty of space in my log and data files etc.
>> Does anybody know what might be going on?
>> Thanks in advance.
>> Jane
>> PS I have also left a copy of this post in the sqlserver tools group.
>|||Hi
The article does not relate to a SQL Server back end, therefore if you did
profile this you can get the exact statement that fails and see what error
message Query Analyser would give you. If it is a datatype problem then you
may want to remove the column from the test or possibly install a different
version of MDAC.
John
"Jane Reynolds" <nospam@.please.com> wrote in message
news:OkyHRvY1EHA.2540@.TK2MSFTNGP09.phx.gbl...
> Thanks
> It looks like it is a code problem iin the utility then. I have done some
> more research and found that there is a bug in the code. I don't know VB
> though to try to edit it so will have to think of something else.
> Jane
> "John Bell" <jbellnewsposts@.hotmail.com> wrote in message
> news:%23ZiKizV1EHA.1404@.TK2MSFTNGP11.phx.gbl...
>> Hi
>> Sounds something like:
>> http://support.microsoft.com/default.aspx?scid=kb;en-us;265166
>> You may want to run profiler to see where it is having problems.
>> John
>> "Jane Reynolds" <nospam@.please.com> wrote in message
>> news:%23i9J6wU1EHA.2676@.TK2MSFTNGP12.phx.gbl...
>> Hello all
>> I am trying to stress test an SQL2000 server running on Windows 2003.
>> I am using the reskit utility database hammer.
>> The utility creates a table with 10,000,000 rows in it fine but when I
>> try to use the query/update part of the tool(procmaster.exe), it fails
>> and I get an error: 'Problem encountered during processing -2147217913'.
>> There is plenty of space in my log and data files etc.
>> Does anybody know what might be going on?
>> Thanks in advance.
>> Jane
>> PS I have also left a copy of this post in the sqlserver tools group.
>>
>

No comments:

Post a Comment