Database level lock: creates

Showing posts with label creates. Show all posts

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.
>>
>

Database Hammer & Stress testing

Saturday, February 25, 2012

Database design question

My company presently creates a sql server database containing detailed
billing information for each of its customers and ships it to them
each month along with an application to view the data and create
reports. These databases contains 99% read only data and most of them
are less than 100Mb. They are looking at providing a web based app
which provides the same functionality however, they do not want to
modify the back end system which creates these individual databases.
I personally am advocating a single large db which would require
modification of the present system but, I am looking for feedback on
either side. Does anyone know of any documentation which compares
these types of designs? Does anyone have experience with a system
which has many databases which are dynamically attached and detached
(we don't anticipate more than 100 databases attached at one time)?
What type of performance was achieved? What maintenance issues did
you encounter?
TIA,
RossPeople can argue about this forever... However there are a couple of issues
you may wish to consider...
1. When you have a large number of databases, the SQL Tools get less
usefull. It seems to take a Lonnnng time opening up Enterprise Manager (for
instance.)
2. If you put things into a single database, you can no longer simply detach
and copy (because the database would contain information for other users .)
However, if you had a web app, you wouldn't have to do the detach at all
(unless your customers are going to require it..?)
Unless there are backup/restore issues or the detach/attach issue , I would
prefer having a single database - Less maintenance, easier use of tools, no
problem with applications - all good.
But reasonable people will differ -
Wayne Snyder MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
(Please respond only to the newsgroups.)
I support the Professional Association for SQL Server
(www.sqlpass.org)
"Ross Bonner" <rosspb3@.yahoo.com> wrote in message
news:47257b97.0403090954.82e83e3@.posting.google.com...
> My company presently creates a sql server database containing detailed
> billing information for each of its customers and ships it to them
> each month along with an application to view the data and create
> reports. These databases contains 99% read only data and most of them
> are less than 100Mb. They are looking at providing a web based app
> which provides the same functionality however, they do not want to
> modify the back end system which creates these individual databases.
> I personally am advocating a single large db which would require
> modification of the present system but, I am looking for feedback on
> either side. Does anyone know of any documentation which compares
> these types of designs? Does anyone have experience with a system
> which has many databases which are dynamically attached and detached
> (we don't anticipate more than 100 databases attached at one time)?
> What type of performance was achieved? What maintenance issues did
> you encounter?
> TIA,
> Ross|||The number of databases used will be large, we presently produce one db
per customer per month, we still haven't decided how many months worth
of data to retain, but it will probably be at least 3 months. The web
app would have to dynamically attach and detach these databases as
needed since leaving all attached would exceed the 32768 database limit.
*** Sent via Developersdex http://www.examnotes.net ***
Don't just participate in USENET...get rewarded for it!

Tuesday, March 27, 2012

Database Hammer & Stress testing

Database Hammer & Stress testing

Database Hammer & Stress testing

Saturday, February 25, 2012

Database design question

Database level lock

Blog Archive

About Me