{"id":3177,"date":"2015-09-28T08:57:47","date_gmt":"2015-09-28T08:57:47","guid":{"rendered":"http:\/\/enjoyasp.net\/?p=3177"},"modified":"2015-09-28T08:57:47","modified_gmt":"2015-09-28T08:57:47","slug":"%e5%b8%b8%e7%94%a8%e7%9a%84sql%e6%80%a7%e8%83%bd%e8%af%ad%e5%8f%a5","status":"publish","type":"post","link":"https:\/\/enjoyasp.net\/index.php\/2015\/09\/28\/%e5%b8%b8%e7%94%a8%e7%9a%84sql%e6%80%a7%e8%83%bd%e8%af%ad%e5%8f%a5\/","title":{"rendered":"\u5e38\u7528\u7684sql\u6027\u80fd\u8bed\u53e5"},"content":{"rendered":"
\r\nSET QUOTED_IDENTIFIER ON\r\nSET ANSI_NULLS ON\r\nGO\r\nCREATE PROC [dbo].[p_lockinfo]\r\n    @kill_lock_spid BIT = 1 , --\u662f\u5426\u6740\u6389\u6b7b\u9501\u7684\u8fdb\u7a0b,1 \u6740\u6389, 0 \u4ec5\u663e\u793a\r\n    @show_spid_if_nolock BIT = 1 --\u5982\u679c\u6ca1\u6709\u6b7b\u9501\u7684\u8fdb\u7a0b,\u662f\u5426\u663e\u793a\u6b63\u5e38\u8fdb\u7a0b\u4fe1\u606f,1 \u663e\u793a,0 \u4e0d\u663e\u793a\r\nAS \r\n    DECLARE @count INT ,\r\n        @s VARCHAR(MAX) ,\r\n        @i INT\r\n    SELECT  id = IDENTITY( INT,1,1 ),\r\n            \u6807\u5fd7 ,\r\n            \u8fdb\u7a0bID = spid ,\r\n            \u7ebf\u7a0bID = kpid ,\r\n            \u5757\u8fdb\u7a0bID = blocked ,\r\n            \u6570\u636e\u5e93ID = dbid ,\r\n            \u6570\u636e\u5e93\u540d = DB_NAME(dbid) ,\r\n            \u7528\u6237ID = uid ,\r\n            \u7528\u6237\u540d = loginame ,\r\n            \u7d2f\u8ba1CPU\u65f6\u95f4 = cpu ,\r\n            \u767b\u9646\u65f6\u95f4 = login_time ,\r\n            \u6253\u5f00\u4e8b\u52a1\u6570 = open_tran ,\r\n            \u8fdb\u7a0b\u72b6\u6001 = status ,\r\n            \u5de5\u4f5c\u7ad9\u540d = hostname ,\r\n            \u5e94\u7528\u7a0b\u5e8f\u540d = program_name ,\r\n            \u5de5\u4f5c\u7ad9\u8fdb\u7a0bID = hostprocess ,\r\n            \u57df\u540d = nt_domain ,\r\n            \u7f51\u5361\u5730\u5740 = net_address,\r\n\t\t\tsql_handle,\r\n\t\t\tstmt_start,\r\n\t\t\tstmt_end\r\n\r\n    INTO    #t\r\n    FROM    ( SELECT    \u6807\u5fd7 = '\u6b7b\u9501\u7684\u8fdb\u7a0b' ,\r\n                        spid ,\r\n                        kpid ,\r\n                        a.blocked ,\r\n                        dbid ,\r\n                        uid ,\r\n                        loginame ,\r\n                        cpu ,\r\n                        login_time ,\r\n                        open_tran ,\r\n                        status ,\r\n                        hostname ,\r\n                        program_name ,\r\n                        hostprocess ,\r\n                        nt_domain ,\r\n                        net_address ,\r\n                        s1 = a.spid ,\r\n                        s2 = 0,\r\n\t\t\t\t\t\tsql_handle,\r\n\t\t\t\t\t\tstmt_start,\r\n\t\t\t\t\t\tstmt_end\r\n              FROM      master..sysprocesses a\r\n                        JOIN ( SELECT   blocked\r\n                               FROM     master..sysprocesses\r\n                               GROUP BY blocked\r\n                             ) b ON a.spid = b.blocked\r\n              WHERE     a.blocked = 0\r\n              UNION ALL\r\n              SELECT    '|_\u727a\u7272\u54c1_>' ,\r\n                        spid ,\r\n                        kpid ,\r\n                        blocked ,\r\n                        dbid ,\r\n                        uid ,\r\n                        loginame ,\r\n                        cpu ,\r\n                        login_time ,\r\n                        open_tran ,\r\n                        status ,\r\n                        hostname ,\r\n                        program_name ,\r\n                        hostprocess ,\r\n                        nt_domain ,\r\n                        net_address ,\r\n                        s1 = blocked ,\r\n                        s2 = 1,\r\n\t\t\t\t\t\tsql_handle,\r\n\t\t\t\t\t\tstmt_start,\r\n\t\t\t\t\t\tstmt_end\r\n              FROM      master..sysprocesses a\r\n              WHERE     blocked <> 0\r\n            ) a\r\n    ORDER BY s1 ,\r\n            s2\r\n\r\n    SELECT  @count = @@rowcount ,\r\n            @i = 1\r\n\r\n    IF @count = 0\r\n        AND @show_spid_if_nolock = 1 \r\n        BEGIN\r\n            INSERT  #t\r\n                    SELECT  \u6807\u5fd7 = '\u6b63\u5e38\u7684\u8fdb\u7a0b' ,\r\n                            spid ,\r\n                            kpid ,\r\n                            blocked ,\r\n                            dbid ,\r\n                            DB_NAME(dbid) ,\r\n                            uid ,\r\n                            loginame ,\r\n                            cpu ,\r\n                            login_time ,\r\n                            open_tran ,\r\n                            status ,\r\n                            hostname ,\r\n                            program_name ,\r\n                            hostprocess ,\r\n                            nt_domain ,\r\n                            net_address,\r\n\t\t\t\t\t\t\tsql_handle,\r\n\t\t\t\t\t\t\tstmt_start,\r\n\t\t\t\t\t\t\tstmt_end\r\n                    FROM    master..sysprocesses\r\n            SET @count = @@rowcount\r\n        END\r\n\r\n    IF @count > 0 \r\n        BEGIN\r\n            CREATE TABLE #t1\r\n                (\r\n                  id INT IDENTITY(1, 1) ,\r\n                  a NVARCHAR(3000) ,\r\n                  b INT ,\r\n                  EventInfo NVARCHAR(2000)\r\n                )\r\n            IF @kill_lock_spid = 1 \r\n                BEGIN\r\n                    DECLARE @spid VARCHAR(50) ,\r\n                        @\u6807\u5fd7 VARCHAR(50)\r\n                    WHILE @i <= @count \r\n                        BEGIN\r\n                            SELECT  @spid = \u8fdb\u7a0bID ,\r\n                                    @\u6807\u5fd7 = \u6807\u5fd7\r\n                            FROM    #t\r\n                            WHERE   id = @i\r\n                            INSERT  #t1\r\n                                    EXEC ( 'dbcc inputbuffer(' + @spid + ')'\r\n                                        )\r\n                            IF @\u6807\u5fd7 = '\u6b7b\u9501\u7684\u8fdb\u7a0b' \r\n                                EXEC('kill '+@spid)\r\n                            SET @i = @i + 1\r\n                        END\r\n                END\r\n            ELSE \r\n                WHILE @i <= @count \r\n                    BEGIN\r\n                        SELECT  @s = 'dbcc inputbuffer('\r\n                                + CAST(\u8fdb\u7a0bID AS VARCHAR) + ')'\r\n                        FROM    #t\r\n                        WHERE   id = @i\r\n                        INSERT  #t1\r\n                                EXEC ( @s\r\n                                    )\r\n                        SET @i = @i + 1\r\n                    END\r\n            SELECT  \u6807\u5fd7 ,\r\n\t\t\t \u6570\u636e\u5e93\u540d ,\r\n\t\t\t  \u8fdb\u7a0b\u7684SQL\u8bed\u53e5 = b.EventInfo,\r\n\t\t\t\t\tsqlText=substring(qt.text,a.stmt_start\/2, \r\n \t\t\t\t\t(case when a.stmt_end = -1 \r\n\t\t\t\t\t\t  then len(convert(nvarchar(max), qt.text)) * 2 \r\n\t\t\t\t\t\t  else a.stmt_end end -a.stmt_start)\/2\r\n\t\t\t\t\t) ,\r\n\t\t\t\t\t \u8fdb\u7a0b\u72b6\u6001,\r\n            \u7528\u6237\u540d,\r\n            \u7d2f\u8ba1CPU\u65f6\u95f4,\r\n            \u767b\u9646\u65f6\u95f4  ,\r\n            \u5de5\u4f5c\u7ad9\u540d ,\r\n            \u5e94\u7528\u7a0b\u5e8f\u540d,\r\n\t\t\t \u8fdb\u7a0bID ,\r\n            \u7ebf\u7a0bID  \r\n            FROM    #t a\r\n                    JOIN #t1 b ON a.id = b.id\r\n\t\t\t\t\tOUTER apply sys.dm_exec_sql_text(a.sql_handle) as qt\r\n        END\r\nGO\r\n\r\n\r\nSET QUOTED_IDENTIFIER ON\r\nSET ANSI_NULLS ON\r\nGO\r\n\r\n\r\n\r\n\r\n--==========================\r\n--\u521b\u5efa\u4eba\uff1a zxs 20110728\r\n\r\n--==========================\r\nCREATE       PROCEDURE [dbo].[p_cpu]\r\n@TopNum INT =NULL,\r\n@Last_Execution_Time VARCHAR(50) = NULL\r\nAS\r\nSET @TopNum = ISNULL(@TopNum,50) --\u9ed8\u8ba4\u524d50\u6761\r\nSET @Last_Execution_Time = ISNULL(@Last_Execution_Time,'2012-01-01') --\u9ed8\u8ba4\u524d50\u6761\r\n\/*\r\nSELECT TOP (@TopNum)\r\n    qs.total_worker_time\/qs.execution_count\/1000. as [\u5e73\u5747\u6d88\u8017CPU \u65f6\u95f4(ms)],\r\n    total_worker_time\/1000 AS [\u603b\u6d88\u8017CPU \u65f6\u95f4(ms)],execution_count [\u8fd0\u884c\u6b21\u6570],\r\n    SUBSTRING(qt.text,qs.statement_start_offset\/2+1,\r\n        (case when qs.statement_end_offset = -1\r\n        then DATALENGTH(qt.text)\r\n        else qs.statement_end_offset end -qs.statement_start_offset)\/2 + 1)\r\n    as [\u67e5\u8be2\u8bed\u53e5], qt.text [\u6240\u5728\u5b58\u50a8\u8fc7\u7a0b],\r\n    qt.dbid, dbname=db_name(qt.dbid),\r\n    qt.objectid,object_name(qt.objectid,qt.dbid) ObjectName\r\n \r\nFROM sys.dm_exec_query_stats qs\r\ncross apply sys.dm_exec_sql_text(qs.sql_handle) as qt\r\nWHERE qs.last_execution_time >=@Last_Execution_Time --\u9650\u5b9a\u65f6\u95f4\r\nORDER BY\r\n        [\u5e73\u5747\u6d88\u8017CPU \u65f6\u95f4(ms)] DESC\r\n*\/\r\n\r\n\tSELECT SUM([\u5e73\u5747\u6d88\u8017CPU \u65f6\u95f4(ms)])[\u5e73\u5747\u6d88\u8017CPU \u65f6\u95f4(ms)],\r\n\tSUM([\u603b\u6d88\u8017CPU \u65f6\u95f4(ms)]) [\u603b\u6d88\u8017CPU \u65f6\u95f4(ms)],\r\n\tSUM([\u8fd0\u884c\u6b21\u6570])[\u8fd0\u884c\u6b21\u6570],[\u67e5\u8be2\u8bed\u53e5],[\u6240\u5728\u5b58\u50a8\u8fc7\u7a0b],\r\n\tdbid, dbname,objectid,ObjectName\r\n\tFROM (\r\n\tSELECT TOP (50)\r\n\t\tqs.total_worker_time\/qs.execution_count\/1000. as [\u5e73\u5747\u6d88\u8017CPU \u65f6\u95f4(ms)],\r\n\t\ttotal_worker_time\/1000 AS [\u603b\u6d88\u8017CPU \u65f6\u95f4(ms)],execution_count [\u8fd0\u884c\u6b21\u6570],\r\n\t    \r\n\t\tdbo.SQLSig(SUBSTRING(qt.text,qs.statement_start_offset\/2+1, --\u5229\u7528sqlsig\u51fd\u6570\u8fdb\u884c\u53c2\u6570\u5316\uff0c\u4ee5\u5c4f\u853d\u4f20\u6765\u7684\u53c2\u6570\uff0c\u4f7f\u4e4b\u6807\u51c6\u5316\r\n\t\t\t(case when qs.statement_end_offset = -1\r\n\t\t\tthen DATALENGTH(qt.text)\r\n\t\t\telse qs.statement_end_offset end -qs.statement_start_offset)\/2 + 1),4000)\r\n\t\tas [\u67e5\u8be2\u8bed\u53e5], qt.text [\u6240\u5728\u5b58\u50a8\u8fc7\u7a0b],\r\n\t\tqt.dbid, dbname=db_name(qt.dbid),\r\n\t\tqt.objectid,object_name(qt.objectid,qt.dbid) ObjectName\r\n\tFROM sys.dm_exec_query_stats qs\r\n\tcross apply sys.dm_exec_sql_text(qs.sql_handle) as qt\r\n\tWHERE qs.last_execution_time >=CONVERT(VARCHAR(10),GETDATE(),120)\r\n\tORDER BY [\u5e73\u5747\u6d88\u8017CPU \u65f6\u95f4(ms)] DESC\r\n\t)M\r\n\tGROUP BY [\u67e5\u8be2\u8bed\u53e5],[\u6240\u5728\u5b58\u50a8\u8fc7\u7a0b],dbid, dbname,objectid,ObjectName\r\n\tORDER BY [\u5e73\u5747\u6d88\u8017CPU \u65f6\u95f4(ms)] DESC\r\n\r\nGO\r\n\r\n\r\nSET QUOTED_IDENTIFIER OFF\r\nSET ANSI_NULLS ON\r\nGO\r\n\r\n--==========================\r\n--\u521b\u5efa\u4eba\uff1a zxs 20120420 \r\n--\u67e5\u8be2\u5f53\u524d\u7684\u9501,\u53ca\u76f8\u5173sql\u8bed\u53e5\r\n--==========================\r\nCREATE       PROCEDURE [dbo].[p_curwaitdropindex]\r\n\tAS\r\nSelect d.database_id,d.name,t.object_id, ix.index_id,user_updates, (user_seeks+user_scans) AS use_Count,t.name AS tb_name,ix.name AS ix_name,sc.name AS col_name\r\n    from sys.dm_db_index_usage_stats ius\r\n\tJOIN sys.databases d ON d.database_id=ius.database_id\r\n    JOIN sys.tables t ON ius.object_id = t.object_id\r\n    JOIN sys.indexes ix ON t.object_id = ix.object_id AND ix.index_id = ius.index_id\r\n    JOIN sys.index_columns ixc ON t.object_id = ixc.object_id AND ix.index_id = ixc.index_id\r\n    JOIN sys.columns sc ON t.object_id = sc.object_id AND ixc.column_id = sc.column_id\r\n    where user_updates > 10 * (user_seeks+user_scans)\r\n    and ius.index_id > 1\r\n    AND CHARINDEX('merge',t.name) <1\r\n    order by user_updates \/ (user_seeks+user_scans+1) DESC\r\n\r\nGO\r\nSET QUOTED_IDENTIFIER ON\r\nSET ANSI_NULLS ON\r\nGO\r\n\r\n\r\n\r\n--==========================\r\n--\u521b\u5efa\u4eba\uff1a zxs 20110728\r\n\r\n--==========================\r\nCREATE       PROCEDURE [dbo].[p_curRun]\r\nAS \r\n\r\n\tSELECT DB_NAME(r.database_id) DB,s.session_id,\r\n\tsubstring(qt.text,r.statement_start_offset\/2,\r\n\t(case when r.statement_end_offset = -1\r\n\tthen len(convert(nvarchar(max), qt.text)) * 2\r\n\telse r.statement_end_offset end -r.statement_start_offset)\/2\r\n\t) as 'SQL statement',\r\n\tqt.text batch,s.status,c.client_net_address,s.login_name, s.program_name,s.host_name,\r\n\ts.login_time,c.connect_time,s.last_request_start_time, s.last_request_end_time,s.session_id,\r\n\ts.host_process_id, s.client_version, s.client_interface_name,c.net_transport, c.net_packet_size,\r\n\tr.request_id, r.start_time, r.status, r.command, r.user_id, r.blocking_session_id, r.wait_type,r.wait_time,\r\n\tr.last_wait_type, r.wait_resource, r.open_transaction_count,r.transaction_id, r.percent_complete, r.cpu_time, r.reads, r.writes,r.granted_query_memory\r\n\tFROM Sys.dm_exec_connections c\r\n\tJOIN Sys.dm_exec_sessions s ON c.session_id = s.session_id\r\n\tJOIN Sys.dm_exec_requests r ON s.session_id = r.session_id\r\n\touter apply sys.dm_exec_sql_text(r.sql_handle) as qt\r\n\tWHERE r.status = 'running' AND s.session_id != @@SPID\r\n\tORDER BY c.client_net_address,s.login_name\r\n\r\n\r\nGO\r\nSET QUOTED_IDENTIFIER ON\r\nSET ANSI_NULLS ON\r\nGO\r\n\r\n\r\n\r\n\r\n\r\n--==========================\r\n--\u521b\u5efa\u4eba\uff1a zxs 20120420 \r\n--\u67e5\u8be2\u5f53\u524d\u7684\u9501,\u53ca\u76f8\u5173sql\u8bed\u53e5\r\n--==========================\r\nCREATE       PROCEDURE [dbo].[p_curlock]\r\n\tAS\r\nSELECT TL.resource_type AS ResType\r\n,TL.resource_description AS ResDescr\r\n,TL.request_mode AS ReqMode\r\n,TL.request_type AS ReqType\r\n,TL.request_status AS ReqStatus\r\n,TL.request_owner_type AS ReqOwnerType\r\n,TAT.[name] AS TransName\r\n,TAT.transaction_begin_time AS TransBegin\r\n,DATEDIFF(ss, TAT.transaction_begin_time, GETDATE()) AS TransDura\r\n,ES.session_id AS S_Id\r\n,ES.login_name AS LoginName\r\n,COALESCE(OBJ.name, PAROBJ.name) AS ObjectName\r\n,PARIDX.name AS IndexName\r\n,ES.host_name AS HostName\r\n,ES.program_name AS ProgramName\r\n,REQ.command AS ReqCommand\r\n,SUBSTRING(EST.text\r\n,1 + REQ.statement_start_offset \/ 2\r\n,(CASE WHEN REQ.statement_end_offset = -1\r\nTHEN LEN(convert(nvarchar(max), EST.text)) * 2\r\nELSE REQ.statement_end_offset END - REQ.statement_start_offset) \/ 2\r\n) AS SqlStatement\r\nFROM sys.dm_tran_locks AS TL\r\nINNER JOIN sys.dm_exec_sessions AS ES\r\nON TL.request_session_id = ES.session_id\r\nLEFT JOIN sys.dm_tran_active_transactions AS TAT\r\nON TL.request_owner_id = TAT.transaction_id\r\nAND TL.request_owner_type = 'TRANSACTION'\r\nLEFT JOIN sys.objects AS OBJ\r\nON TL.resource_associated_entity_id = OBJ.object_id\r\nAND TL.resource_type = 'OBJECT'\r\nLEFT JOIN sys.partitions AS PAR\r\nON TL.resource_associated_entity_id = PAR.hobt_id\r\nAND TL.resource_type IN ('PAGE', 'KEY', 'RID', 'HOBT')\r\n\r\nLEFT JOIN sys.objects AS PAROBJ\r\nON PAR.object_id = PAROBJ.object_id\r\nLEFT JOIN sys.indexes AS PARIDX\r\nON PAR.object_id = PARIDX.object_id\r\nAND PAR.index_id = PARIDX.index_id\r\nLEFT JOIN sys.dm_exec_requests AS REQ\r\nON TAT.transaction_id = REQ.transaction_id\r\nouter APPLY sys.dm_exec_sql_text(REQ.sql_handle) AS EST\r\n\r\nWHERE TL.resource_database_id = DB_ID()\r\nAND ES.session_id <> @@Spid\r\nAND TL.request_mode like  '%x%' \r\nORDER BY TL.resource_type\r\n,TL.request_mode\r\n,TL.request_type\r\n,TL.request_status\r\n,ObjectName\r\n,ES.login_name;\r\n\r\nGO\r\nSET QUOTED_IDENTIFIER ON\r\nSET ANSI_NULLS ON\r\nGO\r\n\r\n\r\n\r\n\r\n\r\n--==========================\r\n--\u521b\u5efa\u4eba\uff1a zxs 20120420 \r\n--\u67e5\u8be2\u5f53\u524d\u4e8b\u52a1\r\n--==========================\r\nCREATE       PROCEDURE [dbo].[p_curtran]\r\nAS\r\n\t\t\r\n\tSELECT CASE WHEN TDT.database_id = 32767\r\n\tTHEN 'MSSQLSystemResource'\r\n\tELSE DB.name END AS DatabaseName\r\n\t,REQ.start_time AS ReqStart\r\n\t,TAT.transaction_begin_time AS TransBegin\r\n\t,TAT.name AS TransName\r\n\t,CASE TDT.database_transaction_type\r\n\tWHEN 1 THEN N'Read\/Write'\r\n\tWHEN 2 THEN N'Read-only'\r\n\tWHEN 3 THEN N'System'\r\n\tELSE N'Unkown' END AS TransType\r\n\t,CASE TAT.transaction_state\r\n\tWHEN 0 THEN N'Not initialized'\r\n\tWHEN 1 THEN N'Not started'\r\n\tWHEN 2 THEN N'Active'\r\n\tWHEN 3 THEN N'Ended'\r\n\tWHEN 4 THEN N'DTC active'\r\n\tWHEN 5 THEN N'Preparing'\r\n\tWHEN 6 THEN N'Committing'\r\n\tWHEN 7 THEN N'Being rolled back'\r\n\tWHEN 8 THEN N'Rolled back'\r\n\tELSE N'Unkown'\r\n\tEND AS TransState\r\n\t,REQ.[status] AS ReqStatus\r\n\t,TDT.database_transaction_log_record_count AS LogRec\r\n\t,TDT.database_transaction_log_bytes_used AS LogBytes\r\n\t,SES.login_name AS LoginName\r\n\t,REQ.wait_type AS ReqWaitType\r\n\t,REQ.percent_complete AS [ReqCompl%]\r\n\t,REQ.command AS ReqCommand\r\n\t,SUBSTRING(EST.text\r\n\t,1 + REQ.statement_start_offset \/ 2\r\n\t,(CASE WHEN REQ.statement_end_offset = -1\r\n\tTHEN LEN(convert(nvarchar(max), EST.text)) * 2\r\n\tELSE REQ.statement_end_offset END - REQ.statement_start_offset) \/ 2\r\n\t) AS SqlStatement\r\n\tFROM sys.dm_tran_active_transactions AS TAT\r\n\tINNER JOIN sys.dm_tran_database_transactions AS TDT\r\n\tON TAT.transaction_id = TDT.transaction_id\r\n\tINNER JOIN sys.databases AS DB\r\n\tON TDT.database_id = DB.database_id\r\n\tLEFT JOIN sys.dm_tran_session_transactions AS TST\r\n\tON TAT.transaction_id = TST.transaction_id\r\n\tLEFT JOIN sys.dm_exec_requests AS REQ\r\n\tON TAT.transaction_id = REQ.transaction_id\r\n\tLEFT JOIN sys.dm_exec_sessions AS SES\r\n\tON REQ.session_id = SES.session_id\r\n\tCROSS APPLY sys.dm_exec_sql_text(REQ.sql_handle) AS EST\r\n\tWHERE TAT.transaction_id > 255\r\n\tAND ISNULL(REQ.session_id, -1) <> @@SPID\r\n\tAND TDT.database_id <> DB_ID(N'tempdb')\r\n\tORDER BY DatabaseName\r\n\t,TransBegin\r\n\t,TransName;\r\nGO\r\n\r\n<\/pre>\n","protected":false},"excerpt":{"rendered":"
SET QUOTED_IDENTIFIER ON SET ANSI_NULLS ON GO CREATE PR […]<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[36],"tags":[],"class_list":["post-3177","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\/3177","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=3177"}],"version-history":[{"count":0,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/posts\/3177\/revisions"}],"wp:attachment":[{"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/media?parent=3177"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/categories?post=3177"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/enjoyasp.net\/index.php\/wp-json\/wp\/v2\/tags?post=3177"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}