##################################################################
### BEGIN ########################################################
##################################################################
select
       objectName    = object_name(i.id), 
       indexId       = i.indid, 
       lockschema    = lockscheme(i.id), 
       fRowCount     = row_count(db_id(), i.id),
       fDataPages    = data_pages(db_id(), i.id, i.indid),
       rowsPerPage   = row_count(db_id(), i.id) / (data_pages(db_id(), i.id, i.indid)*1.0),
       StatFlushed   = i.statmoddate,
       leafcnt       = i.leafcnt,
       pagecnt       = i.pagecnt,
       emptypgcnt    = i.emptypgcnt,
       rowcnt        = i.rowcnt,
       forwrowcnt    = i.forwrowcnt, 
       delrowcnt     = i.delrowcnt,
       dpagecrcnt    = i.dpagecrcnt, 
       dpagecr       = i.dpagecrcnt, 
       ipagecrcnt    = i.ipagecrcnt,
       ipagecr       = i.ipagecrcnt,
       drowcrcnt     = i.drowcrcnt, 
       drowcr        = i.drowcrcnt, 
       oamapgcnt     = i.oamapgcnt,
       extent0pgcnt  = i.extent0pgcnt,
       datarowsize   = i.datarowsize,
       leafrowsize   = i.leafrowsize, 
       indexheight   = i.indexheight,
       plljoindegree = i.plljoindegree,
       SpaceUtilization      = derived_stat(i.id, i.indid, "space utilization"),
       DataPageClusterRatio  = derived_stat(i.id, i.indid, "data page cluster ratio"),
       IndexPageClusterRatio = derived_stat(i.id, i.indid, "index page cluster ratio"),
       DataRowClusterRatio   = derived_stat(i.id, i.indid, "data row cluster ratio"),
       LargeIoEfficiency     = derived_stat(i.id, i.indid, "large io efficiency")
from dbo.systabstats i 
where 1=1
--  and i.emptypgcnt > 5
  and object_name(i.id) not like 'sys%'
  and i.id = object_id('PerformedService')
order by 1, 2
select getdate()
exec sp_spaceused PerformedService

/*
exec sp_whoisw
reorg reclaim_space PerformedService
reorg reclaim_space PerformedService XPKPerformedService
reorg reclaim_space PerformedService XIEPerformedService#login_id#creation_date#customerService_Id
reorg reclaim_space PerformedService XIEPerformedService#creation_date
reorg reclaim_space PerformedService XAKPerformedService#performedService_id
sp_help      PerformedService
sp_helpindex PerformedService

select * from master..monEngine
select * from sysindexes where id = object_id('PerformedService') order by indid
*/


-- sp_configure 'enable housekeeper GC'--, 4

##################################################################
### END ##########################################################
##################################################################




##################################################################
### BEGIN ########################################################
##################################################################
select
       objectName    = object_name(i.id), 
       indexId       = i.indid, 
       lockschema    = lockscheme(i.id), 
       fRowCount     = row_count(db_id(), i.id),
       fDataPages    = data_pages(db_id(), i.id, i.indid),
       rowsPerPage   = row_count(db_id(), i.id) / (data_pages(db_id(), i.id, i.indid)*1.0),
       StatFlushed   = i.statmoddate,
       leafcnt       = i.leafcnt,
       pagecnt       = i.pagecnt,
       emptypgcnt    = i.emptypgcnt,
       rowcnt        = i.rowcnt,
       forwrowcnt    = i.forwrowcnt, 
       delrowcnt     = i.delrowcnt,
       dpagecrcnt    = i.dpagecrcnt, 
       dpagecr       = i.dpagecrcnt, 
       ipagecrcnt    = i.ipagecrcnt,
       ipagecr       = i.ipagecrcnt,
       drowcrcnt     = i.drowcrcnt, 
       drowcr        = i.drowcrcnt, 
       oamapgcnt     = i.oamapgcnt,
       extent0pgcnt  = i.extent0pgcnt,
       datarowsize   = i.datarowsize,
       leafrowsize   = i.leafrowsize, 
       indexheight   = i.indexheight,
       plljoindegree = i.plljoindegree,
       SpaceUtilization      = derived_stat(i.id, i.indid, "space utilization"),
       DataPageClusterRatio  = derived_stat(i.id, i.indid, "data page cluster ratio"),
       IndexPageClusterRatio = derived_stat(i.id, i.indid, "index page cluster ratio"),
       DataRowClusterRatio   = derived_stat(i.id, i.indid, "data row cluster ratio"),
       LargeIoEfficiency     = derived_stat(i.id, i.indid, "large io efficiency")
from dbo.systabstats i 
where 1=1
--  and i.emptypgcnt > 5
  and object_name(i.id) not like 'sys%'
  and i.id = object_id('PerformedService')
order by 1, 2
select getdate()
exec sp_spaceused PerformedService

/*
exec sp_whoisw
reorg reclaim_space PerformedService
reorg reclaim_space PerformedService XPKPerformedService
reorg reclaim_space PerformedService XIEPerformedService#login_id#creation_date#customerService_Id
reorg reclaim_space PerformedService XIEPerformedService#creation_date
reorg reclaim_space PerformedService XAKPerformedService#performedService_id
sp_help      PerformedService
sp_helpindex PerformedService

select * from master..monEngine
select * from sysindexes where id = object_id('PerformedService') order by indid
*/


-- sp_configure 'enable housekeeper GC'--, 4

##################################################################
### END ##########################################################
##################################################################