BizTalk Database Login list

CREATE TAVKE # TEMPWW(
LoginName nvarchar(max),
DBname nvarchar(max)
Username nvarchar(max),
AliasName nvarchar(max)
)

INSERT INTO #TEMPWW
EXEC master..sp_msloginmappings


-- display results
SELECT * FROM #TEMPWW
ORDER BY dbname, username

--cleanup
DROP TABLE #TEMPWW


Or prepare list manually:


 

Logins

Server Roles

User Mapping

User Mapped to this login

Database role membership for: AIF Common

Y

Y

BizTalk Concepts

1. Determining Optimum number of BizTalk Hosts

Tools and Utlities

Compare Files: Windiff.exe
http://social.technet.microsoft.com/wiki/contents/articles/5208.biztalk-server-2010-tools.aspx
Performance Analysis of Logs (PAL) Tool : http://pal.codeplex.com/

BizTalk Performance

Links:
http://msdn.microsoft.com/en-us/library/ee377025.aspx
http://blog.sabratech.co.uk/2008/04/throttling-in-full-action.html
http://biztalkadmin.com/biztalk-self-throttling/
http://msdn.microsoft.com/en-us/library/bb743398%28v=bts.10%29.aspx



BizTalk Database:
http://www.biztalkadminsblogging.com/
http://blogs.biztalk360.com/biztalk-environment-maintenance-from-a-dba-perspective/
http://support.microsoft.com/kb/917845
http://msdn.microsoft.com/en-us/library/gg634509.aspx
http://support.microsoft.com/kb/899000
http://support.microsoft.com/kb/952555
http://support.microsoft.com/kb/912262/en-us
http://blogs.msdn.com/b/biztalkcpr/archive/2011/02/10/using-biztalk-terminator-to-resolve-issues-identified-by-biztalk-msgboxviewer.aspx
Resolving Issues MBV:
- MBV Blog - http://blogs.technet.com/jpierauc/
- MBV FAQ - http://blogs.technet.com/b/jpierauc/archive/2008/07/22/msgboxviewer-mbv-q-a.aspx
- MBV Download location - http://blogs.technet.com/jpierauc/pages/msgboxviewer.asp x



If for some reason Managment database name is changed then change new name in configuration file and then run MsgBoxViewer utility.

MBV\MBVSettings.xml

changed <GlobalProperty ID="MGMTDBNAME" Value="BizTalkMgmtDb_1" />

from <GlobalProperty ID="MGMTDBNAME" Value="BizTalkMgmtDb" />

and then ran

D:\Install\For MBV\MsgBoxViewer.exe

User: BTSTerminator utility 

http://www.microsoft.com/en-us/download/details.aspx?id=2846

http://blogs.msdn.com/b/biztalkcpr/archive/2011/02/10/using-biztalk-terminator-to-resolve-issues-identified-by-biztalk-msgboxviewer.aspx

http://blogs.technet.com/b/jpierauc/archive/2007/12/18/msgboxviewer.aspx

http://msdn.microsoft.com/en-us/library/aa577454(BTS.70).aspx

Go through

http://social.technet.microsoft.com/wiki/contents/articles/2240.biztalk-server-resources-on-the-technet-wiki.aspx
http://alamnaushad.wordpress.com/videos/

Pipeline component examples

http://social.technet.microsoft.com/wiki/contents/articles/11679.biztalk-list-of-custom-pipeline-components-en-us.aspx

http://blogs.msdn.com/b/brajens/archive/2006/12/03/how-to-develop-biztalk-custom-pipeline-components-part2.aspx


http://zeetalks.wordpress.com/tag/biztalk-2010-disassemble-create-a-new-ibasemessage-from-string-content/

Pipeline Component Development

http://blogs.objectsharp.com/post/2008/04/22/Developing-Streaming-Pipeline-Components-Part-3.aspx

BizTalk MAP Error

http://social.msdn.microsoft.com/Forums/da-DK/biztalkgeneral/thread/3275834d-7dff-43a2-9a85-872f66079242

As I can see there is an error "'WPER_PK' in namespace 'http://omni'." error. The element 'WPER_PK' in your file has "" namespace.
Error in namespaces.
I would trace the source message before map, store it and use it to test the map.


Schema generated instance and adding value.

<ns01:     myroot  xmlns:="http://dfkdfjjkfjdk.com>
<ns01:firstelement>value1</ns01:firstelement> 
<ns01:secondelement>value2</ns01:secondelement>
</ns01:myroot>

Above  test message throws error.
Use follwoing test message

<ns01:     myroot  xmlns:="http://dfkdfjjkfjdk.com>
<firstelement>value1<firstelement> 
<secondelement>value2<secondelement>
</ns01:myroot>

Pipeline GAC

Copy and paste following as it is to post build event:


"C:\Program Files (x86)\Microsoft SDKs\Windows\v7.0A\Bin\NETFX 4.0 Tools\GacUtil.exe" /nologo /i "$(TargetPath)" /f
  copy "$(TargetPath)" "C:\Program Files (x86)\Microsoft BizTalk Server 2010\Pipeline Components" /y

 Reference1
 

MBV BizTalk performance

http://blogs.biztalk360.com/biztalk-environment-maintenance-from-a-dba-perspective/
http://support.microsoft.com/kb/952555/en-us
http://biztalkadmin.com/orphaned-messages-in-the-tracking-database/

Violates Microsoft Policy:
USE [biztalkDTADb]
UPDATE [dbo].[dta_ServiceInstances]
SET [dtEndTime] = GetUTCDate()
WHERE dtEndTime is NULL AND [uidServiceInstanceId]
NOT IN(
SELECT [uidInstanceID]
FROM
BizTalkMsgBoxDb.[dbo].[Instances] WITH (NOLOCK)
UNION SELECT [StreamID]
FROM
BizTalkMsgBoxDb.[dbo].[TrackingData] WITH (NOLOCK))




http://msdn.microsoft.com/en-us/library/aa561960.aspx