MultiUser Testing Tool

Hello,
We are in process of rolling out our SQL Server version of our product.
During our beta testing phase we have started receiving problems in
scalability from some clients. The database starts doing a lot of blocks in
multi-user environment. This is not always very easy to replicate in-house.
We are now looking for a testing tool that will automate multi-user testing
while also providing useful information such lock chains and analysis of bad
locks (such as holding exclusive table/page locks for too long), etc when
there are blocks. Is there any testing tool that people here have used
before ? Any experiences or comments will be very useful.
Thanx, Amol.
Hi
You may want to look at the dbhammer program that comes with the resource
kit and using profiler to caputure the information. Loadrunner is a more
costly alternative. You can also use profiler to script the functions you
may want to do, if these are segmented then you can chain them together to
produce specific activities.
John
"Amol Kasbekar" <apk@.nospam.com> wrote in message
news:edbWB%23%23eEHA.3100@.TK2MSFTNGP10.phx.gbl...
> Hello,
> We are in process of rolling out our SQL Server version of our
product.
> During our beta testing phase we have started receiving problems in
> scalability from some clients. The database starts doing a lot of blocks
in
> multi-user environment. This is not always very easy to replicate
in-house.
> We are now looking for a testing tool that will automate multi-user
testing
> while also providing useful information such lock chains and analysis of
bad
> locks (such as holding exclusive table/page locks for too long), etc when
> there are blocks. Is there any testing tool that people here have used
> before ? Any experiences or comments will be very useful.
> Thanx, Amol.
>
>

MultiUser Testing Tool

Hello,
We are in process of rolling out our SQL Server version of our product.
During our beta testing phase we have started receiving problems in
scalability from some clients. The database starts doing a lot of blocks in
multi-user environment. This is not always very easy to replicate in-house.
We are now looking for a testing tool that will automate multi-user testing
while also providing useful information such lock chains and analysis of bad
locks (such as holding exclusive table/page locks for too long), etc when
there are blocks. Is there any testing tool that people here have used
before ? Any experiences or comments will be very useful.
Thanx, Amol.Hi
You may want to look at the dbhammer program that comes with the resource
kit and using profiler to caputure the information. Loadrunner is a more
costly alternative. You can also use profiler to script the functions you
may want to do, if these are segmented then you can chain them together to
produce specific activities.
John
"Amol Kasbekar" <apk@.nospam.com> wrote in message
news:edbWB%23%23eEHA.3100@.TK2MSFTNGP10.phx.gbl...
> Hello,
> We are in process of rolling out our SQL Server version of our
product.
> During our beta testing phase we have started receiving problems in
> scalability from some clients. The database starts doing a lot of blocks
in
> multi-user environment. This is not always very easy to replicate
in-house.
> We are now looking for a testing tool that will automate multi-user
testing
> while also providing useful information such lock chains and analysis of
bad
> locks (such as holding exclusive table/page locks for too long), etc when
> there are blocks. Is there any testing tool that people here have used
> before ? Any experiences or comments will be very useful.
> Thanx, Amol.
>
>

MultiUser Testing Tool

Hello,
We are in process of rolling out our SQL Server version of our product.
During our beta testing phase we have started receiving problems in
scalability from some clients. The database starts doing a lot of blocks in
multi-user environment. This is not always very easy to replicate in-house.
We are now looking for a testing tool that will automate multi-user testing
while also providing useful information such lock chains and analysis of bad
locks (such as holding exclusive table/page locks for too long), etc when
there are blocks. Is there any testing tool that people here have used
before ? Any experiences or comments will be very useful.
Thanx, Amol.Hi
You may want to look at the dbhammer program that comes with the resource
kit and using profiler to caputure the information. Loadrunner is a more
costly alternative. You can also use profiler to script the functions you
may want to do, if these are segmented then you can chain them together to
produce specific activities.
John
"Amol Kasbekar" <apk@.nospam.com> wrote in message
news:edbWB%23%23eEHA.3100@.TK2MSFTNGP10.phx.gbl...
> Hello,
> We are in process of rolling out our SQL Server version of our
product.
> During our beta testing phase we have started receiving problems in
> scalability from some clients. The database starts doing a lot of blocks
in
> multi-user environment. This is not always very easy to replicate
in-house.
> We are now looking for a testing tool that will automate multi-user
testing
> while also providing useful information such lock chains and analysis of
bad
> locks (such as holding exclusive table/page locks for too long), etc when
> there are blocks. Is there any testing tool that people here have used
> before ? Any experiences or comments will be very useful.
> Thanx, Amol.
>
>

Multiuser Databinding in SQL Server 2000?

Hi

I am developing one multi user application in windows environment using VC++ .NET with SQL Server 2000. How Can I create dataset for multi user data updating in my SQL Server 2000. Where I can get help and sample code?

Thanks

Jose

Jose,

The DataSet is an off-line data cache. The DataAdapter is used to submit the pending changes stored in the DataSet. In the DataAdapter's updating logic, you can specify your own concurrency options to control whether you want to use a "last in wins" approach with only the primary key column(s) in the WHERE clause, or use other columns in the WHERE clause to ensure you don't overwrite changes made by another user.

I hope this information proves helpful.

David Sceppa
ADO.NET Program Manager
Microsoft|||Hi

Thankyou for the nice explanation. One more question how can I write custom primary key value. for example (50710000001) like this. 5 is for year, 07 is for month, 10 is for place, and remaining is unique automatic generating number. How can I write program in SQL Server 2000.

Regards,
Jose