Comments
Sort by recent activity
Also, WOW! Those code samples, pasted in using the "Code" format, are really totally displayed wrong! / comments
Also, WOW! Those code samples, pasted in using the "Code" format, are really totally displayed wrong!
Last information I have on this is that there will be a printed edition that will be given out for free at conferences and that will also be for sale through various channels. However that information is from when we just started working on the book. As Grant already said, a lot of time has passed. The world has changed, perhaps the plans have as well. Grant or perhaps Tony might know more. Cheers Hugo (Technical editor for the book, and at least as excited and proud as Grant is!)
/ comments
Last information I have on this is that there will be a printed edition that will be given out for free at conferences and that will also be for sale through various channels.However that informati...
Thanks for the reply, Alex! I'll look into the code sample in the linked post when I'm in the office tomorrow. I have already followed your suggestion to post to Uservoice: https://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/34256914-customize-disk-space-alert-for-c-drive-on-all-ser
/ comments
Thanks for the reply, Alex!I'll look into the code sample in the linked post when I'm in the office tomorrow.I have already followed your suggestion to post to Uservoice: https://sqlmonitor.uservoi...
Thanks for the reply, Russell! Unfortunately, the PurgeSettings table for this customer is totally empty, which I assume is how you store "use factury default settings". And I obviously cannot add a row to it. [image] I'll probably have to do some manual purging. Can you point me to some tables that I can safely trim down a bit? The reason this customer decided to use Express edition is the phrasing on this page: https://documentation.red-gate.com/sm7/getting-started/requirements/hardware-and-performance-guidelines - I now found other pages where you are more explicit about not using Express but this page can defintely be interpreted as "you can use it, just purge a bit more agressive". (They are monitoring 11 instances across 9 servers). I'll talk to them about upgrading the instance to Standard Edition but my first priority now is to remove some data, restart the service. change the data purge settings, and then ensure that everything is working as it should once more. After that I'll try to find business cases for moving back to longer data retention. / comments
Thanks for the reply, Russell!Unfortunately, the PurgeSettings table for this customer is totally empty, which I assume is how you store "use factury default settings". And I obviously cannot add a...
I managed to get this solved myself. I noticed that there were windows of time where monitoring would temporarily resume so I figured that it does still purge data and then re-fill the free space. So I kept trying until today I managed to sneak in an update of the purge settings without getting an error. / comments
I managed to get this solved myself. I noticed that there were windows of time where monitoring would temporarily resume so I figured that it does still purge data and then re-fill the free space. ...
Hi Krzysztof,
After reading your message I tried if I can still reproduce it. I re-enabled the option to add a closing single-quote mark and tried what happens. And it does work as intended (and as it did previously) for me.
So I don't know if this wa a one-time thing, or if it is a sporadic on-and-off thing. I'll leave the option on and I'll let you know if it returns.
I don't know which logs I should check for this or where to find them. The only other SSMS extension I have is the SQL Sentry Plan Explorer plug-in, and I've been using that "forever".
Thanks for your reply. For now, you can probably consider this as fixed.
Cheers,
Hugo / comments
Hi Krzysztof,
After reading your message I tried if I can still reproduce it. I re-enabled the option to add a closing single-quote mark and tried what happens. And it does work as intended (and as...
Closing this because the error went away all by itself.
Thanks for looking into it! / comments
Closing this because the error went away all by itself.
Thanks for looking into it!
No problem, just let me know what you're thinking and I'll tell you how I read the message. / comments
No problem, just let me know what you're thinking and I'll tell you how I read the message.
Worked like a charm, Pete. Thanks for the quick response! / comments
Worked like a charm, Pete. Thanks for the quick response!
Hi James,
Thanks for looking into this. I am waiting for a vendor to come back to me with some quotes on replacement laptops so I will not be upgrading any software on this old wreck - but I will definitely jump to the newest versions once I get my new power-beast!
The issue with the reformatted SQL is that the list of colours in the IN list is syntactical incorrect, these are values and need to remain enclosed within [brackets]. Submitting the reformatted code will produce an error message.
EDIT to add: I know that changing the option fixes this, but regardless of the option the tool should never remove brackets that are non-optional.
Best,
Hugo / comments
Hi James,
Thanks for looking into this. I am waiting for a vendor to come back to me with some quotes on replacement laptops so I will not be upgrading any software on this old wreck - but I will d...