Check if the Default trace is enabled :

SELECT* FROM sys.configurations WHERE configuration_id = 1568;

sp_configure 'show advanced options', 1;

GO

RECONFIGURE;

GO

-- > default trace enabled : run_value

-- disable the Default...

Hi,

See if this one helps :

select

[text], request_time, grant_time, query_cost, timeout_sec, wait_order, wait_time_ms, group_id,

requested_memory_kb, granted_memory_kb, required_memory_kb, used_memory_kb, max_used_memory_kb, ideal_memory_kb,

query_plan,

*

from sys.dm_exec_query_memory_grants qmg

outer apply sys.dm_exec_sql_text(sql_handle) a

outer apply sys.dm_exec_query_plan(plan_handle) b

Cheers,

Robert

Hi,

That should be the default trace ! If you would like to remove it then stop it first and then try to remove it.

Something like this :

EXEC sp_trace_setstatus 1, 0...

See if this helps : http://blogs.technet.com/b/warreny/archive/2010/12/27/sql-server-transactional-replication-resynchronization.aspx

-- @distribution Cleanup Agent

See if this helps : http://www.mofeel.net/1232-microsoft-public-sqlserver-reportingsvcs/7217.aspx

"Final note: If I put the user (DOMAIN\UserSSIS) in the

BUILTIN\Administrators groups on each node of the cluster, then the job works...

Take a look at this https://msdn.microsoft.com/en-us/library/ms188362.aspx , it might help!

Cheers ..

Then you could try something like this :

SELECT name AS published_object, schema_id, is_published AS is_tran_published, is_merge_published, is_schema_published

FROM sys.tables WHERE is_published = 1 or is_merge_published = 1 or is_schema_published =...

There is also a column is_published , that might help !

select top 100 * from sys.objects

where is_published = 1

order by 1

Try to enable the page lock for the index :

ALTER INDEX < Index name > ON < Table Name >

SET (

ALLOW_PAGE_LOCKS = ON

)

Are you sure that the same parameters are used !?

-- DECLARE @startdate datetime = convert(datetime, '2013-05-24 00:00:00', 120);

DECLARE @startdate datetime = convert(datetime, '2013-05-24 20:00:00', 120);

Yes, and that's because your replication was setup to Replicate schema changes !

Just take a look to the properties of the replicated table and under Subscription Options you will be...

..

Hello,

You can use the query below, execute it every 30 seconds or so .. and whatch the number of connections as well !

SELECT

SUM(current_workers_count)current_visible_workers,

SUM(active_workers_count)active_visible_workers,

(SELECT COUNT(*) FROM sys.dm_exec_connections) connections

FROM...

Hi,

Take a look at this query , it might help !

SELECT TOP (10) *

FROM

msdb.dbo.backupmediafamily AS fm

INNER JOIN msdb.dbo.backupmediaset AS...

and what do you get if you run the one below:

Begin tran

select 10

select @@RowCount

Begin tran

select 50

select @@RowCount -- 1

commit tran

select 100

select @@RowCount -- 1

commit tran

select @@RowCount --...