{"id":2383,"date":"2012-12-28T10:00:32","date_gmt":"2012-12-28T10:00:32","guid":{"rendered":"http:\/\/enjoyasp.net\/?p=2383"},"modified":"2013-04-15T06:47:40","modified_gmt":"2013-04-15T06:47:40","slug":"sqlserver%e6%97%a5%e5%bf%97%e6%8f%90%e9%86%92","status":"publish","type":"post","link":"https:\/\/enjoyasp.net\/index.php\/2012\/12\/28\/sqlserver%e6%97%a5%e5%bf%97%e6%8f%90%e9%86%92\/","title":{"rendered":"sqlserver\u65e5\u5fd7\u63d0\u9192"},"content":{"rendered":"
\r\n\u8bfb\u53d6\u7684\u65e5\u5fd7\u6587\u4ef6\u6765\u81ea\u5b89\u88c5\u76ee\u5f55\u4e0b\uff1aMSSQL\\Log\\ERRORLOG\r\n\r\n--This will hold the rows\r\nCREATE TABLE #ErrorLog (LogDate datetime, ProcessInfo VarChar(10), ErrorMessage VarChar(Max))\r\n \r\n-- Dump the errorlog into the table\r\nINSERT INTO #ErrorLog\r\nEXEC master.dbo.xp_readerrorlog\r\n \r\n-- Delete everything older than 5 minutes\r\n-- ideally you will store the max date when it ran last\r\nDELETE #ErrorLog\r\nWHERE LogDate <  DATEADD(mi,-5,GETDATE())\r\n \r\n-- Some stuff you want to check for\r\n-- Failed backups...you want to know this\r\nSELECT * FROM #ErrorLog\r\nWHERE ErrorMessage LIKE'BACKUP failed%'\r\n \r\n-- Why does it take so looong to grow a file, maybe rethink your settings\r\nSELECT * FROM #ErrorLog\r\nWHERE ErrorMessage LIKE'Autogrow of file%'\r\n \r\n-- What is going on any backups or statistic updates running at this time?\r\nSELECT * FROM #ErrorLog\r\nWHERE ErrorMessage LIKE'SQL Server has encountered %occurrence(s) of I\/O requests taking longer than%'\r\n \r\n-- My mirror might not be up to date\r\nSELECT * FROM #ErrorLog\r\nWHERE ErrorMessage LIKE'The alert for ''unsent log'' has been raised%'\r\n \r\n \r\nDROP TABLE #ErrorLog\r\n\r\n\u6e05\u9664\u65e5\u5fd7\uff1aExec sp_cycle_errorlog\uff0c\u6267\u884c\u5f53\u524dERRORLOG \u91cd\u547d\u540d\u4e3aERRORLOG.1\r\n\r\n<\/pre>\n
\r\nExec<\/span> xp_readerrorlog 2<\/span>,1<\/span>,Null<\/span>,Null<\/span>,'<\/span>20130415 08:10<\/span>'<\/span>,'<\/span>20130415 12:30<\/span>'<\/span>,'<\/span>Asc<\/span>'<\/span>\r\nGO\r\nparameters:<\/span><\/strong>\r\n  1.Value of error log file you want to read: 0 = current, 1 = Archive #1, 2 = Archive #2, etc... <\/span>\r\n  2.Log file type: 1 or NULL = error log, 2 = SQL Agent log <\/span>\r\n  3.Search string 1: String one you want to search for <\/span>\r\n  4.Search string 2: String two you want to search for to further refine the results<\/span>\r\n  5.Search the start time<\/span>\r\n  6.Search the end time<\/span>\r\n  7.Sort order for results: N'asc' = ascending, N'desc' = descending<\/span><\/span><\/pre>\n
<\/p>\n
\r\n\r\n\r\n<\/span><\/span><\/pre>\n
\u53c2\u8003\uff1aProactive notifications<\/a> \u6b7b\u9501\u63d0\u9192<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"
\u8bfb\u53d6\u7684\u65e5\u5fd7\u6587\u4ef6\u6765\u81ea\u5b89\u88c5\u76ee\u5f55\u4e0b\uff1aMSSQL\\Log\\ERRORLOG –This will hold the  […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[36],"tags":[],"class_list":["post-2383","post","type-post","status-publish","format-standard","hentry","category-sql-server"],"blocksy_meta":[],"_links":{"self":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/2383","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/comments?post=2383"}],"version-history":[{"count":0,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/2383\/revisions"}],"wp:attachment":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/media?parent=2383"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/categories?post=2383"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/tags?post=2383"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}