In part 2 of diagnosing problems I want to introduce you to an other build-in diagnostics tools that we might ask you to run with tracking down problems, the "event monitor". The event monitor is one of those tools that we use during development of the product for troubleshooting problems during development.

 

Enabling the Event Monitor

Since by default the event monitor is turned off we first need to enable it, by switch a bit in the Registry. Depending on which version you are using you need to do this in a different Registry location:

 

Visual Studio Team Edition for Database Professionals (2005)

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\8.0\DBPro]
"ShowEventMonitor"=dword:00000001

Visual Studio Team System 2008 Database Edition

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\9.0\DBPro]
"ShowEventMonitor"=dword:00000001

Visual Studio Team System 2008 Database Edition GDR

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\9.0\VSTSDB]
"ShowEventMonitor"=dword:00000001

 

NOTE: After you change the Registry setting you need to close down Visual Studio and restart it!

Launching the Event Monitor

image

 

Now that we enable the use of the event monitor we can now launch it. You first need to create or open a "Database Project" (.dbproj) since the Event Monitor is only in the context of a Database Project.

Right click on the Database project node inside Solution Explorer, this will bring up a context menu. The first entry in the context menu is the event monitor. Note that the exact text of the menu entry can be different per version. In the GDR release it is named "VSTSDB Event Monitor".

When you select the menu entry a tool window will appear with the same name as the menu entry.

 

 

 

 

 

 

 

 

 

 

Using the Event Monitor

Now that we have the event monitor launched lets use it.

image

Let's go through each icon in the toolbar first to explore the options.

image  
Clear - this options deletes all captured events from the display window and the internal buffer.


image


Capture - this is a toggle that will turn on and off capturing of events.

 

image


Filter - this will bring up a dialog where you can select the events to capture.

 

The events to capture are:
image

image


Dump Schema Manager - this option dumps the content of the internal schema manager. This is all the information about the schema objects and there relationships.


Example output of Dump Schema Manager:

   1: (1:36:18 PM) 
   2: (1:36:18 PM) ---------------------------------------
   3: (1:36:18 PM)    Schema Context Dump : Database4
   4: (1:36:18 PM) ---------------------------------------
   5: (1:36:18 PM)        Sql Schema Manager : 
   6: (1:36:18 PM)            Disallows Server Objects.
   7: (1:36:18 PM)            Allows User Objects.
   8: (1:36:18 PM)            Collation: Latin1_General_CS_AS
   9: (1:36:18 PM) 
  10: (1:36:18 PM)        Start Custom Data : Database4
  11: (1:36:18 PM)        Custom Data #0
  12: (1:36:18 PM)            Category=ModelCapability
  13: (1:36:18 PM)            DataType=
  14: (1:36:18 PM)            'ModelCapability'='Default'
  15: (1:36:18 PM)        Custom Data #1
  16: (1:36:18 PM)            Category=AnsiNulls
  17: (1:36:18 PM)            DataType=
  18: (1:36:18 PM)            'AnsiNulls'='True'
  19: (1:36:18 PM)        Custom Data #2
  20: (1:36:18 PM)            Category=QuotedIdentifier
  21: (1:36:18 PM)            DataType=
  22: (1:36:18 PM)            'QuotedIdentifier'='True'
  23: (1:36:18 PM)        Custom Data #3
  24: (1:36:18 PM)            Category=DeploymentCollation
  25: (1:36:18 PM)            DataType=
  26: (1:36:18 PM)            'DeploymentCollation'='SQL_Latin1_General_CP1_CS_AS'
  27: (1:36:18 PM)        Custom Data #4
  28: (1:36:18 PM)            Category=CompatibilityMode
  29: (1:36:18 PM)            DataType=
  30: (1:36:18 PM)            'CompatibilityMode'='100'
  31: (1:36:18 PM)        Custom Data #5
  32: (1:36:18 PM)            Category=Reference
  33: (1:36:18 PM)            DataType=DbSchema
  34: (1:36:18 PM)            'FileName'='C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO 9.0\VSTSDB\EXTENSIONS\SQLSERVER\2008\DBSCHEMAS\MICROSOFT.SQLTYPES.DBSCHEMA'
  35: (1:36:18 PM)            'LogicalName'='Microsoft.SqlTypes.dbschema'
  36: (1:36:18 PM)        End Custom Data : Database4
  37: (1:36:18 PM) 
  38: (1:36:18 PM)        Start External Elements : Database4
  39: (1:36:18 PM)        ElementClass = 'ISql100DatabaseOptions', Name = '<unnamed>'
  40: (1:36:18 PM)        ElementClass = 'ISql100Filegroup', Name = '[PRIMARY]'
  41: (1:36:18 PM)        ElementClass = 'ISql100Queue', Name = '[dbo].[EventNotificationErrorsQueue]'
  42: (1:36:18 PM)        ElementClass = 'ISql100Queue', Name = '[dbo].[QueryNotificationErrorsQueue]'
  43: (1:36:18 PM)        ElementClass = 'ISql100Queue', Name = '[dbo].[ServiceBrokerQueue]'
  44: (1:36:18 PM)        ElementClass = 'ISql100Service', Name = '[http://schemas.microsoft.com/SQL/Notifications/EventNotificationService]'
  45: (1:36:18 PM)        ElementClass = 'ISql100Service', Name = '[http://schemas.microsoft.com/SQL/Notifications/QueryNotificationService]'
  46: (1:36:18 PM)        ElementClass = 'ISql100Service', Name = '[http://schemas.microsoft.com/SQL/ServiceBroker/ServiceBroker]'
  47: (1:36:18 PM)        ElementClass = 'ISql90Assembly', Name = '[Microsoft.SqlServer.Types]'
  48: (1:36:18 PM)        ElementClass = 'ISql90AssemblySource', Name = '<unnamed>'
  49: (1:36:18 PM)        ElementClass = 'ISql90Contract', Name = '[DEFAULT]'
  50: (1:36:18 PM)        ElementClass = 'ISql90Contract', Name = '[http://schemas.microsoft.com/SQL/Notifications/PostEventNotification]'
  51: (1:36:18 PM)        ElementClass = 'ISql90Contract', Name = '[http://schemas.microsoft.com/SQL/Notifications/PostQueryNotification]'
  52: (1:36:18 PM)        ElementClass = 'ISql90Contract', Name = '[http://schemas.microsoft.com/SQL/ServiceBroker/BrokerConfigurationNotice]'
  53: (1:36:18 PM)        ElementClass = 'ISql90Contract', Name = '[http://schemas.microsoft.com/SQL/ServiceBroker/ServiceDiagnostic]'
  54: (1:36:18 PM)        ElementClass = 'ISql90Contract', Name = '[http://schemas.microsoft.com/SQL/ServiceBroker/ServiceEcho]'
  55: (1:36:18 PM)        ElementClass = 'ISql90Endpoint', Name = '[Dedicated Admin Connection]'
  56: (1:36:18 PM)        ElementClass = 'ISql90Endpoint', Name = '[TSQL Default TCP]'
  57: (1:36:18 PM)        ElementClass = 'ISql90Endpoint', Name = '[TSQL Default VIA]'
  58: (1:36:18 PM)        ElementClass = 'ISql90Endpoint', Name = '[TSQL Local Machine]'
  59: (1:36:18 PM)        ElementClass = 'ISql90Endpoint', Name = '[TSQL Named Pipes]'
  60: (1:36:18 PM)        ElementClass = 'ISql90MessageType', Name = '[DEFAULT]'
  61: (1:36:18 PM)        ElementClass = 'ISql90MessageType', Name = '[http://schemas.microsoft.com/SQL/Notifications/EventNotification]'
  62: (1:36:18 PM)        ElementClass = 'ISql90MessageType', Name = '[http://schemas.microsoft.com/SQL/Notifications/QueryNotification]'
  63: (1:36:18 PM)        ElementClass = 'ISql90MessageType', Name = '[http://schemas.microsoft.com/SQL/ServiceBroker/BrokerConfigurationNotice/FailedRemoteServiceBinding]'
  64: (1:36:18 PM)        ElementClass = 'ISql90MessageType', Name = '[http://schemas.microsoft.com/SQL/ServiceBroker/BrokerConfigurationNotice/FailedRoute]'
  65: (1:36:18 PM)        ElementClass = 'ISql90MessageType', Name = '[http://schemas.microsoft.com/SQL/ServiceBroker/BrokerConfigurationNotice/MissingRemoteServiceBinding]'
  66: (1:36:18 PM)        ElementClass = 'ISql90MessageType', Name = '[http://schemas.microsoft.com/SQL/ServiceBroker/BrokerConfigurationNotice/MissingRoute]'
  67: (1:36:18 PM)        ElementClass = 'ISql90MessageType', Name = '[http://schemas.microsoft.com/SQL/ServiceBroker/DialogTimer]'
  68: (1:36:18 PM)        ElementClass = 'ISql90MessageType', Name = '[http://schemas.microsoft.com/SQL/ServiceBroker/EndDialog]'
  69: (1:36:18 PM)        ElementClass = 'ISql90MessageType', Name = '[http://schemas.microsoft.com/SQL/ServiceBroker/Error]'
  70: (1:36:18 PM)        ElementClass = 'ISql90MessageType', Name = '[http://schemas.microsoft.com/SQL/ServiceBroker/ServiceDiagnostic/Description]'
  71: (1:36:18 PM)        ElementClass = 'ISql90MessageType', Name = '[http://schemas.microsoft.com/SQL/ServiceBroker/ServiceDiagnostic/Query]'
  72: (1:36:18 PM)        ElementClass = 'ISql90MessageType', Name = '[http://schemas.microsoft.com/SQL/ServiceBroker/ServiceDiagnostic/Status]'
  73: (1:36:18 PM)        ElementClass = 'ISql90MessageType', Name = '[http://schemas.microsoft.com/SQL/ServiceBroker/ServiceEcho/Echo]'
  74: (1:36:18 PM)        ElementClass = 'ISql90Role', Name = '[db_accessadmin]'
  75: (1:36:18 PM)        ElementClass = 'ISql90Role', Name = '[db_backupoperator]'
  76: (1:36:18 PM)        ElementClass = 'ISql90Role', Name = '[db_datareader]'
  77: (1:36:18 PM)        ElementClass = 'ISql90Role', Name = '[db_datawriter]'
  78: (1:36:18 PM)        ElementClass = 'ISql90Role', Name = '[db_ddladmin]'
  79: (1:36:18 PM)        ElementClass = 'ISql90Role', Name = '[db_denydatareader]'
  80: (1:36:18 PM)        ElementClass = 'ISql90Role', Name = '[db_denydatawriter]'
  81: (1:36:18 PM)        ElementClass = 'ISql90Role', Name = '[db_owner]'
  82: (1:36:18 PM)        ElementClass = 'ISql90Role', Name = '[db_securityadmin]'
  83: (1:36:18 PM)        ElementClass = 'ISql90Role', Name = '[public]'
  84: (1:36:18 PM)        ElementClass = 'ISql90Schema', Name = '[db_accessadmin]'
  85: (1:36:18 PM)        ElementClass = 'ISql90Schema', Name = '[db_backupoperator]'
  86: (1:36:18 PM)        ElementClass = 'ISql90Schema', Name = '[db_datareader]'
  87: (1:36:18 PM)        ElementClass = 'ISql90Schema', Name = '[db_datawriter]'
  88: (1:36:18 PM)        ElementClass = 'ISql90Schema', Name = '[db_ddladmin]'
  89: (1:36:18 PM)        ElementClass = 'ISql90Schema', Name = '[db_denydatareader]'
  90: (1:36:18 PM)        ElementClass = 'ISql90Schema', Name = '[db_denydatawriter]'
  91: (1:36:18 PM)        ElementClass = 'ISql90Schema', Name = '[db_owner]'
  92: (1:36:18 PM)        ElementClass = 'ISql90Schema', Name = '[db_securityadmin]'
  93: (1:36:18 PM)        ElementClass = 'ISql90Schema', Name = '[dbo]'
  94: (1:36:18 PM)        ElementClass = 'ISql90Schema', Name = '[guest]'
  95: (1:36:18 PM)        ElementClass = 'ISql90Schema', Name = '[INFORMATION_SCHEMA]'
  96: (1:36:18 PM)        ElementClass = 'ISql90Schema', Name = '[sys]'
  97: (1:36:18 PM)        ElementClass = 'ISql90User', Name = '[dbo]'
  98: (1:36:18 PM)        ElementClass = 'ISql90User', Name = '[guest]'
  99: (1:36:18 PM)        ElementClass = 'ISql90User', Name = '[INFORMATION_SCHEMA]'
 100: (1:36:18 PM)        ElementClass = 'ISql90User', Name = '[sys]'
 101: (1:36:18 PM)        ElementClass = 'ISql90UserDefinedDataType', Name = '[sys].[sysname]'
 102: (1:36:18 PM)        ElementClass = 'ISql90UserDefinedType', Name = '[geography]'
 103: (1:36:18 PM)        ElementClass = 'ISql90UserDefinedType', Name = '[geometry]'
 104: (1:36:18 PM)        ElementClass = 'ISql90UserDefinedType', Name = '[hierarchyid]'
 105: (1:36:18 PM)        ElementClass = 'ISql90UserDefinedType', Name = '[sys].[geography]'
 106: (1:36:18 PM)        ElementClass = 'ISql90UserDefinedType', Name = '[sys].[geometry]'
 107: (1:36:18 PM)        ElementClass = 'ISql90UserDefinedType', Name = '[sys].[hierarchyid]'
 108: (1:36:18 PM)        ElementClass = 'ISqlBuiltInType', Name = '[bigint]'
 109: (1:36:18 PM)        ElementClass = 'ISqlBuiltInType', Name = '[binary]'
 110: (1:36:18 PM)        ElementClass = 'ISqlBuiltInType', Name = '[bit]'
 111: (1:36:19 PM)        ElementClass = 'ISqlBuiltInType', Name = '[char]'
 112: (1:36:19 PM)        ElementClass = 'ISqlBuiltInType', Name = '[cursor]'
 113: (1:36:19 PM)        ElementClass = 'ISqlBuiltInType', Name = '[date]'
 114: (1:36:19 PM)        ElementClass = 'ISqlBuiltInType', Name = '[datetime]'
 115: (1:36:19 PM)        ElementClass = 'ISqlBuiltInType', Name = '[datetime2]'
 116: (1:36:19 PM)        ElementClass = 'ISqlBuiltInType', Name = '[datetimeoffset]'
 117: (1:36:19 PM)        ElementClass = 'ISqlBuiltInType', Name = '[decimal]'
 118: (1:36:19 PM)        ElementClass = 'ISqlBuiltInType', Name = '[float]'
 119: (1:36:19 PM)        ElementClass = 'ISqlBuiltInType', Name = '[image]'
 120: (1:36:19 PM)        ElementClass = 'ISqlBuiltInType', Name = '[int]'
 121: (1:36:19 PM)        ElementClass = 'ISqlBuiltInType', Name = '[money]'
 122: (1:36:19 PM)        ElementClass = 'ISqlBuiltInType', Name = '[nchar]'
 123: (1:36:19 PM)        ElementClass = 'ISqlBuiltInType', Name = '[ntext]'
 124: (1:36:19 PM)        ElementClass = 'ISqlBuiltInType', Name = '[numeric]'
 125: (1:36:19 PM)        ElementClass = 'ISqlBuiltInType', Name = '[nvarchar]'
 126: (1:36:19 PM)        ElementClass = 'ISqlBuiltInType', Name = '[real]'
 127: (1:36:19 PM)        ElementClass = 'ISqlBuiltInType', Name = '[smalldatetime]'
 128: (1:36:19 PM)        ElementClass = 'ISqlBuiltInType', Name = '[smallint]'
 129: (1:36:19 PM)        ElementClass = 'ISqlBuiltInType', Name = '[smallmoney]'
 130: (1:36:19 PM)        ElementClass = 'ISqlBuiltInType', Name = '[sql_variant]'
 131: (1:36:19 PM)        ElementClass = 'ISqlBuiltInType', Name = '[table]'
 132: (1:36:19 PM)        ElementClass = 'ISqlBuiltInType', Name = '[text]'
 133: (1:36:19 PM)        ElementClass = 'ISqlBuiltInType', Name = '[time]'
 134: (1:36:19 PM)        ElementClass = 'ISqlBuiltInType', Name = '[timestamp]'
 135: (1:36:19 PM)        ElementClass = 'ISqlBuiltInType', Name = '[tinyint]'
 136: (1:36:19 PM)        ElementClass = 'ISqlBuiltInType', Name = '[uniqueidentifier]'
 137: (1:36:19 PM)        ElementClass = 'ISqlBuiltInType', Name = '[varbinary]'
 138: (1:36:19 PM)        ElementClass = 'ISqlBuiltInType', Name = '[varchar]'
 139: (1:36:19 PM)        ElementClass = 'ISqlBuiltInType', Name = '[xml]'
 140: (1:36:19 PM)        ElementClass = 'ISqlServerRole', Name = '[bulkadmin]'
 141: (1:36:19 PM)        ElementClass = 'ISqlServerRole', Name = '[dbcreator]'
 142: (1:36:19 PM)        ElementClass = 'ISqlServerRole', Name = '[diskadmin]'
 143: (1:36:19 PM)        ElementClass = 'ISqlServerRole', Name = '[processadmin]'
 144: (1:36:19 PM)        ElementClass = 'ISqlServerRole', Name = '[public]'
 145: (1:36:19 PM)        ElementClass = 'ISqlServerRole', Name = '[securityadmin]'
 146: (1:36:19 PM)        ElementClass = 'ISqlServerRole', Name = '[serveradmin]'
 147: (1:36:19 PM)        ElementClass = 'ISqlServerRole', Name = '[setupadmin]'
 148: (1:36:19 PM)        ElementClass = 'ISqlServerRole', Name = '[sysadmin]'
 149: (1:36:19 PM)        End External Elements : Database4
 150: (1:36:19 PM) 
 151:    <?xml version="1.0" encoding="utf-16"?>
 152:    <SchemaManager DspName="Microsoft.Data.Schema.Sql.SqlDsp.Sql100DatabaseSchemaProvider" Collation="Latin1_General_CS_AS">
 153:      <Header>
 154:        <CustomData Category="ModelCapability">
 155:          <Metadata Name="ModelCapability" Value="Default" />
 156:        </CustomData>
 157:        <CustomData Category="AnsiNulls">
 158:          <Metadata Name="AnsiNulls" Value="True" />
 159:        </CustomData>
 160:        <CustomData Category="QuotedIdentifier">
 161:          <Metadata Name="QuotedIdentifier" Value="True" />
 162:        </CustomData>
 163:        <CustomData Category="DeploymentCollation">
 164:          <Metadata Name="DeploymentCollation" Value="SQL_Latin1_General_CP1_CS_AS" />
 165:        </CustomData>
 166:        <CustomData Category="CompatibilityMode">
 167:          <Metadata Name="CompatibilityMode" Value="100" />
 168:        </CustomData>
 169:        <CustomData Category="Reference" Type="DbSchema">
 170:          <Metadata Name="FileName" Value="C:\PROGRAM FILES (X86)\MICROSOFT VISUAL STUDIO 9.0\VSTSDB\EXTENSIONS\SQLSERVER\2008\DBSCHEMAS\MICROSOFT.SQLTYPES.DBSCHEMA" />
 171:          <Metadata Name="LogicalName" Value="Microsoft.SqlTypes.dbschema" />
 172:        </CustomData>
 173:      </Header>
 174:      <Model>
 175:        <Element Type="ISql100DatabaseOptions">
 176:          <Property Name="Collation" Value="SQL_Latin1_General_CP1_CS_AS" />
 177:          <Property Name="IsAnsiNullDefaultOn" Value="True" />
 178:          <Property Name="IsAnsiNullsOn" Value="True" />
 179:          <Property Name="IsAnsiPaddingOn" Value="True" />
 180:          <Property Name="IsAnsiWarningsOn" Value="True" />
 181:          <Property Name="IsArithAbortOn" Value="True" />
 182:          <Property Name="IsConcatNullYieldsNullOn" Value="True" />
 183:          <Property Name="IsAutoCreateStatisticsOn" Value="True" />
 184:          <Property Name="IsAutoUpdateStatisticsOn" Value="True" />
 185:          <Property Name="RecoveryMode" Value="3" />
 186:          <Property Name="IsFullTextEnabled" Value="True" />
 187:          <Property Name="IsAutoUpdateStatisticsAsyncOn" Value="True" />
 188:          <Property Name="PageVerifyMode" Value="3" />
 189:          <Property Name="MirroringPartnerServer" Value="" />
 190:          <Property Name="IsPartnerServerRedoQueueUnlimited" Value="True" />
 191:          <Property Name="MirroringPartnerServerTimeout" Value="10" />
 192:          <Property Name="MirroringWitnessServer" Value="" />
 193:          <Property Name="ServiceBrokerOption" Value="2" />
 194:          <Property Name="ParameterizationOption" Value="1" />
 195:          <Property Name="CompatibilityMode" Value="100" />
 196:          <Relationship Name="DefaultFilegroup">
 197:            <Entry>
 198:              <References ExternalSource="BuiltIns" Name="[PRIMARY]" />
 199:            </Entry>
 200:          </Relationship>
 201:        </Element>
 202:      </Model>
 203:    </SchemaManager>
 204: (1:36:19 PM) ---------------------------------------
 205: (1:36:19 PM) 

image


Dump Project System - this option will dump all the file names and objects that are in the project system

 

Example output of Dump Project System:

   1: (1:35:35 PM) ---------------------------------------
   2: (1:35:35 PM)   Project System Dump : Database4
   3: (1:35:35 PM) ---------------------------------------
   4: (1:35:35 PM)      DatabaseProjectNode State :c:\demo\Database4\Database4.dbproj
   5: (1:35:35 PM)      DBProItemIdMap ->
   6: (1:35:35 PM)          _idToNodeList ->
   7: (1:35:35 PM)              1, References
   8: (1:35:35 PM)              2, c:\Program Files (x86)\Microsoft Visual Studio 9.0\VSTSDB\Extensions\SqlServer\2008\DBSchemas\Microsoft.SqlTypes.dbschema
   9: (1:35:35 PM)              3, c:\demo\Database4\Properties
  10: (1:35:35 PM)              4, c:\demo\Database4\Properties\Database.sqlsettings
  11: (1:35:35 PM)              5, c:\demo\Database4\Properties\Database.sqldeployment
  12: (1:35:35 PM)              6, c:\demo\Database4\Properties\Database.sqlcmdvars
  13: (1:35:35 PM)              7, c:\demo\Database4\Scripts
  14: (1:35:35 PM)              8, c:\demo\Database4\Scripts\Pre-Deployment
  15: (1:35:35 PM)              9, c:\demo\Database4\Scripts\Pre-Deployment\Script.PreDeployment.sql
  16: (1:35:35 PM)              10, c:\demo\Database4\Scripts\Post-Deployment
  17: (1:35:35 PM)              11, c:\demo\Database4\Scripts\Post-Deployment\Script.PostDeployment.sql
  18: (1:35:35 PM)              12, c:\demo\Database4\Schema Objects
  19: (1:35:35 PM)              13, c:\demo\Database4\Schema Objects\Database Level Objects
  20: (1:35:35 PM)              14, c:\demo\Database4\Schema Objects\Database Level Objects\Assemblies
  21: (1:35:35 PM)              15, c:\demo\Database4\Schema Objects\Database Level Objects\Database Triggers
  22: (1:35:35 PM)              16, c:\demo\Database4\Schema Objects\Database Level Objects\Security
  23: (1:35:35 PM)              17, c:\demo\Database4\Schema Objects\Database Level Objects\Security\Asymmetric Keys
  24: (1:35:35 PM)              18, c:\demo\Database4\Schema Objects\Database Level Objects\Security\Certificates
  25: (1:35:35 PM)              19, c:\demo\Database4\Schema Objects\Database Level Objects\Security\Database Audit Specification
  26: (1:35:35 PM)              20, c:\demo\Database4\Schema Objects\Database Level Objects\Security\Database Encryption Keys
  27: (1:35:35 PM)              21, c:\demo\Database4\Schema Objects\Database Level Objects\Security\Master Keys
  28: (1:35:35 PM)              22, c:\demo\Database4\Schema Objects\Database Level Objects\Security\Roles
  29: (1:35:35 PM)              23, c:\demo\Database4\Schema Objects\Database Level Objects\Security\Roles\Application Roles
  30: (1:35:35 PM)              24, c:\demo\Database4\Schema Objects\Database Level Objects\Security\Roles\Database Roles
  31: (1:35:35 PM)              25, c:\demo\Database4\Schema Objects\Database Level Objects\Security\Schemas
  32: (1:35:35 PM)              26, c:\demo\Database4\Schema Objects\Database Level Objects\Security\Signatures
  33: (1:35:35 PM)              27, c:\demo\Database4\Schema Objects\Database Level Objects\Security\Symmetric Keys
  34: (1:35:35 PM)              28, c:\demo\Database4\Schema Objects\Database Level Objects\Security\Users
  35: (1:35:35 PM)              29, c:\demo\Database4\Schema Objects\Database Level Objects\Service Broker
  36: (1:35:35 PM)              30, c:\demo\Database4\Schema Objects\Database Level Objects\Service Broker\Broker Priorities
  37: (1:35:35 PM)              31, c:\demo\Database4\Schema Objects\Database Level Objects\Service Broker\Contracts
  38: (1:35:35 PM)              32, c:\demo\Database4\Schema Objects\Database Level Objects\Service Broker\Event Notifications
  39: (1:35:35 PM)              33, c:\demo\Database4\Schema Objects\Database Level Objects\Service Broker\Message Types
  40: (1:35:35 PM)              34, c:\demo\Database4\Schema Objects\Database Level Objects\Service Broker\Queues
  41: (1:35:35 PM)              35, c:\demo\Database4\Schema Objects\Database Level Objects\Service Broker\Remote Service Binding
  42: (1:35:35 PM)              36, c:\demo\Database4\Schema Objects\Database Level Objects\Service Broker\Routes
  43: (1:35:35 PM)              37, c:\demo\Database4\Schema Objects\Database Level Objects\Service Broker\Services
  44: (1:35:35 PM)              38, c:\demo\Database4\Schema Objects\Database Level Objects\Storage
  45: (1:35:35 PM)              39, c:\demo\Database4\Schema Objects\Database Level Objects\Storage\Filegroups
  46: (1:35:35 PM)              40, c:\demo\Database4\Schema Objects\Database Level Objects\Storage\Files
  47: (1:35:35 PM)              41, c:\demo\Database4\Schema Objects\Database Level Objects\Storage\Full Text Catalogs
  48: (1:35:35 PM)              42, c:\demo\Database4\Schema Objects\Database Level Objects\Storage\Full Text Stoplists
  49: (1:35:35 PM)              43, c:\demo\Database4\Schema Objects\Database Level Objects\Storage\Partition Functions
  50: (1:35:35 PM)              44, c:\demo\Database4\Schema Objects\Database Level Objects\Storage\Partition Schemes
  51: (1:35:35 PM)              45, c:\demo\Database4\Schema Objects\Schemas
  52: (1:35:35 PM)              46, c:\demo\Database4\Schema Objects\Schemas\dbo
  53: (1:35:35 PM)              47, c:\demo\Database4\Schema Objects\Schemas\dbo\Programmability
  54: (1:35:35 PM)              48, c:\demo\Database4\Schema Objects\Schemas\dbo\Programmability\Defaults
  55: (1:35:35 PM)              49, c:\demo\Database4\Schema Objects\Schemas\dbo\Programmability\Functions
  56: (1:35:35 PM)              50, c:\demo\Database4\Schema Objects\Schemas\dbo\Programmability\Rules
  57: (1:35:35 PM)              51, c:\demo\Database4\Schema Objects\Schemas\dbo\Programmability\Stored Procedures
  58: (1:35:35 PM)              52, c:\demo\Database4\Schema Objects\Schemas\dbo\Programmability\Types
  59: (1:35:35 PM)              53, c:\demo\Database4\Schema Objects\Schemas\dbo\Programmability\Types\User Defined Data Types
  60: (1:35:35 PM)              54, c:\demo\Database4\Schema Objects\Schemas\dbo\Programmability\Types\User Defined Table Types
  61: (1:35:35 PM)              55, c:\demo\Database4\Schema Objects\Schemas\dbo\Programmability\Types\User Defined Types CLR
  62: (1:35:35 PM)              56, c:\demo\Database4\Schema Objects\Schemas\dbo\Programmability\Types\XML Schema Collections
  63: (1:35:35 PM)              57, c:\demo\Database4\Schema Objects\Schemas\dbo\Synonyms
  64: (1:35:35 PM)              58, c:\demo\Database4\Schema Objects\Schemas\dbo\Tables
  65: (1:35:35 PM)              59, c:\demo\Database4\Schema Objects\Schemas\dbo\Tables\Constraints
  66: (1:35:35 PM)              60, c:\demo\Database4\Schema Objects\Schemas\dbo\Tables\Indexes
  67: (1:35:35 PM)              61, c:\demo\Database4\Schema Objects\Schemas\dbo\Tables\Keys
  68: (1:35:35 PM)              62, c:\demo\Database4\Schema Objects\Schemas\dbo\Tables\Statistics
  69: (1:35:35 PM)              63, c:\demo\Database4\Schema Objects\Schemas\dbo\Tables\Triggers
  70: (1:35:35 PM)              64, c:\demo\Database4\Schema Objects\Schemas\dbo\Views
  71: (1:35:35 PM)              65, c:\demo\Database4\Schema Objects\Schemas\dbo\Views\Indexes
  72: (1:35:35 PM)              66, c:\demo\Database4\Schema Objects\Schemas\dbo\Views\Statistics
  73: (1:35:35 PM)              67, c:\demo\Database4\Schema Objects\Schemas\dbo\Views\Triggers
  74: (1:35:35 PM)              68, c:\demo\Database4\Data Generation Plans
  75: (1:35:35 PM)          _folderNodes ->
  76: (1:35:35 PM)              c:\demo\Database4\Properties
  77: (1:35:35 PM)              c:\demo\Database4\Scripts
  78: (1:35:35 PM)              c:\demo\Database4\Scripts\Pre-Deployment
  79: (1:35:35 PM)              c:\demo\Database4\Scripts\Post-Deployment
  80: (1:35:35 PM)              c:\demo\Database4\Schema Objects
  81: (1:35:35 PM)              c:\demo\Database4\Schema Objects\Database Level Objects
  82: (1:35:35 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Assemblies
  83: (1:35:35 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Database Triggers
  84: (1:35:35 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Security
  85: (1:35:35 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Security\Asymmetric Keys
  86: (1:35:35 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Security\Certificates
  87: (1:35:35 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Security\Database Audit Specification
  88: (1:35:35 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Security\Database Encryption Keys
  89: (1:35:35 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Security\Master Keys
  90: (1:35:35 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Security\Roles
  91: (1:35:35 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Security\Roles\Application Roles
  92: (1:35:35 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Security\Roles\Database Roles
  93: (1:35:35 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Security\Schemas
  94: (1:35:35 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Security\Signatures
  95: (1:35:35 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Security\Symmetric Keys
  96: (1:35:35 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Security\Users
  97: (1:35:35 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Service Broker
  98: (1:35:35 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Service Broker\Broker Priorities
  99: (1:35:35 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Service Broker\Contracts
 100: (1:35:35 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Service Broker\Event Notifications
 101: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Service Broker\Message Types
 102: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Service Broker\Queues
 103: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Service Broker\Remote Service Binding
 104: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Service Broker\Routes
 105: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Service Broker\Services
 106: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Storage
 107: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Storage\Filegroups
 108: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Storage\Files
 109: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Storage\Full Text Catalogs
 110: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Storage\Full Text Stoplists
 111: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Storage\Partition Functions
 112: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Storage\Partition Schemes
 113: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Schemas
 114: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Schemas\dbo
 115: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Schemas\dbo\Programmability
 116: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Schemas\dbo\Programmability\Defaults
 117: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Schemas\dbo\Programmability\Functions
 118: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Schemas\dbo\Programmability\Rules
 119: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Schemas\dbo\Programmability\Stored Procedures
 120: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Schemas\dbo\Programmability\Types
 121: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Schemas\dbo\Programmability\Types\User Defined Data Types
 122: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Schemas\dbo\Programmability\Types\User Defined Table Types
 123: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Schemas\dbo\Programmability\Types\User Defined Types CLR
 124: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Schemas\dbo\Programmability\Types\XML Schema Collections
 125: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Schemas\dbo\Synonyms
 126: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Schemas\dbo\Tables
 127: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Schemas\dbo\Tables\Constraints
 128: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Schemas\dbo\Tables\Indexes
 129: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Schemas\dbo\Tables\Keys
 130: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Schemas\dbo\Tables\Statistics
 131: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Schemas\dbo\Tables\Triggers
 132: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Schemas\dbo\Views
 133: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Schemas\dbo\Views\Indexes
 134: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Schemas\dbo\Views\Statistics
 135: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Schemas\dbo\Views\Triggers
 136: (1:35:36 PM)              c:\demo\Database4\Data Generation Plans
 137: (1:35:36 PM)          _urlToNodeList ->
 138: (1:35:36 PM)              c:\demo\Database4\Properties, 3
 139: (1:35:36 PM)              c:\demo\Database4\Properties\Database.sqlsettings, 4
 140: (1:35:36 PM)              c:\demo\Database4\Properties\Database.sqldeployment, 5
 141: (1:35:36 PM)              c:\demo\Database4\Properties\Database.sqlcmdvars, 6
 142: (1:35:36 PM)              c:\demo\Database4\Scripts, 7
 143: (1:35:36 PM)              c:\demo\Database4\Scripts\Pre-Deployment, 8
 144: (1:35:36 PM)              c:\demo\Database4\Scripts\Pre-Deployment\Script.PreDeployment.sql, 9
 145: (1:35:36 PM)              c:\demo\Database4\Scripts\Post-Deployment, 10
 146: (1:35:36 PM)              c:\demo\Database4\Scripts\Post-Deployment\Script.PostDeployment.sql, 11
 147: (1:35:36 PM)              c:\demo\Database4\Schema Objects, 12
 148: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Database Level Objects, 13
 149: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Assemblies, 14
 150: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Database Triggers, 15
 151: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Security, 16
 152: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Security\Asymmetric Keys, 17
 153: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Security\Certificates, 18
 154: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Security\Database Audit Specification, 19
 155: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Security\Database Encryption Keys, 20
 156: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Security\Master Keys, 21
 157: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Security\Roles, 22
 158: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Security\Roles\Application Roles, 23
 159: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Security\Roles\Database Roles, 24
 160: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Security\Schemas, 25
 161: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Security\Signatures, 26
 162: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Security\Symmetric Keys, 27
 163: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Security\Users, 28
 164: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Service Broker, 29
 165: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Service Broker\Broker Priorities, 30
 166: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Service Broker\Contracts, 31
 167: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Service Broker\Event Notifications, 32
 168: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Service Broker\Message Types, 33
 169: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Service Broker\Queues, 34
 170: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Service Broker\Remote Service Binding, 35
 171: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Service Broker\Routes, 36
 172: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Service Broker\Services, 37
 173: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Storage, 38
 174: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Storage\Filegroups, 39
 175: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Storage\Files, 40
 176: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Storage\Full Text Catalogs, 41
 177: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Storage\Full Text Stoplists, 42
 178: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Storage\Partition Functions, 43
 179: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Database Level Objects\Storage\Partition Schemes, 44
 180: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Schemas, 45
 181: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Schemas\dbo, 46
 182: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Schemas\dbo\Programmability, 47
 183: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Schemas\dbo\Programmability\Defaults, 48
 184: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Schemas\dbo\Programmability\Functions, 49
 185: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Schemas\dbo\Programmability\Rules, 50
 186: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Schemas\dbo\Programmability\Stored Procedures, 51
 187: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Schemas\dbo\Programmability\Types, 52
 188: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Schemas\dbo\Programmability\Types\User Defined Data Types, 53
 189: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Schemas\dbo\Programmability\Types\User Defined Table Types, 54
 190: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Schemas\dbo\Programmability\Types\User Defined Types CLR, 55
 191: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Schemas\dbo\Programmability\Types\XML Schema Collections, 56
 192: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Schemas\dbo\Synonyms, 57
 193: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Schemas\dbo\Tables, 58
 194: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Schemas\dbo\Tables\Constraints, 59
 195: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Schemas\dbo\Tables\Indexes, 60
 196: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Schemas\dbo\Tables\Keys, 61
 197: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Schemas\dbo\Tables\Statistics, 62
 198: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Schemas\dbo\Tables\Triggers, 63
 199: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Schemas\dbo\Views, 64
 200: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Schemas\dbo\Views\Indexes, 65
 201: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Schemas\dbo\Views\Statistics, 66
 202: (1:35:36 PM)              c:\demo\Database4\Schema Objects\Schemas\dbo\Views\Triggers, 67
 203: (1:35:36 PM)              c:\demo\Database4\Data Generation Plans, 68
 204: (1:35:36 PM)          _urlsToEvaluate ->
 205: (1:35:36 PM)      ProjectConfigs ->
 206: (1:35:36 PM)         Key Output for config Release is c:\demo\Database4\obj\Release\Database4.dbschema
 207: (1:35:36 PM)         All Outputs -->
 208: (1:35:36 PM)            c:\demo\Database4\obj\Release\Database4.dbschema
 209: (1:35:36 PM)         Key Output for config Debug is c:\demo\Database4\obj\Debug\Database4.dbschema
 210: (1:35:36 PM)         All Outputs -->
 211: (1:35:36 PM)            c:\demo\Database4\obj\Debug\Database4.dbschema
 212: (1:35:36 PM)         Catalog Properties:
 213: (1:35:36 PM)         AllowSnapshotIsolation,False
 214: (1:35:36 PM)         AnsiNullDefault,True
 215: (1:35:36 PM)         AnsiNulls,True
 216: (1:35:36 PM)         AnsiPadding,True
 217: (1:35:36 PM)         AnsiWarnings,True
 218: (1:35:36 PM)         ArithAbort,True
 219: (1:35:36 PM)         AutoClose,False
 220: (1:35:36 PM)         AutoCreateStatistics,True
 221: (1:35:36 PM)         AutoShrink,False
 222: (1:35:36 PM)         AutoUpdateStatistics,True
 223: (1:35:36 PM)         AutoUpdateStatisticsAsynchronously,True
 224: (1:35:36 PM)         ChangeTrackingRetentionPeriod,2
 225: (1:35:36 PM)         ChangeTrackingRetentionUnit,Days
 226: (1:35:36 PM)         CloseCursorOnCommitEnabled,False
 227: (1:35:36 PM)         ConcatNullYieldsNull,True
 228: (1:35:36 PM)         DatabaseAccess,MULTI_USER
 229: (1:35:36 PM)         DatabaseChaining,False
 230: (1:35:36 PM)         DatabaseState,ONLINE
 231: (1:35:36 PM)         DateCorrelationOptimizationOn,False
 232: (1:35:36 PM)         DefaultCollation,SQL_Latin1_General_CP1_CS_AS
 233: (1:35:36 PM)         DefaultCursor,LOCAL
 234: (1:35:36 PM)         DefaultFilegroup,PRIMARY
 235: (1:35:36 PM)         DefaultFileStreamFilegroup,
 236: (1:35:36 PM)         EnableFullTextSearch,True
 237: (1:35:36 PM)         ForcingServiceAllowDataLoss,False
 238: (1:35:36 PM)         IsChangeTrackingAutoCleanupOn,True
 239: (1:35:37 PM)         IsChangeTrackingOn,False
 240: (1:35:37 PM)         IsEncryptionOn,False
 241: (1:35:37 PM)         MirroringPartnerServer,
 242: (1:35:37 PM)         MirroringPartnerServerTimeout,10
 243: (1:35:37 PM)         MirroringWitnessOn,False
 244: (1:35:37 PM)         MirroringWitnessServer,
 245: (1:35:37 PM)         NumericRoundAbort,False
 246: (1:35:37 PM)         PageVerify,NONE
 247: (1:35:37 PM)         Parameterization,SIMPLE
 248: (1:35:37 PM)         PartnerServerFailover,False
 249: (1:35:37 PM)         PartnerServerOff,False
 250: (1:35:37 PM)         PartnerServerRedoQueueSize,
 251: (1:35:37 PM)         PartnerServerRedoQueueUnlimited,True
 252: (1:35:37 PM)         PartnerServerResumed,False
 253: (1:35:37 PM)         PartnerServerSafetyOff,False
 254: (1:35:37 PM)         PartnerServerSuspended,False
 255: (1:35:37 PM)         QuotedIdentifier,True
 256: (1:35:37 PM)         ReadCommittedSnapshot,False
 257: (1:35:37 PM)         Recovery,FULL
 258: (1:35:37 PM)         RecursiveTriggersEnabled,False
 259: (1:35:37 PM)         RollbackMode,DoNotScript
 260: (1:35:37 PM)         ServiceBrokerOption,DisableBroker
 261: (1:35:37 PM)         SupplementalLoggingOn,False
 262: (1:35:37 PM)         TornPageDetection,False
 263: (1:35:37 PM)         Trustworthy,False
 264: (1:35:37 PM)         UpdateOptions,READ_WRITE
 265: (1:35:37 PM)         VardecimalStorageFormatOn,False
 266: (1:35:37 PM)         Server Properties:
 267: (1:35:37 PM) ---------------------------------------
 268: (1:35:37 PM) 


image
Dump RDT (Running Document Table) - this option dumps the content of the Visual Studio Running Document Table for the active Database Project.

 

Example output of Dump RDT

(1:46:03 PM) ---------------------------------------
(1:46:03 PM)   Dumping RDT :
(1:46:03 PM)   c:\demo\Database4\Database4.dbproj
(1:46:03 PM)   c:\demo\Database4\Database4.sln
(1:46:03 PM) ---------------------------------------


image


Dump GC (Garbage Collector) - this option dumps the details of the garbage collector for the process.

 

Example output of Dump GC

(1:34:21 PM) Dump GC Started...
(1:34:21 PM) Total memory: 5698376
(1:34:21 PM) Max generation: 2
(1:34:21 PM) Collection count Gen0: 28
(1:34:21 PM) Collection count Gen1: 7
(1:34:21 PM) Collection count Gen2: 2
(1:34:21 PM) Dump GC Ended...

 image

Start GC Collection - this options force a garbage collection run, trying to trim down the memory consumption

 

Example output of Start GC Collection

(1:47:15 PM) GC Collection Started...
(1:47:15 PM) Total memory: 5862760
(1:47:15 PM) GC.Collect(0)...
(1:47:15 PM) Total memory: 4166892
(1:47:15 PM) GC.Collect(1)...
(1:47:15 PM) Total memory: 4150808
(1:47:15 PM) GC.Collect(2)...
(1:47:15 PM) Total memory: 3931476
(1:47:15 PM) GC Collection Ended...

image


Save to File - this option save the captured events to a text file.

 

This concludes part 2 of the diagnostics series, one more to go!

-GertD