bedbmsguru

SELECT

       DB_NAME() AS 'DB 명'

       ,d.name AS '파일그룹명'

       ,e.tSize AS '전체사이즈(mb)'

       ,SUM(used_page_count)*8 /1024.0 AS '현재사이즈(mb)'

       ,e.tSize-SUM(used_page_count)*8 /1024.0 AS '남은사이즈(mb)'

       ,cast((SUM(used_page_count)*8/1024.0)*100/e.tSize AS DECIMAL(10,2))AS '사용량(%)'

FROM sys.objects AS a  JOIN sys.dm_db_partitiON_stats AS b

ON a.object_id = b.object_id

JOIN  sys.sysindexes AS c

ON a.object_id = c.id

AND b.index_id = c.indid

JOIN sys.filegroups AS d

ON c.groupid = d.data_space_id

JOIN (SELECT data_space_id,SUM(size)*8/1024.0 AS 'tSize'

             FROM sys.databASe_files WHERE data_space_id <> 0 GROUP BY data_space_id) AS e

ON d.data_space_id = e.data_space_id        

GROUP BY d.name,c.groupid,e.tSize

출처: https://sqltalk.tistory.com/15 [SQLTalk]

declare @max int
select @max = max_workers_count from sys.dm_os_sys_info

select 
    @max as 'TotalThreads',
    sum(active_Workers_count) as 'CurrentThreads',
    @max - sum(active_Workers_count) as 'AvailableThreads',
    sum(runnable_tasks_count) as 'WorkersWaitingForCpu',
    sum(work_queue_count) as 'RequestWaitingForThreads' ,
    sum(current_workers_count) as 'AssociatedWorkers'
from  
    sys.dm_os_Schedulers where status='VISIBLE ONLINE'

https://dba.stackexchange.com/questions/188102/who-is-using-my-worker-threads-sql-server-2014-hadr

DECLARE @dateval DATETIME

EXECUTE ('begin my1.spGetDate(?); end;', @dateval OUTPUT) AT ORA_DBLINK_NAME;

EXECUTE ('begin my1.spDeleteOldRecords(?); end;', @dateval) AT ORA_DBLINK_NAME;

--파라미터 여러개

EXECUTE ('begin my1.spProc(?,?,?,?); end;', @param_in_1, @param_in_2, @param_out_3 OUTPUT, @param_out_4 OUTPUT) AT DBLINK_NAME;

출처

https://stackoverflow.com/questions/13741175/calling-oracle-stored-procedure-with-output-parameter-from-sql-server