How can we help you today? How can we help you today?
RofL
Activity overview Badges (0) Posts (3) Comments (7)

Comments

Sort by recent activity
I have, I absolutely have done that. I've uninstalled and reinstalled everything to make sure, but I'm still getting the error. To be clear, I've installed the DLM suite, then put the plugin in the TeamCity plugins folder, restarted all services, and I'm still getting this error. EDIT: FYI, the build agent and the build server are on the same box; so when I say "plugin", I am referring to the Build Agent plugin for the build runner. / comments
  1. Community
  2. SQL Compare 11
  3. remote_data_archive_migration_state
I have, I absolutely have done that. I've uninstalled and reinstalled everything to make sure, but I'm still getting the error. To be clear, I've installed the DLM suite, then put the plugin in the...
0 votes
Hi, I'm getting the same error on Team City using the RedGate Team City plugin. The SQL Server is hosted in Azure, but is not SQL Azure, it's SQL Developer 2014 (not running any service packs). This is a completely fresh install of everything: [15:46:29][Validating database state] Error: Comparison of 'Scripts.state' and [15:46:29][Validating database state] 'np:\.pipeLOCALDB#FB143BFC sqlquery.sqlCI_89e40b26-ee74-475a-be33-c781f5649 [15:46:29][Validating database state] 2da' failed: Invalid column name 'remote_data_archive_migration_state'. I;ve double checked to makre sure that the plugin is the most up-to-date, and have installed SQL Compare on the Team City box just in case that resolved it, but still getting the issue. Bit confused by this one. / comments
  1. Community
  2. SQL Compare 11
  3. remote_data_archive_migration_state
Hi, I'm getting the same error on Team City using the RedGate Team City plugin. The SQL Server is hosted in Azure, but is not SQL Azure, it's SQL Developer 2014 (not running any service packs). Thi...
0 votes
Hi Sergio, I do have the DLM Automation Suite installed on the box running Team City It was downloaded on Friday afternoon. I also downloaded and installed the latest plugin onto the box. Of the DLM suite I installed only SQL Compare 11 (11.5.0.297.) This is a fresh install of pretty much all the software running as the box was created last Wednesday. / comments
  1. Community
  2. SQL Compare 11
  3. remote_data_archive_migration_state
Hi Sergio, I do have the DLM Automation Suite installed on the box running Team City It was downloaded on Friday afternoon. I also downloaded and installed the latest plugin onto the box. Of the DL...
0 votes
This is brilliant thank you. I'm formatting the Cluster_SqlServer_Error_Text column using string functions to extract the names. Once I've got something I'm happy with I'll post here. Hopefully other people will find this really useful. Thanks again! [image] / comments
  1. Community
  2. SQL Monitor Previous Versions
  3. Find Objects with Most deadlocks
This is brilliant thank you. I'm formatting the Cluster_SqlServer_Error_Text column using string functions to extract the names. Once I've got something I'm happy with I'll post here. Hopefully oth...
0 votes
OK I took the results from the query above and put them into a temp table. Then I have put together a script that will group the locking by table and locking mode. This gives a good starting point to show the frequency of locks. The locking mode and locking level here is not complete, it only covers the types of locks I've got in my table. --set a start and end date to get number of locks within a date range DECLARE @DaysBaselineStart INT = 10 DECLARE @DaysBaselineEnd INT = 0 --only key and page locks are accounted for in the cte below --row locks are also possible, as are db and table locks --remember, row locks never happen on indexes and key locks never occur on heaps --there are also key range locks reported. This happens because transactions are serializable ; WITH keylock AS ( SELECT SUBSTRING(LT.Cluster_SqlServer_Error_Text, charindex('objectname=', LT.Cluster_SqlServer_Error_Text) + 11, charindex('.', LT.Cluster_SqlServer_Error_Text) - charindex('objectname=', LT.Cluster_SqlServer_Error_Text) - 11) AS [Database] ,SUBSTRING(LT.Cluster_SqlServer_Error_Text, charindex('objectname', LT.Cluster_SqlServer_Error_Text) + 11, charindex('indexname', LT.Cluster_SqlServer_Error_Text) - charindex('objectname', LT.Cluster_SqlServer_Error_Text) - 11) AS [LockedObject] ,SUBSTRING(LT.Cluster_SqlServer_Error_Text, charindex('indexname=', LT.Cluster_SqlServer_Error_Text) + 10, charindex(' id=', LT.Cluster_SqlServer_Error_Text) - charindex('indexname=', LT.Cluster_SqlServer_Error_Text) - 10) AS [LockedIndex] ,SUBSTRING(LT.Cluster_SqlServer_Error_Text, charindex(' mode=', LT.Cluster_SqlServer_Error_Text) + 6, charindex(' associatedObjectId', LT.Cluster_SqlServer_Error_Text) - charindex(' mode=', LT.Cluster_SqlServer_Error_Text) - 6) AS [LockType] ,LT.[CollectionDate_DateTime] AS [CollectionDate_DateTime] FROM #LockTable_2110 LT WHERE Cluster_SqlServer_Error_Text LIKE '%keylock%' ) ,pagelock AS ( SELECT SUBSTRING(LT.Cluster_SqlServer_Error_Text, charindex('objectname=', LT.Cluster_SqlServer_Error_Text) + 11, charindex('.', LT.Cluster_SqlServer_Error_Text) - charindex('objectname=', LT.Cluster_SqlServer_Error_Text) - 11) AS [Database] ,SUBSTRING(LT.Cluster_SqlServer_Error_Text, charindex('objectname', LT.Cluster_SqlServer_Error_Text) + 11, charindex(' id=', LT.Cluster_SqlServer_Error_Text) - charindex('objectname', LT.Cluster_SqlServer_Error_Text) - 11) AS [LockedObject] ,'No Index - page lock' AS [LockedIndex] ,SUBSTRING(LT.Cluster_SqlServer_Error_Text, charindex(' mode=', LT.Cluster_SqlServer_Error_Text) + 6, charindex(' associatedObjectId', LT.Cluster_SqlServer_Error_Text) - charindex(' mode=', LT.Cluster_SqlServer_Error_Text) - 6) AS [LockType] ,LT.[CollectionDate_DateTime] AS [CollectionDate_DateTime] FROM #LockTable_2110 LT WHERE Cluster_SqlServer_Error_Text LIKE '%pagelock%' ) SELECT K.[Database] ,K.[LockedObject] ,K.[LockedIndex] ,CASE K.[LockType] WHEN 'S' THEN 'SHARED' WHEN 'U' THEN 'UPDATE' WHEN 'IX' THEN 'INTENT EXCLUSIVE' WHEN 'X' THEN 'EXCLUSIVE' WHEN 'IS' THEN 'INTENT SHARED' WHEN 'SIX' THEN 'SHARED INTENT EXCLUSIVE' WHEN 'UIX' THEN 'UPDATE INTENT EXCLUSIVE' WHEN 'IU' THEN 'INTENT UPDATE' WHEN 'RangeS-U' THEN 'SERIALIZABLE UPDATE SCAN' WHEN 'RangeI-N' THEN 'INSERT RANGE, NULL RESOURCE LOCK' WHEN 'RangeX-X' THEN 'EXCLUSIVE RANGE, EXCLUSIVE RESOURCE LOCK' ELSE K.[LockType] END AS [LockType] ,COUNT(1) AS Recurrence FROM keylock K WHERE K.[CollectionDate_DateTime] > DATEADD(DAY, - @DaysBaselineStart, GETDATE()) AND K.[CollectionDate_DateTime] < DATEADD(DAY, - @DaysBaselineEnd, GETDATE()) GROUP BY [Database] ,[LockedObject] ,[LockedIndex] ,[LockType] UNION ALL SELECT P.[Database] ,P.[LockedObject] ,P.[LockedIndex] ,CASE P.[LockType] WHEN 'S' THEN 'SHARED' WHEN 'U' THEN 'UPDATE' WHEN 'IX' THEN 'INTENT EXCLUSIVE' WHEN 'X' THEN 'EXCLUSIVE' WHEN 'IS' THEN 'INTENT SHARED' WHEN 'SIX' THEN 'SHARED INTENT EXCLUSIVE' WHEN 'UIX' THEN 'UPDATE INTENT EXCLUSIVE' WHEN 'IU' THEN 'INTENT UPDATE' WHEN 'RangeS-U' THEN 'SERIALIZABLE UPDATE SCAN' WHEN 'RangeI-N' THEN 'INSERT RANGE, NULL RESOURCE LOCK' WHEN 'RangeX-X' THEN 'EXCLUSIVE RANGE, EXCLUSIVE RESOURCE LOCK' ELSE P.[LockType] END AS [LockType] ,COUNT(1) AS Recurrence FROM pagelock P WHERE P.[CollectionDate_DateTime] > DATEADD(DAY, - @DaysBaselineStart, GETDATE()) AND P.[CollectionDate_DateTime] < DATEADD(DAY, - @DaysBaselineEnd, GETDATE()) GROUP BY [Database] ,[LockedObject] ,[LockedIndex] ,[LockType] ORDER BY [Database] ,[LockedObject] ,[LockedIndex] ,[Recurrence] DESC / comments
  1. Community
  2. SQL Monitor Previous Versions
  3. Find Objects with Most deadlocks
OK I took the results from the query above and put them into a temp table. Then I have put together a script that will group the locking by table and locking mode. This gives a good starting point ...
0 votes
So it seems I was on the the right track: I had to ask the sysadmins to disable the security policy "System cryptography: Use FIPS compliant algorithms for encryption, hashing, and signing" (it is set to "disabled" by default, I have no idea why it was set to "enabled" by default across the whole domain.) I had to exit the installer and go through the process again, but this time it worked successfully. Lucky I was able to disable this feature! / comments
  1. Community
  2. SQL Monitor Previous Versions
  3. Error When Installing SQL Monitor 4
So it seems I was on the the right track: I had to ask the sysadmins to disable the security policy "System cryptography: Use FIPS compliant algorithms for encryption, hashing, and signing" (it is ...
0 votes
Brilliant thanks Petey. I thought this might be the case, but always best to check these things first, especially if you have no place to test this out first! / comments
  1. Community
  2. SQL Backup Previous Versions
  3. Redgate Backup and MS Log Shipping
Brilliant thanks Petey. I thought this might be the case, but always best to check these things first, especially if you have no place to test this out first!
0 votes
Total activity
14
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
4