Log reader reads it from your publishers log file. The only reason why it can be slow is IO bottleneck at the publisher.

Is this snapshot replication ? Or transactional replication?

I seem to miss something here. You only require the user name to check what permission they have and use that user name for logging purpose?

Please keep in mind that...

Wish you the very best... I am sure you will do great in your new position....

Grant Fritchey (7/23/2010)

Nah, the guy's taking a beating for something he didn't create. I know the feeling...

I am not sure if I understood your question correctly but here goes my 2 cents

I do not think it is SQL 2008 that is the root cause of high...

Is the DBA a sysadmin? If so, I do not know of any way to deny access for the DBA to access any DB in that instance

There is an article explaining how to find the object from replication error

http://www.sqlservercentral.com/blogs/robert_davis/archive/2010/03/27/Making-Sense-of-Replication-Errors-in-Replication-Monitor.aspx

Feels like Deja Vu... I remember seeing this same kind of comments about Joe long time back in the cooler itself.

One thing that does come to mind is FileGroups. Maybe you can create Filegroup in a different drive and move these log archive table to this filegroup. That means your...

Yes, I was talking about Stripe...

For user DB, the reads are almost always non sequential. But for the Log files, it is sequential writes. Another thing that you could...

As per books online "OPENROWSET can be used to access remote data from OLE DB data sources only when the DisallowAdhocAccess registry option is explicitly set to 0 for the...

Cant you try to use Host_Name to find out based on who sits on that work station?

Here is the thing, if you do not find out why the TempDb is growing, then what ever you do now, you will end up with the same situation again....

I have been eating too much BBQ... So I am not so thrilled when I hear about this... 😉

Edit : Spelling mistake