it's worth to read although it's a long read

"Slow in the Application, Fast in SSMS?"

http://www.sommarskog.se/query-plan-mysteries.html

Regarding master db :   it has another compatibility level (130) than your db (110 =...

best approach is to  save it into local table

how to get the 5 minute data remotely :

the following...

Kaz hi!

Did you compare config files of SSRS2014 and SSRS2017? Memory settings and the rest?

Thanks - I've already done cross database (scoped credentials etc) querying. I tried that on master, but it doesn't work there - I may ahve got the credentials etc...

In case of SQL2016 read the following article

https://www.sqlrx.com/sql-2016-sp1-use-hint/

Also, take into account that the same behavior can be got using database scoped config changes instead of turning traceflags for the...

Browser is needed for port resolution of named instances. Kind of DNS for named SQLs.

Clients connect to default instances without contacting Browser first, assuming that the default instance is on...

I saw the same weird thing  too.

If i'm not mistaken in my case it was due to dbcc checkdb running in parallel which creates hidden snapshot of the database it...

• This reply was modified 5 years, 6 months ago by  Andrey.

LIKE

try this one:

SELECT r.[session_id]
,s.original_login_name
,c.[client_net_address]
,s.[host_name]
,c.[connect_time]
,r.blocking_session_id [blocking]
,s.[last_request_start_time] [request_start_time] 
,CURRENT_TIMESTAMP [current_time] 
,r.[percent_complete] [Done%]
,dateadd(millisecond, r.[estimated_completion_time], CURRENT_TIMESTAMP) [estimated_finish_time] 
,r.status
,current_command = SUBSTRING(t.[text], r.[statement_start_offset] / 2, COALESCE(NULLIF(r.[statement_end_offset], - 1) / 2, 2147483647))
,module = COALESCE(QUOTENAME(OBJECT_SCHEMA_NAME(t.[objectid],...

obviously, there is/are records without '}'  or  charindex('}', f.form_line1)-2 < 0

check the data or use...

I suspect this one:

https://www.brentozar.com/archive/2013/06/the-elephant-and-the-mouse-or-parameter-sniffing-in-sql-server/

If you  have 10,000, use sampling. If you know a representative set, use that, otherwise, grab 20-50 dbs, do the backups, and make an educated guess. I assume if...

SELECT Id, CONCAT_ws (',',VAL1,VAL2,VAL3,VAL4,VAL5,VAL6) 
FROM #MyTable

or

SELECT Id, (ISNULL(Val1+ ', ' , '') + ISNULL(Val2+ ', ', '')  + ISNULL(Val3+ ', ' , '')+ ISNULL(Val4+...

S  Maybe I can powershell out pids <> programs over the course of the night somehow.  Nothing relevant in task manager & it's not a SQL agent job or...

besides the real-time monitoring using dmv, there are two valuable sources of information:

1) msdb.dbo.backuphistory

https://www.mssqltips.com/sqlservertip/1601/script-to-retrieve-sql-server-database-backup-history-and-no-backups/

2) default trace and "backup/restore" event

https://www.sqlserver-dba.com/2012/07/sql-server-audit-backuprestore-event-with-sql-default-trace-.html

https://www.mssqltips.com/sqlservertip/3445/using-the-sql-server-default-trace-to-audit-events/