Implementing UAT for SQL Server 2008 Cluster

#1

Hi All
Can somebody advice or provide me a link that i can refer if i want to
create some sort of User Acceptance Test in SQL Server 2008 clustering for 2
nodes?

#2

Hi Ole
TQ for the thought..i'm thinking the same way to. I mean, i just can get the
report generated during the prerequisite check to determine the clustering
configuration in OK..

Yes, on application side also we do the UAT. Basically what i mean in this
question is, the database SQL UAT. Of course i need to prepare to user (user
here mean the owner of this sql cluster, not the outside user) on how to show
to them the sql cluster is successfully configured. I need to show to them
the DB service is up, the cluster service and so on is running accordingly.

So that's actually what i mean in SQL database UAT..beside, i can show to
them on how to start the service if SQL is down and some basic documentation
on clustering side so they can understand in a minimal understanding on how
SQL cluster is working..

By the way, TQVM for ur reply Ole

"Ole Kristian Bangås" wrote:

Quote:

"Amirullail" wrote:

Hi All
Can somebody advice or provide me a link that i can refer if i want to
create some sort of User Acceptance Test in SQL Server 2008 clustering for 2
nodes?

Pardon me for possibly stupid questions but, this makes absolutely no sense
to me. Why would you have user acceptance test on a SQL Cluster? For the
users, it's just a database server, and when it runs (hopefully it will not
need to fail over automatically) it actually acts a single database server,
from the end user's point of view. I would expect a user acceptance test
related to the end user applicaton, but not the cluster.

So, if you want to check that the cluster will work as intended, here is a
few thoguhts from me:

1. If you run on Windows Server 2008, the hardware is pretty well checked by
the Cluster Setup. You should not have any warnings or errors during this
setup, and if you did get one or more, you should have fixed them now.

2. Ensure that the end user applications work no matter what node in the
cluster holds their instance/database.

3. IF you have SSIS running in the cluster as well (I really preffer a
separate and pearhaps even virtual server for this), Ensure that the SSIS
packages will run on either node. This basically means that SSIS is correctly
configured for all servers, and that any disk/file operations also goes to a
shared disk.

Well, this was perhaps not exactly what you asked for, but at least my
thoughts which I hope will be to some help.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Implementing UAT for SQL Server 2008 Cluster

microsoft.public.sqlserver.clustering microsoft.public.sqlserver.clustering

Implementing UAT for SQL Server 2008 Cluster - 01-14-2009 , 11:20 PM

RE: Implementing UAT for SQL Server 2008 Cluster - 01-19-2009 , 02:30 AM