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的目录里面,用记事本或者其他编辑器打开找问题原因了
------------------------------------------------------------------------------------------------------------
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>

MySQLはGPLライセンスを使用します。 1)GPLライセンスにより、MySQLの無料使用、変更、分布が可能になりますが、変更された分布はGPLに準拠する必要があります。 2)商業ライセンスは、公的な変更を回避でき、機密性を必要とする商用アプリケーションに適しています。

Myisamの代わりにInnoDBを選択する場合の状況には、次のものが含まれます。1)トランザクションサポート、2)高い並行性環境、3)高いデータの一貫性。逆に、Myisamを選択する際の状況には、1)主に操作を読む、2)トランザクションサポートは必要ありません。 INNODBは、eコマースプラットフォームなどの高いデータの一貫性とトランザクション処理を必要とするアプリケーションに適していますが、Myisamはブログシステムなどの読み取り集約型およびトランザクションのないアプリケーションに適しています。

MySQLでは、外部キーの機能は、テーブル間の関係を確立し、データの一貫性と整合性を確保することです。外部キーは、参照整合性チェックとカスケード操作を通じてデータの有効性を維持します。パフォーマンスの最適化に注意し、それらを使用するときに一般的なエラーを避けてください。

MySQLには、B-Treeインデックス、ハッシュインデックス、フルテキストインデックス、空間インデックスの4つのメインインデックスタイプがあります。 1.B-Treeインデックスは、範囲クエリ、ソート、グループ化に適しており、従業員テーブルの名前列の作成に適しています。 2。HASHインデックスは、同等のクエリに適しており、メモリストレージエンジンのHASH_TABLEテーブルのID列の作成に適しています。 3。フルテキストインデックスは、記事テーブルのコンテンツ列の作成に適したテキスト検索に使用されます。 4.空間インデックスは、地理空間クエリに使用され、場所テーブルのGEOM列での作成に適しています。

tocreateanindexinmysql、usethecreateindexstatement.1)forasinglecolumn、 "createdexidx_lastnameonemployees(lastname);" 2)foracompositeindexを使用して、 "createindexidx_nameonemployees(lastname、firstname);" 3); "3)、" 3)を使用します

MySQLとSQLiteの主な違いは、設計コンセプトと使用法のシナリオです。1。MySQLは、大規模なアプリケーションとエンタープライズレベルのソリューションに適しており、高性能と高い並行性をサポートしています。 2。SQLiteは、モバイルアプリケーションとデスクトップソフトウェアに適しており、軽量で埋め込みやすいです。

MySQLのインデックスは、データの取得をスピードアップするために使用されるデータベーステーブル内の1つ以上の列の順序付けられた構造です。 1)インデックスは、スキャンされたデータの量を減らすことにより、クエリ速度を改善します。 2)B-Tree Indexは、バランスの取れたツリー構造を使用します。これは、範囲クエリとソートに適しています。 3)CreateIndexステートメントを使用して、createIndexidx_customer_idonorders(customer_id)などのインデックスを作成します。 4)Composite Indexesは、createIndexIDX_CUSTOMER_ORDERONORDERS(Customer_Id、Order_date)などのマルチコラムクエリを最適化できます。 5)説明を使用してクエリ計画を分析し、回避します

MySQLでトランザクションを使用すると、データの一貫性が保証されます。 1)StartTransactionを介してトランザクションを開始し、SQL操作を実行して、コミットまたはロールバックで送信します。 2)SavePointを使用してSave Pointを設定して、部分的なロールバックを許可します。 3)パフォーマンスの最適化の提案には、トランザクション時間の短縮、大規模なクエリの回避、分離レベルの使用が合理的に含まれます。


ホットAIツール

Undresser.AI Undress
リアルなヌード写真を作成する AI 搭載アプリ

AI Clothes Remover
写真から衣服を削除するオンライン AI ツール。

Undress AI Tool
脱衣画像を無料で

Clothoff.io
AI衣類リムーバー

Video Face Swap
完全無料の AI 顔交換ツールを使用して、あらゆるビデオの顔を簡単に交換できます。

人気の記事

ホットツール

ZendStudio 13.5.1 Mac
強力な PHP 統合開発環境

SublimeText3 英語版
推奨: Win バージョン、コードプロンプトをサポート!

メモ帳++7.3.1
使いやすく無料のコードエディター

SAP NetWeaver Server Adapter for Eclipse
Eclipse を SAP NetWeaver アプリケーション サーバーと統合します。

WebStorm Mac版
便利なJavaScript開発ツール

ホットトピック









