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.