{"id":730,"date":"2014-10-21T06:05:57","date_gmt":"2014-10-21T06:05:57","guid":{"rendered":"http:\/\/ryltech.wpengine.com\/he\/?page_id=730"},"modified":"2014-10-21T06:06:19","modified_gmt":"2014-10-21T06:06:19","slug":"lock-monitoring","status":"publish","type":"page","link":"https:\/\/www.ryltech.co.il\/he\/professional-directory\/lock-monitoring\/","title":{"rendered":"\u05e0\u05d9\u05d8\u05d5\u05e8 \u05e0\u05e2\u05d9\u05dc\u05d5\u05ea"},"content":{"rendered":"<p>\u05e0\u05e2\u05d9\u05dc\u05d5\u05ea \u05d1\u05d1\u05e1\u05d9\u05e1\u05d9 \u05e0\u05ea\u05d5\u05e0\u05d9\u05dd \u05de\u05ea\u05e8\u05d7\u05e9\u05d5\u05ea \u05dc\u05e2\u05d9\u05ea\u05d9\u05dd \u05e7\u05e8\u05d5\u05d1\u05d5\u05ea \u05d5\u05de\u05d8\u05e8\u05ea\u05df \u05dc\u05d4\u05d2\u05df \u05e2\u05dc \u05de\u05e9\u05d0\u05d1\u05d9 \u05d1\u05e1\u05d9\u05e1\u05d9 \u05d4\u05e0\u05ea\u05d5\u05e0\u05d9\u05dd \u05d5\u05dc\u05e9\u05de\u05d5\u05e8 \u05e2\u05dc \u05d0\u05de\u05d9\u05e0\u05d5\u05ea \u05d5\u05e2\u05e7\u05d1\u05d9\u05d5\u05ea \u05d4\u05e0\u05ea\u05d5\u05e0\u05d9\u05dd \u05e9\u05d1\u05d5. \u05e2\u05dd \u05d6\u05d0\u05ea \u05d4\u05e0\u05e2\u05d9\u05dc\u05d5\u05ea, \u05d1\u05de\u05d9\u05d3\u05d4 \u05d5\u05d4\u05df \u05de\u05de\u05d5\u05e9\u05db\u05d5\u05ea \u05e4\u05d5\u05d2\u05e2\u05d5\u05ea \u05d1\u05d1\u05d9\u05e6\u05d5\u05e2\u05d9 \u05d4\u05de\u05e2\u05e8\u05db\u05ea \u05de\u05db\u05d9\u05d5\u05d5\u05df \u05e9\u05d4\u05df \u05de\u05e2\u05db\u05d1\u05d5\u05ea \u05d8\u05e8\u05d0\u05e0\u05d6\u05d0\u05e7\u05e6\u05d9\u05d5\u05ea \u05d4\u05de\u05de\u05ea\u05d9\u05e0\u05d5\u05ea \u05dc\u05de\u05e9\u05d0\u05d1\u05d9\u05dd \u05d4\u05e0\u05e2\u05d5\u05dc\u05d9\u05dd \u05de\u05dc\u05d4\u05ea\u05d1\u05e6\u05e2, \u05e2\u05dc \u05db\u05df \u05d7\u05e9\u05d5\u05d1 \u05dc\u05e0\u05d8\u05e8 \u05d0\u05ea \u05d4\u05e0\u05e2\u05d9\u05dc\u05d5\u05ea \u05d4\u05df \u05db\u05d3\u05d9 \u05dc\u05d5\u05d5\u05d3\u05d0 \u05e9\u05d4\u05df \u05de\u05ea\u05d1\u05e6\u05e2\u05d5\u05ea \u05d1\u05d8\u05e8\u05d0\u05e0\u05d6\u05d0\u05e7\u05e6\u05d9\u05d5\u05ea \u05d4\u05de\u05e9\u05ea\u05de\u05e9\u05d5\u05ea \u05d1\u05de\u05d9\u05d3\u05e2 \u05e9\u05d1\u05de\u05e9\u05d0\u05d1\u05d9\u05dd \u05d5\/\u05d0\u05d5 \u05de\u05e9\u05e0\u05d5\u05ea \u05d0\u05d5\u05ea\u05d5 \u05db\u05d3\u05d9 \u05dc\u05de\u05e0\u05d5\u05e2 \u05e4\u05d2\u05d9\u05e2\u05d4 \u05d1\u05e0\u05ea\u05d5\u05e0\u05d9\u05dd, \u05d4\u05df \u05db\u05d3\u05d9 \u05dc\u05de\u05e6\u05d5\u05d0 \u05d3\u05e8\u05db\u05d9\u05dd \u05dc\u05e7\u05e6\u05e8 \u05d0\u05ea \u05de\u05e9\u05db\u05df \u05db\u05db\u05dc \u05d4\u05d0\u05e4\u05e9\u05e8 \u05db\u05d3\u05d9 \u05dc\u05de\u05e0\u05d5\u05e2 \u05e4\u05d2\u05d9\u05e2\u05d4 \u05d1\u05d1\u05d9\u05e6\u05d5\u05e2\u05d9\u05dd \u05d5\u05d4\u05df \u05db\u05d3\u05d9 \u05dc\u05d5\u05d5\u05d3\u05d0 \u05e9\u05d0\u05d9\u05e0\u05df \u05de\u05ea\u05d1\u05e6\u05e2\u05d5\u05ea \u05d4\u05d9\u05db\u05df \u05e9\u05d0\u05d9\u05df \u05d1\u05d4\u05df \u05e6\u05d5\u05e8\u05da.<\/p>\n<p>\u05e0\u05e2\u05d9\u05dc\u05d5\u05ea \u05d1\u05d1\u05e1\u05d9\u05e1\u05d9 \u05e0\u05ea\u05d5\u05e0\u05d9\u05dd \u05e0\u05d5\u05e2\u05d3\u05d5 \u05dc\u05d4\u05d2\u05df \u05e2\u05dc \u05de\u05e9\u05d0\u05d1\u05d9\u05dd \u05d0\u05d5 \u05d0\u05d5\u05d1\u05d9\u05d9\u05e7\u05d8\u05d9\u05dd \u05de\u05e9\u05d5\u05ea\u05e4\u05d9\u05dd, \u05de\u05e9\u05d0\u05d1\u05d9\u05dd \u05d0\u05dc\u05d4 \u05e2\u05e9\u05d5\u05d9\u05d9\u05dd \u05dc\u05d4\u05d9\u05d5\u05ea:<\/p>\n<ul>\n<li>\u05d8\u05d1\u05dc\u05d0\u05d5\u05ea<\/li>\n<li>\u05e9\u05d5\u05e8\u05d5\u05ea \u05e0\u05ea\u05d5\u05e0\u05d9\u05dd<\/li>\n<li>\u05d1\u05dc\u05d5\u05e7\u05d9 \u05e0\u05ea\u05d5\u05e0\u05d9\u05dd<\/li>\n<li>\u05e4\u05e8\u05d9\u05d8\u05d9\u05dd \u05de\u05d5\u05d8\u05de\u05e0\u05d9\u05dd<\/li>\n<li>\u05d7\u05d9\u05d1\u05d5\u05e8\u05d9\u05dd (IP)<\/li>\n<li>\u05de\u05e2\u05e8\u05db\u05d5\u05ea \u05e9\u05dc\u05de\u05d5\u05ea<\/li>\n<\/ul>\n<p>\u05e7\u05d9\u05d9\u05de\u05d9\u05dd \u05d2\u05dd \u05e1\u05d5\u05d2\u05d9\u05dd \u05e9\u05d5\u05e0\u05d9\u05dd \u05e9\u05dc \u05de\u05e0\u05e2\u05d5\u05dc\u05d9\u05dd \u05d4\u05d9\u05db\u05d5\u05dc\u05d9\u05dd \u05dc\u05d2\u05e8\u05d5\u05dd \u05dc\u05e0\u05e2\u05d9\u05dc\u05d5\u05ea \u05de\u05e9\u05d5\u05ea\u05e4\u05d5\u05ea, \u05e0\u05e2\u05d9\u05dc\u05d5\u05ea \u05d1\u05dc\u05e2\u05d3\u05d9\u05d5\u05ea, \u05e0\u05e2\u05d9\u05dc\u05d5\u05ea \u05d8\u05e8\u05d0\u05e0\u05d6\u05d0\u05e7\u05e6\u05d9\u05d5\u05e0\u05d0\u05dc\u05d9\u05d5\u05ea, \u05e0\u05e2\u05d9\u05dc\u05d5\u05ea DML \u05d5\u05e0\u05e2\u05d9\u05dc\u05d5\u05ea \u05d2\u05d9\u05d1\u05d5\u05d9-\u05e9\u05d7\u05d6\u05d5\u05e8. \u05de\u05db\u05dc \u05de\u05e7\u05d5\u05dd, \u05de\u05e1\u05de\u05da \u05d6\u05d4 \u05d9\u05ea\u05de\u05e7\u05d3 \u05d1\u05e1\u05d5\u05d2 \u05d0\u05d7\u05d3 \u05e9\u05dc \u05e0\u05e2\u05d9\u05dc\u05d5\u05ea, \u05e0\u05e2\u05d9\u05dc\u05d5\u05ea \u05d8\u05e8\u05d0\u05e0\u05d6\u05d0\u05e7\u05e6\u05d9\u05d5\u05e0\u05d0\u05dc\u05d9\u05d5\u05ea.<br \/>\n\u05d4\u05e0\u05d4 \u05e9\u05d0\u05d9\u05dc\u05ea\u05d0 \u05e9\u05ea\u05e1\u05d9\u05d9\u05e2 \u05dc\u05da \u05dc\u05d2\u05dc\u05d5\u05ea \u05d0\u05ea \u05d4\u05e9\u05d0\u05d9\u05dc\u05ea\u05d5\u05ea \u05d4\u05e0\u05d5\u05e2\u05dc\u05d5\u05ea \u05d1\u05d1\u05e1\u05d9\u05e1 \u05d4\u05e0\u05ea\u05d5\u05e0\u05d9\u05dd \u05e9\u05dc\u05da:<\/p>\n<p><code>-- Perform cleanup.<br \/>\nIF EXISTS(SELECT * FROM sys.server_event_sessions WHERE name='FindBlockers')<br \/>\n    DROP EVENT SESSION FindBlockers ON SERVER<br \/>\nGO<br \/>\nDECLARE @dbid int<\/p>\n<p>SELECT @dbid = db_id(DB_NAME())<\/p>\n<p>DECLARE @sql nvarchar(1024)<br \/>\nSET @sql = '<br \/>\nCREATE EVENT SESSION FindBlockers ON SERVER<br \/>\nADD EVENT sqlserver.lock_acquired<br \/>\n    (action<br \/>\n        ( sqlserver.sql_text, sqlserver.database_id, sqlserver.tsql_stack,<br \/>\n         sqlserver.plan_handle, sqlserver.session_id)<br \/>\n    WHERE ( database_id=' + cast(@dbid as nvarchar) + ' AND resource_0!=0)<br \/>\n    ),<br \/>\nADD EVENT sqlserver.lock_released<br \/>\n    (WHERE ( database_id=' + cast(@dbid as nvarchar) + ' AND resource_0!=0 ))<br \/>\nADD TARGET package0.pair_matching<br \/>\n    ( SET begin_event=''sqlserver.lock_acquired'',<br \/>\n            begin_matching_columns=''database_id, resource_0, resource_1, resource_2, transaction_id, mode'',<br \/>\n            end_event=''sqlserver.lock_released'',<br \/>\n            end_matching_columns=''database_id, resource_0, resource_1, resource_2, transaction_id, mode'',<br \/>\n    respond_to_memory_pressure=1)<br \/>\nWITH (max_dispatch_latency = 1 seconds)'<\/p>\n<p>EXEC (@sql)<br \/>\n--<br \/>\n-- Create the metadata for the event session<br \/>\n-- Start the event session<br \/>\n--<br \/>\nALTER EVENT SESSION FindBlockers ON SERVER<br \/>\nSTATE = START<br \/>\n--<br \/>\n-- The pair matching targets report current unpaired events using<br \/>\n-- the sys.dm_xe_session_targets dynamic management view (DMV)<br \/>\n-- in XML format.<br \/>\n-- The following query retrieves the data from the DMV and stores<br \/>\n-- key data in a temporary table to speed subsequent access and<br \/>\n-- retrieval.<br \/>\n--<br \/>\nSELECT<br \/>\nobjlocks.value('(action[@name=\"session_id\"]\/value)[1]', 'int')<br \/>\n        AS session_id,<br \/>\n    objlocks.value('(data[@name=\"database_id\"]\/value)[1]', 'int')<br \/>\n        AS database_id,<br \/>\n    objlocks.value('(data[@name=\"resource_type\"]\/text)[1]', 'nvarchar(50)' )<br \/>\n        AS resource_type,<br \/>\n    objlocks.value('(data[@name=\"resource_0\"]\/value)[1]', 'bigint')<br \/>\n        AS resource_0,<br \/>\n    objlocks.value('(data[@name=\"resource_1\"]\/value)[1]', 'bigint')<br \/>\n        AS resource_1,<br \/>\n    objlocks.value('(data[@name=\"resource_2\"]\/value)[1]', 'bigint')<br \/>\n        AS resource_2,<br \/>\n    objlocks.value('(data[@name=\"mode\"]\/text)[1]', 'nvarchar(50)')<br \/>\n        AS mode,<br \/>\n    objlocks.value('(action[@name=\"sql_text\"]\/value)[1]', 'varchar(MAX)')<br \/>\n        AS sql_text,<br \/>\n    CAST(objlocks.value('(action[@name=\"plan_handle\"]\/value)[1]', 'varchar(MAX)') AS xml)<br \/>\n        AS plan_handle,<br \/>\n    CAST(objlocks.value('(action[@name=\"tsql_stack\"]\/value)[1]', 'varchar(MAX)') AS xml)<br \/>\n        AS tsql_stack<br \/>\nINTO #unmatched_locks<br \/>\nFROM (<br \/>\n    SELECT CAST(xest.target_data as xml)<br \/>\n        lockinfo<br \/>\n    FROM sys.dm_xe_session_targets xest<br \/>\n    JOIN sys.dm_xe_sessions xes ON xes.address = xest.event_session_address<br \/>\n    WHERE xest.target_name = 'pair_matching' AND xes.name = 'FindBlockers'<br \/>\n) heldlocks<br \/>\nCROSS APPLY lockinfo.nodes('\/\/event[@name=\"lock_acquired\"]') AS T(objlocks)<\/p>\n<p>--<br \/>\n-- Join the data acquired from the pairing target with other<br \/>\n-- DMVs to return provide additional information about blockers<br \/>\n--<br \/>\nSELECT ul.*<br \/>\n    FROM #unmatched_locks ul<br \/>\n    INNER JOIN sys.dm_tran_locks tl ON ul.database_id = tl.resource_database_id AND ul.resource_type = tl.resource_type<br \/>\n    WHERE resource_0 IS NOT NULL<br \/>\n    AND session_id IN<br \/>\n        (SELECT blocking_session_id FROM sys.dm_exec_requests WHERE blocking_session_id != 0)<br \/>\n    AND tl.request_status='wait'<br \/>\n    AND REPLACE(ul.mode, 'LCK_M_', '' ) = tl.request_mode<br \/>\n<\/code><br \/>\n\u05d0\u05d7\u05e8\u05d9 \u05e9\u05ea\u05e1\u05d9\u05d9\u05de\u05d5 \u05dc\u05e0\u05ea\u05d7 \u05d0\u05ea \u05d4\u05ea\u05d5\u05e6\u05d0\u05d5\u05ea \u05d0\u05dc \u05ea\u05e9\u05db\u05d7\u05d5 \u05dc\u05d4\u05e8\u05d9\u05e5 \u05d0\u05ea \u05d4\u05e4\u05e7\u05d5\u05d3\u05d5\u05ea \u05d4\u05d1\u05d0\u05d5\u05ea:<br \/>\n<code>DROP TABLE #unmatched_locks<br \/>\nDROP EVENT SESSION FindBlockers ON SERVER<\/code><\/p>\n<p>\u05db\u05da \u05ea\u05d5\u05db\u05dc \u05dc\u05d6\u05d4\u05d5\u05ea \u05d0\u05ea \u05d4\u05e9\u05d0\u05d9\u05dc\u05ea\u05d5\u05ea \u05d4\u05e0\u05d5\u05e2\u05dc\u05d5\u05ea \u05d1\u05d1\u05e1\u05d9\u05e1 \u05d4\u05e0\u05ea\u05d5\u05e0\u05d9\u05dd \u05e9\u05dc\u05da, \u05dc\u05e0\u05ea\u05d7 \u05d0\u05d5\u05ea\u05df \u05d5\u05dc\u05e4\u05e2\u05d5\u05dc \u05db\u05d3\u05d9 \u05dc\u05d9\u05d9\u05e2\u05dc \u05d0\u05d5\u05ea\u05df.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u05e0\u05e2\u05d9\u05dc\u05d5\u05ea \u05d1\u05d1\u05e1\u05d9\u05e1\u05d9 \u05e0\u05ea\u05d5\u05e0\u05d9\u05dd \u05de\u05ea\u05e8\u05d7\u05e9\u05d5\u05ea \u05dc\u05e2\u05d9\u05ea\u05d9\u05dd \u05e7\u05e8\u05d5\u05d1\u05d5\u05ea \u05d5\u05de\u05d8\u05e8\u05ea\u05df \u05dc\u05d4\u05d2\u05df \u05e2\u05dc \u05de\u05e9\u05d0\u05d1\u05d9 \u05d1\u05e1\u05d9\u05e1\u05d9 \u05d4\u05e0\u05ea\u05d5\u05e0\u05d9\u05dd \u05d5\u05dc\u05e9\u05de\u05d5\u05e8 \u05e2\u05dc \u05d0\u05de\u05d9\u05e0\u05d5\u05ea \u05d5\u05e2\u05e7\u05d1\u05d9\u05d5\u05ea \u05d4\u05e0\u05ea\u05d5\u05e0\u05d9\u05dd \u05e9\u05d1\u05d5. \u05e2\u05dd \u05d6\u05d0\u05ea \u05d4\u05e0\u05e2\u05d9\u05dc\u05d5\u05ea, \u05d1\u05de\u05d9\u05d3\u05d4 \u05d5\u05d4\u05df \u05de\u05de\u05d5\u05e9\u05db\u05d5\u05ea \u05e4\u05d5\u05d2\u05e2\u05d5\u05ea \u05d1\u05d1\u05d9\u05e6\u05d5\u05e2\u05d9 \u05d4\u05de\u05e2\u05e8\u05db\u05ea \u05de\u05db\u05d9\u05d5\u05d5\u05df \u05e9\u05d4\u05df \u05de\u05e2\u05db\u05d1\u05d5\u05ea \u05d8\u05e8\u05d0\u05e0\u05d6\u05d0\u05e7\u05e6\u05d9\u05d5\u05ea \u05d4\u05de\u05de\u05ea\u05d9\u05e0\u05d5\u05ea \u05dc\u05de\u05e9\u05d0\u05d1\u05d9\u05dd \u05d4\u05e0\u05e2\u05d5\u05dc\u05d9\u05dd \u05de\u05dc\u05d4\u05ea\u05d1\u05e6\u05e2, \u05e2\u05dc \u05db\u05df \u05d7\u05e9\u05d5\u05d1 \u05dc\u05e0\u05d8\u05e8 \u05d0\u05ea \u05d4\u05e0\u05e2\u05d9\u05dc\u05d5\u05ea \u05d4\u05df \u05db\u05d3\u05d9 \u05dc\u05d5\u05d5\u05d3\u05d0 \u05e9\u05d4\u05df \u05de\u05ea\u05d1\u05e6\u05e2\u05d5\u05ea \u05d1\u05d8\u05e8\u05d0\u05e0\u05d6\u05d0\u05e7\u05e6\u05d9\u05d5\u05ea \u05d4\u05de\u05e9\u05ea\u05de\u05e9\u05d5\u05ea \u05d1\u05de\u05d9\u05d3\u05e2 \u05e9\u05d1\u05de\u05e9\u05d0\u05d1\u05d9\u05dd \u05d5\/\u05d0\u05d5 \u05de\u05e9\u05e0\u05d5\u05ea \u05d0\u05d5\u05ea\u05d5 \u05db\u05d3\u05d9 \u05dc\u05de\u05e0\u05d5\u05e2 <a class=\"read-more\" href=\"https:\/\/www.ryltech.co.il\/he\/professional-directory\/lock-monitoring\/\">\u05e7\u05e8\u05d0 \u05e2\u05d5\u05d3<\/a><\/p>\n","protected":false},"author":1,"featured_media":733,"parent":712,"menu_order":0,"comment_status":"open","ping_status":"open","template":"page-templates\/script-article-page.php","meta":{"_bbp_topic_count":0,"_bbp_reply_count":0,"_bbp_total_topic_count":0,"_bbp_total_reply_count":0,"_bbp_voice_count":0,"_bbp_anonymous_reply_count":0,"_bbp_topic_count_hidden":0,"_bbp_reply_count_hidden":0,"_bbp_forum_subforum_count":0,"footnotes":""},"class_list":["post-730","page","type-page","status-publish","has-post-thumbnail","hentry"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.9.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u05e8\u05d9\u05dc\u05d8\u05e7 \u05d3\u05d9 \u05d1\u05d9 \u05d0\u05d9\u05d9 | \u05e0\u05d9\u05d8\u05d5\u05e8 \u05e0\u05e2\u05d9\u05dc\u05d5\u05ea<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.ryltech.co.il\/he\/professional-directory\/lock-monitoring\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u05e8\u05d9\u05dc\u05d8\u05e7 \u05d3\u05d9 \u05d1\u05d9 \u05d0\u05d9\u05d9 | \u05e0\u05d9\u05d8\u05d5\u05e8 \u05e0\u05e2\u05d9\u05dc\u05d5\u05ea\" \/>\n<meta property=\"og:description\" content=\"\u05e0\u05e2\u05d9\u05dc\u05d5\u05ea \u05d1\u05d1\u05e1\u05d9\u05e1\u05d9 \u05e0\u05ea\u05d5\u05e0\u05d9\u05dd \u05de\u05ea\u05e8\u05d7\u05e9\u05d5\u05ea \u05dc\u05e2\u05d9\u05ea\u05d9\u05dd \u05e7\u05e8\u05d5\u05d1\u05d5\u05ea \u05d5\u05de\u05d8\u05e8\u05ea\u05df \u05dc\u05d4\u05d2\u05df \u05e2\u05dc \u05de\u05e9\u05d0\u05d1\u05d9 \u05d1\u05e1\u05d9\u05e1\u05d9 \u05d4\u05e0\u05ea\u05d5\u05e0\u05d9\u05dd \u05d5\u05dc\u05e9\u05de\u05d5\u05e8 \u05e2\u05dc \u05d0\u05de\u05d9\u05e0\u05d5\u05ea \u05d5\u05e2\u05e7\u05d1\u05d9\u05d5\u05ea \u05d4\u05e0\u05ea\u05d5\u05e0\u05d9\u05dd \u05e9\u05d1\u05d5. \u05e2\u05dd \u05d6\u05d0\u05ea \u05d4\u05e0\u05e2\u05d9\u05dc\u05d5\u05ea, \u05d1\u05de\u05d9\u05d3\u05d4 \u05d5\u05d4\u05df \u05de\u05de\u05d5\u05e9\u05db\u05d5\u05ea \u05e4\u05d5\u05d2\u05e2\u05d5\u05ea \u05d1\u05d1\u05d9\u05e6\u05d5\u05e2\u05d9 \u05d4\u05de\u05e2\u05e8\u05db\u05ea \u05de\u05db\u05d9\u05d5\u05d5\u05df \u05e9\u05d4\u05df \u05de\u05e2\u05db\u05d1\u05d5\u05ea \u05d8\u05e8\u05d0\u05e0\u05d6\u05d0\u05e7\u05e6\u05d9\u05d5\u05ea \u05d4\u05de\u05de\u05ea\u05d9\u05e0\u05d5\u05ea \u05dc\u05de\u05e9\u05d0\u05d1\u05d9\u05dd \u05d4\u05e0\u05e2\u05d5\u05dc\u05d9\u05dd \u05de\u05dc\u05d4\u05ea\u05d1\u05e6\u05e2, \u05e2\u05dc \u05db\u05df \u05d7\u05e9\u05d5\u05d1 \u05dc\u05e0\u05d8\u05e8 \u05d0\u05ea \u05d4\u05e0\u05e2\u05d9\u05dc\u05d5\u05ea \u05d4\u05df \u05db\u05d3\u05d9 \u05dc\u05d5\u05d5\u05d3\u05d0 \u05e9\u05d4\u05df \u05de\u05ea\u05d1\u05e6\u05e2\u05d5\u05ea \u05d1\u05d8\u05e8\u05d0\u05e0\u05d6\u05d0\u05e7\u05e6\u05d9\u05d5\u05ea \u05d4\u05de\u05e9\u05ea\u05de\u05e9\u05d5\u05ea \u05d1\u05de\u05d9\u05d3\u05e2 \u05e9\u05d1\u05de\u05e9\u05d0\u05d1\u05d9\u05dd \u05d5\/\u05d0\u05d5 \u05de\u05e9\u05e0\u05d5\u05ea \u05d0\u05d5\u05ea\u05d5 \u05db\u05d3\u05d9 \u05dc\u05de\u05e0\u05d5\u05e2 \u05e7\u05e8\u05d0 \u05e2\u05d5\u05d3\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.ryltech.co.il\/he\/professional-directory\/lock-monitoring\/\" \/>\n<meta property=\"og:site_name\" content=\"Ryltech HEB\" \/>\n<meta property=\"article:modified_time\" content=\"2014-10-21T06:06:19+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.ryltech.co.il\/he\/wp-content\/uploads\/sites\/5\/2014\/10\/lock-icon.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"126\" \/>\n\t<meta property=\"og:image:height\" content=\"126\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.ryltech.co.il\/he\/professional-directory\/lock-monitoring\/\",\"url\":\"https:\/\/www.ryltech.co.il\/he\/professional-directory\/lock-monitoring\/\",\"name\":\"\u05e8\u05d9\u05dc\u05d8\u05e7 \u05d3\u05d9 \u05d1\u05d9 \u05d0\u05d9\u05d9 | \u05e0\u05d9\u05d8\u05d5\u05e8 \u05e0\u05e2\u05d9\u05dc\u05d5\u05ea\",\"isPartOf\":{\"@id\":\"https:\/\/www.ryltech.co.il\/he\/#website\"},\"datePublished\":\"2014-10-21T06:05:57+00:00\",\"dateModified\":\"2014-10-21T06:06:19+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.ryltech.co.il\/he\/professional-directory\/lock-monitoring\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.ryltech.co.il\/he\/professional-directory\/lock-monitoring\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.ryltech.co.il\/he\/professional-directory\/lock-monitoring\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.ryltech.co.il\/he\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u05d0\u05e8\u05db\u05d9\u05d5\u05df \u05de\u05e7\u05e6\u05d5\u05e2\u05d9\",\"item\":\"https:\/\/www.ryltech.co.il\/he\/professional-directory\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"\u05e0\u05d9\u05d8\u05d5\u05e8 \u05e0\u05e2\u05d9\u05dc\u05d5\u05ea\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.ryltech.co.il\/he\/#website\",\"url\":\"https:\/\/www.ryltech.co.il\/he\/\",\"name\":\"Ryltech HEB\",\"description\":\"SQL \u05e8\u05d9\u05dc\u05d8\u05e7 \u05d3\u05d9 \u05d1\u05d9 \u05d0\u05d9\u05d9 | \u05de\u05d5\u05de\u05d7\u05d9\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.ryltech.co.il\/he\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u05e8\u05d9\u05dc\u05d8\u05e7 \u05d3\u05d9 \u05d1\u05d9 \u05d0\u05d9\u05d9 | \u05e0\u05d9\u05d8\u05d5\u05e8 \u05e0\u05e2\u05d9\u05dc\u05d5\u05ea","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.ryltech.co.il\/he\/professional-directory\/lock-monitoring\/","og_locale":"en_US","og_type":"article","og_title":"\u05e8\u05d9\u05dc\u05d8\u05e7 \u05d3\u05d9 \u05d1\u05d9 \u05d0\u05d9\u05d9 | \u05e0\u05d9\u05d8\u05d5\u05e8 \u05e0\u05e2\u05d9\u05dc\u05d5\u05ea","og_description":"\u05e0\u05e2\u05d9\u05dc\u05d5\u05ea \u05d1\u05d1\u05e1\u05d9\u05e1\u05d9 \u05e0\u05ea\u05d5\u05e0\u05d9\u05dd \u05de\u05ea\u05e8\u05d7\u05e9\u05d5\u05ea \u05dc\u05e2\u05d9\u05ea\u05d9\u05dd \u05e7\u05e8\u05d5\u05d1\u05d5\u05ea \u05d5\u05de\u05d8\u05e8\u05ea\u05df \u05dc\u05d4\u05d2\u05df \u05e2\u05dc \u05de\u05e9\u05d0\u05d1\u05d9 \u05d1\u05e1\u05d9\u05e1\u05d9 \u05d4\u05e0\u05ea\u05d5\u05e0\u05d9\u05dd \u05d5\u05dc\u05e9\u05de\u05d5\u05e8 \u05e2\u05dc \u05d0\u05de\u05d9\u05e0\u05d5\u05ea \u05d5\u05e2\u05e7\u05d1\u05d9\u05d5\u05ea \u05d4\u05e0\u05ea\u05d5\u05e0\u05d9\u05dd \u05e9\u05d1\u05d5. \u05e2\u05dd \u05d6\u05d0\u05ea \u05d4\u05e0\u05e2\u05d9\u05dc\u05d5\u05ea, \u05d1\u05de\u05d9\u05d3\u05d4 \u05d5\u05d4\u05df \u05de\u05de\u05d5\u05e9\u05db\u05d5\u05ea \u05e4\u05d5\u05d2\u05e2\u05d5\u05ea \u05d1\u05d1\u05d9\u05e6\u05d5\u05e2\u05d9 \u05d4\u05de\u05e2\u05e8\u05db\u05ea \u05de\u05db\u05d9\u05d5\u05d5\u05df \u05e9\u05d4\u05df \u05de\u05e2\u05db\u05d1\u05d5\u05ea \u05d8\u05e8\u05d0\u05e0\u05d6\u05d0\u05e7\u05e6\u05d9\u05d5\u05ea \u05d4\u05de\u05de\u05ea\u05d9\u05e0\u05d5\u05ea \u05dc\u05de\u05e9\u05d0\u05d1\u05d9\u05dd \u05d4\u05e0\u05e2\u05d5\u05dc\u05d9\u05dd \u05de\u05dc\u05d4\u05ea\u05d1\u05e6\u05e2, \u05e2\u05dc \u05db\u05df \u05d7\u05e9\u05d5\u05d1 \u05dc\u05e0\u05d8\u05e8 \u05d0\u05ea \u05d4\u05e0\u05e2\u05d9\u05dc\u05d5\u05ea \u05d4\u05df \u05db\u05d3\u05d9 \u05dc\u05d5\u05d5\u05d3\u05d0 \u05e9\u05d4\u05df \u05de\u05ea\u05d1\u05e6\u05e2\u05d5\u05ea \u05d1\u05d8\u05e8\u05d0\u05e0\u05d6\u05d0\u05e7\u05e6\u05d9\u05d5\u05ea \u05d4\u05de\u05e9\u05ea\u05de\u05e9\u05d5\u05ea \u05d1\u05de\u05d9\u05d3\u05e2 \u05e9\u05d1\u05de\u05e9\u05d0\u05d1\u05d9\u05dd \u05d5\/\u05d0\u05d5 \u05de\u05e9\u05e0\u05d5\u05ea \u05d0\u05d5\u05ea\u05d5 \u05db\u05d3\u05d9 \u05dc\u05de\u05e0\u05d5\u05e2 \u05e7\u05e8\u05d0 \u05e2\u05d5\u05d3","og_url":"https:\/\/www.ryltech.co.il\/he\/professional-directory\/lock-monitoring\/","og_site_name":"Ryltech HEB","article_modified_time":"2014-10-21T06:06:19+00:00","og_image":[{"width":126,"height":126,"url":"https:\/\/www.ryltech.co.il\/he\/wp-content\/uploads\/sites\/5\/2014\/10\/lock-icon.jpg","type":"image\/jpeg"}],"twitter_misc":{"Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.ryltech.co.il\/he\/professional-directory\/lock-monitoring\/","url":"https:\/\/www.ryltech.co.il\/he\/professional-directory\/lock-monitoring\/","name":"\u05e8\u05d9\u05dc\u05d8\u05e7 \u05d3\u05d9 \u05d1\u05d9 \u05d0\u05d9\u05d9 | \u05e0\u05d9\u05d8\u05d5\u05e8 \u05e0\u05e2\u05d9\u05dc\u05d5\u05ea","isPartOf":{"@id":"https:\/\/www.ryltech.co.il\/he\/#website"},"datePublished":"2014-10-21T06:05:57+00:00","dateModified":"2014-10-21T06:06:19+00:00","breadcrumb":{"@id":"https:\/\/www.ryltech.co.il\/he\/professional-directory\/lock-monitoring\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.ryltech.co.il\/he\/professional-directory\/lock-monitoring\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.ryltech.co.il\/he\/professional-directory\/lock-monitoring\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.ryltech.co.il\/he\/"},{"@type":"ListItem","position":2,"name":"\u05d0\u05e8\u05db\u05d9\u05d5\u05df \u05de\u05e7\u05e6\u05d5\u05e2\u05d9","item":"https:\/\/www.ryltech.co.il\/he\/professional-directory\/"},{"@type":"ListItem","position":3,"name":"\u05e0\u05d9\u05d8\u05d5\u05e8 \u05e0\u05e2\u05d9\u05dc\u05d5\u05ea"}]},{"@type":"WebSite","@id":"https:\/\/www.ryltech.co.il\/he\/#website","url":"https:\/\/www.ryltech.co.il\/he\/","name":"Ryltech HEB","description":"SQL \u05e8\u05d9\u05dc\u05d8\u05e7 \u05d3\u05d9 \u05d1\u05d9 \u05d0\u05d9\u05d9 | \u05de\u05d5\u05de\u05d7\u05d9","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.ryltech.co.il\/he\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"}]}},"_links":{"self":[{"href":"https:\/\/www.ryltech.co.il\/he\/wp-json\/wp\/v2\/pages\/730","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.ryltech.co.il\/he\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.ryltech.co.il\/he\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.ryltech.co.il\/he\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.ryltech.co.il\/he\/wp-json\/wp\/v2\/comments?post=730"}],"version-history":[{"count":0,"href":"https:\/\/www.ryltech.co.il\/he\/wp-json\/wp\/v2\/pages\/730\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/www.ryltech.co.il\/he\/wp-json\/wp\/v2\/pages\/712"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.ryltech.co.il\/he\/wp-json\/wp\/v2\/media\/733"}],"wp:attachment":[{"href":"https:\/\/www.ryltech.co.il\/he\/wp-json\/wp\/v2\/media?parent=730"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}