Timeline for SQL Server 2012 Crashes and service doesn't restart
Current License: CC BY-SA 3.0
16 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jun 10, 2015 at 11:48 | history | tweeted | twitter.com/#!/StackDBAs/status/608601526974738433 | ||
| Jun 10, 2015 at 10:40 | answer | added | Spörri | timeline score: 1 | |
| Jun 10, 2015 at 4:23 | comment | added | kaitlyn | I have uploaded the log here: drive.google.com/file/d/0BzcMzZRKZ8cyWkV3YjVYV1dGdms/… | |
| Jun 10, 2015 at 4:00 | comment | added | Shanky | Can you please upload complete errorlog which includes 701 error on some shared location for analysis and post the link here so that we can access it. I would also suggest you to apply SP2 | |
| Jun 9, 2015 at 21:46 | comment | added | James Anderson | Well it doesnt seem to be anything obvious (at least not to me). I would suggsst a review of any non default settings in SQL Server and the OS, trace flags, paging settings, dynamic memory settiings on the VM. Can you move the VM to another host to rule out other VMs causing the issue? Does it crash during high loads (no of connections) or is the load not connected? | |
| Jun 9, 2015 at 21:33 | comment | added | kaitlyn | Yes, it is Windows Server 2012 64bit. | |
| Jun 9, 2015 at 21:07 | comment | added | James Anderson | Humor me, what version of windows? Is it 64 bit? | |
| Jun 9, 2015 at 20:36 | comment | added | kaitlyn | Sorry, just checked with my VM admin guy and he said that there's 256gb available on the host and it is currently using 68gb out of the 256gb. | |
| Jun 9, 2015 at 20:17 | comment | added | James Anderson | You said the server jas 96gb. How much is it using? | |
| Jun 9, 2015 at 19:53 | comment | added | kaitlyn | No, it is just SQL Server running. We didn't not install SSAS or SSRS on the VM. SSIS is installed but nothing is running. There are no other applications running on this server. | |
| Jun 9, 2015 at 19:40 | comment | added | James Anderson | Do you have any other services running like SSAS, SSIS or SSRS on that VM? or any other applications? | |
| Jun 9, 2015 at 19:28 | comment | added | kaitlyn | We are using VMWare 5.1 and the host has 96gb. | |
| Jun 9, 2015 at 19:20 | comment | added | James Anderson | VM Ware or Hyper V? How much RAM does the virtual host have available? | |
| Jun 9, 2015 at 19:04 | comment | added | kaitlyn | Yes, this is running on a VM. The max server memory is at 16.5gb and the server has 20gb of RAM. | |
| Jun 9, 2015 at 19:03 | comment | added | James Anderson | Is this on a VM? Whats your max memory setting and how much RAM does the server have? | |
| Jun 9, 2015 at 19:00 | history | asked | kaitlyn | CC BY-SA 3.0 |