Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...
SQL Server Forum / Other Technologies / Clustering / July 2008

Tip: Looking for answers? Try searching our database.

Testing a cluster with a workload

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Pasquale - 21 Jul 2008 21:40 GMT
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
Reply to this Message
Denny Cherry - 21 Jul 2008 22:12 GMT
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

>I have installed two SQL Server clustered instances in a two node cluster
>(a/a).
[quoted text clipped - 3 lines]
>to test the SQL querying into a cluster in an another manner?
>Thanks
Reply to this Message
Geoff N. Hiten - 22 Jul 2008 01:24 GMT
Denny is correct.  Failover is just another event to test with your
pre-defined test workload.

Signature

Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP

> 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
[quoted text clipped - 10 lines]
>>to test the SQL querying into a cluster in an another manner?
>>Thanks
Reply to this Message
Linchi Shea - 22 Jul 2008 01:34 GMT
The first question to ask is what are the objectives of your tests. What are
you trying to accomplish? What questions are you trying to answer? When you
have your objectives defined, workloads/test methods would naturally follow.

Linchi

> I have installed two SQL Server clustered instances in a two node cluster
> (a/a).
[quoted text clipped - 3 lines]
> to test the SQL querying into a cluster in an another manner?
> Thanks
Reply to this Message
Pasquale - 22 Jul 2008 09:04 GMT
The goal is to verify the behaviour of the cluster during a failover while
the users execute an intensive querying to dbs.
Thanks

> The first question to ask is what are the objectives of your tests. What are
> you trying to accomplish? What questions are you trying to answer? When you
[quoted text clipped - 9 lines]
> > to test the SQL querying into a cluster in an another manner?
> > Thanks
Reply to this Message
Linchi Shea - 23 Jul 2008 04:11 GMT
The app workload has very little impact on the cluster failover behavior.

Linchi

> The goal is to verify the behaviour of the cluster during a failover while
> the users execute an intensive querying to dbs.
[quoted text clipped - 13 lines]
> > > to test the SQL querying into a cluster in an another manner?
> > > Thanks
Reply to this Message
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.