7

SQL Server distribution agent cleanup job causes blocking

view full story
linux-howto

http://serverfault.com – I am using SQL Server transactional replication, and have noticed that on a daily basis all of the publications for a distributor are being blocked when the distribution agent cleanup job executes. I have seen this block persist for up to 2 hours. Some of the subscriptions require extremely low latency, so this is a big problem for me right now. I have read that setting the HistoryVerboseLevel to 0 will stop logging to MSdistribution_history database. Having done this, the blocking subsided for the subscriptions that i changed the distributor profiles for. However, within three days all o (HowTos)

xskl's picture
Submitted by xskl on 01/13/2013 – Made popular on 01/13/2013

Stories similar to SQL Server distribution agent cleanup job causes blocking

What factors into choosing a distribution server for transactional replication? In our topology, we've always had the distributor reside on the publishing server. We rarely generate snapshots and performance is good enough, so this is okay for us today.

My Team Foundation Server creates backups. I want to clear backups that are older than 5 days. Create Maintenanace Cleanup Task in Maintenance Plans of Management of Sql Server 2012. Point there folder, file extension bak, checkbox 'Delete files based on the age of the file at task run time' is checked. Saved task.

When I execute it, got error: Execution failed.

I have a production server which is running on Windows Server 2003 and installed with a logging agent on drive D.

Recently, the database administrators migrated the database which is sitting on D drive to a SAN storage.

I have an SQL 2012 AlwaysOn Cluster and need to setup SharePoint reporting services.

Within SharePoint farm configuration it reports that the SQL server agent is not running.

Since I have multiple SQL nodes to which the connection can fail over to any, how do I handle the SQL server agent or is this clustered also?

Does the downloadable SharePoint reporting SQL script need to be ran on each nod

I am using ipset in conjunction with iptables to create a list of IPs I want to block. I did this:

ipset -N blocking iphash ipset -A blocking 124.205.11.230 // and repeated this line for all IPs I want to add to "blocking" list

now I have to add this rule to iptables

if I do this

iptables -A INPUT -m set --set blocking src -j DROP

the IPs will be blocked for everything SSH, FTP, etc.

With only 11 days until Christmas, I must confess I am biased toward one distributor in particular: A jolly white-bearded man in a red suit whose distribution center is at the North Pole. But until Dec. 24 rolls around, I will keep my eyes focused on the distributors that spread the IT joy.

Greetings, and welcome to the latest episode of Distribution Watch, our weekly collection of doings in the distribution space.

Very new to mod_sec

I want to block a UA string and I noticed there are a few types:

SecRule HTTP_User-Agent SecRule REQUEST_HEADERS:User-Agent

What is the real difference between them?

My block:

SecRule REQUEST_HEADERS:User-Agent "perl" "phase:2,pass,msg:'Perl based user agent identified'"

Do I need to set a SecDefaultAction phase:2,deny,status:403,log,auditlog before that?

I am trying to understand the difference between the following primatives.

send (blocking and non blocking) receive (blocking and non blocking) RPC server accept RPC call

I have tried searching the internet, however I have yet to find a good resource.

thanks, daniel