SQL Server進行Crash Recovery
我們看一下SQL Server的情況,使用DBCC fileheader命令來讀取file header page,編號為10是我的一個使用者庫SSS的資料庫ID
環境:SQL Server2012 64位
SELECT DB_ID('sss')DBCC fileheader(10)
(圖一)
(圖二)
(圖三)
(圖四)
從上面的圖大家應該發現一些規律
RecoveryForkLSN:Cash Recovery的時候需要呼叫的lsn,也是RedoStartLSN:27000000027100001
ReadOnlyLsn:只讀模式資料庫
ReadWriteLsn:讀寫模式資料庫
因為file header page是每個資料庫的mdf檔案的第一個頁面,啟動的過程裡面其實最重要也是最耗時就是資料庫redo和undo過程
所以把Redo Start LSN放在file header page也就不無道理了,資料庫一啟動馬上就讀取LSN資訊,然後到LDF檔案裡讀取日誌
資料庫第0頁:file header page
資料庫第1頁:PFS (Page Free Space) ,也叫頁面自由空間
資料庫第2頁:GAM 全域性分配對映(Global Allocation Map,GAM)頁面
資料庫第3頁:SGAM 共享全域性分配對映(Shared Global Allocation Map,SGAM)頁面
第4頁沒有資料
第5頁沒有資料
資料庫第6頁:DCM 差異變更(Differential Changed Map,DCM)頁面
資料庫第7頁:BCM 批次更改對映(Bulk Changed Map)頁面
資料庫第8頁:sys.sysqnames 存在於每個資料庫中。
資料庫第9頁:boot page 資料庫根據這個頁面的資訊來啟動的
boot page是放在第9頁不是放在第0頁,為什麼呢?因為資料庫先要進行Cash Recovery才能啟動啊
--看一下file header pageDBCC TRACEON(3604,-1)GODBCC PAGE([sss],1,0,3)GO
DBCC 執行完畢。如果 DBCC 輸出了錯誤資訊,請與系統管理員聯絡。PAGE: (1:0)BUFFER:BUF @0x00000002FDABA800bpage = 0x00000002EFF88000 bhash = 0x0000000000000000 bpageno = (1:0)bdbid = 10 breferences = 0 bcputicks = 88bsampleCount = 1 bUse1 = 36811 bstat = 0x9blog = 0x15ab215a bnext = 0x0000000000000000 PAGE HEADER:Page @0x00000002EFF88000m_pageId = (1:0) m_headerVersion = 1 m_type = 15m_typeFlagBits = 0x0 m_level = 0 m_flagBits = 0x208m_objId (AllocUnitId.idObj) = 99 m_indexId (AllocUnitId.idInd) = 0 Metadata: AllocUnitId = 6488064Metadata: PartitionId = 0 Metadata: IndexId = 0 Metadata: ObjectId = 99m_prevPage = (0:0) m_nextPage = (0:0) pminlen = 0m_slotCnt = 1 m_freeCnt = 7029 m_freeData = 7551m_reservedCnt = 0 m_lsn = (878:901:1) m_xactReserved = 0m_xdesId = (0:0) m_ghostRecCnt = 0 m_tornBits = -582568961DB Frag ID = 1 Allocation StatusGAM (1:2) = ALLOCATED SGAM (1:3) = NOT ALLOCATED PFS (1:1) = 0x44 ALLOCATED 100_PCT_FULLDIFF (1:6) = CHANGED ML (1:7) = NOT MIN_LOGGED File Header Data:Record Type = PRIMARY_RECORD Record Attributes = NULL_BITMAP VARIABLE_COLUMNSRecord Size = 1065 Memory Dump @0x000000000D1BB9560000000000000000: 30000800 00000000 31000000 00000000 002e007f 0.......1...........0000000000000014: 007f0081 00830087 008b008f 0093009d 00a700b1 ....................0000000000000028: 00b100b5 00b900bd 00c100cb 00e700f1 00fb0005 ....................000000000000003C: 0115011f 012f0133 013d013d 01430153 01530153 ...../.3.=.=.C.S.S.S0000000000000050: 01530153 01530153 01630163 0163016d 01770193 .S.S.S.S.c.c.c.m.w..0000000000000064: 019d01ad 01c901d1 012904c5 cbddcf11 44c34889 .........)......D.H.0000000000000078: 52cc552b 3eba7601 00010080 c00500ff ffffff80 R.U+>.v.............000000000000008C: 00000000 00000000 00000000 00000000 00000000 ....................00000000000000A0: 00000000 00000000 00000000 00000000 00800100 ....................00000000000000B4: 00000000 00ffffff ff000200 001b0000 000f0100 ....................00000000000000C8: 0001001b 0000000f 01000001 00000053 d02a7787 ...............S.*w.00000000000000DC: 3ec94e97 926f64fe 3febf81b 000000c3 000000b2 >.N..od.?...........00000000000000F0: 00000000 00000000 0000006e 0300006d 0300002e ...........n...m....0000000000000104: 00284a9c 892994c1 4692f4f1 e3c51d34 90000000 .(J..)..F......4....0000000000000118: 00000000 00000014 51b676d9 b1a34abc c0185ae9 ........Q.v...J...Z.000000000000012C: 6fccb108 0000001b 0000000f 01000001 00730073 o................s.s0000000000000140: 0073006a 49d8681b 194f469a 40c068d8 57651953 .s.jI.h..OF.@.h.We.S0000000000000154: d02a7787 3ec94e97 926f64fe 3febf800 00000000 .*w.>.N..od.?.......0000000000000168: 00000000 00000000 00000000 00000000 00000000 ....................000000000000017C: 00000000 00000000 00000000 00000000 00000000 ....................0000000000000190: 0000001b 000000c3 000000b2 006a49d8 681b194f .............jI.h..O00000000000001A4: 469a40c0 68d85765 19000000 00000000 00000000 F.@.h.We............00000000000001B8: 00000000 00000000 00000000 00000000 00000000 ....................00000000000001CC: 00000000 00000000 00000000 00000000 00000000 ....................00000000000001E0: 00000000 00000000 00000000 00000000 00000000 ....................00000000000001F4: 00000000 00000000 00000000 00000000 00000000 ....................0000000000000208: 00000000 00000000 00000000 00000000 00000000 ....................000000000000021C: 00000000 00000000 00000000 00000000 00000000 ....................0000000000000230: 00000000 00000000 00000000 00000000 00000000 ....................0000000000000244: 00000000 00000000 00000000 00000000 00000000 ....................0000000000000258: 00000000 00000000 00000000 00000000 00000000 ....................000000000000026C: 00000000 00000000 00000000 00000000 00000000 ....................0000000000000280: 00000000 00000000 00000000 00000000 00000000 ....................0000000000000294: 00000000 00000000 00000000 00000000 00000000 ....................00000000000002A8: 00000000 00000000 00000000 00000000 00000000 ....................00000000000002BC: 00000000 00000000 00000000 00000000 00000000 ....................00000000000002D0: 00000000 00000000 00000000 00000000 00000000 ....................00000000000002E4: 00000000 00000000 00000000 00000000 00000000 ....................00000000000002F8: 00000000 00000000 00000000 00000000 00000000 ....................000000000000030C: 00000000 00000000 00000000 00000000 00000000 ....................0000000000000320: 00000000 00000000 00000000 00000000 00000000 ....................0000000000000334: 00000000 00000000 00000000 00000000 00000000 ....................0000000000000348: 00000000 00000000 00000000 00000000 00000000 ....................000000000000035C: 00000000 00000000 00000000 00000000 00000000 ....................0000000000000370: 00000000 00000000 00000000 00000000 00000000 ....................0000000000000384: 00000000 00000000 00000000 00000000 00000000 ....................0000000000000398: 00000000 00000000 00000000 00000000 00000000 ....................00000000000003AC: 00000000 00000000 00000000 00000000 00000000 ....................00000000000003C0: 00000000 00000000 00000000 00000000 00000000 ....................00000000000003D4: 00000000 00000000 00000000 00000000 00000000 ....................00000000000003E8: 00000000 00000000 00000000 00000000 00000000 ....................00000000000003FC: 00000000 00000000 00000000 00000000 00000000 ....................0000000000000410: 00000000 00000000 00000000 00000000 00000000 ....................0000000000000424: 00000000 00 ..... BindingID = cfddcbc5-4411-48c3-8952-cc552b3eba76 FileIdProp = 1FileGroupId = 1 Size = 49280 MaxSize = 65535Growth = 128 Perf = 0 BackupLsn = (0:0:0)FirstUpdateLsn = (0:0:0) OldestRestoredLsn = (0:0:0) FirstNonloggedUpdateLsn = [NULL]MinSize = 384 Status = 0 UserShrinkSize = 65535SectorSize = 512 MaxLsn = (27:271:1) FirstLsn = (27:195:178)CreateLsn = (0:0:0) DifferentialBaseLsn = (878:877:46) DifferentialBaseGuid = 899c4a28-9429-46c1-92f4-f1e3c51d3490 FileOfflineLsn = (0:0:0)FileIdGuid = 76b65114-b1d9-4aa3-bcc0-185ae96fccb1 RestoreStatus = 8RestoreRedoStartLsn = (27:271:1) RestoreSourceGuid = 68d8496a-191b-464f-9a40-c068d8576519HardenedSkipLsn = [NULL] ReplTxfTruncationLsn = [NULL] TxfBackupLsn = [NULL]FstrContainerSize = [NULL] MaxLsnBranchId = 772ad053-3e87-4ec9-9792-6f64fe3febf8SecondaryRedoStartLsn = [NULL] SecondaryDifferentialBaseLsn = [NULL]ReadOnlyLsn = (0:0:0) ReadWriteLsn = (0:0:0) RestoreDifferentialBaseLsn = (27:195:178) RestoreDifferentialBaseGuid = 68d8496a-191b-464f-9a40-c068d8576519 RestorePathOriginhex (dec) = 0x00000000:00000000:0000 (0:0:0) m_guid = 00000000-0000-0000-0000-000000000000 DatabaseEncryptionFileState.m_maxScannedPage = 0 DatabaseEncryptionFileState.m_keyId = 0FCBFileDEKm_dbeStatusBits = 0 m_dtCreated = 1900-01-01 00:00:00.000m_dtLastRegenerated = 1900-01-01 00:00:00.000 m_dtLastModified = 1900-01-01 00:00:00.000 m_dtLastSet = 1900-01-01 00:00:00.000m_dtOpened = 1900-01-01 00:00:00.000m_algId = 0 m_algId = 0m_dwBitLen = 0 m_cbThumbprint = 0 m_rgbThumbprint = 0xDBCC 執行完畢。如果 DBCC 輸出了錯誤資訊,請與系統管理員聯絡。
--看一下boot page的內容DBCC TRACEON(3604,-1)GODBCC PAGE([sss],1,9,3)GO
Page @0x00000002EA7DE000m_pageId = (1:9) m_headerVersion = 1 m_type = 13m_typeFlagBits = 0x0 m_level = 0 m_flagBits = 0x200m_objId (AllocUnitId.idObj) = 99 m_indexId (AllocUnitId.idInd) = 0 Metadata: AllocUnitId = 6488064Metadata: PartitionId = 0 Metadata: IndexId = 0 Metadata: ObjectId = 99m_prevPage = (0:0) m_nextPage = (0:0) pminlen = 0m_slotCnt = 1 m_freeCnt = 6590 m_freeData = 1600m_reservedCnt = 0 m_lsn = (878:1345:2) m_xactReserved = 0m_xdesId = (0:0) m_ghostRecCnt = 0 m_tornBits = 2000067799DB Frag ID = 1 Allocation StatusGAM (1:2) = ALLOCATED SGAM (1:3) = NOT ALLOCATED PFS (1:1) = 0x64 MIXED_EXT ALLOCATED 100_PCT_FULL DIFF (1:6) = CHANGEDML (1:7) = NOT MIN_LOGGED Slot 0, Offset 0x60, Length 1504, DumpStyle BYTERecord Type = PRIMARY_RECORD Record Attributes = Record Size = 1504Memory Dump @0x000000000D1BA0600000000000000000: 0000e005 c2026302 00000000 00000000 00000000 ......c.............0000000000000014: 00000000 00000000 00000000 00000000 08008100 ....................0000000000000028: ae80847c bba19900 0ca30000 73007300 73002020 ...|........s.s.s. 000000000000003C: 20202020 20202020 20202020 20202020 20202020 0000000000000050: 20202020 20202020 20202020 20202020 20202020 0000000000000064: 20202020 20202020 20202020 20202020 20202020 0000000000000078: 20202020 20202020 20202020 20202020 20202020 000000000000008C: 20202020 20202020 20202020 20202020 20202020 00000000000000A0: 20202020 20202020 20202020 20202020 20202020 00000000000000B4: 20202020 20202020 20202020 20202020 20202020 00000000000000C8: 20202020 20202020 20202020 20202020 20202020 00000000000000DC: 20202020 20202020 20202020 20202020 20202020 00000000000000F0: 20202020 20202020 20202020 20202020 20202020 0000000000000104: 20202020 20202020 20202020 20202020 20202020 0000000000000118: 20202020 20202020 20202020 20202020 20202020 000000000000012C: 20202020 20202020 06000000 0a006e00 70170000 ......n.p...0000000000000140: 00000000 00000000 00000000 00000000 6e030000 ................n...0000000000000154: 6d030000 2e004000 6e030000 3a050000 0c000200 m.....@.n...:.......0000000000000168: 00000000 00000000 00000000 6e030000 3a050000 ............n...:...000000000000017C: 0c000000 c2271400 00000000 24d00000 00000000 .....'......$.......0000000000000190: 00000041 00000000 53d02a77 873ec94e 97926f64 ...A....S.*w.>.N..od00000000000001A4: fe3febf8 00e67dbf 00000000 00000000 00000000 .?....}.............00000000000001B8: 00000000 1b000000 0f010000 01000000 d305e86e ...................n00000000000001CC: 6e28d54a 892e8070 c5aec1fa 1b000000 0f010000 n(.J...p............00000000000001E0: 01000000 53d02a77 873ec94e 97926f64 fe3febf8 ....S.*w.>.N..od.?..00000000000001F4: 284a9c89 2994c146 92f4f1e3 c51d3490 14000000 (J..)..F......4.....0000000000000208: 01006302 00000000 00000000 00000000 22000000 ..c............."...000000000000021C: d0000000 03000400 80000000 00000000 00000000 ....................0000000000000230: 00000000 00000000 00000000 00000000 00000000 ....................0000000000000244: 00000000 00000000 00000000 00000000 00000000 ....................0000000000000258: 00000000 00000000 00000000 00000000 00000000 ....................000000000000026C: 00000000 00000000 00000000 00000000 00000000 ....................0000000000000280: c9020000 1e000000 e3000000 c3f9a100 bda30000 ....................0000000000000294: 00000000 00000000 00000000 00000000 553cda00 ................U<..00000000000002a8:>.]J.K00000000000002BC: b9a2abb7 5245120c 00000000 00000000 00000000 ....RE..............00000000000002D0: 00000000 00000000 00000000 00000000 96010000 ....................00000000000002E4: 00010000 00000000 00000000 00000000 02000000 ....................00000000000002F8: 00000000 00000000 00000000 00000000 00000000 ....................000000000000030C: 00000000 00000000 00000000 00000000 00000000 ....................0000000000000320: 00000000 00000000 00000000 00000000 00000000 ....................0000000000000334: 00000000 00000000 00000000 00000000 00000000 ....................0000000000000348: 00000000 00000000 00000000 00000000 00000000 ....................000000000000035C: 00000000 00000000 00000000 00000000 00000000 ....................0000000000000370: 00000000 00000000 00000000 00000000 00000000 ....................0000000000000384: 00000000 00000000 00000000 00000000 00000000 ....................0000000000000398: 00000000 00000000 00000000 00000000 00000000 ....................00000000000003AC: 00000000 00000000 00000000 00000000 00000000 ....................00000000000003C0: 00000000 00000000 00000000 00000000 00000000 ....................00000000000003D4: 00000000 00000000 00000000 00000000 00000000 ....................00000000000003E8: 00000000 00000000 00000000 00000000 00000000 ....................00000000000003FC: 00000000 00000000 00000000 00000000 00000000 ....................0000000000000410: 00000000 00000000 00000000 00000000 00000000 ....................0000000000000424: 00000000 00000000 00000000 00000000 00000000 ....................0000000000000438: 00000000 00000000 00000000 00000000 00000000 ....................000000000000044C: 00000000 00000000 00000000 00000000 00000000 ....................0000000000000460: 00000000 00000000 00000000 00000000 00000000 ....................0000000000000474: 00000000 00000000 00000000 00000000 00000000 ....................0000000000000488: 00000000 00000000 00000000 00000000 00000000 ....................000000000000049C: 00000000 00000000 00000000 00000000 00000000 ....................00000000000004B0: 00000000 00000000 00000000 00000000 00000000 ....................00000000000004C4: 00000000 00000000 00000000 00000000 00000000 ....................00000000000004D8: 00000000 00000000 00000000 00000000 00000000 ....................00000000000004EC: 00000000 00000000 00000000 00000000 00000000 ....................0000000000000500: 00000000 00000000 00000000 00000000 00000000 ....................0000000000000514: 00000000 00000000 00000000 00000000 00000000 ....................0000000000000528: 00000000 00000000 00000000 00000000 00000000 ....................000000000000053C: 00000000 00000000 00000000 00000000 00000000 ....................0000000000000550: 00000000 00000000 00000000 00000000 00000000 ....................0000000000000564: 00000000 00000000 00000000 00000000 00000000 ....................0000000000000578: 00000000 00000000 00000000 00000000 00000000 ....................000000000000058C: 00000000 00000000 00000000 00000000 00000000 ....................00000000000005A0: 00000000 00000000 00000000 20000000 78000000 ............ ...x...00000000000005B4: 43000000 00000000 00000000 00000000 00000000 C...................00000000000005C8: 00000000 00000000 00000000 00000000 00000000 ....................00000000000005DC: 00000000 .... DBINFO @0x000000000D1BA060dbi_version = 706 dbi_createVersion = 611 dbi_SEVersion = 0dbi_dvSplitPoint = 0:0:0 (0x00000000:00000000:0000) dbi_dbbackupLSN = 0:0:0 (0x00000000:00000000:0000) dbi_LastLogBackupTime = 1900-01-01 00:00:00.000 dbi_nextseqnum = 1900-01-01 00:00:00.000 dbi_status = 0x00810008dbi_crdate = 2014-04-13 09:19:21.370dbi_dbname = sss dbi_dbid = 10dbi_cmptlevel = 110 dbi_masterfixups = 0 dbi_maxDbTimestamp = 6000dbi_dbbackupLSN = 0:0:0 (0x00000000:00000000:0000) dbi_RebuildLogs = 0dbi_differentialBaseLSN = 878:877:46 (0x0000036e:0000036d:002e) dbi_RestoreFlags = 0x0040dbi_checkptLSN = 878:1338:12 (0x0000036e:0000053a:000c) dbi_dbccFlags = 2dbi_COWLastLSN = 0:0:0 (0x00000000:00000000:0000) dbi_DirtyPageLSN = 878:1338:12 (0x0000036e:0000053a:000c) dbi_RecoveryFlags = 0x00000000dbi_lastxact = 0x1427c2 dbi_collation = 53284 dbi_relstat = 0x41000000dbi_familyGUID = 772ad053-3e87-4ec9-9792-6f64fe3febf8 dbi_maxLogSpaceUsed = 3212699136dbi_recoveryForkNameStackentry 0hex (dec) = 0x0000001b:0000010f:0001 (27:271:1) m_guid = 6ee805d3-286e-4ad5-892e-8070c5aec1fa entry 1hex (dec) = 0x0000001b:0000010f:0001 (27:271:1) m_guid = 772ad053-3e87-4ec9-9792-6f64fe3febf8 dbi_differentialBaseGuid = 899c4a28-9429-46c1-92f4-f1e3c51d3490 dbi_firstSysIndexes = 0001:00000014dbi_oldestBackupXactLSN = 0:0:0 (0x00000000:00000000:0000) dbi_versionChangeLSN = 34:208:3 (0x00000022:000000d0:0003) dbi_mdUpgStat = 0x0004dbi_category = 0x0000000000000080 dbi_safetySequence = 0 dbi_dbMirrorId = 00000000-0000-0000-0000-000000000000 dbi_pageUndoLsn = 0:0:0 (0x00000000:00000000:0000) dbi_pageUndoState = 0dbi_disabledSequence = 0 dbi_dbmRedoLsn = 0:0:0 (0x00000000:00000000:0000)dbi_dbmOldestXactLsn = 0:0:0 (0x00000000:00000000:0000) dbi_CloneCpuCount = 0dbi_CloneMemorySize = 0 dbi_updSysCatalog = 1900-01-01 00:00:00.000dbi_LogBackupChainOrigin = 713:30:227 (0x000002c9:0000001e:00e3) dbi_dbccLastKnownGood = 2014-10-07 09:49:44.117 dbi_roleSequence = 0dbi_dbmHardenedLsn = 0:0:0 (0x00000000:00000000:0000) dbi_localState = 0dbi_safety = 0 dbi_modDate = 2014-04-06 13:14:34.310dbi_verRDB = 184552376 dbi_lazyCommitOption = 0 dbi_svcBrokerGUID = 953e1259-4a5d-4b11-b9a2-abb75245120c dbi_svcBrokerOptions = 0x00000000dbi_dbmLogZeroOutstanding = 0 dbi_dbmLastGoodRoleSequence = 0 dbi_dbmRedoQueue = 0dbi_dbmRedoQueueType = 0 dbi_rmidRegistryValueDeleted = 0 dbi_dbmConnectionTimeout = 0dbi_fragmentId = 0 dbi_AuIdNext = 1099511628182 dbi_MinSkipLsn = 0:0:0 (0x00000000:00000000:0000) dbi_commitTsOfcheckptLSN = 2dbi_dbEmptyVersionState = 0 dbi_CurrentGeneration = 0 dbi_EncryptionHistoryScan 0hex (dec) = 0x00000000:00000000:0000 (0:0:0) EncryptionScanInfo:ScanId = 0 Scan 1hex (dec) = 0x00000000:00000000:0000 (0:0:0) EncryptionScanInfo:ScanId = 0 Scan 2hex (dec) = 0x00000000:00000000:0000 (0:0:0) EncryptionScanInfo:ScanId = 0 dbi_latestVersioningUpgradeLSN = 32:120:67 (0x00000020:00000078:0043) dbi_splitAGE = 0dbi_PendingRestoreOutcomesId = 00000000-0000-0000-0000-000000000000 dbi_ContianmentState = 0
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/3407/viewspace-2812949/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- [zt]如何進行SQL Server 2000進行Disaster RecoverySQLServerAST
- postgres crash recovery
- Crash recovery和Media recovery的區別
- 【Oracle】-Difference between Instance recovery and Crash RecoveryOracle
- Overview of Instance and Crash RecoveryView
- SQL Server小知識:Recovery IntervalSQLServer
- SQL Server如何配置cdc進行ETLSQLServer
- MySQL crash recovery恢復慢分析MySql
- MySQL InnoDB Update和Crash Recovery流程MySql
- MySQL:Innodb crash recovery一些程式碼MySql
- SQL Server SQL語句進行優化的基本原則SQLServer優化
- SQL Server的幾種恢復模式(recovery models)SQLServer模式
- 執行SQL語句導致mysqld的crashMySql
- SQL Server SQL語句進行優化的基本原則 (轉)SQLServer優化
- 用SQL Server來進行會話狀態管理SQLServer會話
- SQL Server 行號SQLServer
- 在SQL Server中對檢視進行增刪改SQLServer
- SQL Server中對圖片進行儲存和輸出SQLServer
- Errors and Recovery for the Server Parameter FileErrorServer
- SQL Server執行計劃SQLServer
- SQL SERVER執行指令碼SQLServer指令碼
- 使用 Visual Studio 進行 SQL Server 原始碼管理和部署SQLServer原始碼
- SQL Server中使用DTS設計器進行資料轉移SQLServer
- SQL Server 2008進行備份事務日誌SQLServer
- SQL Server SQL語句執行順序SQLServer
- 進行SQL Server縱向擴充套件的必備條件KVSQLServer套件
- 通過SQL Server對上傳檔案內容進行查詢SQLServer
- SQL Server中利用SET ROWCOUNT來高效能地進行分頁SQLServer
- 剖析SQL Server執行計劃SQLServer
- SQL Server調優系列進階篇(查詢優化器的執行方式)SQLServer優化
- SQLServer進行SQL跟蹤SQLServer
- 使用sqlmap進行sql注入SQL
- 使用SQL Profile進行SQL優化案例SQL優化
- 用並行查詢讓SQL Server加速執行並行SQLServer
- SQL Server 查詢歷史執行的SQL語句SQLServer
- SQL Server簡潔查詢正在執行SQL(等待事件)SQLServer事件
- SQL server 動態SQL對變數講行賦值SQLServer變數賦值
- SQL Server中檢視SQL句子執行所用的時間SQLServer