Activity overview
Latest activity by SEarle86
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
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:
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
Queries in Top Queries by Total split into separate items
What is the difference between these queries in the Top Queries section ordered by total in the Server Overview page?
The top two have executed millions of times in the selected time period and ha...
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...
Text in Long Running Query Alert - Last statement to run?
I have a long running query alert telling me a query has run for 3675 seconds:However, when I find the query in the Server overview, I find that the query only took 67 seconds, and query store seem...
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 /...
Unexpected Databases showing in tempdb version store graph
I am seeing some unexpected databases showing in the tempdb version store graph on the server overview page:We can see msdb, and some user databases I have named T1, T2, B1, B2 and B3, are all usin...
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
Report Access
Hi,Is is possible to grant access to just the reports page and just a given number of reports?We have some users who I would like to be able to see a report in real time (rather than just on the Em...