Location of database at sql server failover clustering

Hello there
If i set ewo nodes for sql server failover clustering, where does the
database is located?
See my reply to your other post in this group.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:ul8WfAh0HHA.4236@.TK2MSFTNGP06.phx.gbl...
Hello there
If i set ewo nodes for sql server failover clustering, where does the
database is located?
|||Whell Tom
I didn't understand where exacly the shared disk is: On node 1? on node 2?,
in a diffrent computer?
I didn't understand that from your explain. sorry.
Also what happen if node1 is being shut down?
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:eUo$TKj0HHA.5884@.TK2MSFTNGP02.phx.gbl...
> See my reply to your other post in this group.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
> news:ul8WfAh0HHA.4236@.TK2MSFTNGP06.phx.gbl...
> Hello there
> If i set ewo nodes for sql server failover clustering, where does the
> database is located?
>
|||On Mon, 30 Jul 2007 15:25:49 +0300, "Roy Goldhammer" <roy@.hotmail.com>
wrote:

>I didn't understand where exacly the shared disk is: On node 1? on node 2?,
>in a diffrent computer?
The shared disk is not in either computer, it is a box of disk drives
that is shared by BOTH computers. Both computers are connected to the
drives, but only one of them uses it at a time.
Roy Harvey
Beacon Falls, CT
|||Typically, the shared disks reside on a SAN - Storage Area Network. A
volume is carved out of the SAN and is presented to the cluster. Both nodes
have access, but only one at a time.
If NODE1 is being shut down, the clustered services running on NODE1
failover to NODE2 and begin running on there.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
SQL Server MVP
Toronto, ON Canada
https://mvp.support.microsoft.com/profile/Tom.Moreau
"Roy Goldhammer" <roy@.hotmail.com> wrote in message
news:uDraDTq0HHA.5380@.TK2MSFTNGP04.phx.gbl...
Whell Tom
I didn't understand where exacly the shared disk is: On node 1? on node 2?,
in a diffrent computer?
I didn't understand that from your explain. sorry.
Also what happen if node1 is being shut down?
"Tom Moreau" <tom@.dont.spam.me.cips.ca> wrote in message
news:eUo$TKj0HHA.5884@.TK2MSFTNGP02.phx.gbl...
> See my reply to your other post in this group.
> --
> Tom
> ----
> Thomas A. Moreau, BSc, PhD, MCSE, MCDBA, MCITP, MCTS
> SQL Server MVP
> Toronto, ON Canada
> https://mvp.support.microsoft.com/profile/Tom.Moreau
>
> "Roy Goldhammer" <roy@.hotmail.com> wrote in message
> news:ul8WfAh0HHA.4236@.TK2MSFTNGP06.phx.gbl...
> Hello there
> If i set ewo nodes for sql server failover clustering, where does the
> database is located?
>

LoadRunner + SqlTrace Problem

Hi ,
I am having Evaluation version of LoadRunner. I create a
sceneiro for 10 virtual users. My requirement is i want to know the
database hits. (ie i need to see the Database hits for 10 Virual
users).Because for me in some cases dead lock are occured. So i want to
see the transactions. I open the Sql Profiler to see the transactions.
When i run the sceneiro and i open the SQL profiler nothing
will happend in the SQL Profiler. Any one can please explain how to
attach the profiler for the Virual users.
I want to generate a hit for my local server with 10 virtual
users. And also i want to see the Hits with the help of Profiler.
Any can help me regarding this..
Thanks in Advance..
Thanks & Regards
VeluHi
If you are running connection pooling or the same user login, then I don't
think it will be possible to distinguish which client is running the code
unless you do something like adding a comment to the command string. This
would mean a change in the application.
If you do differentiate connections to different logins then you would need
to change the loadrunner script to read the user details on start up.
HTH
John
"velus123@.yahoo.com" wrote:

>
> Hi ,
> I am having Evaluation version of LoadRunner. I create a
> sceneiro for 10 virtual users. My requirement is i want to know the
> database hits. (ie i need to see the Database hits for 10 Virual
> users).Because for me in some cases dead lock are occured. So i want to
> see the transactions. I open the Sql Profiler to see the transactions.
>
> When i run the sceneiro and i open the SQL profiler nothing
> will happend in the SQL Profiler. Any one can please explain how to
> attach the profiler for the Virual users.
> I want to generate a hit for my local server with 10 virtual
> users. And also i want to see the Hits with the help of Profiler.
> Any can help me regarding this..
>
> Thanks in Advance..
>
> Thanks & Regards
> Velu
>