How can we help you today? How can we help you today?
PeterDanielsCRB
Activity overview Badges (0) Posts (40) Comments (85)

Comments

Sort by recent activity
I'm rather confused about that last post, @Russell D . / comments
  1. Community
  2. Redgate Monitor
  3. "Unauthorized" when attempting to add a VMWarte host to SQL Monitor
I'm rather confused about that last post, @Russell D .
0 votes
The answer to this is that we needed to use the top-level vCenter host name/IP itself, not the host name/IP of the individual VMWare hosts (that house guest VMs) within vCenter. / comments
  1. Community
  2. Redgate Monitor
  3. "Unauthorized" when attempting to add a VMWarte host to SQL Monitor
The answer to this is that we needed to use the top-level vCenter host name/IP itself, not the host name/IP of the individual VMWare hosts (that house guest VMs) within vCenter.
0 votes
Apologies for the delay in my response, @Russell D.  I DL'd the log files zip from the Configuration page.  I'm a hesitant to post them here.  Can you verify that it's safe?  If not, shall we open a support case? / comments
  1. Community
  2. Redgate Monitor
  3. "Unauthorized" when attempting to add a VMWarte host to SQL Monitor
Apologies for the delay in my response, @Russell D.  I DL'd the log files zip from the Configuration page.  I'm a hesitant to post them here.  Can you verify that it's safe?  If not, shall we open ...
0 votes
No worries, @Russell D.  I've been bouncing around with other projects.  I'll send the logs to support. / comments
  1. Community
  2. Redgate Monitor
  3. "Unauthorized" when attempting to add a VMWarte host to SQL Monitor
No worries, @Russell D.  I've been bouncing around with other projects.  I'll send the logs to support.
0 votes
Oddly, when I go to the Redgate User Voice page, there is no category for SQL Monitor. https://redgate.uservoice.com/forums/602209-redgate / comments
  1. Community
  2. Redgate Monitor
  3. Change schedule for fragmented indexes check for single SQL Server instance?
Oddly, when I go to the Redgate User Voice page, there is no category for SQL Monitor.https://redgate.uservoice.com/forums/602209-redgate
0 votes
Thanks, @Russell D.  Unfortunately, we run index re-orgs and rebuilds on different nights for different servers (same as when full backups run).  If I move it for one server, the next one will probably bubble up.  It would be nice if we could change this setting at a per-instance grain. / comments
  1. Community
  2. Redgate Monitor
  3. Change schedule for fragmented indexes check for single SQL Server instance?
Thanks, @Russell D.  Unfortunately, we run index re-orgs and rebuilds on different nights for different servers (same as when full backups run).  If I move it for one server, the next one will prob...
0 votes
Thanks, @Russell D.  That makes sense to me, even if it's not the answer I wanted.  I'd still like a way to get around that and see various "instances" of the query execution like I can in SQL Sentry.  Every time I feel the need to set up an XE trace to get to the details I need for RCA, I wonder if SQL Monitor is just missing some functionality.  Perhaps I am expecting too much.  How do you recommend I dive deeper when I want to correlate what I'm seeing in SQL Monitor with actual query events? / comments
  1. Community
  2. Redgate Monitor
  3. For TOP 10 Queries, where can we find the host and SPID/session_id of the connection?
Thanks, @Russell D.  That makes sense to me, even if it's not the answer I wanted.  I'd still like a way to get around that and see various "instances" of the query execution like I can in SQL Sent...
0 votes
Thanks, @Ivo_Miller and @Nick_Foster.  I think between these options, I've got enough to move forward. / comments
  1. Community
  2. SQL Change Automation
  3. Why are all programmable objects deploying (deploy) to a target DB that is already baselined?
Thanks, @Ivo_Miller and @Nick_Foster.  I think between these options, I've got enough to move forward.
0 votes
FWIW, I made a powershell function to copy the SCA meta objects + __MigrationLog data to a target DB.  It relies on the dbatools module. <div>function&nbsp;Copy-ScaMigrationLog&nbsp;{</div><div>&nbsp;&nbsp;&nbsp;&nbsp;[CmdletBinding()]</div><div>&nbsp;&nbsp;&nbsp;&nbsp;param&nbsp;(</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;#&nbsp;Parameter&nbsp;help&nbsp;description</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[Parameter()]</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[string]</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$SourceSqlInstance&nbsp;=&nbsp;'localhost'</div><br><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;,#&nbsp;Parameter&nbsp;help&nbsp;description</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[Parameter(Mandatory=$true)]</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[string]</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$SourceDatabase&nbsp;</div><br><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;,#&nbsp;Parameter&nbsp;help&nbsp;description</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[Parameter(Mandatory=$true)]</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[string]</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$TargetSqlInstance&nbsp;</div><br><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;,#&nbsp;Parameter&nbsp;help&nbsp;description</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[Parameter(Mandatory=$true)]</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;[string]</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$TargetDatabase&nbsp;</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;)</div><div>&nbsp;&nbsp;&nbsp;&nbsp;</div><div>&nbsp;&nbsp;&nbsp;&nbsp;begin&nbsp;{</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</div><div>&nbsp;&nbsp;&nbsp;&nbsp;}</div><div>&nbsp;&nbsp;&nbsp;&nbsp;</div><div>&nbsp;&nbsp;&nbsp;&nbsp;process&nbsp;{</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;#&nbsp;Get&nbsp;the&nbsp;migration&nbsp;log&nbsp;tables&nbsp;and&nbsp;views&nbsp;from&nbsp;the&nbsp;src&nbsp;DB&nbsp;and&nbsp;copy&nbsp;them&nbsp;to&nbsp;the&nbsp;target&nbsp;DB</div><br><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;#&nbsp;First,&nbsp;make&nbsp;sure&nbsp;we&nbsp;don't&nbsp;already&nbsp;have&nbsp;the&nbsp;object&nbsp;in&nbsp;the&nbsp;target&nbsp;DB</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$Table&nbsp;=&nbsp;Get-DbaDbTable&nbsp;-SqlInstance&nbsp;$TargetSqlInstance&nbsp;-Database&nbsp;$TargetDatabase&nbsp;-Table&nbsp;'dbo.__MigrationLog'</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;if&nbsp;($Table)&nbsp;{</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Write-Error&nbsp;-Message&nbsp;'dbo.__MigrationLog&nbsp;already&nbsp;exists.&nbsp;&nbsp;Aborting.'</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;return&nbsp;#TODO:&nbsp;Return?</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;}</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;#&nbsp;Copy-DbaDbTableData&nbsp;does&nbsp;not&nbsp;get&nbsp;anything&nbsp;but&nbsp;the&nbsp;base&nbsp;table&nbsp;DDL&nbsp;-&nbsp;no&nbsp;PK,&nbsp;no&nbsp;defaults,&nbsp;no&nbsp;extended&nbsp;properties,&nbsp;etc.</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;#&nbsp;And&nbsp;it&nbsp;has&nbsp;no&nbsp;ScriptingOptions&nbsp;parm.</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;#Copy-DbaDbTableData&nbsp;-SqlInstance&nbsp;$SourceSqlInstance&nbsp;-Database&nbsp;$SourceDatabase&nbsp;-Destination&nbsp;localhost&nbsp;-DestinationDatabase&nbsp;test&nbsp;-Table&nbsp;'dbo.__MigrationLog'&nbsp;-AutoCreateTable</div><br><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$ScriptingOptions&nbsp;=&nbsp;New-DbaScriptingOption</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$ScriptingOptions.DriAll&nbsp;=&nbsp;$true</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$ScriptingOptions.Indexes&nbsp;=&nbsp;$true</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$ScriptingOptions.ExtendedProperties&nbsp;=&nbsp;$true</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$ScriptingOptions.ScriptBatchTerminator&nbsp;=&nbsp;$true</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$ScriptingOptions.NoCommandTerminator&nbsp;=&nbsp;$false&nbsp;#&nbsp;I&nbsp;think&nbsp;we&nbsp;need&nbsp;this&nbsp;for&nbsp;views&nbsp;-&nbsp;nope&nbsp;-&nbsp;fail.&nbsp;Still&nbsp;not&nbsp;getting&nbsp;the&nbsp;GOs&nbsp;that&nbsp;we&nbsp;need.</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;#&nbsp;TODO:&nbsp;parm:</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;#&nbsp;$ScriptingOptions.TargetDatabaseEngineEdition&nbsp;=&nbsp;'Standard'</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;#&nbsp;$ScriptingOptions.TargetServerVersion&nbsp;=&nbsp;'Version100'</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$ScriptingOptions.EnforceScriptingOptions&nbsp;=&nbsp;$true</div><br><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$tables&nbsp;=&nbsp;@('dbo.__MigrationLog',&nbsp;'dbo.__SchemaSnapshot')</div><br><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;#&nbsp;Let's&nbsp;try&nbsp;to&nbsp;just&nbsp;script&nbsp;the&nbsp;DDL&nbsp;from&nbsp;the&nbsp;table&nbsp;object</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;#&nbsp;Yes,&nbsp;this&nbsp;works.</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$SQLDDL&nbsp;=&nbsp;[string](Get-DbaDbTable&nbsp;-SqlInstance&nbsp;$SourceSqlInstance&nbsp;-Database&nbsp;$SourceDatabase&nbsp;-Table&nbsp;$tables).Script($ScriptingOptions)&nbsp;</div><br><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;#&nbsp;$Table&nbsp;=&nbsp;Get-DbaDbTable&nbsp;-SqlInstance&nbsp;$SourceSqlInstance&nbsp;-Database&nbsp;$SourceDatabase&nbsp;-Table&nbsp;'dbo.__MigrationLog'</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;#&nbsp;$Table.Script($ScriptingOptions)</div><br><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;#&nbsp;This&nbsp;works,&nbsp;too&nbsp;-&nbsp;needed&nbsp;to&nbsp;convert&nbsp;the&nbsp;output&nbsp;to&nbsp;a&nbsp;string.&nbsp;&nbsp;Seems&nbsp;hack-ish,&nbsp;tho.</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;#&nbsp;[string]$SQLDDL&nbsp;=&nbsp;[string](Get-DbaDbTable&nbsp;-SqlInstance&nbsp;$SourceSqlInstance&nbsp;-Database&nbsp;$SourceDatabase&nbsp;-Table&nbsp;$tables&nbsp;|</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;#&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Export-DbaScript&nbsp;-Passthru&nbsp;-ScriptingOptionsObject&nbsp;$ScriptingOptions)</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Invoke-DbaQuery&nbsp;-SqlInstance&nbsp;$TargetSqlInstance&nbsp;-Database&nbsp;$TargetDatabase&nbsp;-Query&nbsp;$SQLDDL</div><br><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;#&nbsp;Copy&nbsp;the&nbsp;data&nbsp;over</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Copy-DbaDbTableData&nbsp;-SqlInstance&nbsp;$SourceSqlInstance&nbsp;-Database&nbsp;$SourceDatabase&nbsp;-Destination&nbsp;$TargetSqlInstance&nbsp;-DestinationDatabase&nbsp;$TargetDatabase&nbsp;-Table&nbsp;'dbo.__MigrationLog'&nbsp;-KeepNulls</div><br><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;#&nbsp;now&nbsp;we&nbsp;need&nbsp;to&nbsp;get&nbsp;the&nbsp;view</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$SQLDDL&nbsp;=&nbsp;[string](Get-Dbadbview&nbsp;-sqlinstance&nbsp;$SourceSqlInstance&nbsp;-Database&nbsp;$SourceDatabase&nbsp;|&nbsp;Where-object&nbsp;Name&nbsp;-eq&nbsp;'__MigrationLogCurrent').Script($ScriptingOptions)</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;#&nbsp;TODO:&nbsp;This&nbsp;is&nbsp;a&nbsp;hack&nbsp;-&nbsp;due&nbsp;to&nbsp;no&nbsp;GO&nbsp;or&nbsp;statement&nbsp;terminator&nbsp;after&nbsp;the&nbsp;SET&nbsp;statements.&nbsp;&nbsp;Sigh.</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;#&nbsp;OK&nbsp;-&nbsp;add&nbsp;my&nbsp;own&nbsp;GOs</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$SQLDDL&nbsp;=&nbsp;$SQLDDL.Replace('CREATE&nbsp;VIEW&nbsp;',&nbsp;"`r`nGO`r`nCREATE&nbsp;VIEW&nbsp;")</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$SQLDDL&nbsp;=&nbsp;$SQLDDL.Replace('EXEC&nbsp;sys.sp_addextendedproperty&nbsp;',&nbsp;"`r`nGO`r`nEXEC&nbsp;sys.sp_addextendedproperty&nbsp;")</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Invoke-DbaQuery&nbsp;-SqlInstance&nbsp;$TargetSqlInstance&nbsp;-Database&nbsp;$TargetDatabase&nbsp;-Query&nbsp;$SQLDDL</div><br><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;#&nbsp;Now&nbsp;we&nbsp;just&nbsp;need&nbsp;to&nbsp;delete&nbsp;the&nbsp;rows&nbsp;for&nbsp;our&nbsp;migrations&nbsp;(after&nbsp;the&nbsp;baseline)&nbsp;and&nbsp;the&nbsp;progr.&nbsp;objects&nbsp;we&nbsp;want&nbsp;to&nbsp;deploy.</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;#&nbsp;TODO:&nbsp;This&nbsp;should&nbsp;be&nbsp;parameterized.</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;#&nbsp;ReplaceExpressionsInFileAndFolderNames</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;#&nbsp;GenerateExpressionReplacementSQL</div><br><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;$SQL&nbsp;=&nbsp;"</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;DELETE&nbsp;&nbsp;dbo.__MigrationLog</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;WHERE</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;script_filename&nbsp;LIKE&nbsp;'Migrations\1.1.0-Changes\%'</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Invoke-DbaQuery&nbsp;-SqlInstance&nbsp;$TargetSqlInstance&nbsp;-Database&nbsp;$TargetDatabase&nbsp;-Query&nbsp;$SQL</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</div><div>&nbsp;&nbsp;&nbsp;&nbsp;}</div><div>&nbsp;&nbsp;&nbsp;&nbsp;</div><div>&nbsp;&nbsp;&nbsp;&nbsp;end&nbsp;{</div><div>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</div><div>&nbsp;&nbsp;&nbsp;&nbsp;}</div><div>}</div> / comments
  1. Community
  2. SQL Change Automation
  3. Why are all programmable objects deploying (deploy) to a target DB that is already baselined?
FWIW, I made a powershell function to copy the SCA meta objects + __MigrationLog data to a target DB.  It relies on the dbatools module. <div>function&nbsp;Copy-ScaMigrationLog&nbsp;{</div><div>&n...
0 votes
Apologies for my difficulty in getting the whole code block to format correctly. / comments
  1. Community
  2. SQL Change Automation
  3. Why are all programmable objects deploying (deploy) to a target DB that is already baselined?
Apologies for my difficulty in getting the whole code block to format correctly.
0 votes
Total activity
162
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
37