Comments
Sort by recent activity
Hi Kevan
I have previously raised SRP-3078 after a similar request for an alert like this (except it was for log file usage rather than data file). I'll add this particular request to that.
I believe the data size is captured and can be seen in the Cluster_SqlServer_Database_Storage_StableSamples_View view.
Regards
Chris / comments
Hi Kevan
I have previously raised SRP-3078 after a similar request for an alert like this (except it was for log file usage rather than data file). I'll add this particular request to that.
I belie...
Hi Kevan
I've raised this as a bug (reference SRP-3140). We're probably more likely to fix the text than enhance the graph at this point in time. But we'll consider the potential enchancements to this graph for future releases.
Regards
Chris / comments
Hi Kevan
I've raised this as a bug (reference SRP-3140). We're probably more likely to fix the text than enhance the graph at this point in time. But we'll consider the potential enchancements to t...
Hi
Would it be possible to get some more information regarding your setup?
Browser being used and version number?
Are you using IIS or the XSP web server shipped with SQL Monitor?
If IIS then which version + general setup information (port, virtual directory etc).
Also it might be possible for us to diagnose the problems by reading through the error logs we create at C:\ProgramData\Red Gate\Logs\SQL Monitor 2 (on vista and newer OS). These files exist on both the web server and base monitor machines. Both could provide useful information. If you can zip up all the files and send them to chris.spencer@red-gate.com I could go through them.
Regards
Chris / comments
Hi
Would it be possible to get some more information regarding your setup?
Browser being used and version number?
Are you using IIS or the XSP web server shipped with SQL Monitor?
If IIS then which...
Hi
An enhancement request has been raised (ref SRP-3143). We'll investigate and see what options are open to us.
Thanks for the feedback.
Chris / comments
Hi
An enhancement request has been raised (ref SRP-3143). We'll investigate and see what options are open to us.
Thanks for the feedback.
Chris
Hi
We use the standard .NET regular expression library (System.Text.RegularExpressions I believe) to implement this functionality and we do validate the expressions entered to ensure they are well-formed. For example, entering [[ will display an error message 'Not a valid regular expression'.
Another option is to use free third-party RegEx creation/testing applications. http://www.ultrapico.com/Expresso.htm http://www.regexbuddy.com/
Does this sound adequate? If not then I will definitely raise an enhancement request.
Regards
Chris / comments
Hi
We use the standard .NET regular expression library (System.Text.RegularExpressions I believe) to implement this functionality and we do validate the expressions entered to ensure they are well-...
Hi Kenny
We haven't tested SQL Monitor with compression enabled so can't be 100% sure that there won't be any issues. However, I am currently rebuilding one of the larger tables on my local installation to use page compression and will let you know if there are any obvious issues.
I think that the table named data.Cluster_SqlServer_SqlProcess_UnstableSamples is a good candidate for compression. In my database it contains about 90% of the total data. Running sp_estimate_data_compression_savings for this table showed potential improvements of ~4% for row compression and ~12% for page.
An alternative is to set up a strict purge policy (especially for SQL Server data).
Regards
Chris / comments
Hi Kenny
We haven't tested SQL Monitor with compression enabled so can't be 100% sure that there won't be any issues. However, I am currently rebuilding one of the larger tables on my local install...
Chris Spencer wrote:
I've been running SQL Monitor for a while now after rebuilding the data.Cluster_SqlServer_SqlProcess_UnstableSamples table with page compression. The compression was about 12% as predicted by the sp_estimate_data_compression_savings stored proc.
By comparison SQL Storage Compress compressed the data files by ~90% (142GB reduced to just under 14GB).
SQL Monitor appears to be running fine on this compressed repository without (as far as I can see) any performance degradation. So this seems to be another very good option.
Regards
Chris / comments
Chris Spencer wrote:
I've been running SQL Monitor for a while now after rebuilding the data.Cluster_SqlServer_SqlProcess_UnstableSamples table with page compression. The compression was about 1...
I've been running SQL Monitor for a while now after rebuilding the data.Cluster_SqlServer_SqlProcess_UnstableSamples table with page compression. The compression was about 12% as predicted by the sp_estimate_data_compression_savings stored proc.
General issues:
It took 2 hours to rebuild a 90GB table
I needed about 90GB of free disk space for the rebuild to complete successfully
SQL Monitor specific:
My installation is monitoring the instance that hosts its data repository. This instance was reported as being offline until I restarted the SQL Monitor 2 Base Monitor service after the rebuild had completed (could well be a bug)
Otherwise everything seems to be working just fine.
Regards
Chris / comments
I've been running SQL Monitor for a while now after rebuilding the data.Cluster_SqlServer_SqlProcess_UnstableSamples table with page compression. The compression was about 12% as predicted by the s...
Hi Kevan
I've raised an enhancement request (ref: SRP-3090) for this. It would definitely help to have seconds here.
Thanks again
Chris / comments
Hi Kevan
I've raised an enhancement request (ref: SRP-3090) for this. It would definitely help to have seconds here.
Thanks again
Chris
Hi
I've raised 2 more enchancement requests to cover these.
Ref: SRP-3127 - Comment-clear checkbox
Ref: SRP-3128 - Add regular link to each alert row.
Thank you for the excellent feedback.
Regards
Chris / comments
Hi
I've raised 2 more enchancement requests to cover these.
Ref: SRP-3127 - Comment-clear checkbox
Ref: SRP-3128 - Add regular link to each alert row.
Thank you for the excellent feedback.
Regards
...