最近開始學習html5,因為一直都是研究as,所以還是覺得as順眼一點,但是html5也不能不學,於是就想出了,可以把html5用as的文法來寫出來,做遊戲應該來的比較順手一些,下面開始第一篇第一篇,顯示一張圖片一,代碼對比as代碼:public var loader:Loader;public function loadimg():void{loader = new
--查詢引發io最多的前10位查詢或批處理SELECT TOP 10 (total_logical_reads/execution_count) AS AVG_LOGICAL_READS, (total_logical_writes/execution_count) AS AVG_LOGICAL_WRITES, (total_physical_reads/execution_count) AS AVG_PHYSICAL_READS, execution_count, ( SELECT
--查詢tempdb中是否存在一個或多個正在擷取頁面鎖的等待SELECT session_id,wait_duration_ms,resource_description FROM SYS.dm_os_waiting_tasksWHERE wait_type LIKE 'PAGE%LATCH_%' AND resource_description LIKE '2:%'--查詢tempdb中引發最多頁面分配和回收操作的執行查詢SELECT TOP 10
SELECT SERVERPROPERTY('IsClustered')SELECT DISTINCT OBJECT_NAME(SI.object_id) AS Table_Name , SI.name AS Statistics_Name , STATS_DATE(SI.object_id, SI.index_id) AS Last_Stat_Update_Date , SSI.rowmodctr AS
--最佳化查詢計劃花費時間SELECT * FROM SYS.dm_exec_query_optimizer_info WHERE [counter]='OPTIMIZATIONS' OR [counter]='ELAPSED TIME'--查詢狀態SELECT * FROM SYS.dm_exec_query_stats--等待任務SELECT * FROM SYS.dm_os_waiting_tasksSELECT COUNT(*) AS CPU_WAITOR
SELECT * FROM SYS.dm_os_memory_clerks WHERE [TYPE]='MEMORYCLERK_SQLBUFFERPOOL'SELECT * FROM SYS.dm_os_ring_buffers--緩衝池消耗記憶體總量SELECT sum(multi_pages_kb+awe_allocated_kb+virtual_memory_committed_kb+shared_memory_committed_kb) FROM