Cluster training

Does anyone have suggestions for courses (offsite or CBT) to help my team come up to speed on clusters? My team members are DBAs.
Check out: www.solidqualitylearning.com
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Brenda Pingle" <Brenda Pingle@.discussions.microsoft.com> wrote in message
news:616748DE-D8DF-497F-8E9B-9B660CB0D786@.microsoft.com...
Does anyone have suggestions for courses (offsite or CBT) to help my team
come up to speed on clusters? My team members are DBAs.
|||Here is a link to Windows Clustering exam.
Exam 70-223: Installing, Configuring, and Administering Microsoft Clustering Services by Using Microsoft Windows 2000 Advanced Server
http://www.microsoft.com/learning/exams/70-223.asp
Implementing Microsoft Windows 2000 Clustering
Course 2087: Three days; Instructor-led
http://www.microsoft.com/traincert/s...2087aFINAL.ASP
I am not aware of any exam/course for SQL Server 2000 Clustering but the following books/whitepapers/webcast should be a good starting point
Microsoft SQL Server 2000 High Availability (MS Press)
ISBN 0-7356-1920-4
Microsoft Whitepaper - SQL Server 2000 Failover Clustering
http://www.microsoft.com/SQL/techinf...vercluster.asp
SQL Server 2000 Pricing and Licensing
http://www.microsoft.com/sql/howtobu...rlicensing.asp
Microsoft SQL Server 2000 High Availability Series
http://www.microsoft.com/technet/pro...y/sqlhalp.mspx
Microsoft Webcasts
Introduction to Microsoft SQL Server 2000 Clustering
http://support.microsoft.com/default...lurb051001.asp
Microsoft SQL Server 2000 Virtual Server: Things You Should Know
http://support.microsoft.com/default...lurb032602.asp
Microsoft SQL Server 2000 Virtual Server Basic Setup, Maintenance, and Service Pack http://support.microsoft.com/default...lurb061002.asp
Microsoft SQL Server 2000 Failover Clustering Disaster Recovery Procedures
http://support.microsoft.com/default...lurb101802.asp
Troubleshooting SQL 2000 Virtual Server and Service Pack Setups for Failover Clustering
http://support.microsoft.com/default...lurb020703.asp
Microsoft Knowledge Base Articles
Q243218 INF: Installation Order for SQL 2000 Enterprise Edition
http://support.microsoft.com/?kbid=243218
Q260758 - INF: Frequently Asked Questions - SQL Server 2000 - Failover Clustering
http://support.microsoft.com/?kbid=260758
Best Regards,
Uttam Parui
Microsoft Corporation
This posting is provided "AS IS" with no warranties, and confers no rights.
Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
http://www.microsoft.com/protect
http://www.microsoft.com/security/guidance/default.mspx
|||im a CTEC trainer, is their an efficient way to conduct this class course
2087 without purchasing an SCSI external hard drive for clustering? please
advise
"Uttam Parui[MS]" wrote:

> Here is a link to Windows Clustering exam.
> Exam 70-223: Installing, Configuring, and Administering Microsoft Clustering Services by Using Microsoft Windows 2000 Advanced Server
> http://www.microsoft.com/learning/exams/70-223.asp
>
> Implementing Microsoft Windows 2000 Clustering
> Course 2087: Three days; Instructor-led
> http://www.microsoft.com/traincert/s...2087aFINAL.ASP
>
> I am not aware of any exam/course for SQL Server 2000 Clustering but the following books/whitepapers/webcast should be a good starting point
> Microsoft SQL Server 2000 High Availability (MS Press)
> ISBN 0-7356-1920-4
> Microsoft Whitepaper - SQL Server 2000 Failover Clustering
> http://www.microsoft.com/SQL/techinf...vercluster.asp
> SQL Server 2000 Pricing and Licensing
> http://www.microsoft.com/sql/howtobu...rlicensing.asp
> Microsoft SQL Server 2000 High Availability Series
> http://www.microsoft.com/technet/pro...y/sqlhalp.mspx
> Microsoft Webcasts
> Introduction to Microsoft SQL Server 2000 Clustering
> http://support.microsoft.com/default...lurb051001.asp
> Microsoft SQL Server 2000 Virtual Server: Things You Should Know
> http://support.microsoft.com/default...lurb032602.asp
>
> Microsoft SQL Server 2000 Virtual Server Basic Setup, Maintenance, and Service Pack http://support.microsoft.com/default...lurb061002.asp
> Microsoft SQL Server 2000 Failover Clustering Disaster Recovery Procedures
> http://support.microsoft.com/default...lurb101802.asp
> Troubleshooting SQL 2000 Virtual Server and Service Pack Setups for Failover Clustering
> http://support.microsoft.com/default...lurb020703.asp
>
> Microsoft Knowledge Base Articles
>
> Q243218 INF: Installation Order for SQL 2000 Enterprise Edition
> http://support.microsoft.com/?kbid=243218
> Q260758 - INF: Frequently Asked Questions - SQL Server 2000 - Failover Clustering
> http://support.microsoft.com/?kbid=260758
> Best Regards,
> Uttam Parui
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no rights.
> Are you secure? For information about the Strategic Technology Protection Program and to order your FREE Security Tool Kit, please visit http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their Microsoft software to better protect against viruses and security vulnerabilities. The easiest way to do this is to visit the following websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
>
>
|||You can emulate clustering through VMWare.
Tom
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Benjsoft" <Benjsoft@.discussions.microsoft.com> wrote in message
news:0E6D46CF-6410-4154-9EF0-FBDC1A9CAE54@.microsoft.com...
im a CTEC trainer, is their an efficient way to conduct this class course
2087 without purchasing an SCSI external hard drive for clustering? please
advise
"Uttam Parui[MS]" wrote:

> Here is a link to Windows Clustering exam.
> Exam 70-223: Installing, Configuring, and Administering Microsoft
Clustering Services by Using Microsoft Windows 2000 Advanced Server
> http://www.microsoft.com/learning/exams/70-223.asp
>
> Implementing Microsoft Windows 2000 Clustering
> Course 2087: Three days; Instructor-led
> http://www.microsoft.com/traincert/s...2087aFINAL.ASP
>
> I am not aware of any exam/course for SQL Server 2000 Clustering but the
following books/whitepapers/webcast should be a good starting point
> Microsoft SQL Server 2000 High Availability (MS Press)
> ISBN 0-7356-1920-4
> Microsoft Whitepaper - SQL Server 2000 Failover Clustering
>
http://www.microsoft.com/SQL/techinf...vercluster.asp
> SQL Server 2000 Pricing and Licensing
> http://www.microsoft.com/sql/howtobu...rlicensing.asp
> Microsoft SQL Server 2000 High Availability Series
> http://www.microsoft.com/technet/pro...y/sqlhalp.mspx
> Microsoft Webcasts
> Introduction to Microsoft SQL Server 2000 Clustering
>
http://support.microsoft.com/default...lurb051001.asp
> Microsoft SQL Server 2000 Virtual Server: Things You Should Know
>
http://support.microsoft.com/default...lurb032602.asp
>
> Microsoft SQL Server 2000 Virtual Server Basic Setup, Maintenance, and
Service Pack
http://support.microsoft.com/default...lurb061002.asp
> Microsoft SQL Server 2000 Failover Clustering Disaster Recovery Procedures
>
http://support.microsoft.com/default...lurb101802.asp
> Troubleshooting SQL 2000 Virtual Server and Service Pack Setups for
Failover Clustering
>
http://support.microsoft.com/default...lurb020703.asp
>
> Microsoft Knowledge Base Articles
>
> Q243218 INF: Installation Order for SQL 2000 Enterprise Edition
> http://support.microsoft.com/?kbid=243218
> Q260758 - INF: Frequently Asked Questions - SQL Server 2000 - Failover
Clustering
> http://support.microsoft.com/?kbid=260758
> Best Regards,
> Uttam Parui
> Microsoft Corporation
> This posting is provided "AS IS" with no warranties, and confers no
rights.
> Are you secure? For information about the Strategic Technology Protection
Program and to order your FREE Security Tool Kit, please visit
http://www.microsoft.com/security.
> Microsoft highly recommends that users with Internet access update their
Microsoft software to better protect against viruses and security
vulnerabilities. The easiest way to do this is to visit the following
websites:
> http://www.microsoft.com/protect
> http://www.microsoft.com/security/guidance/default.mspx
>
>

Cluster Names

I have a basic segmentation model that uses the clustering algorithm. I've renamed the clusters in the cluster diagram, but they still show up as Cluster 1-n in the dimension browser and in the cube browser.

After renaming the clusters, I did a full reprosses on the data mining dimension and on the linked cube. Can anyone tell me what else I need to do to use the new cluster names in the report?

Thanks

A full reprocess of the DM dimension and the linked cube should do the trick - in fact, you don't really need to reprocess the cube with the linked DM dimension. Are you sure the reprocess completed successfully and you refreshed the dimension/cube browsers?|||

Yes. I tried it again with the same results. I noticed that when I opened the project that the cluster names that I entered were gone. The model had Cluster 1-10 again. I renamed them again, saved the .dmm file, reprocessed the dimension (full, successful), and reconnected in the browser. It still shows Cluster 1-10. I tried re-processing the model. That resets the cluster names in the model viewer.

Thanks for your help Raman.

|||

Renaming clusters in the viewer directly updated the model on the server - there is no need to reprocess the model. What you're seeing still looks like a client refresh issue.

What version of the Analysis Services 2005 and client tools (BI Dev Studio) are you running? RTM or SP1? Would you be able to provide complete repro steps for this problem?

|||

SP1, using BIDS to browse

In trying to re-create the problem in AdventureWorks, I found that changing the cluster names worked. I noticed the AllowDrillthrough setting in the AW cluster model was set to True. After changing that property in my project, the cluster names showed in the dimension. This seems to fix the problem.

Thanks for your help Raman.

sqlsql

Cluster Euclidean Distance

I am new to data mining so please excuse my ignorance. Lets assume

- i have created a cluser model

- identified 3 clusters ( a, b, c)

- each record consists of 15 columns

- collecting new records( 15 variables) real time

what i would like to do is plot these new records programmatically as i collect them realtime. I assume this new record will belong to one of these three clusters. I believe we can find the cluster this new record belongs to by ' SELECT Cluster()....' and distance from the center of the cluster by ClusterDistance(). To plot this on a 2-dimentional space i need (x, y).

ClusterDistance() could be Y but what will be X.

thanks.

Cluster() will return cluster that is most likely contain an input case (in your case, the new case). You can also use ClusterProbability() to get the probability that a case belongs to a particular cluster. This basically serves as the (reversed) cluster distance you are talking about; and it works with more general data (including both numeric and discrete data). Moreover, you can use PredictHistogrom(…) to return a histogram of the likelihood of the input case existing in each of the model’s clusters. You can also use CaseLikelihood(…) to return a measure from 0 to 1 that indicates how likely an input case is to exist considering the model learned by the algorithm.

For your reference, we have a live sample The Art of Clustering demonstrating how to use all these features to render 2D data points according to clustering results. I hope this sample will be of help to your project.

Good luck,

|||Your x and y are whatever you choose them to be. For example, the way our cluster diagram works is to plot cluster locations on a 2d plane by arbitrarily laying them out and using a "point-charge" approach to move the clusters around until they converge (or we get tired....). If you were to use such a method for identifying cluster "locations" in 2d space, you could then use ClusterDistance() (which is 1-ClusterProbability) for each case vs. each cluster to approximate where the case would land in the 2d space. You could then color the case by the most likely cluster, and you would have a diagram that looked similar to Yimin's Art of Clustering example, but with arbitrarily dimensioned cluster models.|||

Thanks Wu. I have one more question.

lets assume the new record( all floats columns ) belongs to cluster A but is significantly away from the center of the cluster.

there can be one or more than one columns that caused this record to be far away from the center of the cluster.

Is there any way we can find out the most significant columns in this record that caused it .

thanks

|||This is exactly how we implemented the outlier detection in the data mining addins for Excel. Code that shows how to do this is at http://www.sqlserverdatamining.com/DMCommunity/LiveSamples/46.aspx

Cluster Euclidean Distance

I am new to data mining so please excuse my ignorance. Lets assume

- i have created a cluser model

- identified 3 clusters ( a, b, c)

- each record consists of 15 columns

- collecting new records( 15 variables) real time

what i would like to do is plot these new records programmatically as i collect them realtime. I assume this new record will belong to one of these three clusters. I believe we can find the cluster this new record belongs to by ' SELECT Cluster()....' and distance from the center of the cluster by ClusterDistance(). To plot this on a 2-dimentional space i need (x, y).

ClusterDistance() could be Y but what will be X.

thanks.

Cluster() will return cluster that is most likely contain an input case (in your case, the new case). You can also use ClusterProbability() to get the probability that a case belongs to a particular cluster. This basically serves as the (reversed) cluster distance you are talking about; and it works with more general data (including both numeric and discrete data). Moreover, you can use PredictHistogrom(…) to return a histogram of the likelihood of the input case existing in each of the model’s clusters. You can also use CaseLikelihood(…) to return a measure from 0 to 1 that indicates how likely an input case is to exist considering the model learned by the algorithm.

For your reference, we have a live sample The Art of Clustering demonstrating how to use all these features to render 2D data points according to clustering results. I hope this sample will be of help to your project.

Good luck,

|||Your x and y are whatever you choose them to be. For example, the way our cluster diagram works is to plot cluster locations on a 2d plane by arbitrarily laying them out and using a "point-charge" approach to move the clusters around until they converge (or we get tired....). If you were to use such a method for identifying cluster "locations" in 2d space, you could then use ClusterDistance() (which is 1-ClusterProbability) for each case vs. each cluster to approximate where the case would land in the 2d space. You could then color the case by the most likely cluster, and you would have a diagram that looked similar to Yimin's Art of Clustering example, but with arbitrarily dimensioned cluster models.|||

Thanks Wu. I have one more question.

lets assume the new record( all floats columns ) belongs to cluster A but is significantly away from the center of the cluster.

there can be one or more than one columns that caused this record to be far away from the center of the cluster.

Is there any way we can find out the most significant columns in this record that caused it .

thanks

|||This is exactly how we implemented the outlier detection in the data mining addins for Excel. Code that shows how to do this is at http://www.sqlserverdatamining.com/DMCommunity/LiveSamples/46.aspx

Client EM produce OS "failed login errors"

hi all, have anyone else met with the following problem.

we've got a SQL2000SP3a on a 2 active-active node clusters of W2K3,
this cluster in using AD.

I've found that whenever I use Enterprise Manager on my local computer
to register the above instance, it will constantly produce "Failed
login for <Domain>\<DomainUser>" errors in the Windows Security Log of
the database server machine. There's no failed login in the SQL error
log and I can work normally with the Enterprise Manager. The OS failed
logins error are gone once I un-register the instance from my
Enterprise Manager.

Does anyone know or met with this before?"New MSSQL DBA" <boscong88@.gmail.com> wrote in message
news:1120635376.062877.121860@.z14g2000cwz.googlegr oups.com...
> hi all, have anyone else met with the following problem.
> we've got a SQL2000SP3a on a 2 active-active node clusters of W2K3,
> this cluster in using AD.
> I've found that whenever I use Enterprise Manager on my local computer
> to register the above instance, it will constantly produce "Failed
> login for <Domain>\<DomainUser>" errors in the Windows Security Log of
> the database server machine. There's no failed login in the SQL error
> log and I can work normally with the Enterprise Manager. The OS failed
> logins error are gone once I un-register the instance from my
> Enterprise Manager.
> Does anyone know or met with this before?

I don't really know, but as a complete guess, EM is trying to connect to the
operating system to get information about the MSSQL service state, and your
Windows account doesn't have those permissions. If this isn't helpful, you
might consider posting the full error details from the log.

Simon