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
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.
Let's go through each icon in the toolbar first to explore the options.
Clear - this options deletes all captured events from the display window and the internal buffer.
Capture - this is a toggle that will turn on and off capturing of events.
Filter - this will bring up a dialog where you can select the events to capture.
The events to capture are:
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 = '[https://schemas.microsoft.com/SQL/Notifications/EventNotificationService]'
45: (1:36:18 PM) ElementClass = 'ISql100Service', Name = '[https://schemas.microsoft.com/SQL/Notifications/QueryNotificationService]'
46: (1:36:18 PM) ElementClass = 'ISql100Service', Name = '[https://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 = '[https://schemas.microsoft.com/SQL/Notifications/PostEventNotification]'
51: (1:36:18 PM) ElementClass = 'ISql90Contract', Name = '[https://schemas.microsoft.com/SQL/Notifications/PostQueryNotification]'
52: (1:36:18 PM) ElementClass = 'ISql90Contract', Name = '[https://schemas.microsoft.com/SQL/ServiceBroker/BrokerConfigurationNotice]'
53: (1:36:18 PM) ElementClass = 'ISql90Contract', Name = '[https://schemas.microsoft.com/SQL/ServiceBroker/ServiceDiagnostic]'
54: (1:36:18 PM) ElementClass = 'ISql90Contract', Name = '[https://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 = '[https://schemas.microsoft.com/SQL/Notifications/EventNotification]'
62: (1:36:18 PM) ElementClass = 'ISql90MessageType', Name = '[https://schemas.microsoft.com/SQL/Notifications/QueryNotification]'
63: (1:36:18 PM) ElementClass = 'ISql90MessageType', Name = '[https://schemas.microsoft.com/SQL/ServiceBroker/BrokerConfigurationNotice/FailedRemoteServiceBinding]'
64: (1:36:18 PM) ElementClass = 'ISql90MessageType', Name = '[https://schemas.microsoft.com/SQL/ServiceBroker/BrokerConfigurationNotice/FailedRoute]'
65: (1:36:18 PM) ElementClass = 'ISql90MessageType', Name = '[https://schemas.microsoft.com/SQL/ServiceBroker/BrokerConfigurationNotice/MissingRemoteServiceBinding]'
66: (1:36:18 PM) ElementClass = 'ISql90MessageType', Name = '[https://schemas.microsoft.com/SQL/ServiceBroker/BrokerConfigurationNotice/MissingRoute]'
67: (1:36:18 PM) ElementClass = 'ISql90MessageType', Name = '[https://schemas.microsoft.com/SQL/ServiceBroker/DialogTimer]'
68: (1:36:18 PM) ElementClass = 'ISql90MessageType', Name = '[https://schemas.microsoft.com/SQL/ServiceBroker/EndDialog]'
69: (1:36:18 PM) ElementClass = 'ISql90MessageType', Name = '[https://schemas.microsoft.com/SQL/ServiceBroker/Error]'
70: (1:36:18 PM) ElementClass = 'ISql90MessageType', Name = '[https://schemas.microsoft.com/SQL/ServiceBroker/ServiceDiagnostic/Description]'
71: (1:36:18 PM) ElementClass = 'ISql90MessageType', Name = '[https://schemas.microsoft.com/SQL/ServiceBroker/ServiceDiagnostic/Query]'
72: (1:36:18 PM) ElementClass = 'ISql90MessageType', Name = '[https://schemas.microsoft.com/SQL/ServiceBroker/ServiceDiagnostic/Status]'
73: (1:36:18 PM) ElementClass = 'ISql90MessageType', Name = '[https://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)
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)
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) ---------------------------------------
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...
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...
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