This article may help you : https://docs.microsoft.com/en-us/troubleshoot/sql/availability-groups/query-performance-degradation

and this as well : https://www.sqlshack.com/isolation-levels-behavior-in-sql-server-always-on-availability-groups/

Hi,

Use a return value in your stored procedure , 0 for success and 1 for failure for example:

create procedure bla

as

select 1/0

if @@error <> 0

return 1

return 0

In your job...

See if this helps https://www.mssqltips.com/sqlservertip/1819/using-change-tracking-in-sql-server-2008/

Then run exec sp_lock @@SPID where @@SPID is the session id from where you create the index and see what is locking ..

1) Is there any trigger on that table ?

2) You must ensure your database have enough space to perform the online index operation, as it requires about 1.5 times the...

Hi there,

When it comes to near the end of the process, it will acquire a schema modification lock.. for a period in order to actually add the index to...

1 ) You might be able to see who was starting the trace in SQL Server Log ...

2 ) What is running : open the trace file or just...

hi,

But if you update the statistics with fullscan you will get the correct estimation , correct ?

-- R

Try this:

Select * from sys.traces;

EXEC sp_trace_setstatus @traceid, 0 -- stops the trace

EXEC sp_trace_setstatus @traceid, 2 -- closes the trace

Cheers,

Robert

Hi,

There is a nice article here : http://www.sqlpassion.at/archive/2014/02/18/improving-sql-server-performance-by-using-instant-file-initialization/

Cheers,

Robert

Hi,

Try to manually copy the snapshot folder to Subscriber , this may help:

https://blogs.msdn.microsoft.com/repltalk/2010/03/07/tips-to-improve-performance-when-applying-snapshot-in-transactional-replication/

Cheers,

Robert

Hi,

Run this script and see what you get .. !

SELECT DISTINCT TOP (100)

bss.database_name ,

bm.physical_device_name,

bss.backup_size ,

bss.backup_start_date ,

bss.backup_finish_date

FROM

msdb.dbo.backupmediafamily AS bm

INNER...

Hi,

You can try using using FOR XML PATH() , an example is here :

-- > https://sqlandme.com/2011/04/27/tsql-concatenate-rows-using-for-xml-path/

Cheers,

Robert

Maybe @W_NoOfBBMs returns Null ?