Clustering SQL

Are there any major issues in clustering SQL 2000 on a Windows 2003 cluster?
Will with is also be fine for SQL 2005 on a Windows 2003 cluster?
No major issues. But take a read of these articles:
http://support.microsoft.com/kb/888121
http://support.microsoft.com/kb/301520
http://support.microsoft.com/kb/327270
http://support.microsoft.com/kb/815431
http://support.microsoft.com/kb/301600
http://support.microsoft.com/kb/872931
Linchi
"Peter Downes" <pjtdownes@.hotmail.com> wrote in message
news:OQH5msk4EHA.3840@.tk2msftngp13.phx.gbl...
> Are there any major issues in clustering SQL 2000 on a Windows 2003
cluster?
> Will with is also be fine for SQL 2005 on a Windows 2003 cluster?
>
|||Are there huge performance benfits in clustering SQL? Would a second
identical server in a cluster double the performance?
"Linchi Shea" <linchi_shea@.NOSPAM.ml.com> wrote in message
news:ODmm5Rl4EHA.524@.TK2MSFTNGP09.phx.gbl...
> No major issues. But take a read of these articles:
> http://support.microsoft.com/kb/888121
> http://support.microsoft.com/kb/301520
> http://support.microsoft.com/kb/327270
> http://support.microsoft.com/kb/815431
> http://support.microsoft.com/kb/301600
> http://support.microsoft.com/kb/872931
> Linchi
> "Peter Downes" <pjtdownes@.hotmail.com> wrote in message
> news:OQH5msk4EHA.3840@.tk2msftngp13.phx.gbl...
> cluster?
>
|||I would add that you need to do 817064 BEFORE 301600
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://www.msmvps.com/clustering - Blog
"Linchi Shea" <linchi_shea@.NOSPAM.ml.com> wrote in message
news:ODmm5Rl4EHA.524@.TK2MSFTNGP09.phx.gbl...
> No major issues. But take a read of these articles:
> http://support.microsoft.com/kb/888121
> http://support.microsoft.com/kb/301520
> http://support.microsoft.com/kb/327270
> http://support.microsoft.com/kb/815431
> http://support.microsoft.com/kb/301600
> http://support.microsoft.com/kb/872931
> Linchi
> "Peter Downes" <pjtdownes@.hotmail.com> wrote in message
> news:OQH5msk4EHA.3840@.tk2msftngp13.phx.gbl...
> cluster?
>
|||A database; or an instance of SQL for that matter, will only run on one
server at a time - clustered or not. You can not load balance SQL databases
across servers.
The benefit to clustering SQL is High Availability. Oh, and its really cool.
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://www.msmvps.com/clustering - Blog
"Peter Downes" <pjtdownes@.hotmail.com> wrote in message
news:%237I81Xl4EHA.1120@.TK2MSFTNGP11.phx.gbl...
> Are there huge performance benfits in clustering SQL? Would a second
> identical server in a cluster double the performance?
> "Linchi Shea" <linchi_shea@.NOSPAM.ml.com> wrote in message
> news:ODmm5Rl4EHA.524@.TK2MSFTNGP09.phx.gbl...
>
|||Thanks for the advice!
"Rodney R. Fournier [MVP]" <rod@.die.spam.die.nw-america.com> wrote in
message news:e1u6mbl4EHA.2624@.TK2MSFTNGP11.phx.gbl...
> I would add that you need to do 817064 BEFORE 301600
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering
> http://www.msmvps.com/clustering - Blog
> "Linchi Shea" <linchi_shea@.NOSPAM.ml.com> wrote in message
> news:ODmm5Rl4EHA.524@.TK2MSFTNGP09.phx.gbl...
>

Clustering

Can any one give me some idea regarding the major difference between working
in Clustering environment and Non Clustering environment with respect of SQL
SERVER.
Thanks
Joh hi,
The major difference is that you are able to run SQL in the second node,
even if the first had an enormous hardware error.
You can read in BOL the topic "Creating a Failover Cluster" as well as the
http://support.microsoft.com/default...b;en-us;260758 article
HTH
Andreas
"Joh" wrote:

> Can any one give me some idea regarding the major difference between working
> in Clustering environment and Non Clustering environment with respect of SQL
> SERVER.
> Thanks
>
>
|||Thanks Andreas,
one more question I have a two systems and I want to implement the
clustering so can you guide me like step by step installation as well as
which software I have to used for ... I am totally new in clustering.
Thanks
"Andreas Mavrogenis" <AndreasMavrogenis@.discussions.microsoft.com> wrote in
message news:12145165-29BC-4C66-A138-46E8598A72C4@.microsoft.com...[vbcol=seagreen]
> Joh hi,
> The major difference is that you are able to run SQL in the second node,
> even if the first had an enormous hardware error.
> You can read in BOL the topic "Creating a Failover Cluster" as well as the
> http://support.microsoft.com/default...b;en-us;260758 article
> HTH
> Andreas
> "Joh" wrote:
working[vbcol=seagreen]
SQL[vbcol=seagreen]
|||Hi, Joh
You will have lots of hours reading! Also there are specific training
courses for that reason.
http://www.microsoft.com/learning/training/default.asp
White Paper: Windows Server 2003 Server Cluster Architecture
http://www.microsoft.com/windowsserv...ercluster.mspx
Microsoft Cluster Service Installation Resources
http://support.microsoft.com/default...b;en-us;259267
Installation order for SQL Server 2000 Enterprise Edition on Microsoft
Cluster Server
http://support.microsoft.com/default...b;en-us;243218
HTH
Andreas
"Joh" wrote:

> Thanks Andreas,
> one more question I have a two systems and I want to implement the
> clustering so can you guide me like step by step installation as well as
> which software I have to used for ... I am totally new in clustering.
> Thanks
> "Andreas Mavrogenis" <AndreasMavrogenis@.discussions.microsoft.com> wrote in
> message news:12145165-29BC-4C66-A138-46E8598A72C4@.microsoft.com...
> working
> SQL
>
>
|||Thanks Andreas
"Andreas Mavrogenis" <AndreasMavrogenis@.discussions.microsoft.com> wrote in
message news:54E16DAB-F178-4195-BC09-73757E224BB9@.microsoft.com...
> Hi, Joh
> You will have lots of hours reading! Also there are specific training
> courses for that reason.
> http://www.microsoft.com/learning/training/default.asp
> White Paper: Windows Server 2003 Server Cluster Architecture
>
http://www.microsoft.com/windowsserv...ervercluster.m
spx[vbcol=seagreen]
> Microsoft Cluster Service Installation Resources
> http://support.microsoft.com/default...b;en-us;259267
> Installation order for SQL Server 2000 Enterprise Edition on Microsoft
> Cluster Server
> http://support.microsoft.com/default...b;en-us;243218
> HTH
> Andreas
>
> "Joh" wrote:
in[vbcol=seagreen]
node,[vbcol=seagreen]
the[vbcol=seagreen]
respect of[vbcol=seagreen]

clustered Vs NonClustered indexes

I was looking for some info on the major differences between a clustered and
a non-clustered index, but I couldn't find anything in the MS knowledgebase.
Which is more efficient? I am creating reports on an audit table that has
approx 20,000,000 rows in it. I indexed 3 columns as non clustered and my
queries take for ever to run. If I changed the indexes to clustered will
that speed things up or will it make no difference?
TIA,
JoeClustered Index Design Guidelines
http://msdn2.microsoft.com/en-us/library/ms190639.aspx
Nonclustered Index Design Guidelines
http://msdn.microsoft.com/library/e...ar_da2_1tbn.asp
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"jaylou" <jaylou@.discussions.microsoft.com> wrote in message
news:DC221C09-B1F5-47B3-92EC-BF677B1F4017@.microsoft.com...
>I was looking for some info on the major differences between a clustered
>and
> a non-clustered index, but I couldn't find anything in the MS
> knowledgebase.
> Which is more efficient? I am creating reports on an audit table that has
> approx 20,000,000 rows in it. I indexed 3 columns as non clustered and my
> queries take for ever to run. If I changed the indexes to clustered will
> that speed things up or will it make no difference?
> TIA,
> Joe
>|||Efficient for reporting queries? I have found it is particularly beneficial
to have a clustered index that compliments the same sort order of the query.
It also helps if the first column of the clustered index is included in the
where clause.
select
state, product category, dateofsale, price
from
SALES
where
state = 'FL'
order by
state, product category, dateofsale
Try creating a clustered index on: state, product category, dateofsale
"jaylou" <jaylou@.discussions.microsoft.com> wrote in message
news:DC221C09-B1F5-47B3-92EC-BF677B1F4017@.microsoft.com...
>I was looking for some info on the major differences between a clustered
>and
> a non-clustered index, but I couldn't find anything in the MS
> knowledgebase.
> Which is more efficient? I am creating reports on an audit table that has
> approx 20,000,000 rows in it. I indexed 3 columns as non clustered and my
> queries take for ever to run. If I changed the indexes to clustered will
> that speed things up or will it make no difference?
> TIA,
> Joe
>|||On Fri, 16 Dec 2005 12:38:02 -0800, jaylou
<jaylou@.discussions.microsoft.com> wrote:
>I was looking for some info on the major differences between a clustered an
d
>a non-clustered index, but I couldn't find anything in the MS knowledgebase
.
>Which is more efficient? I am creating reports on an audit table that has
>approx 20,000,000 rows in it. I indexed 3 columns as non clustered and my
>queries take for ever to run. If I changed the indexes to clustered will
>that speed things up or will it make no difference?
Indexed separately or together?
How many rows is returned by each query?
If you want any informed answers here, posting at least the select
statements (and what fields you've indexed) is going to be helpful.
In general, it's unlikely that clustered/unclustered by itself is
going to affect your runtimes much.
J.
ps - how long is "for ever"?
pps - are other people updating the table at the same time you're
running reports?|||Clustered indexes are best used when you need to return data ordered
according to a criteria, in other words a range of data. Non-clustered
indexes are best used for singleton fetches, or data which is not
necessarily contiguous.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"jaylou" <jaylou@.discussions.microsoft.com> wrote in message
news:DC221C09-B1F5-47B3-92EC-BF677B1F4017@.microsoft.com...
>I was looking for some info on the major differences between a clustered
>and
> a non-clustered index, but I couldn't find anything in the MS
> knowledgebase.
> Which is more efficient? I am creating reports on an audit table that has
> approx 20,000,000 rows in it. I indexed 3 columns as non clustered and my
> queries take for ever to run. If I changed the indexes to clustered will
> that speed things up or will it make no difference?
> TIA,
> Joe
>