Testing a cluster with a workload

#1

I have installed two SQL Server clustered instances in a two node cluster
(a/a).
Now, I need to test the environment with a workload in presence of a
failover event.
Do I have to use SQL Profiler? Do I have already a workload? Is it possible
to test the SQL querying into a cluster in an another manner?
Thanks

#2

You can run the workload against the SQL Server using what ever method
works best for you. If you already have a SQL PRofiler workload
created from your current production enviroment then use this.

Denny

On Mon, 21 Jul 2008 13:40:10 -0700, Pasquale
<Pasquale (AT) discussions (DOT) microsoft.com> wrote:

Quote:

I have installed two SQL Server clustered instances in a two node cluster
(a/a).
Now, I need to test the environment with a workload in presence of a
failover event.
Do I have to use SQL Profiler? Do I have already a workload? Is it possible
to test the SQL querying into a cluster in an another manner?
Thanks

#3

You can run the workload against the SQL Server using what ever method
works best for you. If you already have a SQL PRofiler workload
created from your current production enviroment then use this.

Denny

On Mon, 21 Jul 2008 13:40:10 -0700, Pasquale
<Pasquale (AT) discussions (DOT) microsoft.com> wrote:

Quote:

I have installed two SQL Server clustered instances in a two node cluster
(a/a).
Now, I need to test the environment with a workload in presence of a
failover event.
Do I have to use SQL Profiler? Do I have already a workload? Is it possible
to test the SQL querying into a cluster in an another manner?
Thanks

#4

You can run the workload against the SQL Server using what ever method
works best for you. If you already have a SQL PRofiler workload
created from your current production enviroment then use this.

Denny

On Mon, 21 Jul 2008 13:40:10 -0700, Pasquale
<Pasquale (AT) discussions (DOT) microsoft.com> wrote:

Quote:

I have installed two SQL Server clustered instances in a two node cluster
(a/a).
Now, I need to test the environment with a workload in presence of a
failover event.
Do I have to use SQL Profiler? Do I have already a workload? Is it possible
to test the SQL querying into a cluster in an another manner?
Thanks

#5

You can run the workload against the SQL Server using what ever method
works best for you. If you already have a SQL PRofiler workload
created from your current production enviroment then use this.

Denny

On Mon, 21 Jul 2008 13:40:10 -0700, Pasquale
<Pasquale (AT) discussions (DOT) microsoft.com> wrote:

Quote:

I have installed two SQL Server clustered instances in a two node cluster
(a/a).
Now, I need to test the environment with a workload in presence of a
failover event.
Do I have to use SQL Profiler? Do I have already a workload? Is it possible
to test the SQL querying into a cluster in an another manner?
Thanks

#6

You can run the workload against the SQL Server using what ever method
works best for you. If you already have a SQL PRofiler workload
created from your current production enviroment then use this.

Denny

On Mon, 21 Jul 2008 13:40:10 -0700, Pasquale
<Pasquale (AT) discussions (DOT) microsoft.com> wrote:

Quote:

I have installed two SQL Server clustered instances in a two node cluster
(a/a).
Now, I need to test the environment with a workload in presence of a
failover event.
Do I have to use SQL Profiler? Do I have already a workload? Is it possible
to test the SQL querying into a cluster in an another manner?
Thanks

#7

You can run the workload against the SQL Server using what ever method
works best for you. If you already have a SQL PRofiler workload
created from your current production enviroment then use this.

Denny

On Mon, 21 Jul 2008 13:40:10 -0700, Pasquale
<Pasquale (AT) discussions (DOT) microsoft.com> wrote:

Quote:

I have installed two SQL Server clustered instances in a two node cluster
(a/a).
Now, I need to test the environment with a workload in presence of a
failover event.
Do I have to use SQL Profiler? Do I have already a workload? Is it possible
to test the SQL querying into a cluster in an another manner?
Thanks

#8

You can run the workload against the SQL Server using what ever method
works best for you. If you already have a SQL PRofiler workload
created from your current production enviroment then use this.

Denny

On Mon, 21 Jul 2008 13:40:10 -0700, Pasquale
<Pasquale (AT) discussions (DOT) microsoft.com> wrote:

Quote:

I have installed two SQL Server clustered instances in a two node cluster
(a/a).
Now, I need to test the environment with a workload in presence of a
failover event.
Do I have to use SQL Profiler? Do I have already a workload? Is it possible
to test the SQL querying into a cluster in an another manner?
Thanks

#9

You can run the workload against the SQL Server using what ever method
works best for you. If you already have a SQL PRofiler workload
created from your current production enviroment then use this.

Denny

On Mon, 21 Jul 2008 13:40:10 -0700, Pasquale
<Pasquale (AT) discussions (DOT) microsoft.com> wrote:

Quote:

I have installed two SQL Server clustered instances in a two node cluster
(a/a).
Now, I need to test the environment with a workload in presence of a
failover event.
Do I have to use SQL Profiler? Do I have already a workload? Is it possible
to test the SQL querying into a cluster in an another manner?
Thanks

#10

You can run the workload against the SQL Server using what ever method
works best for you. If you already have a SQL PRofiler workload
created from your current production enviroment then use this.

Denny

On Mon, 21 Jul 2008 13:40:10 -0700, Pasquale
<Pasquale (AT) discussions (DOT) microsoft.com> wrote:

Quote:

I have installed two SQL Server clustered instances in a two node cluster
(a/a).
Now, I need to test the environment with a workload in presence of a
failover event.
Do I have to use SQL Profiler? Do I have already a workload? Is it possible
to test the SQL querying into a cluster in an another manner?
Thanks