{"id":2273,"date":"2016-11-16T23:22:54","date_gmt":"2016-11-16T23:22:54","guid":{"rendered":"http:\/\/pariswells.com\/blog\/?p=2273"},"modified":"2023-06-08T09:01:20","modified_gmt":"2023-06-08T09:01:20","slug":"iis-performance-counter-total-locked-errors-how-to-detect-locked-files","status":"publish","type":"post","link":"https:\/\/pariswells.com\/blog\/random\/iis-performance-counter-total-locked-errors-how-to-detect-locked-files","title":{"rendered":"IIS Performance Counter – Total Locked Errors – How to detect locked files"},"content":{"rendered":"
\n
\"solarwinds-inc-logo[1]\"<\/figure>\n<\/div>\n\n\n

We had some alerts coming up for an IIS site in Solarwinds which read the value for this <\/p>\n\n\n\n


Win32_PerfFormattedData_W3SVC_WebService(SITECODE)\\TotalLockedErrors<\/strong><\/p>\n\n\n\n

And alerted us when above 0. This is a Custom Performance Counter Monitor which uses WMI to get the counter by reading the IIS Log Files.<\/p>\n\n\n\n

Per Microsoft Description of the alert : <\/p>\n\n\n\n

Number of requests that could not be satisfied by the server because the requested document was locked (since service startup).Generally reported as HTTP error 423.<\/em><\/p>\n\n\n\n

There is no other way to find out which files were locked apart from Parsing the IIS Log Files<\/p>\n\n\n\n

How to do this?<\/strong><\/p>\n\n\n\n

Download and install these both<\/p>\n\n\n\n

https:\/\/www.microsoft.com\/en-us\/download\/confirmation.aspx?id=24659<\/a><\/p>\n\n\n\n

https:\/\/techcommunity.microsoft.com\/t5\/exchange-team-blog\/introducing-log-parser-studio\/ba-p\/601131<\/a> -> Click on LPSV2.D2.zip<\/p>\n\n\n\n

<\/a><\/p>\n\n\n\n

Once done , open up Studio and insert the IIS Log Files. ( Click here for how to find these<\/a> ) <\/p>\n\n\n\n

Make sure the Log type is set to IISW3CLOG <\/p>\n\n\n\n

Use the Query below to Query all the 423 Errors<\/p>\n\n\n\n

The list you are presented should show you all the files that have been locked which you can inspect and up the threshold if needed or increase the value of this Threshold!<\/p>\n\n\n

\/* All 423 errors to any IIS\/.NET Web Service *\/<\/p>\n

SELECT cs-uri-stem as Uri,<\/p>\n

sc-status as HttpStatus,<\/p>\n

sc-substatus as SubStatus,<\/p>\n

sc-win32-status as Win32Status,<\/p>\n

COUNT(*) AS Total<\/p>\n

FROM ‘[LOGFILEPATH]’<\/p>\n

WHERE (sc-status = 423)<\/p>\n

GROUP BY Uri, HttpStatus, SubStatus, Win32Status<\/p>\n

ORDER BY Total DESC<\/p>\n","protected":false},"excerpt":{"rendered":"

We had some alerts coming up for an IIS site in Solarwinds which read the value for this  Win32_PerfFormattedData_W3SVC_WebService(SITECODE)\\TotalLockedErrors And alerted us when above 0. This is […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[1659,1660,1401,1658,1663,1662,1661,1267,1664],"class_list":["post-2273","post","type-post","status-publish","format-standard","hentry","category-random","tag-how-to-find-locked-files","tag-http-error-423","tag-iis","tag-locked","tag-locked-files","tag-log-files","tag-parse","tag-solarwinds","tag-total-locked-files"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t