How can we help you today? How can we help you today?
ginacresse
Activity overview Badges (0) Posts (4) Comments (2)

Activity overview

Latest activity by ginacresse

Unable to send test email. Please check your settings
  1. Community
  2. SQL Monitor Previous Versions
I can send alert e-mails to my e-mail address, but as soon as I try to send a test e-mail to myphone#@txt.att.net, it fails. I can send texts to my phone without problem from our e-mail system. I...
1 follower 1 comment 0 votes
Hi Priya, When I run the sql from the post you directed me to: SELECT object_name(partitions.object_id) AS [Table], indexes.name AS [Index] FROM sys.partitions AS partitions INNER JOIN sys.indexes AS indexes ON partitions.object_id = indexes.object_id WHERE hobt_id = 72057595237695488 I get the following results: Table Index InventoryTran cidx_InventoryTran InventoryTran PK_InventoryTran InventoryTran idx_InventoryTran InventoryTran idx_InventoryTran1 InventoryTran idx_InventoryTran2 InventoryTran idx_InventoryTran3 InventoryTran idx_TranDate InventoryTran idx_InventoryTran4 InventoryTran idx_InventoryTran5 InventoryTran idx_InventoryTran6 InventoryTran idx_InventoryTran7 InventoryTran idx_InventoryTran8 InventoryTran idx_InventoryTran9 When I run the same code with the victim hbid_id: SELECT object_name(partitions.object_id) AS [Table], indexes.name AS [Index] FROM sys.partitions AS partitions INNER JOIN sys.indexes AS indexes ON partitions.object_id = indexes.object_id WHERE hobt_id = 72057595237957632 I get identical results: Table Index InventoryTran cidx_InventoryTran InventoryTran PK_InventoryTran InventoryTran idx_InventoryTran InventoryTran idx_InventoryTran1 InventoryTran idx_InventoryTran2 InventoryTran idx_InventoryTran3 InventoryTran idx_TranDate InventoryTran idx_InventoryTran4 InventoryTran idx_InventoryTran5 InventoryTran idx_InventoryTran6 InventoryTran idx_InventoryTran7 InventoryTran idx_InventoryTran8 InventoryTran idx_InventoryTran9 I'm not sure how this helps me. Am I missing something? / comments
  1. Community
  2. SQL Monitor Previous Versions
  3. Deadlock with no SQL Query Fragment
Hi Priya, When I run the sql from the post you directed me to: SELECT object_name(partitions.object_id) AS [Table], indexes.name AS [Index] FROM s...
0 votes
Thank you, Priya. I had looked at that post before, but it seems to be returning information about an index(s). My specific object is a stored procedure (I can tell because of the "DELETE Line #: 469". Why does the Victim object id refer to the correct stored procedure, but the victor object id does not? I have already resolved this particular deadlock on my own, so if you don't have an answer, that is okay. I was just curious. / comments
  1. Community
  2. SQL Monitor Previous Versions
  3. Trouble with deadlock object id
Thank you, Priya. I had looked at that post before, but it seems to be returning information about an index(s). My specific object is a stored procedure (I can tell because of the "DELETE Line #:...
0 votes
Database ID not identified in deadlock alert
  1. Community
  2. SQL Monitor Previous Versions
We get a lot of deadlock alerts that look like this:Deadlocked processes: 139 139 139 139 Object blocked: Unknown Deadlocked processes SPID Victim Lock details Statement type 139 No Event: Port: 0x...
1 follower 1 comment 0 votes
Deadlock with no SQL Query Fragment
  1. Community
  2. SQL Monitor Previous Versions
I have a deadlock alert that provides the following:Object blocked: Index/(Key) 72057595237695488 Deadlocked processes SPID Victim Lock details Statement type 139 dbid: 10, object id: 72057595237...
2 followers 3 comments 0 votes
Trouble with deadlock object id
  1. Community
  2. SQL Monitor Previous Versions
We just purchased SQL Monitor and I'm trying to learn how to use it. I'm having trouble identifying the object id for the 'Victor' in a recent deadlock. Clicking on the Victor process shows this: ...
2 followers 2 comments 0 votes
Total activity
8
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
2