Comments
Sort by recent activity
I don't think that the space utilization is stored in the data repository as a distinct entry. I believe that it is calculated as needed using the 'current' _FreeBytes and the _TotalBytes values in the tables you have quoted. / comments
I don't think that the space utilization is stored in the data repository as a distinct entry. I believe that it is calculated as needed using the 'current' _FreeBytes and the _TotalBytes values i...
This document explains the Back-In-time feature https://documentation.red-gate.com/disp ... +Time+mode
This can be used in conjunction with generated alerts to view captured queries. / comments
This document explains the Back-In-time featurehttps://documentation.red-gate.com/disp ... +Time+mode
This can be used in conjunction with generated alerts to view captured queries.
Unfortunately it is not possible to exclude specific error id from this alert. However, if you are able change the severity level to be lower than the lower threshold then this would stop the alerts. Alternatively you can edit the thresholds to do the same thing. / comments
Unfortunately it is not possible to exclude specific error id from this alert. However, if you are able change the severity level to be lower than the lower threshold then this would stop the aler...
To restore any SQL Backup backup you must decompress and/or decrypt them. This requires the SQL Backup Server Components to work, and in turn the components need to be activated.
Unfortunately this cannot be worked around on a scheduled job. / comments
To restore any SQL Backup backup you must decompress and/or decrypt them. This requires the SQL Backup Server Components to work, and in turn the components need to be activated.
Unfortunately thi...
If you Select All then a green bar appears which gives you the option to "Select all alerts across all pages". You can then apply any changes to all the alerts. This should have been true in version 2.3 too. / comments
If you Select All then a green bar appears which gives you the option to "Select all alerts across all pages". You can then apply any changes to all the alerts. This should have been true in vers...
When you navigate to the website do things like the SQL Monitor title bar (with Overviews, Alerts etc) display? Or are you seeing the error message before this point?
Have the user account details changed at all? During installation you would have been asked to supply a user account to connect to the Base Monitor with.
If you navigate to Configuration > About and select Retrieve All Log Files, can you send the .zip to support@red-gate.com and quote the ticket number #13936 in the subject line. / comments
When you navigate to the website do things like the SQL Monitor title bar (with Overviews, Alerts etc) display? Or are you seeing the error message before this point?
Have the user account details...
Thank you for your reply.
Yes, this is as I thought it would be. The query that you have mentioned is one which performs processing on the collected data to enable to various features that use the data to make sense. As the collections are disabled, the query has no processing to perform and there is no data to display in the Top 10 waits etc.
The fact that the data collections themselves do not appear to be problematic but the subsequent processing appears to be leads me to suggest the following:
- leave the collections disabled. The features will therefore have no data to display, but the data repository host will not see the pressure on its resources.
- migrate the database to a machine with more resources available. This wouldn't change the usage, but would ensure that there are sufficient resources available to handle it.
I know that neither of these options are particularly great. However, the only other option would be to get a developer to change the frequency of the execution of the query you have quoted. However, this wouldn't affect the spikes, it would only affect the frequency of them.
I hope this makes sense. Please let me know if you have any questions. / comments
Thank you for your reply.
Yes, this is as I thought it would be. The query that you have mentioned is one which performs processing on the collected data to enable to various features that use the...
I have resent an email from a couple of days ago. Please let me know if you do not receive it. / comments
I have resent an email from a couple of days ago. Please let me know if you do not receive it.
To improve things you could try
(1) Rebuilding all indexes in the data.ClusterSqlServer_TopQueries* tables. Adding this to the maintenance plan is recommended.
(2) Reducing the purge window for top queries to as small a window as you are happy with. I'd suggest 3 days, personally. You can always gradually increase this later. / comments
To improve things you could try
(1) Rebuilding all indexes in the data.ClusterSqlServer_TopQueries* tables. Adding this to the maintenance plan is recommended.
(2) Reducing the purge window for top...
Please can you send the requested information, including the log files to support@red-gate.com unless you already have done so. / comments
Please can you send the requested information, including the log files to support@red-gate.com unless you already have done so.