mysql教程

SQLSERVER errorlog讲解

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB

Jun 07, 2016 pm 03:40 PM

sqlserver講解

SQLSERVER errorlog讲解很多时候诊断SQLSERVER问题都需要看SQLSERVER的错误日志日志里面很多内容没有书本专门讲解，今天我就讲一下，可能里面的日志信息是从我个人的机器里抓出来的，跟大家的机器环境会有所不同，但是SQLSERVER启动部分的日志大家都是一

SQLSERVER errorlog讲解

很多时候诊断SQLSERVER问题都需要看SQLSERVER的错误日志

日志里面很多内容没有书本专门讲解，今天我就讲一下，可能里面的日志信息是从我个人的机器

里抓出来的，跟大家的机器环境会有所不同，但是SQLSERVER启动部分的日志大家都是一样的

特别的说一下：2013-02-12 17:53:29.29 spid29s

这些spid指的是SQLSERVER内部的进程，因为SQLSERVER内部有SQL OS，所以称呼他自己内部的线程为“进程”

所以在Windows的任务管理器里是看不到这些“进程ID的”的，这些进程ID也会跟会话关联的，例如你在

SSMS里新建一个查询，SQLSERVER就会新建一个会话ID（SPID），这些“进程”可以kill的

<span>1</span> <span>KILL</span> spid <span>--</span><span>相应的spid</span>

相当于在cmd下运行：TASKKILL notepad.exe（进程ID）

不过这些kill命令是发给SQLSERVER去执行

在启动的时候，SQLSERVER会创建很多线程来进行初始化数据库或者其他工作，所以会看到下面的，但是spid会不同

2013-02-12 17:53:29.29 spid29s

开头：

<span>1</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>22.26</span> Server      Microsoft SQL Server <span>2005</span> <span>-</span> <span>9.00</span>.<span>5069.00</span><span> (Intel X86) 
</span><span>2</span>     Aug <span>22</span> <span>2012</span> <span>16</span>:<span>01</span>:<span>52</span> 
<span>3</span>     Copyright (c) <span>1988</span><span>-</span><span>2005</span><span> Microsoft Corporation
</span><span>4</span>     Developer Edition <span>on</span> Windows NT <span>6.1</span> (Build <span>7601</span>: Service Pack <span>1</span><span>)
</span><span>5</span> 
<span>6</span> <span>--</span><span>启动信息，记录了你当前机器的SQL版本 和操作系统版本 SP补丁版本</span>

<span>1</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>22.26</span> Server      (c) <span>2005</span><span> Microsoft Corporation.
</span><span>2</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>22.26</span> Server      <span>All</span><span> rights reserved.
</span><span>3</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>22.26</span> Server      Server process ID <span>is</span> <span>5164</span><span>.
</span><span>4</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>22.26</span> Server      Authentication mode <span>is</span><span> MIXED.
</span><span>5</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>22.26</span> Server      Logging SQL Server messages <span>in</span> <span>file</span> <span>'</span><span>C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG</span><span>'</span><span>.
</span><span>6</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>22.26</span> Server      This instance <span>of</span> SQL Server last reported using a process ID <span>of</span> <span>3756</span> at <span>2013</span><span>/</span><span>2</span><span>/</span><span>12</span> <span>15</span>:<span>38</span>:<span>30</span> (local) <span>2013</span><span>/</span><span>2</span><span>/</span><span>12</span> <span>7</span>:<span>38</span>:<span>30</span> (UTC). This <span>is</span> an informational message <span>only</span>; no <span>user</span> action <span>is</span><span> required.
</span><span>7</span> <span>--</span><span>SQL进程ID是5164  登录SQLSERVER的验证模式是：混合模式</span>
<span>8</span> <span>--</span><span>errorlog存放的目录是：你懂的</span>
<span>9</span> <span>--</span><span>上次启动SQLSERVER使用的进程ID是3756</span>

启动信息：

<span> 1</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>22.26</span><span> Server      Registry startup parameters:
</span><span> 2</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>22.26</span> Server           <span>-</span>d C:\Program Files\Microsoft SQL Server\MSSQL.<span>1</span><span>\MSSQL\DATA\master.mdf
</span><span> 3</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>22.26</span> Server           <span>-</span>e C:\Program Files\Microsoft SQL Server\MSSQL.<span>1</span>\MSSQL\<span>LOG</span><span>\ERRORLOG
</span><span> 4</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>22.26</span> Server           <span>-</span>l C:\Program Files\Microsoft SQL Server\MSSQL.<span>1</span><span>\MSSQL\DATA\mastlog.ldf
</span><span> 5</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>22.26</span> 服务器         SQL Server <span>is</span> starting at normal priority base (<span>=</span><span>7</span>). This <span>is</span> an informational message <span>only</span>. No <span>user</span> action <span>is</span><span> required.
</span><span> 6</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>22.26</span> 服务器         Detected <span>4</span> CPUs. This <span>is</span> an informational message; no <span>user</span> action <span>is</span><span> required.
</span><span> 7</span> 
<span> 8</span> <span>--</span><span>读取注册表的启动参数，启动参数都存放在注册表里面的</span>
<span> 9</span> <span>--</span><span>这些参数可以SQLSERVER配置管理器里改</span>
<span>10</span> <span>--</span><span>检测到4个逻辑cpu 我的机器cpu是酷睿i3 双核四线程</span>
<span>11</span> <span>--</span><span>四个线程就是4个逻辑cpu，多少线程就是多少逻辑cpu</span>
<span>12</span> <span>--</span><span>启动优先级是7，这个优先级不是很明白</span>

<span>1</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>22.56</span> 服务器         <span>Set</span> AWE Enabled <span>to</span> <span>1</span> <span>in</span> the configuration parameters <span>to</span> allow <span>use</span> <span>of</span><span> more memory.
</span><span>2</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>22.69</span> 服务器         Using dynamic lock allocation.  Initial allocation <span>of</span> <span>2500</span> Lock blocks <span>and</span> <span>5000</span> Lock Owner blocks per node.  This <span>is</span> an informational message <span>only</span>.  No <span>user</span> action <span>is</span><span> required.
</span><span>3</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>22.71</span> 服务器         Attempting <span>to</span> initialize Microsoft <span>Distributed</span> <span>Transaction</span> Coordinator (MS DTC). This <span>is</span> an informational message <span>only</span>. No <span>user</span> action <span>is</span><span> required.
</span><span>4</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>23.78</span> 服务器         Attempting <span>to</span> recover <span>in-</span>doubt <span>distributed</span> transactions involving Microsoft <span>Distributed</span> <span>Transaction</span> Coordinator (MS DTC). This <span>is</span> an informational message <span>only</span>. No <span>user</span> action <span>is</span><span> required.
</span><span>5</span> 
<span>6</span> <span>--</span><span>AWE已经配置成功，AWE可以使SQLSERVER使用更多内存，突破32位操作系统限制</span>
<span>7</span> <span>--</span><span>使用动态锁分配，因为是多核处理器，所以使用了NUMA架构，将CPU分成多个节点，每个节点都有一些锁</span>
<span>8</span> <span>--</span><span>初始化和恢复MSDTC，如果你的应用需要用到分布式事务，例如分布式查询，查询access数据库就需要MSDTC的支持</span>

<span> 1</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>23.78</span> 服务器         <span>Database</span> mirroring has been enabled <span>on</span> this instance <span>of</span><span> SQL Server.
</span><span> 2</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>23.79</span> spid5s      Starting up <span>database</span> <span>'</span><span>master</span><span>'</span><span>.
</span><span> 3</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>23.83</span> spid5s      Recovery <span>is</span> writing a <span>checkpoint</span> <span>in</span> <span>database</span> <span>'</span><span>master</span><span>'</span> (<span>1</span>). This <span>is</span> an informational message <span>only</span>. No <span>user</span> action <span>is</span><span> required.
</span><span> 4</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>23.87</span> spid5s      SQL Trace ID <span>1</span> was started <span>by</span><span> login "sa".
</span><span> 5</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>23.88</span> spid5s      Starting up <span>database</span> <span>'</span><span>mssqlsystemresource</span><span>'</span><span>.
</span><span> 6</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>23.89</span> spid5s      The resource <span>database</span> build version <span>is</span> <span>9.00</span>.<span>5069</span>. This <span>is</span> an informational message <span>only</span>. No <span>user</span> action <span>is</span><span> required.
</span><span> 7</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>24.63</span> spid5s      Server name <span>is</span> <span>'</span><span>JOE</span><span>'</span>. This <span>is</span> an informational message <span>only</span>. No <span>user</span> action <span>is</span><span> required.
</span><span> 8</span> 
<span> 9</span> <span>--</span><span>数据库镜像已经准备就绪，我的机器配置了数据库镜像</span>
<span>10</span> <span>--</span><span>启动master数据库，恢复master数据库，使用检查点技术把数据写入磁盘</span>
<span>11</span> <span>--</span><span>因为我启动了SQL Trace 所以会看到SQL Trace的信息</span>
<span>12</span> <span>--</span><span>启动sqlserver 系统资源数据库，这个数据库在SSMS里是不可见的</span>
<span>13</span> <span>--</span><span>但是他又很重要，存储数据库的元数据</span>
<span>14</span> <span>--</span><span>我的计算机名：joe</span>

<span> 1</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>24.63</span> spid9s      Starting up <span>database</span> <span>'</span><span>model</span><span>'</span><span>.
</span><span> 2</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>24.66</span> spid9s      Clearing tempdb <span>database</span><span>.
</span><span> 3</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>25.48</span> spid9s      Starting up <span>database</span> <span>'</span><span>tempdb</span><span>'</span><span>.
</span><span> 4</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>25.62</span> spid12s     The Service Broker protocol transport <span>is</span> disabled <span>or</span> <span>not</span><span> configured.
</span><span> 5</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>25.62</span> spid12s     The <span>Database</span> Mirroring protocol transport <span>is</span> disabled <span>or</span> <span>not</span><span> configured.
</span><span> 6</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>25.62</span><span> spid12s     Service Broker manager has started.
</span><span> 7</span> 
<span> 8</span> <span>--</span><span>启动model数据库</span>
<span> 9</span> <span>--</span><span>清空tempdb数据库，清空tempdb数据库的时机就是在</span>
<span>10</span> <span>--</span><span>SQLSERVER启动的时候</span>
<span>11</span> <span>--</span><span>我的ServiceBroker没有配置</span>
<span>12</span> <span>--</span><span>数据库镜像传输没有配置，因为我之前把镜像删除了，但是因为启用了镜像，所以还是会提示在启动的时候</span>

<span> 1</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>26.91</span> 服务器         A self<span>-</span>generated certificate was successfully loaded <span>for</span><span> encryption.
</span><span> 2</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>26.91</span> 服务器         Server local connection provider <span>is</span> ready <span>to</span> accept connection <span>on</span> <span>[</span><span> \\.\pipe\SQLLocal\MSSQLSERVER </span><span>]</span><span>.
</span><span> 3</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>26.91</span> 服务器         Server local connection provider <span>is</span> ready <span>to</span> accept connection <span>on</span> <span>[</span><span> \\.\pipe\sql\query </span><span>]</span><span>.
</span><span> 4</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>26.92</span> 服务器         Server <span>is</span> listening <span>on</span> <span>[</span><span> 'any' <ipv6> 1434</ipv6></span><span>]</span><span>.
</span><span> 5</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>26.92</span> 服务器         Server <span>is</span> listening <span>on</span> <span>[</span><span> 'any' <ipv4> 1434</ipv4></span><span>]</span><span>.
</span><span> 6</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>26.92</span> 服务器         Dedicated admin connection support was established <span>for</span> listening remotely <span>on</span> port <span>1434</span><span>.
</span><span> 7</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>26.92</span> 服务器         SQL Server <span>is</span> now ready <span>for</span> client connections. This <span>is</span> an informational message; no <span>user</span> action <span>is</span><span> required.
</span><span> 8</span> 
<span> 9</span> <span>--</span><span>之前配置过数据库镜像，使用证书的方式，所以这里也会提示成功加载</span>
<span>10</span> <span>--</span><span>证书，因为我的证书还没有删除</span>
<span>11</span> <span>--</span><span>下面的几个都说明了SQLSERVER已经准备就绪接受连接</span>
<span>12</span> <span>--</span><span>包括命名管道，共享内存，TCP/IP</span>
<span>13</span> <span>--</span><span>因为开启了SQL BROSWER服务，所以会侦听1434端口</span>
<span>14</span> <span>--</span><span>SQL BROSWER的作用可以看MSDN</span>
<span>15</span> <span>--</span><span>专用管理员连接支持已经建立，也是侦听1434端口</span>
<span>16</span> <span>--</span><span>专用管理员连接DAC是当遇到数据库连接不上或者某些原因</span>
<span>17</span> <span>--</span><span>登录不了数据库而使用的，侦听1434的原因估计是因为</span>
<span>18</span> <span>--</span><span>1433端口都用不了</span>

<span> 1</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>26.95</span> spid18s     Starting up <span>database</span> <span>'</span><span>msdb</span><span>'</span><span>.
</span><span> 2</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>26.95</span> spid19s     Starting up <span>database</span> <span>'</span><span>ReportServer</span><span>'</span><span>.
</span><span> 3</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>26.95</span> spid21s     Starting up <span>database</span> <span>'</span><span>AdventureWorks</span><span>'</span><span>.
</span><span> 4</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>26.95</span> spid22s     Starting up <span>database</span> <span>'</span><span>AdventureWorksDW</span><span>'</span><span>.
</span><span> 5</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>26.95</span> spid20s     Starting up <span>database</span> <span>'</span><span>ReportServerTempDB</span><span>'</span><span>.
</span><span> 6</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>26.96</span> spid23s     Starting up <span>database</span> <span>'</span><span>dbdreamlink</span><span>'</span><span>.
</span><span> 7</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>26.96</span> spid24s     Starting up <span>database</span> <span>'</span><span>DLGPOS</span><span>'</span><span>.
</span><span> 8</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>26.98</span> spid25s     Starting up <span>database</span> <span>'</span><span>hengshan</span><span>'</span><span>.
</span><span> 9</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>27.02</span> spid19s     Starting up <span>database</span> <span>'</span><span>Monitoring</span><span>'</span><span>.
</span><span>10</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>27.02</span> spid26s     Starting up <span>database</span> <span>'</span><span>Northwind</span><span>'</span><span>.
</span><span>11</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>27.03</span> spid27s     Starting up <span>database</span> <span>'</span><span>partionTest</span><span>'</span><span>.
</span><span>12</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>27.03</span> spid20s     Starting up <span>database</span> <span>'</span><span>pratice</span><span>'</span><span>.
</span><span>13</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>27.04</span> spid28s     Starting up <span>database</span> <span>'</span><span>pubs</span><span>'</span><span>.
</span><span>14</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>27.05</span> spid29s     Starting up <span>database</span> <span>'</span><span>TransactionTestDb</span><span>'</span><span>.
</span><span>15</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>27.05</span> spid25s     Starting up <span>database</span> <span>'</span><span>GPOSDB</span><span>'</span><span>.
</span><span>16</span> 
<span>17</span> <span>--</span><span>前面的一些检查成功之后，开始各个数据库的启动</span>

<span> 1</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>28.36</span> spid5s      Recovery <span>is</span> writing a <span>checkpoint</span> <span>in</span> <span>database</span> <span>'</span><span>msdb</span><span>'</span> (<span>4</span>). This <span>is</span> an informational message <span>only</span>. No <span>user</span> action <span>is</span><span> required.
</span><span> 2</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>29.24</span> spid27s     <span>1</span> transactions rolled forward <span>in</span> <span>database</span> <span>'</span><span>partionTest</span><span>'</span> (<span>14</span>). This <span>is</span> an informational message <span>only</span>. No <span>user</span> action <span>is</span><span> required.
</span><span> 3</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>29.24</span> spid27s     <span>0</span> transactions rolled back <span>in</span> <span>database</span> <span>'</span><span>partionTest</span><span>'</span> (<span>14</span>). This <span>is</span> an informational message <span>only</span>. No <span>user</span> action <span>is</span><span> required.
</span><span> 4</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>29.24</span> spid27s     Recovery <span>is</span> writing a <span>checkpoint</span> <span>in</span> <span>database</span> <span>'</span><span>partionTest</span><span>'</span> (<span>14</span>). This <span>is</span> an informational message <span>only</span>. No <span>user</span> action <span>is</span><span> required.
</span><span> 5</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>29.24</span> spid28s     <span>1</span> transactions rolled forward <span>in</span> <span>database</span> <span>'</span><span>pubs</span><span>'</span> (<span>16</span>). This <span>is</span> an informational message <span>only</span>. No <span>user</span> action <span>is</span><span> required.
</span><span> 6</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>29.26</span> spid27s     <span>0</span> transactions rolled back <span>in</span> <span>database</span> <span>'</span><span>pubs</span><span>'</span> (<span>16</span>). This <span>is</span> an informational message <span>only</span>. No <span>user</span> action <span>is</span><span> required.
</span><span> 7</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>29.26</span> spid27s     Recovery <span>is</span> writing a <span>checkpoint</span> <span>in</span> <span>database</span> <span>'</span><span>pubs</span><span>'</span> (<span>16</span>). This <span>is</span> an informational message <span>only</span>. No <span>user</span> action <span>is</span><span> required.
</span><span> 8</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>29.28</span> spid29s     <span>1</span> transactions rolled forward <span>in</span> <span>database</span> <span>'</span><span>TransactionTestDb</span><span>'</span> (<span>17</span>). This <span>is</span> an informational message <span>only</span>. No <span>user</span> action <span>is</span><span> required.
</span><span> 9</span> 
<span>10</span> <span>--</span><span>开始恢复各个数据库并进行前滚或者回滚数据库，使各个数据库进入</span>
<span>11</span> <span>--</span><span>在线状态，关于各种状态可以看我这篇文章</span>
<span>12</span> <span>--</span><span>SQLSERVER数据库主要状态和切换路径</span>
<span>13</span> <span>--</span><span>http://www.cnblogs.com/lyhabc/archive/2012/09/15/2687076.html<br>14 --数据库后面的数字是DBID</span>

<span>1</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>29.29</span> spid29s     CHECKDB <span>for</span> <span>database</span> <span>'</span><span>TransactionTestDb</span><span>'</span> finished without errors <span>on</span> <span>2012</span><span>-</span><span>11</span><span>-</span><span>29</span> <span>20</span>:<span>22</span>:<span>02.540</span> (local time). This <span>is</span> an informational message <span>only</span>; no <span>user</span> action <span>is</span><span> required.
</span><span>2</span> 
<span>3</span> <span>--</span><span>使用checkdb命令检查各个数据库的状态</span>
<span>4</span> <span>--</span><span>由于数据库太多我就不贴出来了</span>

<span> 1</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>33.10</span> spid5s      Recovery <span>of</span> <span>any</span> <span>in-</span>doubt <span>distributed</span> transactions involving Microsoft <span>Distributed</span> <span>Transaction</span> Coordinator (MS DTC) has completed. This <span>is</span> an informational message <span>only</span>. No <span>user</span> action <span>is</span><span> required.
</span><span> 2</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>33.10</span> spid5s      Recovery <span>is</span> complete. This <span>is</span> an informational message <span>only</span>. No <span>user</span> action <span>is</span><span> required.
</span><span> 3</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>34.29</span> spid51      Using <span>'</span><span>xpsqlbot.dll</span><span>'</span> version <span>'</span><span>2005.90.5000</span><span>'</span> <span>to</span> <span>execute</span> extended stored <span>procedure</span> <span>'</span><span>xp_qv</span><span>'</span>. This <span>is</span> an informational message <span>only</span>; no <span>user</span> action <span>is</span><span> required.
</span><span> 4</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>34.60</span> spid51      Using <span>'</span><span>xpstar90.dll</span><span>'</span> version <span>'</span><span>2005.90.5000</span><span>'</span> <span>to</span> <span>execute</span> extended stored <span>procedure</span> <span>'</span><span>xp_instance_regread</span><span>'</span>. This <span>is</span> an informational message <span>only</span>; no <span>user</span> action <span>is</span><span> required.
</span><span> 5</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>17</span>:<span>53</span>:<span>34.66</span> spid51      Using <span>'</span><span>xplog70.dll</span><span>'</span> version <span>'</span><span>2005.90.5000</span><span>'</span> <span>to</span> <span>execute</span> extended stored <span>procedure</span> <span>'</span><span>xp_msver</span><span>'</span>. This <span>is</span> an informational message <span>only</span>; no <span>user</span> action <span>is</span><span> required.
</span><span> 6</span> <span>--</span><span>检查所有的分布式事务都没有问题</span>
<span> 7</span> <span>--</span><span>加载xpsqlbot.dll来执行扩展存储过程xp_qv</span>
<span> 8</span> <span>--</span><span>加载xpstar90.dll来执行扩展存储过程xp_instance_regread</span>
<span> 9</span> <span>--</span><span>加载xplog70.dll来执行扩展存储过程xp_msver</span>
<span>10</span> 
<span>11</span> <span>--</span><span>这些扩展存储过程都需要加载第三方dll来执行的，之前遇到过</span>
<span>12</span> <span>--</span><span>有人因为缺少xplog70.dll 而不能执行xp_cmdshell</span>
<span>13</span> <span>--</span><span>无法装载 DLL xpsql70.dll 或该DLL所引用的某一 DLL。</span>
<span>14</span> <span>--</span><span>原因126（找不到指定模块）</span>
<span>15</span> <span>--</span><span>无法在库 xpweb70.dll 中找到函数 xp_cmdshell</span>

启动完毕

运行过程的SQL ErrorLog

<span>1</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>18</span>:<span>02</span>:<span>57.41</span> spid1s      A significant part <span>of</span> sql server process memory has been paged out. This may result <span>in</span> a performance degradation. Duration: <span>0</span> seconds. Working <span>set</span> (KB): <span>7484</span>, <span>committed</span> (KB): <span>63256</span>, memory utilization: <span>11</span><span>%</span><span>.
</span><span>2</span> 
<span>3</span> <span>--</span><span>因为我的机器内存不足，所以需要把SQLSERVER内存页面换出</span>
<span>4</span> <span>--</span><span>这个信息在Windows事件查看器里应用程序日志也能看到</span>

<span>1</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>19</span>:<span>48</span>:<span>24.67</span> spid55      <span>DBCC</span> TRACEON <span>3604</span>, server process ID (SPID) <span>55</span>. This <span>is</span> an informational message <span>only</span>; no <span>user</span> action <span>is</span><span> required.
</span><span>2</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>19</span>:<span>48</span>:<span>24.76</span> spid55      <span>DBCC</span> TRACEOFF <span>3604</span>, server process ID (SPID) <span>55</span>. This <span>is</span> an informational message <span>only</span>; no <span>user</span> action <span>is</span><span> required.
</span><span>3</span> 
<span>4</span> <span>--</span><span>3604跟踪标志已经打开</span>

<span>1</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>22</span>:<span>37</span>:<span>21.56</span> spid55      <span>DBCC</span> TRACEON <span>1222</span>, server process ID (SPID) <span>55</span>. This <span>is</span> an informational message <span>only</span>; no <span>user</span> action <span>is</span><span> required.
</span><span>2</span> <span>2013</span><span>-</span><span>02</span><span>-</span><span>12</span> <span>22</span>:<span>37</span>:<span>21.60</span> spid55      <span>DBCC</span> TRACEON <span>1204</span>, server process ID (SPID) <span>55</span>. This <span>is</span> an informational message <span>only</span>; no <span>user</span> action <span>is</span><span> required.
</span><span>3</span> 
<span>4</span> <span>--</span><span>跟踪标志1222和1204已经打开，刚才因为我要跟踪死锁信息</span>
<span>5</span> <span>--</span><span>所以手动打开了1222和1204跟踪标志</span>

就这麽多了，SQL ErrorLog不会很多，所以有时候遇到SQL问题先查找SQL ErrorLog里的记录会比较好

当然了，在SSMS里也能看到SQL ErrorLog，SSMS里还包括筛选和搜索功能，但是有时候如果连SQLSERVER服务都启动不了

那只能到SQL ErrorLog的目录里面，用记事本或者其他编辑器打开找问题原因了

SQLSERVER errorlog讲解

------------------------------------------------------------------------------------------------------------

2013-10-21

附上SQLSERVER2012 启动时候的ERRORLOG

<span> 1</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>06</span>:<span>18.51</span> Server      Microsoft SQL Server <span>2012</span> (SP1) <span>-</span> <span>11.0</span>.<span>3000.0</span><span> (X64) 
</span><span> 2</span>     Oct <span>19</span> <span>2012</span> <span>13</span>:<span>38</span>:<span>57</span> 
<span> 3</span> <span>    Copyright (c) Microsoft Corporation
</span><span> 4</span>     Developer Edition (<span>64</span><span>-</span><span>bit</span>) <span>on</span> Windows NT <span>6.1</span> <span>X64<span>></span> (Build <span>7601</span>: Service Pack <span>1</span><span>) (Hypervisor)
</span><span> 5</span> 
<span> 6</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>06</span>:<span>18.53</span><span> Server      (c) Microsoft Corporation.
</span><span> 7</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>06</span>:<span>18.53</span> Server      <span>All</span><span> rights reserved.
</span><span> 8</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>06</span>:<span>18.53</span> Server      Server process ID <span>is</span> <span>2364</span><span>.
</span><span> 9</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>06</span>:<span>18.53</span> Server      System Manufacturer: <span>'</span><span>VMware, Inc.</span><span>'</span>, System Model: <span>'</span><span>VMware Virtual Platform</span><span>'</span><span>.
</span><span>10</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>06</span>:<span>18.53</span> Server      Authentication mode <span>is</span><span> MIXED.
</span><span>11</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>06</span>:<span>18.54</span> Server      Logging SQL Server messages <span>in</span> <span>file</span> <span>'</span><span>D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\Log\ERRORLOG</span><span>'</span><span>.
</span><span>12</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>06</span>:<span>18.54</span> Server      The service account <span>is</span> <span>'</span><span>NT Service\MSSQLSERVER</span><span>'</span>. This <span>is</span> an informational message; no <span>user</span> action <span>is</span><span> required.
</span><span>13</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>06</span>:<span>18.54</span><span> Server      Registry startup parameters: 
</span><span>14</span>      <span>-</span><span>d D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\master.mdf
</span><span>15</span>      <span>-</span>e D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\<span>Log</span><span>\ERRORLOG
</span><span>16</span>      <span>-</span><span>l D:\Program Files\Microsoft SQL Server\MSSQL11.MSSQLSERVER\MSSQL\DATA\mastlog.ldf
</span><span>17</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>06</span>:<span>18.54</span><span> Server      Command Line Startup Parameters:
</span><span>18</span>      <span>-</span><span>s "MSSQLSERVER"
</span><span>19</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>06</span>:<span>19.24</span> 服务器         SQL Server detected <span>2</span> sockets <span>with</span> <span>2</span> cores per socket <span>and</span> <span>2</span> logical processors per socket, <span>4</span> total logical processors; using <span>4</span> logical processors based <span>on</span> SQL Server licensing. This <span>is</span> an informational message; no <span>user</span> action <span>is</span><span> required.
</span><span>20</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>06</span>:<span>19.24</span> 服务器         SQL Server <span>is</span> starting at normal priority base (<span>=</span><span>7</span>). This <span>is</span> an informational message <span>only</span>. No <span>user</span> action <span>is</span><span> required.
</span><span>21</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>06</span>:<span>19.24</span> 服务器         Detected <span>2999</span> MB <span>of</span> RAM. This <span>is</span> an informational message; no <span>user</span> action <span>is</span><span> required.
</span><span>22</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>06</span>:<span>19.26</span> 服务器         Using conventional memory <span>in</span><span> the memory manager.
</span><span>23</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>06</span>:<span>24.37</span> 服务器         This instance <span>of</span> SQL Server last reported using a process ID <span>of</span> <span>2328</span> at <span>2013</span><span>/</span><span>10</span><span>/</span><span>19</span> <span>11</span>:<span>13</span>:<span>57</span> (local) <span>2013</span><span>/</span><span>10</span><span>/</span><span>19</span> <span>3</span>:<span>13</span>:<span>57</span> (UTC). This <span>is</span> an informational message <span>only</span>; no <span>user</span> action <span>is</span><span> required.
</span><span>24</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>06</span>:<span>24.42</span> 服务器         Node configuration: node <span>0</span>: CPU mask: <span>0x000000000000000f</span>:<span>0</span> Active CPU mask: <span>0x000000000000000f</span>:<span>0</span>. This message provides a description <span>of</span> the NUMA configuration <span>for</span> this computer. This <span>is</span> an informational message <span>only</span>. No <span>user</span> action <span>is</span><span> required.
</span><span>25</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>06</span>:<span>24.47</span> 服务器         Using dynamic lock allocation.  Initial allocation <span>of</span> <span>2500</span> Lock blocks <span>and</span> <span>5000</span> Lock Owner blocks per node.  This <span>is</span> an informational message <span>only</span>.  No <span>user</span> action <span>is</span><span> required.
</span><span>26</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>06</span>:<span>24.53</span> 服务器         Software Usage Metrics <span>is</span><span> disabled.
</span><span>27</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>06</span>:<span>24.61</span> Server      CLR version v4.<span>0.30319</span><span> loaded.
</span><span>28</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>06</span>:<span>24.65</span> spid2s      Starting up <span>database</span> <span>'</span><span>master</span><span>'</span><span>.
</span><span>29</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>06</span>:<span>25.38</span> 服务器         Common language runtime (CLR) functionality initialized using CLR version v4.<span>0.30319</span> <span>from</span> C:\Windows\Microsoft.NET\Framework64\v4.<span>0.30319</span><span>\.
</span><span>30</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>06</span>:<span>30.12</span><span> spid2s      Resource governor reconfiguration succeeded.
</span><span>31</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>06</span>:<span>30.14</span> spid2s      SQL Server Audit <span>is</span> starting the audits. This <span>is</span> an informational message. No <span>user</span> action <span>is</span><span> required.
</span><span>32</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>06</span>:<span>30.16</span> spid2s      SQL Server Audit has started the audits. This <span>is</span> an informational message. No <span>user</span> action <span>is</span><span> required.
</span><span>33</span> <span>{39B75A24<span>-</span><span>0837</span><span>-</span>4CEC<span>-</span>AFDF<span>-</span>B960027AE07E}<span>></span>RsFxNso initialized. InstanceId <span>=</span> <span>00000001</span>
<span>34</span> <span>{<span>50080099</span><span>-</span>5EC4<span>-</span>4EAF<span>-</span>A2A2<span>-</span>63C3DA97F8EB}<span>></span>FsAgent <span>is</span><span> initialized
</span><span>35</span> <span>{09C4480B<span>-</span>DBA4<span>-</span>49B7<span>-</span>956F<span>-</span>68A8B8B2445D}<span>></span>FsAgent <span>is</span> up <span>and</span><span> running
</span><span>36</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>06</span>:<span>30.45</span> spid2s      FILESTREAM: effective <span>level</span> <span>=</span> <span>2</span> (remote access enabled), configured <span>level</span> <span>=</span> <span>2</span>, <span>file</span> system access share name <span>=</span> <span>'</span><span>MSSQLSERVER</span><span>'</span><span>.
</span><span>37</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>06</span>:<span>33.25</span> spid2s      SQL Trace ID <span>1</span> was started <span>by</span><span> login "sa".
</span><span>38</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>06</span>:<span>33.99</span> spid2s      Server name <span>is</span> <span>'</span><span>WIN7U-20130702M</span><span>'</span>. This <span>is</span> an informational message <span>only</span>. No <span>user</span> action <span>is</span><span> required.
</span><span>39</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>06</span>:<span>34.92</span> spid18s     A self<span>-</span>generated certificate was successfully loaded <span>for</span><span> encryption.
</span><span>40</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>06</span>:<span>35.04</span> spid18s     Server <span>is</span> listening <span>on</span> <span>[</span><span> 'any' <ipv6> 1433</ipv6></span><span>]</span><span>.
</span><span>41</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>06</span>:<span>35.05</span> spid18s     Server <span>is</span> listening <span>on</span> <span>[</span><span> 'any' <ipv4> 1433</ipv4></span><span>]</span><span>.
</span><span>42</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>06</span>:<span>35.05</span> spid18s     Server local connection provider <span>is</span> ready <span>to</span> accept connection <span>on</span> <span>[</span><span> \\.\pipe\SQLLocal\MSSQLSERVER </span><span>]</span><span>.
</span><span>43</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>06</span>:<span>35.06</span> spid18s     Server named <span>pipe</span> provider <span>is</span> ready <span>to</span> accept connection <span>on</span> <span>[</span><span> \\.\pipe\sql\query </span><span>]</span><span>.
</span><span>44</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>06</span>:<span>35.06</span> 服务器         Server <span>is</span> listening <span>on</span> <span>[</span><span> ::1 <ipv6> 1434</ipv6></span><span>]</span><span>.
</span><span>45</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>06</span>:<span>35.06</span> 服务器         Server <span>is</span> listening <span>on</span> <span>[</span><span> 127.0.0.1 <ipv4> 1434</ipv4></span><span>]</span><span>.
</span><span>46</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>06</span>:<span>35.06</span> 服务器         Dedicated admin connection support was established <span>for</span> listening locally <span>on</span> port <span>1434</span><span>.
</span><span>47</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>06</span>:<span>35.39</span> 服务器         SQL Server <span>is</span> attempting <span>to</span> register a Service Principal Name (SPN) <span>for</span> the SQL Server service. Kerberos authentication will <span>not</span> be possible until a SPN <span>is</span> registered <span>for</span> the SQL Server service. This <span>is</span> an informational message. No <span>user</span> action <span>is</span><span> required.
</span><span>48</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>06</span>:<span>35.39</span> 服务器         The SQL Server Network Interface library could <span>not</span> register the Service Principal Name (SPN) <span>[</span><span> MSSQLSvc/WIN7U-20130702M </span><span>]</span> <span>for</span> the SQL Server service. Windows <span>return</span> code: <span>0xffffffff</span>, state: <span>63</span>. Failure <span>to</span> register a SPN might cause integrated authentication <span>to</span> <span>use</span> NTLM instead <span>of</span> Kerberos. This <span>is</span> an informational message. Further action <span>is</span> <span>only</span> required <span>if</span> Kerberos authentication <span>is</span> required <span>by</span> authentication policies <span>and</span> <span>if</span> the SPN has <span>not</span><span> been manually registered.
</span><span>49</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>06</span>:<span>35.39</span> 服务器         The SQL Server Network Interface library could <span>not</span> register the Service Principal Name (SPN) <span>[</span><span> MSSQLSvc/WIN7U-20130702M:1433 </span><span>]</span> <span>for</span> the SQL Server service. Windows <span>return</span> code: <span>0xffffffff</span>, state: <span>63</span>. Failure <span>to</span> register a SPN might cause integrated authentication <span>to</span> <span>use</span> NTLM instead <span>of</span> Kerberos. This <span>is</span> an informational message. Further action <span>is</span> <span>only</span> required <span>if</span> Kerberos authentication <span>is</span> required <span>by</span> authentication policies <span>and</span> <span>if</span> the SPN has <span>not</span><span> been manually registered.
</span><span>50</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>06</span>:<span>35.39</span> spid18s     SQL Server <span>is</span> now ready <span>for</span> client connections. This <span>is</span> an informational message; no <span>user</span> action <span>is</span><span> required.
</span><span>51</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>07</span>:<span>13.64</span> spid26s     Starting up <span>database</span> <span>'</span><span>ReportServer</span><span>'</span><span>.
</span><span>52</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>07</span>:<span>13.65</span> spid23s     Starting up <span>database</span> <span>'</span><span>ReportServerTempDB</span><span>'</span><span>.
</span><span>53</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>07</span>:<span>13.65</span> spid28s     Starting up <span>database</span> <span>'</span><span>GPOSDB</span><span>'</span><span>.
</span><span>54</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>07</span>:<span>13.65</span> spid24s     Starting up <span>database</span> <span>'</span><span>msdb</span><span>'</span><span>.
</span><span>55</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>07</span>:<span>13.66</span> spid27s     Starting up <span>database</span> <span>'</span><span>hengshan</span><span>'</span><span>.
</span><span>56</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>07</span>:<span>13.66</span> spid25s     Starting up <span>database</span> <span>'</span><span>pratice</span><span>'</span><span>.
</span><span>57</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>07</span>:<span>13.66</span> spid9s      Starting up <span>database</span> <span>'</span><span>mssqlsystemresource</span><span>'</span><span>.
</span><span>58</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>07</span>:<span>13.71</span> spid29s     Starting up <span>database</span> <span>'</span><span>FileStreamTestDb</span><span>'</span><span>.
</span><span>59</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>07</span>:<span>13.72</span> spid30s     Starting up <span>database</span> <span>'</span><span>长铁物业公司资产数据库</span><span>'</span><span>.
</span><span>60</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>07</span>:<span>13.82</span> spid9s      The resource <span>database</span> build version <span>is</span> <span>11.00</span>.<span>3000</span>. This <span>is</span> an informational message <span>only</span>. No <span>user</span> action <span>is</span><span> required.
</span><span>61</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>07</span>:<span>16.04</span> spid9s      Starting up <span>database</span> <span>'</span><span>model</span><span>'</span><span>.
</span><span>62</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>07</span>:<span>18.92</span> spid9s      Clearing tempdb <span>database</span><span>.
</span><span>63</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>07</span>:<span>25.96</span> spid9s      Starting up <span>database</span> <span>'</span><span>tempdb</span><span>'</span><span>.
</span><span>64</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>07</span>:<span>27.18</span> spid11s     The Service Broker endpoint <span>is</span> <span>in</span> disabled <span>or</span><span> stopped state.
</span><span>65</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>07</span>:<span>27.37</span> spid11s     The <span>Database</span> Mirroring endpoint <span>is</span> <span>in</span> disabled <span>or</span><span> stopped state.
</span><span>66</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>07</span>:<span>28.82</span> spid28s     CHECKDB <span>for</span> <span>database</span> <span>'</span><span>GPOSDB</span><span>'</span> finished without errors <span>on</span> <span>2013</span><span>-</span><span>06</span><span>-</span><span>10</span> <span>00</span>:<span>00</span>:<span>41.420</span> (local time). This <span>is</span> an informational message <span>only</span>; no <span>user</span> action <span>is</span><span> required.
</span><span>67</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>07</span>:<span>29.57</span><span> spid11s     Service Broker manager has started.
</span><span>68</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>07</span>:<span>35.01</span> spid25s     CHECKDB <span>for</span> <span>database</span> <span>'</span><span>pratice</span><span>'</span> finished without errors <span>on</span> <span>2013</span><span>-</span><span>06</span><span>-</span><span>10</span> <span>00</span>:<span>00</span>:<span>56.963</span> (local time). This <span>is</span> an informational message <span>only</span>; no <span>user</span> action <span>is</span><span> required.
</span><span>69</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>07</span>:<span>35.53</span> spid2s      Recovery <span>is</span> complete. This <span>is</span> an informational message <span>only</span>. No <span>user</span> action <span>is</span><span> required.
</span><span>70</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>07</span>:<span>52.84</span> spid20s     A new instance <span>of</span> the <span>full</span><span>-</span><span>text</span><span> filter daemon host process has been successfully started.
</span><span>71</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>08</span>:<span>10.24</span> spid51      Attempting <span>to</span> <span>load</span> library <span>'</span><span>xpsqlbot.dll</span><span>'</span> <span>into</span> memory. This <span>is</span> an informational message <span>only</span>. No <span>user</span> action <span>is</span><span> required.
</span><span>72</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>08</span>:<span>10.64</span> spid51      Using <span>'</span><span>xpsqlbot.dll</span><span>'</span> version <span>'</span><span>2011.110.2100</span><span>'</span> <span>to</span> <span>execute</span> extended stored <span>procedure</span> <span>'</span><span>xp_qv</span><span>'</span>. This <span>is</span> an informational message <span>only</span>; no <span>user</span> action <span>is</span><span> required.
</span><span>73</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>08</span>:<span>14.48</span> spid51      Attempting <span>to</span> <span>load</span> library <span>'</span><span>xpstar.dll</span><span>'</span> <span>into</span> memory. This <span>is</span> an informational message <span>only</span>. No <span>user</span> action <span>is</span><span> required.
</span><span>74</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>08</span>:<span>15.66</span> spid51      Using <span>'</span><span>xpstar.dll</span><span>'</span> version <span>'</span><span>2011.110.3000</span><span>'</span> <span>to</span> <span>execute</span> extended stored <span>procedure</span> <span>'</span><span>xp_instance_regread</span><span>'</span>. This <span>is</span> an informational message <span>only</span>; no <span>user</span> action <span>is</span><span> required.
</span><span>75</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>08</span>:<span>17.53</span> spid51      Attempting <span>to</span> <span>load</span> library <span>'</span><span>xplog70.dll</span><span>'</span> <span>into</span> memory. This <span>is</span> an informational message <span>only</span>. No <span>user</span> action <span>is</span><span> required.
</span><span>76</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>18</span>:<span>08</span>:<span>18.21</span> spid51      Using <span>'</span><span>xplog70.dll</span><span>'</span> version <span>'</span><span>2011.110.2100</span><span>'</span> <span>to</span> <span>execute</span> extended stored <span>procedure</span> <span>'</span><span>xp_msver</span><span>'</span>. This <span>is</span> an informational message <span>only</span>; no <span>user</span> action <span>is</span><span> required.
</span><span>77</span> <span>2013</span><span>-</span><span>10</span><span>-</span><span>21</span> <span>19</span>:<span>16</span>:<span>46.09</span> spid3s      Warning: Failure <span>to</span> calculate super<span>-</span>latch promotion threshold.</span></span></span></span>

陳述

本文內容由網友自願投稿，版權歸原作者所有。本站不承擔相應的法律責任。如發現涉嫌抄襲或侵權的內容，請聯絡admin@php.cn

MySQL與Sqlite有何不同？Apr 24, 2025 am 12:12 AM

MySQL和SQLite的主要區別在於設計理念和使用場景：1.MySQL適用於大型應用和企業級解決方案，支持高性能和高並發；2.SQLite適合移動應用和桌面軟件，輕量級且易於嵌入。

MySQL中的索引是什麼？它們如何提高性能？Apr 24, 2025 am 12:09 AM

MySQL中的索引是數據庫表中一列或多列的有序結構，用於加速數據檢索。 1）索引通過減少掃描數據量提升查詢速度。 2）B-Tree索引利用平衡樹結構，適合範圍查詢和排序。 3）創建索引使用CREATEINDEX語句，如CREATEINDEXidx_customer_idONorders(customer_id)。 4）複合索引可優化多列查詢，如CREATEINDEXidx_customer_orderONorders(customer_id,order_date)。 5）使用EXPLAIN分析查詢計劃，避

說明如何使用MySQL中的交易來確保數據一致性。Apr 24, 2025 am 12:09 AM

在MySQL中使用事務可以確保數據一致性。 1)通過STARTTRANSACTION開始事務，執行SQL操作後用COMMIT提交或ROLLBACK回滾。 2)使用SAVEPOINT可以設置保存點，允許部分回滾。 3)性能優化建議包括縮短事務時間、避免大規模查詢和合理使用隔離級別。

在哪些情況下，您可以選擇PostgreSQL而不是MySQL？Apr 24, 2025 am 12:07 AM

選擇PostgreSQL而非MySQL的場景包括：1)需要復雜查詢和高級SQL功能，2)要求嚴格的數據完整性和ACID遵從性，3)需要高級空間功能，4)處理大數據集時需要高性能。 PostgreSQL在這些方面表現出色，適合需要復雜數據處理和高數據完整性的項目。

如何保護MySQL數據庫？Apr 24, 2025 am 12:04 AM

MySQL數據庫的安全可以通過以下措施實現：1.用戶權限管理：通過CREATEUSER和GRANT命令嚴格控制訪問權限。 2.加密傳輸：配置SSL/TLS確保數據傳輸安全。 3.數據庫備份和恢復：使用mysqldump或mysqlpump定期備份數據。 4.高級安全策略：使用防火牆限制訪問，並啟用審計日誌記錄操作。 5.性能優化與最佳實踐：通過索引和查詢優化以及定期維護兼顧安全和性能。

您可以使用哪些工具來監視MySQL性能？Apr 23, 2025 am 12:21 AM

如何有效監控MySQL性能？使用mysqladmin、SHOWGLOBALSTATUS、PerconaMonitoringandManagement(PMM)和MySQLEnterpriseMonitor等工具。 1.使用mysqladmin查看連接數。 2.用SHOWGLOBALSTATUS查看查詢數。 3.PMM提供詳細性能數據和圖形化界面。 4.MySQLEnterpriseMonitor提供豐富的監控功能和報警機制。

MySQL與SQL Server有何不同？Apr 23, 2025 am 12:20 AM

MySQL和SQLServer的区别在于：1)MySQL是开源的，适用于Web和嵌入式系统，2)SQLServer是微软的商业产品，适用于企业级应用。两者在存储引擎、性能优化和应用场景上有显著差异，选择时需考虑项目规模和未来扩展性。

在哪些情況下，您可以選擇SQL Server而不是MySQL？Apr 23, 2025 am 12:20 AM

在需要高可用性、高級安全性和良好集成性的企業級應用場景下，應選擇SQLServer而不是MySQL。 1)SQLServer提供企業級功能，如高可用性和高級安全性。 2)它與微軟生態系統如VisualStudio和PowerBI緊密集成。 3)SQLServer在性能優化方面表現出色，支持內存優化表和列存儲索引。

See all articles