BIZTALK DATABASES SNAPSHOT HEADER

NameInfoLink
Collection TitleMy Collect 
Generation Date/Time07/05/2008 at 15:38:31 
All Collect queries have been triedTrue 
Tool NameMsgBoxViewerWhat is MsgBoxViewer
Tool Version9.23Get latest version
Tool's Userjpierauc 
Tool's User role 1 - I am a SQL Admin of SQL Server(s) hosting BizTalk DbsYes 
Tool's User role 2 - I am a BizTalk AdminYes 
Tool's User role 3 - I can query Registry of BizTalk Servers and SQL Servers hosting BizTalk dbsYes 
Tool's User role 4 - I can query WMI System Info of BizTalk Servers and SQL Servers hosting BizTalk dbsYes 
Connection Timeout30 secs 
Query Timeout30 secs 
Name of Computer executing the toolMYTESTSERVER (BizTalk Server) 
OS Ver of Computer executing the tool3790.srv03_sp2_gdr.070304-2240 
BTS Edition of Computer executing the toolEnterprise 
BTS Version of Computer executing the toolMicrosoft BizTalk Server 2006 Build 3.5.1602.0 - BizTalk 2006 RTM 
BizTalk FolderC:\Program Files\Microsoft BizTalk Server 2006\ 
BizTalk Lang1033 
BizTalk Install Date20/11/2007 
BizTalk File Info - Btsntsvc.exe3.5.1602.0 
BizTalk File Info - Btsntsvc64.exe3.5.1602.0 
BizTalk File Info - BtsMsgCore.dll3.5.1602.0 
BizTalk File Info - BTSMessageAgent.dll3.5.1602.0 
BizTalk File Info - Microsoft.BizTalk.Pipeline.dll3.5.1602.0 
BizTalk File Info - Microsoft.BizTalk.Messaging.dll3.5.1602.0 
BizTalk File Info - Microsoft.XLANGs.Engine.dll3.5.1602.0 
BizTalk File Info - Microsoft.XLANGs.BizTalk.Engine.dll3.5.1602.0  
Targeted Mgmt DB ServerMYTESTSERVER 
Targeted Mgmt DB NameBizTalkMgmtDb 
   


Summary Report    Topology Report    Detailed Reports    Identified Message Flows








DETAILED REPORTS   



 This Server : BizTalk HotFixes
 BizTalk DB Servers : BizTalk DBs Ver & SQL Servers Ver
 MsgBox Servers : SQL Server Info
 All BizTalk Dbs : Dbs Info
 DTA and MSGBOX Dbs : Files Sizes
 All BizTalk Dbs : Dbs Space
 Mgmt Db : BizTalk Group Settings
 Mgmt Db : BizTalk Users Settings
 Mgmt Db : Service Class Settings
 Mgmt Db : Throttling Settings (BizTalk 2K6 only)
 Mgmt Db : MsgBox Settings
 Mgmt Db : BizTalk Servers
 Mgmt Db : BizTalk Hosts
 Mgmt Db : BizTalk Host Instances
 Mgmt Db : BizTalk Adapters Installed
 Mgmt Db : BizTalk Applications
 Mgmt Db : Receive Locations
 Mgmt Db : Send Ports
 Mgmt Db : Send Ports Groups
 Mgmt Db : Orchestrations Deployed
 Mgmt Db : PipeLines
 DTA Db : Tables Size
 DTA Db : Instances Types
 DTA Db : Orphaned Svc Instances
 MsgBox Db : Queues
 MsgBox Db : Tables Size
 MsgBox Db : Tables Index Info
 MsgBox & Mgmt Db : BizTalk Jobs
 MsgBox Db : Integrity Check
      Integrity Check Summary
 MsgBox Db (Master) : Activation Subscriptions
 DTA Db : Message counts
 DTA Db : Fragmentation Info
 MsgBox Db : Fragmentation Info
 MsgBox Db : Orchestrations Instances
 MsgBox Db : Active Msgs for Send Ports
 MsgBox Db : Service Instances Status
 MsgBox Db : Top 100 Parts ordered by NumFragments
 MsgBox Db : Active Cached Msg Ref. in Spool
 MsgBox Db : Suspended Cached Msg Ref. in Spool
 MsgBox Db : 'EqualsPredicates' table Properties
 MsgBox Servers : Running Spids (sp_who3) for SQL MsgBox Server MYTESTSERVER
 MsgBox Servers : Locked Spids (sp_who3) for SQL Msgbox Server MYTESTSERVER
 MsgBox Servers : SQL Server CPU Usage (SQL 2K5 only)
 MsgBox Servers : Top 50 CPU Batch (SQL 2K5 only)
 MsgBox Servers : Most CPU Queries (SQL 2K5 only)
 All BizTalk Servers : Versions
 All BizTalk Servers : BizTalk Hotfixes
 All BizTalk Servers : BizTalk Svc Reg Values
 All BizTalk Servers : CLR Thread Pool Settings
 All BizTalk Servers : Running BizTalk Services
 All Servers : DTC Settings
 All Servers : TCPIP Settings
 This Server : BTS Config File
 This Server : Running Bz Svc & Modules
      BTSNTSvc64 BizTalkServerApplication (Pid=600)
      BTSNTSvc test (Pid=1144)
      BTSNTSvc toto (Pid=932)
 This Server : Perfmon BizTalk Counters
      BizTalk:Messaging Perf Counters
      BizTalk:Message Agent Perf Counters
      BizTalk:Messaging Latency Perf Counters
      XLANG/s Orchestrations Perf Counters



IDENTIFIED MESSAGE FLOWS   

===============>>============================================ MSG FLOW ===============================>>===========================>>

Ordered by Receive Port   

      WebPort_MyOrch_Proxy/MyOrch_Orchestration_1_Port_2

Ordered by MessageType   

      http://MyWSSchemas.Schema1#Root



TOPOLOGY REPORT - ORDERED BY SERVER   


 MYTESTSERVER : SQL Server;BTS Server


SUMMARY REPORT


NameValueReportLinks
Errors during collect statement0  
BizTalk Group   
BizTalk Group NameBizTalk Group2 (has been renamed, look for SOX070501700025 for possible consequences)   
BizTalk Group Version AssumedBizTalk 2006 RTM  
Installation TypeFresh Installation  
Total Applications3 
BizTalk Databases   
MGMT DBDataSource: MYTESTSERVER , DataBase: BizTalkMgmtDb , DB Schema Version: 3.5.0.0  
DTA DBDataSource: MYTESTSERVER , DataBase: BizTalkDTADb , DB Schema Version: 3.6.0.0  
BAM DBDataSource: MYTESTSERVER , DataBase: BAMPrimaryImport , DB Schema Version: 3.4.1.0  
Multiple MsgBox DBNo  
MSGBOX DB (Master)DataSource: MYTESTSERVER , DataBase: BizTalkMsgBoxDb , DB Schema Version: 3.6.1.0  
BAM Alerts Application DBDataSource: MYTESTSERVER , DataBase: BAMAlertsApplication , DB Schema Version: 3.3.1.0  
BAM Alerts Instance DBDataSource: MYTESTSERVER , DataBase: BAMAlertsNSMain , DB Schema Version: 3.3.1.0  
EDI DBDataSource: MYTESTSERVER , DataBase: BizTalkEDIDb , DB Schema Version: 3.3.0.0  
HWS Administration DBDataSource: MYTESTSERVER , DataBase: BizTalkHwsDb , DB Schema Version: 3.3.0.0  
RuleEngine DBDataSource: MYTESTSERVER , DataBase: BizTalkRuleEngineDb , DB Schema Version: 3.4.0.0  
SSO DBDataSource: MYTESTSERVER , DataBase: SSODB , DB Schema Version:   
SSO DBNot Clustered (this DB is critical as it keep encrypted ports properties)  How to cluster SSO
BizTalk Databases Sizes   
Total DB Space Used for MGMT DB - 'BizTalkMgmtDb'8,94 MB 
Total DB Space Used for DTA DB - 'BizTalkDTADb'3,89 MB 
Total DB Space Used for BAM DB - 'BAMPrimaryImport'2,09 MB 
Total DB Space Used for MSGBOX DB - 'BizTalkMsgBoxDb'8,84 MB 
Total DB Space Used for BAM Alerts Application DB - 'BAMAlertsApplication'24,52 MB 
Total DB Space Used for BAM Alerts Instance DB - 'BAMAlertsNSMain'3,05 MB 
Total DB Space Used for EDI DB - 'BizTalkEDIDb'6,60 MB 
Total DB Space Used for HWS Administration DB - 'BizTalkHwsDb'2,66 MB 
Total DB Space Used for RuleEngine DB - 'BizTalkRuleEngineDb'2,27 MB 
Total DB Space Used for SSO DB - 'SSODB'4,15 MB 
BizTalk Databases Files   
LDF and MDF files Location for 'BizTalkDTADb'Same Drive (Can cause disk contention) BizTalk Server Performance Characteristics
LDF and MDF files Location for 'BizTalkMsgBoxDb' DBSame Drive (can cause disk contention) BizTalk Server Performance Characteristics
MDF files Location for 'BizTalkDTADb' and 'BizTalkMsgBoxDb' DBs Same Drive (can cause disk contention) BizTalk Server Performance Characteristics
LDF files Location for 'BizTalkDTADb' and 'BizTalkMsgBoxDb' DBs Same Drive (can cause disk contention) BizTalk Server Performance Characteristics
SQL Server(s) Hosting BizTalk Dbs   
SQL Server 2005 RTM installed on MYTESTSERVERRecommended to install SQL 2005 SP2, RTM is not supported since 10-Jul-2007  Lifecycle Supported Service Packs
BizTalk Servers   
Total BTS Servers1 
MsgBox DB 'BizTalkMsgBoxDb'Located also on a BizTalk Server MYTESTSERVER (Recommended to separate them)  BizTalk Server Performance Characteristics
CLR Thread Pool SettingsNot found in Registry KB 886966, Configuration Parameters that Affect Adapter Performance
BizTalk Hosts   
Total Hosts4 
Total Hosts 64 bits0 
Total InProc Hosts3 
Total Tracking Hosts1 
Total Host Instances4 
Total Host Instances Running3 
Total Tracking Host Instances Running1Tracking Bottlenecks
Tracking Host Instance Running on each BizTalk ServerYes 
Host 'BizTalkServerApplication'Run ReceiveLocations + SendPorts + Orchestrations (Recommended to dedicate this host to run either ReceiveLocations, Orchestrations, or SendPorts) BizTalk Performances WhitePaper
Dedicated Tracking host(s) :No (better to have some host(s) dedicated ONLY for tracking)  BizTalk Performances WhitePaper
Ports, Pipelines & Orchs   
Total Receive Locations2 
Total Send Ports1 
Total Orch Deployed1 
Tracking Events for some OrchsYes 
Tracking Events for ALL OrchsYes (if Orchs are complex and numerous, it can impact seriously performance and cause quick DTA DB increase)  
Tracking Events for some PipelinesYes 
DTA Database   
Larger tableName: dta_ServiceInstances , Rows: 30 , Size: 88 KB 
Table "dta_DebugTrace" Row Count - BizTalkDTADb16 rows ("select count(*) from dta_DebugTrace") 
Table "dta_ServiceInstances" Row Count - BizTalkDTADb30 rows ("select count(*) from dta_ServiceInstances") 
Table "dta_MessageInOutEvents" Row Count - BizTalkDTADb42 rows ("select count(*) from dta_MessageInOutEvents") 
Table "Tracking_Spool1" Row Count - BizTalkDTADb0 rows ("select count(*) from Tracking_Spool1") 
Table "Tracking_Spool2" Row Count - BizTalkDTADb0 rows ("select count(*) from Tracking_Spool2") 
Table "TDDS_FailedTrackingData" Row Count - BizTalkDTADb0 rows ("select count(*) from TDDS_FailedTrackingData") 
MsgBox Queues   
Total Suspended Messages for 'BizTalkMsgBoxDb'0BizTalk Server : Monitoring and Troubleshooting
Total Suspended Resumables Messages for 'BizTalkMsgBoxDb'0BizTalk Server : Monitoring and Troubleshooting
Total Pending Messages in Work Q for 'BizTalkMsgBoxDb'0BizTalk Server : Monitoring and Troubleshooting
MsgBox Tables - BizTalkMsgBoxDb   
Larger table - BizTalkMsgBoxDbName: StaticStateInfo , Rows: 1 , Size: 760 KB 
Total in Msgbox TrackingData table(s) - BizTalkMsgBoxDbRows=0, Space=96 KB 
Total in Tracking Body tables - BizTalkMsgBoxDbRows=0, Space=0 KB 
Table "Spool" Row Count - BizTalkMsgBoxDb4 rows ("select count(*) from Spool") 
Table "Instances" Row Count - BizTalkMsgBoxDb3 rows ("select count(*) from Instances") 
Table "Subscription" Row Count - BizTalkMsgBoxDb5 rows ("select count(*) from Subscription") 
Other Checks   
SQL ServerAgent on MYTESTSERVERNot Running (BizTalk jobs can not run)   
Max Job History Log size on MYTESTSERVER1001 (too large size can cause some locking with sp 'MsgBoxPerfCounters_GetPurgeJobInfo', see SOX080317700034)   
Special TCP SettingsSynAttackProtect enabled on server MYTESTSERVER - can generate General Network errors 'General Network'errors
Special TCP SettingsFound in Registry for server(s) MYTESTSERVER - see the corresponding report for details 'General Network'errors, Configuration Parameters that Affect Adapter Performance
Scalable Network PackUpdate KB948496 is installed on MYTESTSERVER to disable SNP features update to turn off default SNP features
BTS Config FileChanged  
BizTalk Jobs   
Biztalk Job 'Backup BizTalk Server (BizTalkMgmtDb)'Disabled , No History (Job to backup BizTalk DBs, SQL Tn log can increase if not running) Jobs Description
Biztalk Job 'DTA Purge and Archive (BizTalkDTADb)'Disabled , No History (Job to backup and purge DTA, if Tracking is enabled DTA db size can become large) How to Configure the DTA Purge and Archive Job
Biztalk Job 'MessageBox_Message_ManageRefCountLog_BizTalkMsgBoxDb' - Not Running (Job to clean msg in MsgBox Db, MsgBox Db can grow if not running) Jobs Description