查看分发数据库数据量sql2008

create table #t(name varchar(100),num int) insert #t select 'MStracer_tokens', (select count(1) from dbo.[MStracer_tokens] with (nolock)) insert #t select 'MSarticles', (select count(1) from dbo.[MSarticles] with (nolock)) insert #t select

create table #t(name varchar(100),num int)

insert #t select 'MStracer_tokens', (select count(1) from dbo.[MStracer_tokens] with (nolock))
insert #t select 'MSarticles', (select count(1) from dbo.[MSarticles] with (nolock))
insert #t select 'MStracer_history', (select count(1) from dbo.[MStracer_history] with (nolock))
insert #t select 'MSsync_states', (select count(1) from dbo.[MSsync_states] with (nolock))
insert #t select 'MSsubscriptions', (select count(1) from dbo.[MSsubscriptions] with (nolock))
insert #t select 'MSmerge_articleresolver', (select count(1) from dbo.[MSmerge_articleresolver] with (nolock))
insert #t select 'MSmerge_subscriptions', (select count(1) from dbo.[MSmerge_subscriptions] with (nolock))
insert #t select 'MSrepl_transactions', (select count(1) from dbo.[MSrepl_transactions] with (nolock))
insert #t select 'MSrepl_commands', (select count(1) from dbo.[MSrepl_commands] with (nolock))
insert #t select 'MSrepl_originators', (select count(1) from dbo.[MSrepl_originators] with (nolock))
insert #t select 'MSreplication_monitordata', (select count(1) from dbo.[MSreplication_monitordata] with (nolock))
insert #t select 'MSsubscriber_info', (select count(1) from dbo.[MSsubscriber_info] with (nolock))
insert #t select 'MSsubscriber_schedule', (select count(1) from dbo.[MSsubscriber_schedule] with (nolock))
insert #t select 'MSsnapshot_history', (select count(1) from dbo.[MSsnapshot_history] with (nolock))
insert #t select 'MSlogreader_history', (select count(1) from dbo.[MSlogreader_history] with (nolock))
insert #t select 'MSdistribution_history', (select count(1) from dbo.[MSdistribution_history] with (nolock))
insert #t select 'MSmerge_sessions', (select count(1) from dbo.[MSmerge_sessions] with (nolock))
insert #t select 'MSmerge_articlehistory', (select count(1) from dbo.[MSmerge_articlehistory] with (nolock))
insert #t select 'MSrepl_errors', (select count(1) from dbo.[MSrepl_errors] with (nolock))
insert #t select 'MSmerge_history', (select count(1) from dbo.[MSmerge_history] with (nolock))
insert #t select 'MSmerge_identity_range_allocations', (select count(1) from dbo.[MSmerge_identity_range_allocations] with (nolock))
insert #t select 'MSsnapshot_agents', (select count(1) from dbo.[MSsnapshot_agents] with (nolock))
insert #t select 'MSlogreader_agents', (select count(1) from dbo.[MSlogreader_agents] with (nolock))
insert #t select 'MSdistribution_agents', (select count(1) from dbo.[MSdistribution_agents] with (nolock))
insert #t select 'MSmerge_agents', (select count(1) from dbo.[MSmerge_agents] with (nolock))
insert #t select 'MSrepl_identity_range', (select count(1) from dbo.[MSrepl_identity_range] with (nolock))
insert #t select 'MSpublication_access', (select count(1) from dbo.[MSpublication_access] with (nolock))
insert #t select 'MSqreader_agents', (select count(1) from dbo.[MSqreader_agents] with (nolock))
insert #t select 'MSqreader_history', (select count(1) from dbo.[MSqreader_history] with (nolock))
insert #t select 'MSrepl_backup_lsns', (select count(1) from dbo.[MSrepl_backup_lsns] with (nolock))
insert #t select 'MSpublicationthresholds', (select count(1) from dbo.[MSpublicationthresholds] with (nolock))
insert #t select 'IHpublishers', (select count(1) from dbo.[IHpublishers] with (nolock))
insert #t select 'IHpublishertables', (select count(1) from dbo.[IHpublishertables] with (nolock))
insert #t select 'IHarticles', (select count(1) from dbo.[IHarticles] with (nolock))
insert #t select 'IHpublishercolumns', (select count(1) from dbo.[IHpublishercolumns] with (nolock))
insert #t select 'IHcolumns', (select count(1) from dbo.[IHcolumns] with (nolock))
insert #t select 'IHindextypes', (select count(1) from dbo.[IHindextypes] with (nolock))
insert #t select 'IHpublisherindexes', (select count(1) from dbo.[IHpublisherindexes] with (nolock))
insert #t select 'IHpublishercolumnindexes', (select count(1) from dbo.[IHpublishercolumnindexes] with (nolock))
insert #t select 'IHpublications', (select count(1) from dbo.[IHpublications] with (nolock))
insert #t select 'IHconstrainttypes', (select count(1) from dbo.[IHconstrainttypes] with (nolock))
insert #t select 'IHpublisherconstraints', (select count(1) from dbo.[IHpublisherconstraints] with (nolock))
insert #t select 'IHpublishercolumnconstraints', (select count(1) from dbo.[IHpublishercolumnconstraints] with (nolock))
insert #t select 'IHsubscriptions', (select count(1) from dbo.[IHsubscriptions] with (nolock))
insert #t select 'sysschemaarticles', (select count(1) from dbo.[sysschemaarticles] with (nolock))
insert #t select 'MScached_peer_lsns', (select count(1) from dbo.[MScached_peer_lsns] with (nolock))
insert #t select 'MSrepl_version', (select count(1) from dbo.[MSrepl_version] with (nolock))
insert #t select 'MSpublisher_databases', (select count(1) from dbo.[MSpublisher_databases] with (nolock))
insert #t select 'MSpublications', (select count(1) from dbo.[MSpublications] with (nolock))

select * from #t order by num desc
drop table #t

【一淘专享价】Lenovo/联想 B460A-ITH(L) 扬天B460 I3 电脑 包邮