TOP 10 queries by IO and CPU Top Queries by Average CPU Time SELECT TOP(10) creation_time , last_execution_time , (total_worker_time+0.0)/1000 AS total_worker_time , (total_worker_time+0.0)/(execution_count*1000) AS [AvgCPUTime] , execution_count , st.text FROM sys.dm_exec_query_stats qs CROSS APPLY sys.dm_exec_sql_text(sql_handle) st WHERE total_worker_time > 0 ORDER BY total_worker_time DESC Top Queries by Average IO Time.. 더보기 [SQL] 백업과 복구 기본 스크립트 데이터베이스 백업과 유효성 체크 -- Backup DatabaseBACKUP DATABASE [TESTDB] TO DISK = N'D:\MSSQLEXPR\BACKUP\TESTDB.bak' WITH DESCRIPTION = N'설명', NAME = N'TESTDB-전체 데이터베이스 백업', SKIP, -- 만료일 무시STATS = 10 -- 진행률 표시(%) GO -- Verifying Backup fileDECLARE @BACKUPSETID AS INTSELECT @BACKUPSETID = POSITION FROM MSDB..BACKUPSET WHERE DATABASE_NAME=N'TESTDB' AND BACKUP_SET_ID=(SELECT MAX(BACKUP_SET_ID) FROM MSDB..BACKU.. 더보기 이전 1 2 3 4 5 6 ··· 40 다음