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


Top 5 Contributors of the Month
Sharon Maxwell
Post New Web Links

What processes will delay the SQL server failover process

Posted By:      Posted Date: September 24, 2010    Points: 0   Category :Sql Server
 

Hi,

We have an Active-Active-Passive setup. We have two SQL instances namely SQL1 and SQL2. When we tried to failover, SQL1 SQL resource is taking more than 2 Minutes to failover where as the other one is failing over in fraction of sec. We are facing this issue from last two days. Before that it's working fine.

We have checked whether there are any backups running which might delay the failover process, but no backups running. We have checked the DNS response time and it's very quick(same as the case of SQL1). There is very minimal IO activity on the SAN(SQL2 IO activity is more than the SQL1). Ther were no patches applied recently.

Following is our production environment.

OS             : Windows 2008 X64 bit

SQL           : SQL 2008 x64 bit Ent Edition

Noof CPUs : 4 (Intel quad core)

RAM          : 64 GB RAM

SAN          : HP EVA4450

Please let me know the factors which will delay the SQL failover process.




View Complete Post


More Related Resource Links

CI Server: Redefine Your Build Process with Continuous Integration

  

Jay Flowers demonstrates how to set up and use a Continuous Integration server using both discrete tools and the more comprehensive CI Factory solution.

Jay Flowers

MSDN Magazine March 2008


What is BPEL4WS?: Build Better Business Processes with Web Services in BizTalk Server 2004

  

In this article the author focuses on one critically important Web services specification that has been largely overlooked: the Business Process Execution Language for Web Services (BPEL4WS, or BPEL). He describes why BPEL is important and what it offers you if you are implementing Web services today or planning to in the future. Concrete examples using BizTalk Server 2004 are presented in the article.

Jon Fancey

MSDN Magazine March 2005


Failed to generate a user instance of SQL Server due to failure in starting the Process for the User

  
Could someone help with this please? I'm using VWD 2010 to build a new web site - I tried to add a new database file but it won't do it. I started by clicking on the folder 'App_Data', then right clicking and selecting 'Add new item' - after that I tried to add an SQL Server Database but received this message...  'Failed to generate a user instance of SQL Server due to failure in starting the Process for the User Instance' What does this mean? How do I start the 'Process for the User Instance'?  I imagined all that was done for me at the install stage, when I installed VWD2010, but it appears not.  Thank you for any help at all.    Regards

System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> Object canno

  
hello,i am using a web servicewrtitten in .net and i access the webservice from my wepApplication i get this error System.Web.Services.Protocols.SoapException: Server was unable to process request. ---> Object cannot be cast from DBNull to other types.my code is access webservice: protected void btnSave_Click(object sender, EventArgs e)        {            int intStatusCode;            dtProjectStatus = (DataTable)ViewState["dtProjectStatus"];            try            {                objService.Credentials = System.Net.CredentialCache.DefaultCredentials;                if(dtProjectStatus.Rows.Count>0)                {                  intStatusCode = objService.InsertTest(dtProjectStatus);                }   

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"

System.Diagnostics.Process.Start not work with IIS, but on ASP.NET Development Server

  
System.Diagnostics.Process.Start not work with IIS, but on ASP.NET Development Server 

SQL server 2008 failover cluster install

  
Hello all, Looking for the definitive answer with supporting documentation (link). Does a SQL server 2008 cluster have to be installed as or run as a domain service account or can local accounts be used?  I looked for a document that stated yes or no and could not find one. If anyone can provide info it would be much appreciated. Have all ready looked at these 2 links of interest. http://msdn.microsoft.com/en-us/library/ms143504.aspx#Service_SID http://technet.microsoft.com/en-us/library/cc731002(WS.10).aspx Thanks in advance,  

Server failed with error code 0xc0000000 to spawn a thread to process a new login or connection

  
Hello All, Suddenly, the sql server is down, in the log file, C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG, I found the record as follows, 2007-03-05 15:40:31.59 Logon       Error: 17189, Severity: 16, State: 1.2007-03-05 15:40:31.59 Logon       SQL Server failed with error code 0xc0000000 to spawn a thread to process a new login or connection. Check the SQL Server error log and the Windows event logs for information about possible related problems. [CLIENT: 172.21.123.48] What else I can do to further investigate? Thanks Spencer

SQL Server 2000, or SQL Server 2005 failover clusters on the 32-bit subsystem (WOW64)

  
Hi All I don't know what is WOW64,some where I read "SQL Server 2000, or SQL Server 2005 failover clusters on the 32-bit subsystem (WOW64)" In my environment SQL Server 2000 version is "Microsoft SQL Server  2000 - 8.00.2282 (Intel X86)   Dec 30 2008 02:22:41   Copyright (c) 1988-2003 Microsoft Corporation  Enterprise Edition on Windows NT 5.2 (Build 3790: Service Pack 2) " is it same ?? How find out my environment is WOW or NOT. Thanks in advance          SNIVAS

Uninstall of SQL2008 Standard failover server failed

  
Tried to uninstall SQL2008 Standard cluster server via add/remove and failed. The message is "The SQL Server failover cluster instance name '' could not be found as a cluster resource. Please provide help on it.

Failed to generate a user instance of SQL Server due to a failure in starting the process for the us

  
Hello,Failed to generate a user instance of SQL Server due to a failure in starting the process for the user instance. The connection will be closed. I'm using SQLServer2005 and VWD2010. Did the following below but to no avail. 1.) I have set SQL SERVER (SQLEXPRESS) built-in account to "Local System" at SQL Server Configuration Manager. Restart.  2.) Couldn't find the folder "SQLEXPRESS" at Vista c://Users/[username]/appdata/local/microsoft/microsoft sql server. Is there anything else I miss before doing my last resort? FORMAT my pc and hope it will work the next time.I'm using SQLServer2005 and VWD2010. I Did the following below but to no avail.1.) I have set SQL SERVER (SQLEXPRESS) built-in account to "Local System" at SQL Server Configuration Manager. Restart. 2.) Couldn't find the folder "SQLEXPRESS" at Vista c://Users/[username]/appdata/local/microsoft/microsoft sql server.Is there anything else I miss before doing my last resort? FORMAT my pc and hope it will work the next time.Thank You,-imperialx

COM Server process compiled with /clr option doesn't unload itself from memory when last COM client

  
I created Visual C++ ATL project in VS2010, exe type, imlemented COM object, then added /clr option to project. Project uses other C# dlls (WCF service). When last COM client disconnects and last COM object instance destroys, WCF service stopped, my COM server process doesn't unload itself from memory. All managed threads in C# dll are background, COM object doesn't create threads. How can I unload server process? Thank you in advance. 

C# COM Client to Existing C++ out-of-process COM Server

  
I'm reposting this question since I've been having some problems with my MSDN subscription, hoping I might have some better assistance now that aforementioned problems seem to have been resolved. I'm trying to connect a COM client written in C# to an existing (legacy) out-of-process COM server written in C++. I have imported the tlb using tlbimp.exe and have referenced the RWC in my project. I can connect to the COM server using object scComm32ComObj = Marshal.GetActiveObject("ScComm32.Document"); But that is as far as I am able to get. I need to be able to call some methods on the ScComm32CommObj, but trying to cast it to an interface or a class usign the interface results in an exception. Thanks, Bill

Issues with Kerberos and SQL Server failover-cluster

  
I have a dual-instance SQL 2008 SP1 2-node Failover-cluster running on Server 2008 x64 SP2. SPNs have been manually created in AD for the service account running SQL Server (on both nodes).When the cluster nodes first boot up and the virtual groups come online, everything works flawlessly. I have linked server connections set up between the two instances of SQL server, with one instance running on each node. I can successfully make linked server connections from one instance to another from a third client PC, indicating Kerberos is working successfully, which is great!Problem is, this all stops working as soon as one of the SQL cluster groups fails over (or is taken offline, and moved to the other node). As soon as this happens, all authentications seems to fall back to NTLM. Of course, running both instances on the same physical node will work since Kerberos is not required for this. But as soon as an instance moves to another node - kerberos seems to be permenantly broken for that instance, even if moved back to its original node, until both nodes are rebooted again.One thing to note - the service account running SQL server is not a domain admin. This of course prevents SQL server from auto-registering the SPN upon startup and generates the following in the SQL log: "The SQL Server Network Interface library could not register the Service Principal Name (SPN) for the SQL

The SQL Server failover cluster instance name 'Server02' already exists as a clustered resource. S

  
Hello, I have a node of 2 servers of Win 2008 R2 Enterprise and trying to install a 2nd instance in a SQL 2008 R2 Cluster. I had SQL_INSTANCE2 previously installed that I removed from the two nodes. Now when I attempt to install it again from scratch, in setup GUI where I specify the SQL Server Network Name and enter the previously entered name "Server02", I get a failure in the setup with the following error message: "The SQL Server failover cluster instance name 'Server02' already exists as a clustered resource. Specify a different failover cluster instance name." How do I fix this problem, I don't want to enter a new name like "Server03" in order to proceed with the setup, because when I do enter "Server03" the setup does continue without an error message. So what am I missing? Do I have to ask the DNS administrator to see if there's an A record for "Server03" and have him delete it so that the setup works? Or the fix is by doing something else? I would appreciate any help. Thank you  

SQL server 2008R2 install on a server 2008 R2 failover cluster. Other resources won't failover to o

  
As the subject says, I've built a fresh install w2k8r2 and sql2k8r2 failover cluster. Sql works fine on the primary node, but when I test a failover it breaks. Specifically, if I were to stop the node1 cluster service (causing the cluster to switch to node2), windows changes the cluster DNS appropriatly and moves the shared storage just fine, but sql server doesn't failover.  Server Name, Disk Drives and Other Resources all go offline. I've verified that the advanced policies of the server name, IP, cluster drives all have both nodes checked as possible owners However, Other resources only lists node1 as a possible owner and there appears to be no way to add node2.  Under the Other resources, SQL Server and SQL Server Agent are listed. I'm sorta stumped, I've been combing the forums and have found similar issues, but nothing seems to explain why the two resources won't failover.

SQL Server 2005 Cluster failover issue

  
Hi All, I'm fequently experience Cluster failover issue. The cluster tries to failover and it fails back. Because of this the SQL server is getting restarted and this is a bugging issue during business hours. The following are the System event logs, Cluster resource 'SQL Server' in Resource Group 'Production' failed. The SQL Server Agent (MSSQLSERVER) service was successfully sent a stop control. The SQL Server Agent (MSSQLSERVER) service entered the stopped state. The SQL Server (MSSQLSERVER) service was successfully sent a stop control. The SQL Server (MSSQLSERVER) service entered the stopped state. The SQL Server (MSSQLSERVER) service was successfully sent a start control. The SQL Server (MSSQLSERVER) service entered the running state. The Cluster Service brought the Resource Group "Production" online.    The following are the application event logs, The client was unable to reuse a session with SPID 131, which had been reset for connection pooling. This error may have been caused by an earlier operation failing. Check the error logs for failed operations immediately before this error message. [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed [sqsrvres] printODBCError: sqlstate = HYT00; native error = 0; message = [Microsoft][SQL Native Client]Query timeout expired [sqsrvres] OnlineThread: QP is not online. The client was unable
Categories: 
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