Wednesday, March 7, 2012
Connection to Lan fails and locks server
We have two nodes in a sql cluster. The "Lan" connection on one of the
servers fails at different times and I can't track down the problem and I am
not sure where to start.
I have changed NIC's Cables, Switches and still no luck..
Any suggestions where to start would be appreciated.
Thanks
Firmware? BIOS? Drivers? Called the vendors?
Cheers,
Rod
MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering
http://msmvps.com/clustering - Blog
"James" <James@.discussions.microsoft.com> wrote in message
news:C32C79C1-AE2F-4F80-B425-F038C789D0F8@.microsoft.com...
> Morning,
> We have two nodes in a sql cluster. The "Lan" connection on one of the
> servers fails at different times and I can't track down the problem and I
> am
> not sure where to start.
> I have changed NIC's Cables, Switches and still no luck..
> Any suggestions where to start would be appreciated.
> Thanks
|||Actually we had a DELL rep come out and set this up because we did not want
to mess with the SAN LUN's. He couldn't figure it out either. I will take a
look at the BIOS. We are running a Win 2003 with sql 2000 cluster.
I noticed earlier that Network DTC was not installed on both servers so I
installed that see if maybe that will make a difference.
"Rodney R. Fournier [MVP]" wrote:
> Firmware? BIOS? Drivers? Called the vendors?
> Cheers,
> Rod
> MVP - Windows Server - Clustering
> http://www.nw-america.com - Clustering
> http://msmvps.com/clustering - Blog
> "James" <James@.discussions.microsoft.com> wrote in message
> news:C32C79C1-AE2F-4F80-B425-F038C789D0F8@.microsoft.com...
>
>
|||"James" <James@.discussions.microsoft.com> wrote in message
news:9E080491-54A2-43AF-9E79-45B388030ACE@.microsoft.com...
> Actually we had a DELL rep come out and set this up because we did not
want
> to mess with the SAN LUN's. He couldn't figure it out either. I will
take a
> look at the BIOS. We are running a Win 2003 with sql 2000 cluster.
>
To ask the obvious... SP3a installed?
[vbcol=seagreen]
> I noticed earlier that Network DTC was not installed on both servers so I
> installed that see if maybe that will make a difference.
> "Rodney R. Fournier [MVP]" wrote:
the[vbcol=seagreen]
and I[vbcol=seagreen]
|||SP3 A is installed. Server failed again after 3 day. Network cards pass all
test? I will post some logs see if anyone has seen it before.
"Greg D. Moore (Strider)" wrote:
> "James" <James@.discussions.microsoft.com> wrote in message
> news:9E080491-54A2-43AF-9E79-45B388030ACE@.microsoft.com...
> want
> take a
> To ask the obvious... SP3a installed?
>
> the
> and I
>
>
|||Ok Here is the Cluster Log as soon as it fails I cannot figure this out. We
have had this problem for 3 weeks now, the amount of time it takes to fail
varies. Any help would be appreciated.
000003c0.00000508::2004/12/30-14:53:44.063 INFO [NM] Reporting connectivity
to leader for network 4acd10cf-f965-42a4-b597-14d61d286b4c.
000003c0.00000508::2004/12/30-14:53:44.063 INFO [NM] Connectivity report
completed successfully for network 4acd10cf-f965-42a4-b597-14d61d286b4c.
000003c0.00000508::2004/12/30-14:53:44.063 INFO [NM] Connectivity report
worker thread finished.
000003c0.00000804::2004/12/30-14:53:46.531 INFO [GUM] s_GumUpdateNode:
dispatching seq 8884type 2 context 15
000003c0.00000804::2004/12/30-14:53:46.531 INFO [NM] Received update to set
state for network 4acd10cf-f965-42a4-b597-14d61d286b4c.
000003c0.00000804::2004/12/30-14:53:46.547 WARN [NM] Interface
8a0a2f09-80e0-46a1-ae1f-663f765f414b is unreachable (node: Server1, network:
LAN).
000003c0.00000804::2004/12/30-14:53:46.547 WARN [NM] Interface
09b7cff6-2020-43ba-bb7e-23f36d09f7c4 is unreachable (node: Server2, network:
LAN).
000003c0.00000804::2004/12/30-14:53:46.547 WARN [NM] Network
4acd10cf-f965-42a4-b597-14d61d286b4c (LAN) is down.
000003c0.00000804::2004/12/30-14:53:46.547 INFO [GUM] s_GumUpdateNode:
completed update seq 8884type 2 context 15
000003c0.00000804::2004/12/30-14:53:50.405 INFO [NM] Received request to get
online address enum for interface 09b7cff6-2020-43ba-bb7e-23f36d09f7c4.
000003c0.00000804::2004/12/30-14:53:50.499 INFO [NM] Found address
10.40.0.91 for interface 09b7cff6-2020-43ba-bb7e-23f36d09f7c4.
000003c0.00000804::2004/12/30-14:53:50.499 INFO [NM] Received request to get
ping address enum for interface 09b7cff6-2020-43ba-bb7e-23f36d09f7c4.
000003c0.00000804::2004/12/30-14:53:50.515 INFO [NM] Received request to
ping targets for interface 09b7cff6-2020-43ba-bb7e-23f36d09f7c4.
000003c0.00000804::2004/12/30-14:53:50.515 INFO [NM] Pinging targets for
interface 09b7cff6-2020-43ba-bb7e-23f36d09f7c4.
000003c0.00000804::2004/12/30-14:53:50.515 INFO [NM] Pinging host 10.40.0.1
000003c0.00000804::2004/12/30-14:53:54.139 INFO [NM] Ping of host 10.40.0.1
failed.
000003c0.00000804::2004/12/30-14:53:54.139 INFO [NM] Pinging host 10.40.0.182
000003c0.00000804::2004/12/30-14:53:58.138 INFO [NM] Ping of host
10.40.0.182 failed.
000003c0.00000804::2004/12/30-14:53:58.138 INFO [NM] Pinging host 10.40.0.2
000003c0.00000804::2004/12/30-14:54:02.138 INFO [NM] Ping of host 10.40.0.2
failed.
000003c0.00000804::2004/12/30-14:54:02.138 INFO [NM] Pinging host 10.40.0.7
000003c0.00000804::2004/12/30-14:54:06.137 INFO [NM] Ping of host 10.40.0.7
failed.
000003c0.00000804::2004/12/30-14:54:06.137 INFO [NM] Pinging host 10.40.0.39
000003c0.00000804::2004/12/30-14:54:10.136 INFO [NM] Ping of host 10.40.0.39
failed.
000003c0.00000804::2004/12/30-14:54:10.136 INFO [NM] Finished pinging
targets for interface 09b7cff6-2020-43ba-bb7e-23f36d09f7c4.
000003c0.00000688::2004/12/30-14:54:10.136 INFO [GUM] s_GumUpdateNode:
dispatching seq 8885type 2 context 15
000003c0.00000688::2004/12/30-14:54:10.136 INFO [NM] Received update to set
state for network 4acd10cf-f965-42a4-b597-14d61d286b4c.
000003c0.00000688::2004/12/30-14:54:10.136 INFO [NM] Interface
8a0a2f09-80e0-46a1-ae1f-663f765f414b is up (node: Server1, network: LAN).
000003c0.00000688::2004/12/30-14:54:10.136 WARN [NM] Interface
09b7cff6-2020-43ba-bb7e-23f36d09f7c4 failed (node: Server2, network: LAN).
000003c0.00000688::2004/12/30-14:54:10.136 WARN [NM] Network
4acd10cf-f965-42a4-b597-14d61d286b4c (LAN) is up.
000003c0.00000688::2004/12/30-14:54:10.136 INFO [GUM] s_GumUpdateNode:
completed update seq 8885type 2 context 15
"James" wrote:
> Morning,
> We have two nodes in a sql cluster. The "Lan" connection on one of the
> servers fails at different times and I can't track down the problem and I am
> not sure where to start.
> I have changed NIC's Cables, Switches and still no luck..
> Any suggestions where to start would be appreciated.
> Thanks
Tuesday, February 14, 2012
Connection still apperas in SQLServer Entreprise Manager over Locks / process ID
i have a doubt here, after a close the connection, i still can see the last stored procedure active in the LOCKS/PROCESSID in enterprise manager of SQL SERVER.
I think i'm closing the connection well
Try
IfMe.ID > 0Then
Dim strSqlAsString = "SP_CHANGECLASSCONTENTS"
Dim sqlcommandAsNew SqlCommand(strSql,New SqlConnection(ConnStr))
sqlcommand.CommandType = CommandType.StoredProcedure
sqlcommand.Parameters.Add("@.PerformActivation", SqlDbType.Bit).Value = 0
sqlcommand.Parameters.Add("@.PerformInactivation", SqlDbType.Bit).Value = 0
sqlcommand.Parameters.Add("@.PerformDelete", SqlDbType.Bit).Value = 1
sqlcommand.Parameters.Add("@.PerformUndelete", SqlDbType.Bit).Value = 0
sqlcommand.Parameters.Add("@.PermanentDelete", SqlDbType.Bit).Value = CBit(PermanentDelete)
sqlcommand.Parameters.Add("@.Class_ID", SqlDbType.Int).Value = _id
sqlcommand.Connection.Open()
sqlcommand.ExecuteNonQuery()
sqlcommand.Connection.Close()
Else
Err.Raise(10205, "CLASS", "CLASS ID is empty")
EndIf
Catch exAs Exception
_err = ex.Message
Return Err.Number
EndTry
Hi,
.NET Framework SQl data provider utilizes database connection pooling (there's one pool per unique connection string). When you close a SqlConnection, it is returned to this pool (there are min amount of connections in the pool ) and the hard connection to the db is not necessarily closed (connection ).
E.g this way usage of connections is kept efficient and opening & closing of "real connections" is kept minimum.
Here's more details
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/cpguide/html/cpconconnectionpoolingforsqlservernetdataprovider.asp
but what if i use many procedures like this one several times, and each one creates it's own connection. Even if i close the connection well it still appears several processes concerning this procedures in SQLSERVER. does this degrades the performance ?
tks|||
Hi,
see the previous link for exact details.
Anyways, it happens within the limits of the connection pool. If there are free connections in the pool, they are utilized to fullfill those which you instantiate and run e.g even if you instantiate new connections in code, the pool might be able to deal with them without increasing its size (the actual pooled connections are of type SqlInternalConnection not those which SqlConnection objects which you instantiate).
If the pool cannot deal with new connection requests, it starts creating new ones (within the max limit of the pool). If max limit is reached then new connection requests are queued. Note also that after a burst usage of connections, they are also dropped from the pool to the mimum limit when lifetime has expired or connectiion is severed.
E.g the pools are there to keep connection count in control in situation like these.