Event Monitor

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