Activity overview
Latest activity by camaro322hp
Same here. Can confirm that multiple server connections seem to trigger this. My workaround is closing the SQL Search window and re-opening it, and then it will have search results.
SQL Search 2.4.0.1203
SSMS 13.0.16106.4
/ comments
Same here. Can confirm that multiple server connections seem to trigger this. My workaround is closing the SQL Search window and re-opening it, and then it will have search results.
SQL Search 2.4...
Thanks Adam - I placed my vote for that. I see that the suggestion is over 3 years old and has 39 votes now. Realistically, what are the odds this ever gets added?
Also, any input as to my other issue - getting long running query alerts for queries that run less than my threshold? It's happened multiple times now. / comments
Thanks Adam - I placed my vote for that. I see that the suggestion is over 3 years old and has 39 votes now. Realistically, what are the odds this ever gets added?
Also, any input as to my other ...
Well, it's getting worse. Is there a known bug with the long-running query alert? I have this alert set at the 'All Servers' level to trigger after 20 seconds. No levels below 'All Servers' have been configured to be anything different. Every so often, I'll get a couple long-running query emails that definitely don't meet the 20 second threshold. I just got a couple that were 6 seconds and 0 seconds. What is going on here? / comments
Well, it's getting worse. Is there a known bug with the long-running query alert? I have this alert set at the 'All Servers' level to trigger after 20 seconds. No levels below 'All Servers' have...
Another update - it looks like there are some that I really need to be able to exclude at the login or user level, unless I spend the time to put in every stored procedure called by a specific login which is less than ideal.
Is there some way to exclude by user or login? / comments
Another update - it looks like there are some that I really need to be able to exclude at the login or user level, unless I spend the time to put in every stored procedure called by a specific logi...
Looking at this more, I may be able to accomplish this using the Process Name exclusions. Would be easier if there was a User or Login exclusion also. / comments
Looking at this more, I may be able to accomplish this using the Process Name exclusions. Would be easier if there was a User or Login exclusion also.
Long-running query alert
Hello. I'm a new user to SQL Monitor - trying to replace all my cobbled together home-grown monitoring tools I've made over the last few years.
One thing I depend on a lot is a trace that is const...
Thanks Stephanie. I do have Data Compare and can use that for the time being. I just thought I'd mention it in case it was supposed to be working now, to let you know it wasn't. Thanks for the reply. I do hope this is being considered for the final release. / comments
Thanks Stephanie. I do have Data Compare and can use that for the time being. I just thought I'd mention it in case it was supposed to be working now, to let you know it wasn't. Thanks for the r...
Stephanie - It appears that the "Undo Changes" functionality does not recognize data changes to the tables with source controlled data. It appears to only recognize schema changes. / comments
Stephanie - It appears that the "Undo Changes" functionality does not recognize data changes to the tables with source controlled data. It appears to only recognize schema changes.
Yes, thank you for this. I have installed and already run it through some paces. It seems to be working well so far. The only thing I noticed is that when you have data in source control, and you get latest from that to a blank database, the first get latest only gets the schema, not the data. If you get latest a second time, then you will get the data. Not sure if this is by design or not. Subsequent get latest requests will get both schema and data changes.
This will make our DB source control much easier. Looking forward to the final release of this. / comments
Yes, thank you for this. I have installed and already run it through some paces. It seems to be working well so far. The only thing I noticed is that when you have data in source control, and yo...