Database stress tester

Hello

Are there any database stress testing tools like database hammer bundled with any editions of 2005?

Or is there a resource kit somewhere that has one?

Thanks

this is the closest thing from MSFT http://msdn.microsoft.com/vstudio/teamsystem/products/dbpro/ .|||

third-party tool...

http://www.idera.com/Products/SQLscaler/?s=GW

|||

The original DBHammer tool works with SQL 2005, I've used it several times on it, have you tried it?

|||

Thanks for the replies

I had heard of the database hammer, but I have never used it. I will try it as, as soon as I can find a copy of it somewhere! Is it available to download?

Database resource won't start after changing cluster subnet

I'm running a SQL Server 2000 SP4 2-node active/acitve cluster on
Windows 2003 Server Enterprise Edition SP1. I changed the subnet mask
of my public network config, as well as the MCS virtual subnet and two
database resource subnets (all are using the same subnet). DNS is
correctly resolving to the IP addresses for all cluster resources. I
have two databases on this cluster. After changing the subnet, the
first one starts correctly on both nodes. The second one fails to
start at the SQL Server resource on node 1, but starts correctly on
node 2. I've included the three major application log errors below.
Before I start troubleshooting any further, I'm looking for any
suggestions. Does anyone know if running the SQL Server installation
advanced options mode would make any difference? Could a machine
reboot be necessary?
Type: Error
User: N/A
Source: MSSQL$LCCSQLINST1
Category: (3)
Event ID: 17052
Description:
[sqsrvres] ODBC sqldriverconnect failed
=======================================
Type: Error
User: N/A
Source: MSSQL$LCCSQLINST1
Category: (3)
Event ID: 17052
Description:
[sqsrvres] checkODBCConnectError: sqlstate = 08001; native error = 11;
message = [Microsoft][ODBC SQL Server
Driver][DBNETLIB]SQL Server does not exist or access denied.
=======================================
Type: Error
User: N/A
Source: MSSQL$LCCSQLINST1
Category: (3)
Event ID: 17052
Description:
[sqsrvres] checkODBCConnectError: sqlstate = 01000; native error = 35;
message = [Microsoft][ODBC SQL Server
Driver][DBNETLIB]ConnectionOpen (Connect()).
=======================================
Thanks,
Curt
http://support.microsoft.com/kb/244980/en-us
There's a section in there on how to change the subnet for the resources on
a SQL Server 2000 failover cluster configuration.
Sincerely,
Anthony Thomas

"Curtis Morrison" <curtmorrison@.hotmail.com> wrote in message
news:1174920700.449721.209260@.l77g2000hsb.googlegr oups.com...
> I'm running a SQL Server 2000 SP4 2-node active/acitve cluster on
> Windows 2003 Server Enterprise Edition SP1. I changed the subnet mask
> of my public network config, as well as the MCS virtual subnet and two
> database resource subnets (all are using the same subnet). DNS is
> correctly resolving to the IP addresses for all cluster resources. I
> have two databases on this cluster. After changing the subnet, the
> first one starts correctly on both nodes. The second one fails to
> start at the SQL Server resource on node 1, but starts correctly on
> node 2. I've included the three major application log errors below.
> Before I start troubleshooting any further, I'm looking for any
> suggestions. Does anyone know if running the SQL Server installation
> advanced options mode would make any difference? Could a machine
> reboot be necessary?
> Type: Error
> User: N/A
> Source: MSSQL$LCCSQLINST1
> Category: (3)
> Event ID: 17052
> Description:
> [sqsrvres] ODBC sqldriverconnect failed
> =======================================
> Type: Error
> User: N/A
> Source: MSSQL$LCCSQLINST1
> Category: (3)
> Event ID: 17052
> Description:
> [sqsrvres] checkODBCConnectError: sqlstate = 08001; native error = 11;
> message = [Microsoft][ODBC SQL Server
> Driver][DBNETLIB]SQL Server does not exist or access denied.
> =======================================
> Type: Error
> User: N/A
> Source: MSSQL$LCCSQLINST1
> Category: (3)
> Event ID: 17052
> Description:
> [sqsrvres] checkODBCConnectError: sqlstate = 01000; native error = 35;
> message = [Microsoft][ODBC SQL Server
> Driver][DBNETLIB]ConnectionOpen (Connect()).
> =======================================
> Thanks,
> Curt
>

database or system integration

Hi,
Can anyone please give me some resource or guideline on how to do
database consolidation or system integration? Thanks.You're gonna need to provide a bit more info on what you mean by system
integration...
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Eric Clapton" <no_spam@.bk.com> wrote in message
news:eQ32yBmAEHA.1700@.TK2MSFTNGP12.phx.gbl...
> Hi,
> Can anyone please give me some resource or guideline on how to
do
> database consolidation or system integration? Thanks.
>|||Say, combine some local access mdb and some SQL server together in order to
make it easier to maintain and manage. Thanks.
"Brian Moran" <brian@.solidqualitylearning.com> wrote in message
news:%23x3$hxrAEHA.916@.tk2msftngp13.phx.gbl...
> You're gonna need to provide a bit more info on what you mean by system
> integration...
> --
> Brian Moran
> Principal Mentor
> Solid Quality Learning
> SQL Server MVP
> http://www.solidqualitylearning.com
>
> "Eric Clapton" <no_spam@.bk.com> wrote in message
> news:eQ32yBmAEHA.1700@.TK2MSFTNGP12.phx.gbl...
to
> do
>

database or system integration

Hi,
Can anyone please give me some resource or guideline on how to do
database consolidation or system integration? Thanks.You're gonna need to provide a bit more info on what you mean by system
integration...
--
Brian Moran
Principal Mentor
Solid Quality Learning
SQL Server MVP
http://www.solidqualitylearning.com
"Eric Clapton" <no_spam@.bk.com> wrote in message
news:eQ32yBmAEHA.1700@.TK2MSFTNGP12.phx.gbl...
> Hi,
> Can anyone please give me some resource or guideline on how to
do
> database consolidation or system integration? Thanks.
>