I know how to create mount point in windows 20003 cluster, I am not sure how
to set it up with SQL 2005 running on the cluster.
Does sql need to be dependant on any of the disks? I have tried looking for
a guide, but cannot find.
current setup active active cluster running. I need to add san space which
will hold the databases. The san will be carved up into drive letters. each
drive letter will hold 3 mount points.
ie.
node 1
J:-2 mount point
k:2 mount point
l:2 mount point
node 2-
r:-2 mount point
s:2 mount point
t:2 mount point
each node would be able to own the disk if the other node failed over.
any help is appreciate. I have tried books online etc.. cannot find a good
step by step.;
Vision,
there are three area's you want to get familiar with prior to setting up a
production cluster
1) how to setup mountpoints in a cluster
http://support.microsoft.com/kb/280297
2) Be aware of this one, I have seen this once or twice after installing
SP1, if you do not have the symptom you do not need the hotfix.
http://support.microsoft.com/kb/898790
3) SQL 2005 and mount points
http://www.microsoft.com/technet/prodtechnol/sql/2005/physdbstor.mspx
http://support.microsoft.com/kb/819546
Test everything thoroughly before you put this into any production.
HTH,
_Edwin.
"vision" <vision@.discussions.microsoft.com> wrote in message
news:F0C6D7D8-F9F2-46DF-A128-2D384DACD40C@.microsoft.com...
> I know how to create mount point in windows 20003 cluster, I am not sure
how
> to set it up with SQL 2005 running on the cluster.
> Does sql need to be dependant on any of the disks? I have tried looking
for
> a guide, but cannot find.
> current setup active active cluster running. I need to add san space
which
> will hold the databases. The san will be carved up into drive letters.
each
> drive letter will hold 3 mount points.
> ie.
> node 1
> J:-2 mount point
> k:2 mount point
> l:2 mount point
> node 2-
> r:-2 mount point
> s:2 mount point
> t:2 mount point
> each node would be able to own the disk if the other node failed over.
> any help is appreciate. I have tried books online etc.. cannot find a
good
> step by step.;
Showing posts with label cluster. Show all posts
Showing posts with label cluster. Show all posts
Monday, March 26, 2012
Wednesday, March 21, 2012
Monitoring Wish List ...
We are in the process of bringing a new SQL Cluster into production. One of
the things we are insisting on is that we have appropriate performance
monitoring in place BEFORE our customers start using it.
Briefly, the cluster is twin quad xeons, expandable to eight processors. 8
gig ram expandable to 64. Fiber channel to a drive array, log files to a
separate array. The cluster is an ASP environment. Customers access the
database server through a load balanced Citrix farm. The expectation is to
go from about 100 customers to over 1000 in the next 24 months, partly
through aquiring new customers and partly through moving existing customers
to the ASP model. Each customer has a separate set of databases. The obvious
problem is that performance is maintianed as new customers are added. The
monitoring plan is to take a baseline set of readings with no load on the
new cluster, then take data at prescribed intervals so that we can project
utilization and adjust planned upgrades accordingly. All standard procedure
(or at least it should be, right?).
My question is, that if you had the opportunity to set up such monitoring on
a pristine system, what would you include? We are currently going to look at
the following:
Logical Disk:
Avg Queue Length
Current Disk Queue
Physical Disk
Avg Queue Length
Current Disk Queue
Memory
Pages/sec
Page Reads/sec
Page Faults/sec
System
Processor Queue Length
CPU %
SQL:
Cache Hit Ratio
I/O - Single Page Write/Sec
I/O - Page Reads/Sec
I/O - Transactions/Sec
User Connections
What would you add or remove from this list?
Thanks,
Bob Castleman
SuccessWare SoftWareBob,
I'd take a look at the Microsoft SQL Server 2000
operations guide - as it has reccommendations for creating
a performance baseline..
Take a look at :-
http://www.microsoft.com/technet/treeview/default.asp?
url=/technet/prodtechnol/sql/maintain/operate/opsguide/sqlo
ps5.asp
and look for 'Creating The Baseline - Suggested Counters'
Hope this helps.
>--Original Message--
>We are in the process of bringing a new SQL Cluster into
production. One of
>the things we are insisting on is that we have
appropriate performance
>monitoring in place BEFORE our customers start using it.
>Briefly, the cluster is twin quad xeons, expandable to
eight processors. 8
>gig ram expandable to 64. Fiber channel to a drive array,
log files to a
>separate array. The cluster is an ASP environment.
Customers access the
>database server through a load balanced Citrix farm. The
expectation is to
>go from about 100 customers to over 1000 in the next 24
months, partly
>through aquiring new customers and partly through moving
existing customers
>to the ASP model. Each customer has a separate set of
databases. The obvious
>problem is that performance is maintianed as new
customers are added. The
>monitoring plan is to take a baseline set of readings
with no load on the
>new cluster, then take data at prescribed intervals so
that we can project
>utilization and adjust planned upgrades accordingly. All
standard procedure
>(or at least it should be, right?).
>My question is, that if you had the opportunity to set up
such monitoring on
>a pristine system, what would you include? We are
currently going to look at
>the following:
>Logical Disk:
> Avg Queue Length
> Current Disk Queue
>Physical Disk
> Avg Queue Length
> Current Disk Queue
>Memory
> Pages/sec
> Page Reads/sec
> Page Faults/sec
>System
> Processor Queue Length
> CPU %
>SQL:
> Cache Hit Ratio
> I/O - Single Page Write/Sec
> I/O - Page Reads/Sec
> I/O - Transactions/Sec
> User Connections
>
>What would you add or remove from this list?
>
>Thanks,
>Bob Castleman
>SuccessWare SoftWare
>
>.
>|||Thanks Steve.
Unfortunately, the info at the link you provided is pretty generic. I guess
I'm looking for specifics based on the experiences of the experts that post
here.
"Steve Hindmarsh" <steve@.nowhere.com> wrote in message
news:019f01c3db96$3e331ba0$a401280a@.phx.gbl...
> Bob,
> I'd take a look at the Microsoft SQL Server 2000
> operations guide - as it has reccommendations for creating
> a performance baseline..
> Take a look at :-
> http://www.microsoft.com/technet/treeview/default.asp?
> url=/technet/prodtechnol/sql/maintain/operate/opsguide/sqlo
> ps5.asp
> and look for 'Creating The Baseline - Suggested Counters'
> Hope this helps.
> >--Original Message--
> >We are in the process of bringing a new SQL Cluster into
> production. One of
> >the things we are insisting on is that we have
> appropriate performance
> >monitoring in place BEFORE our customers start using it.
> >
> >Briefly, the cluster is twin quad xeons, expandable to
> eight processors. 8
> >gig ram expandable to 64. Fiber channel to a drive array,
> log files to a
> >separate array. The cluster is an ASP environment.
> Customers access the
> >database server through a load balanced Citrix farm. The
> expectation is to
> >go from about 100 customers to over 1000 in the next 24
> months, partly
> >through aquiring new customers and partly through moving
> existing customers
> >to the ASP model. Each customer has a separate set of
> databases. The obvious
> >problem is that performance is maintianed as new
> customers are added. The
> >monitoring plan is to take a baseline set of readings
> with no load on the
> >new cluster, then take data at prescribed intervals so
> that we can project
> >utilization and adjust planned upgrades accordingly. All
> standard procedure
> >(or at least it should be, right?).
> >
> >My question is, that if you had the opportunity to set up
> such monitoring on
> >a pristine system, what would you include? We are
> currently going to look at
> >the following:
> >
> >Logical Disk:
> > Avg Queue Length
> > Current Disk Queue
> >Physical Disk
> > Avg Queue Length
> > Current Disk Queue
> >Memory
> > Pages/sec
> > Page Reads/sec
> > Page Faults/sec
> >System
> > Processor Queue Length
> > CPU %
> >SQL:
> > Cache Hit Ratio
> > I/O - Single Page Write/Sec
> > I/O - Page Reads/Sec
> > I/O - Transactions/Sec
> > User Connections
> >
> >
> >
> >What would you add or remove from this list?
> >
> >
> >Thanks,
> >
> >Bob Castleman
> >SuccessWare SoftWare
> >
> >
> >.
> >
the things we are insisting on is that we have appropriate performance
monitoring in place BEFORE our customers start using it.
Briefly, the cluster is twin quad xeons, expandable to eight processors. 8
gig ram expandable to 64. Fiber channel to a drive array, log files to a
separate array. The cluster is an ASP environment. Customers access the
database server through a load balanced Citrix farm. The expectation is to
go from about 100 customers to over 1000 in the next 24 months, partly
through aquiring new customers and partly through moving existing customers
to the ASP model. Each customer has a separate set of databases. The obvious
problem is that performance is maintianed as new customers are added. The
monitoring plan is to take a baseline set of readings with no load on the
new cluster, then take data at prescribed intervals so that we can project
utilization and adjust planned upgrades accordingly. All standard procedure
(or at least it should be, right?).
My question is, that if you had the opportunity to set up such monitoring on
a pristine system, what would you include? We are currently going to look at
the following:
Logical Disk:
Avg Queue Length
Current Disk Queue
Physical Disk
Avg Queue Length
Current Disk Queue
Memory
Pages/sec
Page Reads/sec
Page Faults/sec
System
Processor Queue Length
CPU %
SQL:
Cache Hit Ratio
I/O - Single Page Write/Sec
I/O - Page Reads/Sec
I/O - Transactions/Sec
User Connections
What would you add or remove from this list?
Thanks,
Bob Castleman
SuccessWare SoftWareBob,
I'd take a look at the Microsoft SQL Server 2000
operations guide - as it has reccommendations for creating
a performance baseline..
Take a look at :-
http://www.microsoft.com/technet/treeview/default.asp?
url=/technet/prodtechnol/sql/maintain/operate/opsguide/sqlo
ps5.asp
and look for 'Creating The Baseline - Suggested Counters'
Hope this helps.
>--Original Message--
>We are in the process of bringing a new SQL Cluster into
production. One of
>the things we are insisting on is that we have
appropriate performance
>monitoring in place BEFORE our customers start using it.
>Briefly, the cluster is twin quad xeons, expandable to
eight processors. 8
>gig ram expandable to 64. Fiber channel to a drive array,
log files to a
>separate array. The cluster is an ASP environment.
Customers access the
>database server through a load balanced Citrix farm. The
expectation is to
>go from about 100 customers to over 1000 in the next 24
months, partly
>through aquiring new customers and partly through moving
existing customers
>to the ASP model. Each customer has a separate set of
databases. The obvious
>problem is that performance is maintianed as new
customers are added. The
>monitoring plan is to take a baseline set of readings
with no load on the
>new cluster, then take data at prescribed intervals so
that we can project
>utilization and adjust planned upgrades accordingly. All
standard procedure
>(or at least it should be, right?).
>My question is, that if you had the opportunity to set up
such monitoring on
>a pristine system, what would you include? We are
currently going to look at
>the following:
>Logical Disk:
> Avg Queue Length
> Current Disk Queue
>Physical Disk
> Avg Queue Length
> Current Disk Queue
>Memory
> Pages/sec
> Page Reads/sec
> Page Faults/sec
>System
> Processor Queue Length
> CPU %
>SQL:
> Cache Hit Ratio
> I/O - Single Page Write/Sec
> I/O - Page Reads/Sec
> I/O - Transactions/Sec
> User Connections
>
>What would you add or remove from this list?
>
>Thanks,
>Bob Castleman
>SuccessWare SoftWare
>
>.
>|||Thanks Steve.
Unfortunately, the info at the link you provided is pretty generic. I guess
I'm looking for specifics based on the experiences of the experts that post
here.
"Steve Hindmarsh" <steve@.nowhere.com> wrote in message
news:019f01c3db96$3e331ba0$a401280a@.phx.gbl...
> Bob,
> I'd take a look at the Microsoft SQL Server 2000
> operations guide - as it has reccommendations for creating
> a performance baseline..
> Take a look at :-
> http://www.microsoft.com/technet/treeview/default.asp?
> url=/technet/prodtechnol/sql/maintain/operate/opsguide/sqlo
> ps5.asp
> and look for 'Creating The Baseline - Suggested Counters'
> Hope this helps.
> >--Original Message--
> >We are in the process of bringing a new SQL Cluster into
> production. One of
> >the things we are insisting on is that we have
> appropriate performance
> >monitoring in place BEFORE our customers start using it.
> >
> >Briefly, the cluster is twin quad xeons, expandable to
> eight processors. 8
> >gig ram expandable to 64. Fiber channel to a drive array,
> log files to a
> >separate array. The cluster is an ASP environment.
> Customers access the
> >database server through a load balanced Citrix farm. The
> expectation is to
> >go from about 100 customers to over 1000 in the next 24
> months, partly
> >through aquiring new customers and partly through moving
> existing customers
> >to the ASP model. Each customer has a separate set of
> databases. The obvious
> >problem is that performance is maintianed as new
> customers are added. The
> >monitoring plan is to take a baseline set of readings
> with no load on the
> >new cluster, then take data at prescribed intervals so
> that we can project
> >utilization and adjust planned upgrades accordingly. All
> standard procedure
> >(or at least it should be, right?).
> >
> >My question is, that if you had the opportunity to set up
> such monitoring on
> >a pristine system, what would you include? We are
> currently going to look at
> >the following:
> >
> >Logical Disk:
> > Avg Queue Length
> > Current Disk Queue
> >Physical Disk
> > Avg Queue Length
> > Current Disk Queue
> >Memory
> > Pages/sec
> > Page Reads/sec
> > Page Faults/sec
> >System
> > Processor Queue Length
> > CPU %
> >SQL:
> > Cache Hit Ratio
> > I/O - Single Page Write/Sec
> > I/O - Page Reads/Sec
> > I/O - Transactions/Sec
> > User Connections
> >
> >
> >
> >What would you add or remove from this list?
> >
> >
> >Thanks,
> >
> >Bob Castleman
> >SuccessWare SoftWare
> >
> >
> >.
> >
Monday, March 19, 2012
monitoring SQL cluster
Is their any document avaiable on monitoring SQL cluster
. If yes can some one please send the link
http://www.microsoft.com/technet/pro...n/sqlops0.mspx
See chapter 5.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
"Ritesh Gupta" <Ritesh Gupta@.discussions.microsoft.com> wrote in message
news:ADB48C6F-98B0-4835-B2CD-FF2A337F90B7@.microsoft.com...
> Is their any document avaiable on monitoring SQL cluster
> . If yes can some one please send the link
>
. If yes can some one please send the link
http://www.microsoft.com/technet/pro...n/sqlops0.mspx
See chapter 5.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
"Ritesh Gupta" <Ritesh Gupta@.discussions.microsoft.com> wrote in message
news:ADB48C6F-98B0-4835-B2CD-FF2A337F90B7@.microsoft.com...
> Is their any document avaiable on monitoring SQL cluster
> . If yes can some one please send the link
>
Subscribe to:
Posts (Atom)