Comments
Sort by recent activity
Hi, We have upgraded to 13.0.39.27122 and seeing the same issue: [image] [image] [image] However, the server has no log shipping databases. I will wait for the expected release to see if that helps / comments
Hi,We have upgraded to 13.0.39.27122 and seeing the same issue:However, the server has no log shipping databases.I will wait for the expected release to see if that helps
I have worked it out, I think. For each entry in the sub list (31 entries) the query is part of a different batch / comments
I have worked it out, I think. For each entry in the sub list (31 entries) the query is part of a different batch
Hi, We are on 13.0.25.22151 and are seeing the same issue periodically: [image] [image] sp_whoisactive: [image] / comments
Hi,We are on 13.0.25.22151 and are seeing the same issue periodically:sp_whoisactive:
Hi Ben, I just ran the AdventureWorks example in management studio to demonstrate that sys.dm_exec_sql_text returns the most recent command in the session, regardless of whether that was the long running command or not What is populating the SQL Process Fragment section please? / comments
Hi Ben,I just ran the AdventureWorks example in management studio to demonstrate that sys.dm_exec_sql_text returns the most recent command in the session, regardless of whether that was the long ru...
I came to ask the exact same question and found your post after a quick browse of the forum. I agree - it would be useful to be able to see a top <n> queries by server by avg/total time / CPU time / reads etc. I have upvoted your suggestion on UserVoice and added a comment / comments
I came to ask the exact same question and found your post after a quick browse of the forum.I agree - it would be useful to be able to see a top <n> queries by server by avg/total time / CPU time /...
HI, That is slightly more restricted but they can still see the overview, analysis and estate pages which I would like to restrict / comments
HI,That is slightly more restricted but they can still see the overview, analysis and estate pages which I would like to restrict
Hi Ben, Thanks for this. Seems a shame to have a duplicate something that is already being captured but it will do what I need Steve / comments
Hi Ben,Thanks for this. Seems a shame to have a duplicate something that is already being captured but it will do what I needSteve
Thanks Alex, I have raised the suggestion https://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/46205350-make-source-hyperlink-in-alert-take-you-to-the-s / comments
Thanks Alex,I have raised the suggestionhttps://sqlmonitor.uservoice.com/forums/91743-suggestions/suggestions/46205350-make-source-hyperlink-in-alert-take-you-to-the-s
Thanks Alex, I wasn't aware of the uservoice page and have now raised a suggestion there Thanks Steve / comments
Thanks Alex,I wasn't aware of the uservoice page and have now raised a suggestion thereThanksSteve
FWIW, I have this in place which seems to be working well: ^BACKUP DATABASE ^BACKUP LOG ^RESTORE DATABASE ^RESTORE LOG DBCC CHECKDB / comments
FWIW, I have this in place which seems to be working well:^BACKUP DATABASE^BACKUP LOG^RESTORE DATABASE^RESTORE LOGDBCC CHECKDB