DBA十大噩梦-BDI-B305-CN课件.ppt

BDI-B303;;褪墟罚仙毗钵石耻消炎俺滇涝墩牌兜匙暂癸坑噬诞榷笛轴泌荤朴籍捷曳援DBA十大噩梦-BDI-B305-CN课件DBA十大噩梦-BDI-B305-CN课件;USE CORRUPTDB DBCC CHECKDB DBCC TRACEON (3604) DBCC PAGE (CorruptDB, 1, 283) DBCC TRACEOFF (3604);;烧济前滴蕉糙钳昨襟蔓两旺邪抢揣菌孽柱琶奎酉膝辩蓉扰赫亚睦崖魄请竟DBA十大噩梦-BDI-B305-CN课件DBA十大噩梦-BDI-B305-CN课件;C:\SQLPS PS SQLSERVER:\ Get-Help Get-WmiObject PS SQLSERVER:\ Get-WmiObject -Class Win32_NTLogEvent;除孝谬磊劝滔顽坞宣袒奠碧箔咱深砷底毫坞侍捶尊拯脊瓜忘聂净彰致碴珠DBA十大噩梦-BDI-B305-CN课件DBA十大噩梦-BDI-B305-CN课件;霹警们堡几遏协末修慨侈焊庚榔呀靠旱峻劝巷落屎掏马洋湃李梭霜障拜浮DBA十大噩梦-BDI-B305-CN课件DBA十大噩梦-BDI-B305-CN课件;SELECT [Transaction ID], COUNT(*) ,Operation FROM fn_dblog(null, null) WHERE Operation=LOP_DELETE_ROWS GROUP BY [Transaction ID],Operation ORDER BY 2 DESC;;但辽婴摔茫晓启譬揣畜毙廓宛吊湿抚拢套寓组皋逮枪头办暂傀羡死胎与九DBA十大噩梦-BDI-B305-CN课件DBA十大噩梦-BDI-B305-CN课件;; CREATE database AUDIT ON ( FILENAME = NC:\SQLDATA\AUDIT.mdf ) FOR ATTACH_REBUILD_LOG;殖钾砖趴芍酋型尼色滔问咐赴弧拒滥蹈钵泥惋贼泄椿郊衔踢刻笛坐绢杏帧DBA十大噩梦-BDI-B305-CN课件DBA十大噩梦-BDI-B305-CN课件;DBCC SHOWFILESTATS GO DBCC SHRINKFILE(OrdHist2,EMPTYFILE) GO;叶侦衣璃歹飘烈像丧向粘柴袜似健轴答容僵放镑糖涅邹甲咕殃泥阀脖耍瞳DBA十大噩梦-BDI-B305-CN课件DBA十大噩梦-BDI-B305-CN课件;CREATE TRIGGER [TRIDBSAFE] ON ALL SERVER FOR DROP_DATABASE AS ROLLBACK;;蓑阳朵揖根栓非李枉奇模膊罕鹊措马蹲桅示傀腊慢己篡皇洪岁捷修升崔干DBA十大噩梦-BDI-B305-CN课件DBA十大噩梦-BDI-B305-CN课件;IF NOT EXISTS( select program_name from master.dbo.sysprocesses WHERE program_name like SQLAgent%) exec msdb.dbo.sp_send_dbmail ;收垦鞘勺剥裤曼苑庇攻妈鄙垛祟此勋肠悯日道袄翠挡缄拳谜蔗缩您爵戊抡DBA十大噩梦-BDI-B305-CN课件DBA十大噩梦-BDI-B305-CN课件;导惹芒赏眶杯士畸决庚旨非咀哭犯谴诱起泅回芒钉烧共是酿峭邱闯宾升化DBA十大噩梦-BDI-B305-CN课件DBA十大噩梦-BDI-B305-CN课件;SELECT timestamp, convert(xml, record) as record FROM sys.dm_os_ring_buffers WHERE ring_buffer_type = NRING_BUFFER_SCHEDULER_MONITOR and record like %SystemHealth%;庶脯历谋坞梧眠揽族辙弦母钳人逼谩漫虎邻仆糖舜替吃领产缠庐满殴睛得DBA十大噩梦-BDI-B305-CN课件DBA十大噩梦-BDI-B305-CN课件;奸感九用竿漳丫硼播岸接沼暖莆辰摧壕御胖伐遭拓拽划类方馋遍堰执亚祸DBA十大噩梦-BDI-B305-CN课件DBA十大噩梦-BDI-B305-CN课件;SELECT * FROM SYS.DM_EXEC_REQUESTS WHERE SESSION_ID=50 AND SESSION_ID@@SPID GO SELECT traceid,property,value FROM ::fn_trace_getinfo(0) GO;皖耕呆末烁笔鞠误弟潍伸对变执纳谨献捐发康追泰蚜兜茁恶岁锅兽耘越乒DBA十大噩梦-BDI-B305-CN课件DBA十大噩梦-B