Rank: Guest
Medals: Groups: Joined: 3/22/2010 Posts: 7 Points: 369
Thanks: 0 times Was thanked: 0 time(s) in 0 post(s)
|
BB კოდი:-- ინფორმაცია ბაზის შესახებ
select db_name(sa.dbid) as DBname , sa.name as LogicalName , case sa.groupid WHEN 0 then 'LOG' ELSE sfg.groupname end as Filegroup , sa.filename as Filename , cast(sf.size*8/1024. as numeric(19,3))as sizeMB , cast(sf.spaceused*8/1024. as numeric(19,3)) as spaceusedMB , cast((sf.size-sf.spaceused)*8/1024. as numeric(19,3)) as freespaceMB , case sf.maxsize when -1 then 'Unlimited' else cast(cast(sf.maxsize*8/1024. as numeric(19,3))as varchar(22)) end as maxsizeMB , cast(sf.growth*8/1024. as numeric(19,3)) as nextgrowthMB from master..sysaltfiles sa left join ( select cast(size as bigint) as size ,fileid ,groupid ,cast(fileproperty(name,'SpaceUsed')as bigint) as spaceused ,cast(maxsize as bigint) as maxsize ,cast(case when status & 0x100000 = 0 then growth else size*growth/100 end as bigint) as growth from sysfiles ) sf on sf.fileid=sa.fileid and sf.groupid = sa.groupid left outer join sysfilegroups sfg on sfg.groupid = sf.groupid where sa.dbid = db_id() order by case when sa.groupid = 0 then 1 else 0 end, sa.groupid, sa.fileid
BB კოდი:-- ინფორმაცია ცხრილების შესახებ SELECT object_name(object_id) name, SUM (reserved_page_count)/128 ReservedMb, SUM (used_page_count)/128 UsedMb, SUM ( CASE WHEN (index_id < 2) THEN (used_page_count/128) ELSE 0 END ) TableSumData , SUM ( CASE WHEN (index_id < 2) THEN (in_row_used_page_count)/128 ELSE 0 END ) TableInRowData ,
SUM ( CASE WHEN (index_id < 2) THEN (lob_used_page_count+row_overflow_used_page_count)/128 ELSE 0 END ) TableBLOBandOverflowData , SUM ( CASE WHEN (index_id < 2) THEN 0 ELSE (used_page_count/128) END ) IndexSumData , SUM ( CASE WHEN (index_id < 2) THEN 0 ELSE (in_row_used_page_count)/128 END ) IndexInRowData , SUM ( CASE WHEN (index_id < 2) THEN 0 ELSE (lob_used_page_count+row_overflow_used_page_count)/128 END ) IndexBLOBandOverflowData , SUM ( CASE WHEN (index_id < 2) THEN row_count ELSE 0 END ) RowCnt FROM sys.dm_db_partition_stats group by object_id order by 2 desc
|
|
Apex ltd. http://www.apex.ge
|