March 27, 2014 at 3:29 pm
So I created Cluster log and last data are from 25.3 🙁
March 27, 2014 at 3:42 pm
I found something, but it looks like information about operation.
Log Name: Microsoft-Windows-FailoverClustering/Operational
Source: Microsoft-Windows-FailoverClustering
Date: 21. 3. 2014 18:09:40
Event ID: 1201
Task Category: Resource Control Manager
Level: Information
Keywords:
User: SYSTEM
Computer: NameOfServer
Description:
The Cluster service successfully brought the clustered service or application 'MES-SQL-CL' online.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="Microsoft-Windows-FailoverClustering" Guid="{BAF908EA-3421-4CA9-9B84-6689B8C6F85F}" />
<EventID>1201</EventID>
<Version>0</Version>
<Level>4</Level>
<Task>3</Task>
<Opcode>0</Opcode>
<Keywords>0x4000000000000000</Keywords>
<TimeCreated SystemTime="2014-03-21T17:09:40.906587700Z" />
<EventRecordID>627</EventRecordID>
<Correlation />
<Execution ProcessID="2140" ThreadID="9552" />
<Channel>Microsoft-Windows-FailoverClustering/Operational</Channel>
<Computer> NameOfServer</Computer>
<Security UserID="S-1-5-18" />
</System>
<EventData>
<Data Name="ResourceGroup">MES-SQL-CL</Data>
</EventData>
</Event>
Log Name: Microsoft-Windows-FailoverClustering/Operational
Source: Microsoft-Windows-FailoverClustering
Date: 21. 3. 2014 18:09:41
Event ID: 1201
Task Category: Resource Control Manager
Level: Information
Keywords:
User: SYSTEM
Computer: NameOfServer
Description:
The Cluster service successfully brought the clustered service or application 'SQL Server (MSSQLSERVER)' online.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="Microsoft-Windows-FailoverClustering" Guid="{BAF908EA-3421-4CA9-9B84-6689B8C6F85F}" />
<EventID>1201</EventID>
<Version>0</Version>
<Level>4</Level>
<Task>3</Task>
<Opcode>0</Opcode>
<Keywords>0x4000000000000000</Keywords>
<TimeCreated SystemTime="2014-03-21T17:09:41.270688400Z" />
<EventRecordID>628</EventRecordID>
<Correlation />
<Execution ProcessID="2140" ThreadID="8428" />
<Channel>Microsoft-Windows-FailoverClustering/Operational</Channel>
<Computer> NameOfServer</Computer>
<Security UserID="S-1-5-18" />
</System>
<EventData>
<Data Name="ResourceGroup">SQL Server (MSSQLSERVER)</Data>
</EventData>
</Event>
March 27, 2014 at 3:51 pm
So what do you think about that I will try function of Failover Clustering during weekend?
March 27, 2014 at 5:03 pm
tony28 (3/27/2014)
Ok Now I will do log, after finish I will send..do you think that is good this setting from your experience ? Auto restart SQL Server if it stops unexpectedly
I am thinking about this and maybe it is better that SQL server will be restart than frozen or something.
True. But it's good to document the setting so that you are aware of that and will help you with troubleshooting in the future.
http://technet.microsoft.com/en-us/magazine/gg313742.aspx
And please can you explain me something ?
SQL Server may stop unexpectedly due to different reasons :
Memory leaks from a process within the SQL Server memory space, such as from an extended stored procedure or from OLE automation.
and so is not missing the problem with Failover Clustering here ? Because you said 3 reasons, but from this log I see that problem was with Cluster.
Thank you.
I was mentioning about the possible reasons for that SQL server failure. And they are not the only reasons. Could be something else too ..
Check this for more info Memory Leaking
http://mssqlwiki.com/2012/12/04/sql-server-memory-leak/
Cluster Log could be helpful in finding the actual reason.
--
SQLBuddy
March 27, 2014 at 5:04 pm
tony28 (3/27/2014)
I found something, but it looks like information about operation.Log Name: Microsoft-Windows-FailoverClustering/Operational
Source: Microsoft-Windows-FailoverClustering
Date: 21. 3. 2014 18:09:40
Event ID: 1201
Task Category: Resource Control Manager
Level: Information
Keywords:
User: SYSTEM
Computer: NameOfServer
Description:
The Cluster service successfully brought the clustered service or application 'MES-SQL-CL' online.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="Microsoft-Windows-FailoverClustering" Guid="{BAF908EA-3421-4CA9-9B84-6689B8C6F85F}" />
<EventID>1201</EventID>
<Version>0</Version>
<Level>4</Level>
<Task>3</Task>
<Opcode>0</Opcode>
<Keywords>0x4000000000000000</Keywords>
<TimeCreated SystemTime="2014-03-21T17:09:40.906587700Z" />
<EventRecordID>627</EventRecordID>
<Correlation />
<Execution ProcessID="2140" ThreadID="9552" />
<Channel>Microsoft-Windows-FailoverClustering/Operational</Channel>
<Computer> NameOfServer</Computer>
<Security UserID="S-1-5-18" />
</System>
<EventData>
<Data Name="ResourceGroup">MES-SQL-CL</Data>
</EventData>
</Event>
Log Name: Microsoft-Windows-FailoverClustering/Operational
Source: Microsoft-Windows-FailoverClustering
Date: 21. 3. 2014 18:09:41
Event ID: 1201
Task Category: Resource Control Manager
Level: Information
Keywords:
User: SYSTEM
Computer: NameOfServer
Description:
The Cluster service successfully brought the clustered service or application 'SQL Server (MSSQLSERVER)' online.
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
<System>
<Provider Name="Microsoft-Windows-FailoverClustering" Guid="{BAF908EA-3421-4CA9-9B84-6689B8C6F85F}" />
<EventID>1201</EventID>
<Version>0</Version>
<Level>4</Level>
<Task>3</Task>
<Opcode>0</Opcode>
<Keywords>0x4000000000000000</Keywords>
<TimeCreated SystemTime="2014-03-21T17:09:41.270688400Z" />
<EventRecordID>628</EventRecordID>
<Correlation />
<Execution ProcessID="2140" ThreadID="8428" />
<Channel>Microsoft-Windows-FailoverClustering/Operational</Channel>
<Computer> NameOfServer</Computer>
<Security UserID="S-1-5-18" />
</System>
<EventData>
<Data Name="ResourceGroup">SQL Server (MSSQLSERVER)</Data>
</EventData>
</Event>
Could you attach the log file ?
--
SQLBuddy
March 27, 2014 at 5:57 pm
sqlbuddy123 (3/27/2014)
True. But it's good to document the setting so that you are aware of that and will help you with troubleshooting in the future.
I know but I didnt install server, but with external . I am not directly DBA..we dont have,but only I have some knowledge and experience about SQL... I am doing in my freetime, because i am interesting in SQL 🙂
I was mentioning about the possible reasons for that SQL server failure. And they are not the only reasons. Could be something else too ..
Check this for more info Memory Leaking
http://mssqlwiki.com/2012/12/04/sql-server-memory-leak/
Cluster Log could be helpful in finding the actual reason.
--
SQLBuddy
thank you I will check
and
I checked my data from Data collection. I saw for tempdb from 13 march from 10MB/sec was progresivelly increased to 19-20MB/sec to this crash time. I didnt check before 13.march, because I created Data collection in this date
I checked now for last 24hours and it is about 1-2MB/sec and for yesterday 24hours and it was 2-4MB/sec
So it looks like next problem with temporary database.
March 27, 2014 at 6:12 pm
sqlbuddy123 (3/27/2014)
Could you attach the log file ?
--
SQLBuddy
I found according to this http://windowsitpro.com/windows-server-2012/troubleshooting-windows-server-2012-failover-clusters
in attachment is log
March 28, 2014 at 8:13 am
tony28 (3/27/2014)
I found according to this http://windowsitpro.com/windows-server-2012/troubleshooting-windows-server-2012-failover-clusters
in attachment is log
Unfortunately, nothing much logged in this log too ..
--
SQLBuddy
Viewing 8 posts - 16 through 22 (of 22 total)
You must be logged in to reply to this topic. Login to reply