How can we help you today? How can we help you today?
benrees
Activity overview Badges (0) Posts (0) Comments (16)

Comments

Sort by recent activity
padda wrote: Hi, Is the hotfix for SQL Compare 9 in the pipeline for this afternoon too? I'm not using SQLAzureBackup. Just SQLCompare and SQLDataCompare. Thanks Hi there - I'm afraid the SQL Compare 9 fix won't be out today. Apologies for this, but we're working as quickly as we can to get this out for tomorrow. We'll keep you updated and get this out to you as soon as we can. Regards Ben Rees / comments
  1. Community
  2. SQL Compare Previous Versions
  3. SQL Azure support broke today?
padda wrote: Hi, Is the hotfix for SQL Compare 9 in the pipeline for this afternoon too? I'm not using SQLAzureBackup. Just SQLCompare and SQLDataCompare. Thanks Hi there - I'm afraid the SQL ...
0 votes
Thanks for your feedback. We’ve looked in to this and you can ignore the error (we’re going to fix the next version, so that we’re less zealous with error messages!). The IPN Service is part of the Check for Updates process, installed with Red Gate products, and helps ensure you have the latest releases and to keep your support and upgrades up-to-date (if relevant). Ben Rees Product Manager Red Gate Software / comments
  1. Community
  2. SQL Prompt Previous Versions
  3. Still getting thread aborted error in Event Log with 5.1
Thanks for your feedback. We’ve looked in to this and you can ignore the error (we’re going to fix the next version, so that we’re less zealous with error messages!). The IPN Service is part ...
0 votes
Hi there This is definitely something we're looking in to for the future, though not in the next release, I'm afraid. Thank you for your input. Regards Ben / comments
  1. Community
  2. SQL Monitor Previous Versions
  3. Enhancement: alert locked sql account
Hi there This is definitely something we're looking in to for the future, though not in the next release, I'm afraid. Thank you for your input. Regards Ben
0 votes
Hi Apologies that you've been having some problems with the monitoring stopping unexpectedly. We've had a few people mention how useful it would be if they were notified when monitoring stops, so we'll be putting out an early release (in the next few weeks) with the very alerts you mention. I.e. something which informs you when monitoring as stopped. Separately, if you get in touch with support, we can look in to the issue of why the monitoring has stopped in your environment. Hope this helps. Ben / comments
  1. Community
  2. SQL Monitor Previous Versions
  3. Monitoring Stopped - NOT INFORMED OF THIS
Hi Apologies that you've been having some problems with the monitoring stopping unexpectedly. We've had a few people mention how useful it would be if they were notified when monitoring stops, so w...
0 votes
Hi lehrsj24 Below is some code I've put together linking the Alerts VIEW [alert].[Alert_Current] and the Job History VIEW [data].[Cluster_SqlServer_Agent_Job_History_Instances_View]. I've put the most relevant info in the first few columns (alert ID, error message, date/time of alert), but have also included other columns in case you're interested in these. NB: I've put this together quite hastily - let me know if you have any problems with this code and I'll try to fix it! Hope this helps. Ben Rees SELECT AlertID , Cluster_SqlServer_Agent_Job_History_Message , DateTimeRaised , Id AS Job_History_Id , IdCollectionDate , Cluster_SqlServer_Agent_Job_History_RunDuration , Cluster_SqlServer_Agent_Job_History_RunStatus , Cluster_SqlServer_Agent_Job_History_SqlMessageId , Cluster_SqlServer_Agent_Job_History_SqlSeverity , CollectionDate , CollectionDate_DateTime , Cluster_Name , Cluster_SqlServer_Name , Cluster_SqlServer_Agent_Job_Id , Cluster_SqlServer_Agent_Job_History_Id , Cluster_SqlServer_Agent_Job_History_RunDate , Cluster_SqlServer_Agent_Job_History_RunDate_DateTime , AlertType , AlertDescription , AlertTicks FROM ( SELECT [Id] , [IdCollectionDate] , [Cluster_SqlServer_Agent_Job_History_Message] , [Cluster_SqlServer_Agent_Job_History_RunDuration] , [Cluster_SqlServer_Agent_Job_History_RunStatus] , [Cluster_SqlServer_Agent_Job_History_SqlMessageId] , [Cluster_SqlServer_Agent_Job_History_SqlSeverity] , [CollectionDate] , [CollectionDate_DateTime] , [Cluster_Name] , [Cluster_SqlServer_Name] , [Cluster_SqlServer_Agent_Job_Id] , [Cluster_SqlServer_Agent_Job_History_Id] , [Cluster_SqlServer_Agent_Job_History_RunDate] , [Cluster_SqlServer_Agent_Job_History_RunDate_DateTime] FROM [data].[Cluster_SqlServer_Agent_Job_History_Instances_View] ) AS jh INNER JOIN ( SELECT SUBSTRING(TargetObject, 21 + PATINDEX('%:%', SUBSTRING(TargetObject, 21, 4)), CAST(SUBSTRING(TargetObject, 21, PATINDEX('%:%', SUBSTRING(TargetObject, 21, 4)) - 1) AS INT)) AS ClusterName , CASE WHEN PATINDEX('%7:Machine,1,4:Name%', TargetObject) > 0 THEN SUBSTRING(TargetObject, PATINDEX('%7:Machine,1,4:Name%', TargetObject) + 20 + PATINDEX('%:%', SUBSTRING(TargetObject, PATINDEX('%7:Machine,1,4:Name%', TargetObject) + 20, 4)), CAST(SUBSTRING(TargetObject, PATINDEX('%7:Machine,1,4:Name%', TargetObject) + 20, PATINDEX('%:%', SUBSTRING(TargetObject, PATINDEX('%7:Machine,1,4:Name%', TargetObject) + 20, 4)) - 1) AS INT)) ELSE '' END AS MachineName , CASE WHEN PATINDEX('%9:SqlServer,1,4:Name%', TargetObject) > 0 THEN SUBSTRING(TargetObject, PATINDEX('%9:SqlServer,1,4:Name%', TargetObject) + 22 + PATINDEX('%:%', SUBSTRING(TargetObject, PATINDEX('%9:SqlServer,1,4:Name%', TargetObject) + 22, 4)), CAST(SUBSTRING(TargetObject, PATINDEX('%9:SqlServer,1,4:Name%', TargetObject) + 22, PATINDEX('%:%', SUBSTRING(TargetObject, PATINDEX('%9:SqlServer,1,4:Name%', TargetObject) + 22, 4)) - 1) AS INT)) ELSE '' END AS SQLServerName , at.Name AS AlertType , at.Description AS AlertDescription , [utils].[TicksToDateTime](ai.Raised) AS DateTimeRaised , ai.Raised AS AlertTicks , ai.AlertId AS AlertID FROM alert.Alert_Current AS ai INNER JOIN alert.Alert_Type AS at ON ai.AlertType = at.AlertType ) AS ad ON ad.ClusterName = jh.Cluster_Name AND ad.SQLServerName = jh.Cluster_SqlServer_Name WHERE ad.AlertType = 'Job failed' AND AlertTicks = Cluster_SqlServer_Agent_Job_History_RunDate ORDER BY ad.DateTimeRaised DESC / comments
  1. Community
  2. SQL Monitor Previous Versions
  3. Data dictionary?
Hi lehrsj24 Below is some code I've put together linking the Alerts VIEW [alert].[Alert_Current] and the Job History VIEW [data].[Cluster_SqlServer_Agent_Job_History_Instances_View]. I've put the m...
0 votes
Hi there We have put in a number of VIEWs which should, hopefully, help you create reports or queries for the sort of data you’re looking for. The most interesting VIEWs can be found under [data].xxxxx_View. A lot of these should be self-explanatory. For example, looking at the information that you mention: Monitored Servers with OS info etc This can be found in the view [data].[Cluster_SqlServer_Properties_StableSamples_View] Mem Disk Space Memory values can be found in [data].[Cluster_Machine_Memory_UnstableSamples_View] Disk space can be found in [data].[Cluster_Machine_LogicalDisk_UnstableSamples_View] Databases Lists of databases can be found in [data].[Cluster_SqlServer_Database_StableSamples_View] though this needs to be grouped (there is more than one row per database as this table also includes some availability information.) Database Size This can be found in [data].[Cluster_SqlServer_Database_Storage_UnstableSamples_View] NB: There’s also a couple of functions to convert between Ticks (as used in many views and tables) and proper date times, [utils].[DateTimeToTicks] and [utils].[TicksToDateTime] Hope that helps! Ben / comments
  1. Community
  2. SQL Monitor Previous Versions
  3. Data dictionary?
Hi there We have put in a number of VIEWs which should, hopefully, help you create reports or queries for the sort of data you’re looking for. The most interesting VIEWs can be found under [data]...
0 votes
Hi there I'm taking a look at this request, though I'm afraid it's not as trivial as some other possible reports! I'll post back as soon as I've put some T-SQL together.. Apologies for the delay. Regards Ben / comments
  1. Community
  2. SQL Monitor Previous Versions
  3. Data dictionary?
Hi there I'm taking a look at this request, though I'm afraid it's not as trivial as some other possible reports! I'll post back as soon as I've put some T-SQL together.. Apologies for the delay. R...
0 votes
Hi Lehrsj24 We're going to provide some sample SSRS reports soon, to help people get started, but you're right - though some of the schema is obvious, not all of it is. NB: We've added a number of VIEWs to make some of the obvious joins so that you don't have to (for example, joining various data tables to the server reference tables). I'll add a data dictionary to the plans - are there any particular pieces of data you were after in the mean time? Ben / comments
  1. Community
  2. SQL Monitor Previous Versions
  3. Data dictionary?
Hi Lehrsj24 We're going to provide some sample SSRS reports soon, to help people get started, but you're right - though some of the schema is obvious, not all of it is. NB: We've added a number of ...
0 votes
Hi Linque I've not used an iPad much, but if it's the same as my iPhone, you can use two fingers to scroll the descriptive text on the right hand side. I.e. if you try to scroll the page upwards, but hold two fingers side-by-side on the description when scrolling, this should move this part only. Hope that works! Ben / comments
  1. Community
  2. SQL Monitor Previous Versions
  3. Need Monitoring Software ASAP, but 2.1 Will Not Cut It
Hi Linque I've not used an iPad much, but if it's the same as my iPhone, you can use two fingers to scroll the descriptive text on the right hand side. I.e. if you try to scroll the page upwards, b...
0 votes
Thanks for your response, and we appreciate the feedback - as with the original 2.0 project, what goes in to the product is driven by the DBAs out there, so this is really useful to help us drive the next release. And glad that you generally like the product - were there any areas in particular that you found particularly useful? That we can build upon? / comments
  1. Community
  2. SQL Monitor Previous Versions
  3. Need Monitoring Software ASAP, but 2.1 Will Not Cut It
Thanks for your response, and we appreciate the feedback - as with the original 2.0 project, what goes in to the product is driven by the DBAs out there, so this is really useful to help us drive t...
0 votes
Total activity
25
Last activity
Member since
Following
0 users
Followed by
0 users
Votes
0
Subscriptions
9