Viewing 15 posts - 136 through 150 (of 245 total)
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 27, 2014 at 6:12 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...
March 27, 2014 at 5:57 pm
So what do you think about that I will try function of Failover Clustering during weekend?
March 27, 2014 at 3:51 pm
I found something, but it looks like information about operation.
Log Name: Microsoft-Windows-FailoverClustering/Operational
Source: Microsoft-Windows-FailoverClustering
Date: ...
March 27, 2014 at 3:42 pm
So I created Cluster log and last data are from 25.3 🙁
March 27, 2014 at 3:29 pm
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...
March 27, 2014 at 3:13 pm
GilaMonster (3/27/2014)
tony28 (3/26/2014)
It is not possible to buy...
March 27, 2014 at 1:13 am
GilaMonster (3/27/2014)
I've seen 10, I've seen 50000. You can't compare that number to someone else, it's about your specific workload.
Yes, I was thinking about it. Is any way how to...
March 27, 2014 at 12:56 am
Thank you, good job, very helpful and thanks for experience. I know that this option is in SQL server, but i wouldn't remember in that time
So Service state is both...
March 27, 2014 at 12:43 am
free_mascot (3/26/2014)
What is transactions/sec on your server/database?
I used this and about 750-850
DECLARE @cntr_value bigint
SELECT @cntr_value = cntr_value
FROM sys.dm_os_performance_counters
WHERE counter_name LIKE 'Transactions/sec%'
AND instance_name LIKE '_Total%'
WAITFOR DELAY '00:00:01'
SELECT cntr_value - @cntr_value
FROM sys.dm_os_performance_counters
WHERE...
March 26, 2014 at 11:03 pm
ramana3327 (3/26/2014)
Thanks for you reply. They are doing some load test. Not exactly database they are doing load test of a tool but that tool brings the data from...
March 26, 2014 at 8:12 pm
sqlbuddy123 (3/26/2014)
tony28 (3/26/2014)
And Now I am seeing that I forgot System log, but time is after the problem, but maybe was problem with failoverclustering and it caused restart service,,, is...
March 26, 2014 at 6:32 pm
Grant Fritchey (3/26/2014)
ONLINE index rebuild uses both memory and tempdb to keep the index online while the the rebuild process occurs.I don't know Ola's scripts enough to help out.
yes right,...
March 26, 2014 at 5:33 pm
sqlbuddy123 (3/26/2014)
Also check if SQL Server dump file has been created during the SQL Server restart. It's a .mdmp file found in SQL Server Log folder like
C:\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Log
--
SQLBuddy
no...
March 26, 2014 at 5:25 pm
sqlbuddy123 (3/26/2014)
Check the Windows Application and System logs in the Event Veiwer ( Control Panel --> Administrative Tools ).--
SQLBuddy
From this query below I found create date of tempdb - last...
March 26, 2014 at 5:12 pm
Viewing 15 posts - 136 through 150 (of 245 total)