SQL Blocking SQL Query

SELECT db.name DBName,
tl.request_session_id,
wt.blocking_session_id,
OBJECT_NAME(p.OBJECT_ID) BlockedObjectName,
tl.resource_type,
h1.TEXT AS RequestingText,
h2.TEXT AS BlockingTest,
tl.request_mode FROM sys.dm_tran_locks AS tl
INNER JOIN
sys.databases db ON db.database_id =tl.resource_database_id
INNER JOIN sys.dm_os_waiting_tasks AS wt
ON tl.lock_owner_address =wt.resource_address
INNER JOIN sys.partitions AS p ON
p.hobt_id =tl.resource_associated_entity_id
INNER JOIN sys.dm_exec_connections ec1 ON
 ec1.session_id =tl.request_session_id
INNER JOIN sys.dm_exec_connections ec2
ON
ec2.session_id =wt.blocking_session_id
CROSS APPLY  sys.dm_exec_sql_text(ec1.most_recent_sql_handle) AS  h1
CROSS APPLY  sys.dm_exec_sql_text(ec2.most_recent_sql_handle) AS  h2
GO


sp_who2

sp_who2  'spid'

kill  'spid'

Information Rights Management :Protector could not be created as a generic COM object

Information Rights Management (IRM): Protector {78E40D5F-0C51-45B6-AC87-72119EC6669A} could not be created as a generic COM object (IUnknown). Protector: {78E40D5F-0C51-45B6-AC87-72119EC6669A} This indicates a major problem with the protector. Any COM object can be created as an IUnknown.

These errors are due to password protected filed being uploaded into SharePoint. Currently there is no action needed from an IT perspective.

List the available SharePoint site templates installed in your farm using Powershell

Get-SPWebTemplate | select ID, Name, Title | Sort-Object ID | Format-Table

Get-SPWebTemplate "STS#0"

List Active Databases used in sharepoint 2010 By Power Shell

Get List of All Databases
Goto SharePoint 2010 Management Shell

Get-SPDatabase | Sort-Objectdisksizerequired -desc | Format-Table Name

Get list of Content Databases

Get-SPContentDatabase | Sort-Object Name | Format-Table Name