Sunday, June 30, 2013

[SQL 2012] SQL Server 2012 running on Windwos 2012 won't start

[SQL 2012] SQL Server 2012 running on Windwos 2012 won't start

SQL Server 2012 running on Windwos 2012 won't start

Posted: 29 Jun 2013 08:56 PM PDT

I've made 2 changes to SQL Server 2012 running on Windows 2012:Enabled Named PipesChanged the max amount of memory allocated to SQL Server from 256 to 240GB.And now SQL Server won't start. I get the error stating "SQL Server started and then stopped>The error log reads:2013-06-30 02:40:36.83 Server Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (X64) Dec 28 2012 20:23:12 Copyright (c) Microsoft Corporation Enterprise Edition (64-bit) on Windows NT 6.2 <X64> (Build 9200: )2013-06-30 02:40:36.83 Server (c) Microsoft Corporation.2013-06-30 02:40:36.83 Server All rights reserved.2013-06-30 02:40:36.83 Server Server process ID is 1128.2013-06-30 02:40:36.83 Server System Manufacturer: 'Dell Inc.', System Model: 'PowerEdge R815'.2013-06-30 02:40:36.83 Server Authentication mode is MIXED.2013-06-30 02:40:36.83 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Log\ERRORLOG'.2013-06-30 02:40:36.83 Server The service account is 'WORKGROUP\SUPERSCR-300$'. This is an informational message; no user action is required.2013-06-30 02:40:36.83 Server Registry startup parameters: -d C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\master.mdf -e C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Log\ERRORLOG -l C:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\mastlog.ldf2013-06-30 02:40:36.83 Server Command Line Startup Parameters: -s "MSSQLSERVER"2013-06-30 02:40:36.98 Server SQL Server detected 4 sockets with 8 cores per socket and 16 logical processors per socket, 64 total logical processors; using 40 logical processors based on SQL Server licensing. This is an informational message; no user action is required.2013-06-30 02:40:36.98 Server SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.2013-06-30 02:40:36.98 Server Detected 262118 MB of RAM. This is an informational message; no user action is required.2013-06-30 02:40:36.98 Server Using locked pages in the memory manager.2013-06-30 02:40:36.99 Server Large Page Allocated: 32MB2013-06-30 02:40:37.00 Server Large Page Allocated: 32MB2013-06-30 02:40:37.01 Server Large Page Allocated: 32MB2013-06-30 02:40:37.02 Server Large Page Allocated: 32MB2013-06-30 02:40:37.03 Server Large Page Allocated: 32MB2013-06-30 02:40:37.04 Server Large Page Allocated: 32MB2013-06-30 02:40:37.05 Server Large Page Allocated: 32MB2013-06-30 02:40:37.06 Server Large Page Allocated: 32MB2013-06-30 02:40:38.66 Server This instance of SQL Server last reported using a process ID of 5576 at 6/30/2013 2:37:16 AM (local) 6/30/2013 9:37:16 AM (UTC). This is an informational message only; no user action is required.2013-06-30 02:40:38.66 Server Node configuration: node 0: CPU mask: 0x00000000000000ff:0 Active CPU mask: 0x00000000000000ff:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.2013-06-30 02:40:38.66 Server Node configuration: node 1: CPU mask: 0x000000000000ff00:0 Active CPU mask: 0x000000000000ff00:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.2013-06-30 02:40:38.66 Server Node configuration: node 2: CPU mask: 0x0000000000ff0000:0 Active CPU mask: 0x0000000000ff0000:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.2013-06-30 02:40:38.66 Server Node configuration: node 3: CPU mask: 0x00000000ff000000:0 Active CPU mask: 0x00000000ff000000:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.2013-06-30 02:40:38.66 Server Node configuration: node 4: CPU mask: 0x000000ff00000000:0 Active CPU mask: 0x000000ff00000000:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.2013-06-30 02:40:38.66 Server Node configuration: node 5: CPU mask: 0x0000ff0000000000:0 Active CPU mask: 0x0000000000000000:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.2013-06-30 02:40:38.66 Server Node configuration: node 6: CPU mask: 0x00ff000000000000:0 Active CPU mask: 0x0000000000000000:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.2013-06-30 02:40:38.66 Server Node configuration: node 7: CPU mask: 0xff00000000000000:0 Active CPU mask: 0x0000000000000000:0. This message provides a description of the NUMA configuration for this computer. This is an informational message only. No user action is required.2013-06-30 02:40:38.66 Server Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.2013-06-30 02:40:38.66 Server Lock partitioning is enabled. This is an informational message only. No user action is required.2013-06-30 02:40:43.71 Server Failed allocate pages: FAIL_PAGE_ALLOCATION 12013-06-30 02:40:43.71 Server Process/System Counts Value---------------------------------------- ----------Available Physical Memory 260836831232Available Virtual Memory 8412996153344Available Paging File 295601201152Working Set 778735616Percent of Committed Memory in WS 94Page Faults 202070System physical memory high 1System physical memory low 0Process physical memory low 1Process virtual memory low 02013-06-30 02:40:43.71 Server Memory Manager KB---------------------------------------- ----------VM Reserved 373542104VM Committed 1654144Locked Pages Allocated 67620Large Pages Allocated 800768Emergency Memory 1024Emergency Memory In Use 16Target Committed 245784Current Committed 1721768Pages Allocated 65920Pages Reserved 0Pages Free 0Pages In Use 1721256Page Alloc Potential -1487784NUMA Growth Phase 2Last OOM Factor 6Last OS Error 02013-06-30 02:40:43.71 Server Memory node Id = 0 KB---------------------------------------- ----------VM Reserved 373312536VM Committed 1424608Locked Pages Allocated 56180Pages Allocated 54480Pages Free 0Target Committed 28496Current Committed 1480792Foreign Committed 0Away Committed 0Taken Away Committed 02013-06-30 02:40:43.71 Server Memory node Id = 1 KB---------------------------------------- ----------VM Reserved 32768VM Committed 32788Locked Pages Allocated 1640Pages Allocated 1640Pages Free 0Target Committed 28496Current Committed 34432Foreign Committed 0Away Committed 0Taken Away Committed 02013-06-30 02:40:43.71 spid11s Error: 701, Severity: 17, State: 123.2013-06-30 02:40:43.71 spid11s There is insufficient system memory in resource pool 'internal' to run this query.2013-06-30 02:40:43.71 Server Memory node Id = 2 KB---------------------------------------- ----------VM Reserved 32768VM Committed 32788Locked Pages Allocated 1632Pages Allocated 1632Pages Free 0Target Committed 28496Current Committed 34424Foreign Committed 0Away Committed 0Taken Away Committed 02013-06-30 02:40:43.71 Server Memory node Id = 3 KB---------------------------------------- ----------VM Reserved 32768VM Committed 32788Locked Pages Allocated 1632Pages Allocated 1632Pages Free 0Target Committed 28496Current Committed 34424Foreign Committed 0Away Committed 0Taken Away Committed 02013-06-30 02:40:43.71 Server Memory node Id = 4 KB---------------------------------------- ----------VM Reserved 32768VM Committed 32788Locked Pages Allocated 1632Pages Allocated 1632Pages Free 0Target Committed 28496Current Committed 34424Foreign Committed 0Away Committed 0Taken Away Committed 02013-06-30 02:40:43.71 Server Memory node Id = 5 KB---------------------------------------- ----------VM Reserved 32768VM Committed 32788Locked Pages Allocated 1640Pages Allocated 1640Pages Free 0Target Committed 34432Current Committed 34432Foreign Committed 0Away Committed 0Taken Away Committed 02013-06-30 02:40:43.71 Server Memory node Id = 6 KB---------------------------------------- ----------VM Reserved 32768VM Committed 32788Locked Pages Allocated 1632Pages Allocated 1632Pages Free 0Target Committed 34424Current Committed 34424Foreign Committed 0Away Committed 0Taken Away Committed 02013-06-30 02:40:43.71 Server Memory node Id = 7 KB---------------------------------------- ----------VM Reserved 32768VM Committed 32788Locked Pages Allocated 1632Pages Allocated 1632Pages Free 0Target Committed 34424Current Committed 34424Foreign Committed 0Away Committed 0Taken Away Committed 02013-06-30 02:40:43.71 Server Memory node Id = 64 KB---------------------------------------- ----------VM Reserved 0VM Committed 20Locked Pages Allocated 02013-06-30 02:40:43.71 Server MEMORYCLERK_SQLGENERAL (node 0) KB---------------------------------------- ----------VM Reserved 0VM Committed 0Locked Pages Allocated 0SM Reserved 0SM Committed 0Pages Allocated 18562013-06-30 02:40:43.71 Server MEMORYCLERK_SQLBUFFERPOOL (node 0) KB---------------------------------------- ----------VM Reserved 103975052VM Committed 524288Locked Pages Allocated 132SM Reserved 0SM Committed 0Pages Allocated 82013-06-30 02:40:43.71 Server MEMORYCLERK_SQLQUERYEXEC (node 0) KB---------------------------------------- ----------VM Reserved 0VM Committed 0Locked Pages Allocated 0SM Reserved 0SM Committed 0Pages Allocated 5362013-06-30 02:40:43.71 Server MEMORYCLERK_SQLOPTIMIZER (node 0) KB---------------------------------------- ----------VM Reserved 0VM Committed 0Locked Pages Allocated 0SM Reserved 0SM Committed 0Pages Allocated 11202013-06-30 02:40:43.71 Server Error: 17300, Severity: 16, State: 1.2013-06-30 02:40:43.71 Server SQL Server was unable to run a new system task, either because there is insufficient memory or the number of configured sessions exceeds the maximum allowed in the server. Verify that the server has adequate memory. Use sp_configure with option 'user connections' to check the maximum number of user connections allowed. Use sys.dm_exec_sessions to check the current number of sessions, including user processes.2013-06-30 02:40:43.71 Server MEMORYCLERK_SQLUTILITIES (node 0) KB---------------------------------------- ----------VM Reserved 0VM Committed 0Locked Pages Allocated 0SM Reserved 0SM Committed 0Pages Allocated 242013-06-30 02:40:43.71 Server MEMORYCLERK_SQLSTORENG (node 0) KB---------------------------------------- ----------VM Reserved 0VM Committed 0Locked Pages Allocated 0SM Reserved 0SM Committed 0Pages Allocated 20802013-06-30 02:40:43.71 Server Error: 17312, Severity: 16, State: 1.2013-06-30 02:40:43.71 Server SQL Server is terminating a system or background task Lockmonitor Task due to errors in starting up the task (setup state 1).2013-06-30 02:40:43.71 Server MEMORYCLERK_SQLCONNECTIONPOOL (node 0) KB---------------------------------------- ----------VM Reserved 0VM Committed 0Locked Pages Allocated 0SM Reserved 0SM Committed 0Pages Allocated 482013-06-30 02:40:43.71 Server MEMORYCLERK_SQLCONNECTIONPOOL (node 1) KB---------------------------------------- ----------VM Reserved 0VM Committed 0Locked Pages Allocated 0SM Reserved 0SM Committed 0Pages Allocated 242013-06-30 02:40:43.71 Server MEMORYCLERK_SQLCONNECTIONPOOL (node 2) KB---------------------------------------- ----------VM Reserved 0VM Committed 0Locked Pages Allocated 0SM Reserved 0SM Committed 0Pages Allocated 162013-06-30 02:40:43.71 Server MEMORYCLERK_SQLCONNECTIONPOOL (node 3) KB---------------------------------------- ----------VM Reserved 0VM Committed 0Locked Pages Allocated 0SM Reserved 0SM Committed 0Pages Allocated 162013-06-30 02:40:43.71 Server MEMORYCLERK_SQLCONNECTIONPOOL (node 4) KB---------------------------------------- ----------VM Reserved 0VM Committed 0Locked Pages Allocated 0SM Reserved 0SM Committed 0Pages Allocated 162013-06-30 02:40:43.71 Server SQL Server Audit failed to record the SERVER SHUTDOWN action.2013-06-30 02:40:43.71 Server MEMORYCLERK_SQLCONNECTIONPOOL (node 5) KB---------------------------------------- ----------VM Reserved 0VM Committed 0Locked Pages Allocated 0SM Reserved 0SM Committed 0Pages Allocated 162013-06-30 02:40:43.71 Server MEMORYCLERK_SQLCONNECTIONPOOL (node 6) KB---------------------------------------- ----------VM Reserved 0VM Committed 0Locked Pages Allocated 0SM Reserved 0SM Committed 0Pages Allocated 162013-06-30 02:40:43.71 Server MEMORYCLERK_SQLCONNECTIONPOOL (node 7) KB---------------------------------------- ----------VM Reserved 0VM Committed 0Locked Pages Allocated 0SM Reserved 0SM Committed 0Pages Allocated 162013-06-30 02:40:43.71 Server MEMORYCLERK_SQLCONNECTIONPOOL (Total) KB---------------------------------------- ----------VM Reserved 0VM Committed 0Locked Pages Allocated 0SM Reserved 0SM Committed 0Pages Allocated 1682013-06-30 02:40:43.71 Server MEMORYCLERK_SQLCLR (node 0) KB---------------------------------------- ----------VM Reserved 0VM Committed 0Locked Pages Allocated 0SM Reserved 0SM Committed 0Pages Allocated 8

How to connect SSMS 2012 with database engine?

Posted: 29 Jun 2013 09:42 AM PDT

Hi all,Installed SSMS 2012 Express addition with localDB. I don't know how to connect with Database engine and start using Sql Server?
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Search This Blog