Deadlock in version

Provides intelligent code completion for SQL Server editors.

Deadlock in version

Postby » Fri Jun 14, 2013 5:19 pm

Sql Prompt caused a deadlock in a production system.

The lock message from our monitoring sofware was:

The deadlock victim was spid 200 with application name 'Red Gate Software Ltd SQL Prompt' by user xxxxxx' on host 'xxxxxx'.

Last command issued:

SELECT name, schema_id AS id FROM [tempdb].[sys].schemas; SELECT o.schema_id AS owner,, o.type, o.object_id AS id, o.parent_object_id AS parent,
CONVERT(BIT, ( CASE WHEN o.is_ms_shipped = 1 THEN 1
WHEN x.major_id IS NOT NULL THEN 1
ELSE 0 END )) AS sysobj
FROM [tempdb].sys.objects o
LEFT JOIN [tempdb].sys.extended_properties x ON o.object_id = x.major_id
AND x.minor_id = 0 AND x.class = 1
AND = N'microsoft_database_tools_support'
WHERE type != 'PK' AND type != 'TR' AND schema_id!=4;
SELECT object_id AS id, parent_id AS owner, name FROM [tempdb].[sys].triggers; SELECT user_type_id AS id, name, schema_id AS owner, system_type_id as systype, is_table_type FROM [tempdb].[sys].types;

SELECT name, id AS owner, xusertype, colid, CONVERT(BIT, (colstat & 1)) AS is_identity, CONVERT(BIT, (colstat & 4)) AS is_computed,

I can't imagine why a deadlock should occur just reading schema information.
Posts: 9
Joined: Fri Jun 08, 2012 1:29 pm

Postby eddie davis » Mon Jun 17, 2013 3:26 pm

Thank you for your forum post.

How often do you encounter this deadlock?

Whilst I have known SQL Prompt to encounter performance issues, I have never known it create SQL Deadlock.

Do you have any other Red Gate products that plug-in to SSMS installed? for example SQL Source Control, SQL Search or SQL Test.

Is there any information in the SQL Prompt logs for the date/time the deadlock appeared? You will find the SQL Prompt log files in this path:

C:\\Users\\<user_name>\\AppData\\local\\red Gate\\SQL Prompt 5

Many Thanks
Eddie Davis
Technical Support Engineer
Red Gate Software Ltd
eddie davis
Posts: 1036
Joined: Wed Jun 14, 2006 2:47 pm
Location: Red Gate Software


Postby » Mon Jun 17, 2013 5:02 pm

This is the first time I have seen a deadlock occur.

I do have those other products installed. I only use the Search application however.

Scanning through the logs, I only see exceptions for not being able to find the PK for a column, perhaps due to it being a table type.

The other errors in the logs are regarding not being able to decrypt system_internals_allocation_units and another regarding having no access to run DBCC TRACEON

I dont' see anything that appears to be related to the deadlock.
Posts: 9
Joined: Fri Jun 08, 2012 1:29 pm

Return to SQL Prompt Previous Versions

Who is online

Users browsing this forum: Google [Bot] and 0 guests