.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

troubleshooting clustering

Posted By:      Posted Date: August 28, 2010    Points: 0   Category :Sql Server
i need step by step for installations of clustering in sql server 2008 environment? please help me on this.

View Complete Post

More Related Resource Links

Troubleshooting Webservices


Hello All,

I have been working on web services for quite sometime. Have been creating and consuming simple to intermediate levels of web services. But now i want to start using some third party web services.

I have got to know that there are good ways to troubleshoot issues in our own web services or any third party web services. For example, if a particular web method was working since 3 months and all of a sudden, it stopped working as expected or its not giving the results now. In these kind of situations, what are the best approaches to troubleshoot the issue. 

Can someone please share some points on this? May be some right articles having some examples will give me the clear picture. Please let me know. Thanks.

Learning Snack for IT Professionals: Managing and Troubleshooting with Microsoft SharePoint 2010

Learn about the powerful performance improvement in SharePoint 2010, large list resource throttling, unattached content database recovery options, and how to use the SharePoint Best Practices Analyzer.


Hi  I am a newbie for data mining. As part of a project I need to categorise a set of customers of a grocery based on their age, gender, and average spending. I believe I should use the Clustering algorithm. I created a mining model a structure and a cube as well from the existing data base. But i can't get much further than that. What kind of queries should i write to "cluster" the customers and get their relevant clusters??  

Would you use clustering to find documents similar to this one?

Hi, I am taking a BI Developer course and enrolled at a school where the teacher knows nothing about data mining. So I designed a project for myself and am trying to surmount the curve without the benefit of a mentor. Please have patience with me. I have a database full of documents where the entire text resides in a single field (nvarchar(max)) I want to find documents that are similar to the one I pick. I am not sure what approach I should take to get there..         1) create clusters for the entire database and then see what cluster my document is in OR                 2) some-how train a model on the single document and then let the DM engine go find the matches.   I have tried approach 1, but the similarity between the documents is not very high (at least in the few of thousands I looked at) I do not see how to do approach 2, unless I cluster with a test set size of 1, and that doesnt seem right.   Is clustering even the way to go?   Thanks, struggling in Austin

Clustering on cube slices

Hi, I would like to use the clustering algorithm "seperately" on each cube slice.  The problem description: Having many employes and their arrival-to-work time I created a cube with a fact table and 3 dimensions: Employee, Time, Office and I would like to run the clustering algorithm seperately for each employee to receive his arrival-to-work clusters and to find his exceptions e.g., for the employee John who has the following arrival time records: 08:05, 07:55, 8:10, 8:07, 10:30, 10:31, 10:28, 15:00 I want to receive two clusters, the first one will include  08:05, 07:55, 8:10, 8:07 The second one will include 10:30, 10:31, 10:28 (and the exception will be 15:00) Having many employees I would like to create one data mining model and to use the cube slice and dice options    Searching the web and the MSDN I didn't find whether and how it can be done - I will very appreciate your help   Thanks in advance, Lora

SQL 2008 R2 Full Clustering

I was recently informed during a Microsoft Roadmap meeting that SQL2008R2 can now be fully clustered. That is full load balancing across SQL servers not just Failover. However, having come away from the meeting and done some investigation I cannot find any references as to how to setup SQL2008R2 in anything other than a failover cluster. My question is ... Is SQL 2008 R2 fully clusterable ... and if Yes where can I find some documentation helping with its setup ?   Thanks in advance Derek

20,000 foot view: Sql Server clustering vs. Windows OS Clustering

I read that Sql Server Failover requires Windows Sevrer clustering to be in place first. (The former builds on the latter). Why is this the case? In other words, what does "sql server clustering" bring to the mix  that normal Windows clustering doesn't supply? TIA, Barkingdog  

Clustering of Sql server

Hi Everybody, please answer this questions this will be very helpful to me     1. discuss at a high level how to add a new node to an existing SQL cluster in both SQL 2008 and SQL 2005. Begin with SQL 2005.   2. You are a DBA.  The SAN Admin has provisioned a LUN on the SAN and presented it to the nodes and made it clustered storage. At a high level, in either 2005 or 2008 walk through adding the new storage to the SQL instance and what is very important not to forget?   3. Beginning in 2005, there is a SERVERPROPERTY we can now use in T-SQL to discover which node the SQL instance is running on?     Thank you Regards rcnj

SQL clustering 2008

While going to install sql2008 in 2008 OS sp1 unable to install Error " Managed SQL Server Landing Page has stopped Working"

Troubleshooting IIS 7 network performance issues and TCP Chimney Offload, Receive Side Scaling, and

There is a lot of posts on http://forums.iis.net related to network performance.  Actually, there was two today!.  The problems can be different, but the common thread seems to be network performance.  Windows Server 2008 (and R2) enabled a new network feature by default which has been referred to as "Scalable Networking Pak".  Some people refer to the feature as TCP Chimney Offload.  Either way, in my experience this feature causes more issues than it solves.  If you are having a network related issue or performance, this is a easy setting to check and verify if disabling portions or all of them can resolve the issue.   KB article on TCP Chimney Offloadhttp://technet.microsoft.com/en-us/network/dd277645.aspx KB Article how to show your settings and disablehttp://support.microsoft.com/kb/951037 I strongly encourage test these changes in a non-production environment before making changes to your production systems! Enjoy, Steve SchofieldMicrosoft MVP - IIS

Getting Started -> clustering

Hello All,   We currently have the following:   SERVER A2000 with SQL Server 2000 SERVER B2005 with SQL Server 2005 SERVER C2005 with SQL Server 2005   SERVER B2005 is our research database and currently has a growing number of survey-based applications that each has its own database {SurveySystem1, SurveySystem2, SurveySystem3, SurveySystem4, etc...} ..... each of these applications are C# .net applications.   Over time we have noticed that if one of the SurveySystem applications (for example: SurveySystem2) has a large simultaneous response (100+ participants all responding to a survey at the same time), the SurveySystem2 website application will slow down and some participants will not be able to complete the survey.   We think the problem is the SQL Server 2005 database... and that it is not able to handle that many simultaneous users.  So, we are thinking of upgrading (BOTH to 2008 AND to a clustered environment).....   QUESTION: can someone give me an overview of: (1)What we will need to move to this new environment (software + hardware); (2)Do you think this will fix the problems that the participants are experiencing, or do you think the bottleneck is 'more likely' somewhere else? (3)Any words of caution?   thanks!  

Open SQL Server Connection Troubleshooting

Hello, This is regarding ASP.Net (VB) 2.0 and SQL Server 2008.  My project's (there is only one in my solution) has a "Start Action" set to a "Specific Page" (..\Forms\frmMain.aspx).  Occasionally (though not always) a large number of connections (30+) will be opened prior to the frmMain.PreInit event.  These connections stay open for quite some time.  I am closing all of my connections with extreme prejudice.  In my "finally" clause of my try...catch I have myconnection.close.  Immediately after the "End Try" I have myconnection.dispose (redundant, I know).  I have accounted for all connections.  I placed a breakpoint on frmMain.PreInit and then (sometimes) a large number of connections (used SSMS to run sp_who and sp_who2) will have just opened.  What would open a large number of connections prior to the starting page's preinit event?  I am closing (and then disposing) all of my connections.  I thought that I must be missing a myconnection.close in the "finally" clause, but I have looked repeatedly and cannot find anywhere that a connection is open and then not closed.  Also, I do not believe that I have even opened a connection prior to the frmMain's preinit event.        

In windows server 2008 standard edition feature Failover clustering is not looking

In windows server 2008 standard edition feature Failover clustering is not looking.Yet microsoft is telling that we give 2 node cluster support on 2008 server standard edition.Therefore I have suggested the company to buy it and now I am fixed due to this.  Please Help  "SQLSERVER DBA" "INDIA"

SQL Server 2008 R2 Clustering Questions?

Hi All, I have got bit Idea for my question from http://social.msdn.microsoft.com/Forums/en-US/sqlsetupandupgrade/thread/bff2b555-f25e-4644-a58f-264611818971 I have several questions 1. We have two Serves with Different Configuration (Server Model, CPU, Memory, etc.). Can we do Active-Active Failover Clustering on the same? 2. Can we do Database Level Clustering in SQL Serve 2008 R2 3. Where I will get Documentation for Clustering SQL Serve 2008 R2? Thanks, Ashish K India  

Troubleshooting an XSL Select to another List in a Dataview.

I've done this before to join in some column from another List into a dataview.    I've looked over the two list and  this line of code for a few hours now. It's producing no output, when I know there are matches. <TD class="{$IDASV40H}">    <xsl:value-of select="/dsQueryResponse/Applicant/Rows/Row[@ID = current()/@ApplicantID]/@AName"/></TD> None of the colums or lists have been renamed. None of the columns have spaces in the names. I want to make sure I'm reading this right.  do I need to define current()? Any bood way to troubleshoot this in Designer? any issue with trying to compare @ID? Thanks.

Is there any article or webcast for how to set up a SQL Server Clustering in Hyper-V environment?

I have already set up a Windows Server 2008 R2 Enterprise x64 with Hyper-V installed for trying out different features in SQL Server.  I'm interesting in trying out SQL Server Clustering.  I have only set up Windows 7 Enterprise x64, Windows 7 Pro x64,  and Windows XP PRO SP2 x86 VMs.  Can I use this VMs for SQL Server 2005 or 2008 Clustering?  Is there any article or webcast for how to set up a SQL Server Clustering in Hyper-V environment?


Hi Team,   can any body please guide me how can i install clustering in MS SQL SERVER 2008   What are requirements we need. to check before installing      subu
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend