Query to Get Database Size

s
easy method to show all your database size :


use master
declare @PageSize varchar(10)
select @PageSize=v.low/1024.0
from master..spt_values v
where v.number=1 and v.type='E'
select name as DatabaseName, convert(float,null) as Size
into #tem
From sysdatabases where dbid>4
declare @SQL varchar (8000)
set @SQL=''
while exists (select * from #tem where size is null)
begin
select @SQL='update #tem set size=(select round(sum(size)*'+@PageSize+'/1024,0) From '+quotename(databasename)+'.dbo.sysfiles) where databasename='''+databasename+''''
from #tem
where size is null
exec (@SQL)
end
select * from #tem order by DatabaseName
drop table #tem

this script is created by Here

SharePoint Dispose Checker Tool

ha ha..this is the tool to check on your dll or exe develop by your sharepoint developer have any memory leak on the solution or not. you can use the tools to check and tell the developer what going wrong and cause your server IIS out of memory.


Resource Page Description
SPDisposeCheck is a tool to help you to check your assemblies that use the SharePoint API so that you can build better code. It provides assistance in correctly disposing of certain SharePoint objects to help you follow published best practice. This tool may not show all memory leaks in your code. Further investigation is advised if you continue to experience issues.
SPDisposeCheck.exe takes the path to a managed .DLL or .EXE or the path to a directory containing many managed assemblies. It will recursively search for and analyze each managed module attempting to detect coding patterns based on the MDSN article.

The SPDisposeCheck tool can be downloaded here.

Delete MOSS orphan sites manually in SQL DB

Running Scoping tool and stsadm -o databaserepair but the results is showed different, but the scoping tool is listed more orphan sites. so we decide to clean up the orphan sites , due to the stsadm  unable to detect that mean the databaserepair will not able to help us to do clean up.

after discuss with mircrosoft , we decide to remove it manually from MOSS SQL DB. This make me excited because can learnt a lot one the MOSS DB table.

This clean up activity we can category in detect , confirm , delete.

Detect stage: Run the scooping tool if don’t have than maybe you can follow the script at internet .

Confirm stage ( make sure the content is really not in used) :
Results from the detect stage will provided the siteid and content DB.
use the path URL from the script go to CA to check which one is actual use content DB. after this go to sql content DB check the Database id.
once get the Databse id you can keep this is record then can refer to the database id you get from sitemap.

select * from sitemap where id='xxxxxx-xxxxxx--xxxxxxx-xxxxxxxx’ 
this results will give the orphan database id

select * from SiteMap where Path like 'url'
EXP:
Select * from SiteMap where Path like '/sites/accmgmt'
this will give you the database id same as the CA.(which is the database current in use)

please confirm the orphan databaseid is not same as the CA databaseid

Delete satage ( we will go to the content db to delete the orphan site)
Use [databasename]
exec proc_DeleteSite [siteId]

Learn how to use excel generate Batch file

Some time we need to create some batch file with a lot command line from some list , example you have MOSS list in excel then you want add the parameter to stsadm then create batch file.

here is the some command i learn and able to help on the purpose :

=VLOOKUP ( what you want to look , look from where, which column you want the return, false value is exact value)

=REPLACE( start from, start from which location ,how many world u want replace, copy from where )

=CONCATENATE( "string", c1 (Colum parameter)  )
>>>>> results is string [c1 value]