Well, that could definitely have an effect on performance. A lot of extra I/O is going to occur due to the data being spread all over the place and...

Is the execution plan the same between the STG and Test? Hopefully they both are leveraging that same index?

Any idea on what the fragementation levels of the affected indexes...

I've never been down that path for troubleshooting as I rely on a a shema compare and a homegrown batch process leveraging tablediff.exe (msdn.microsoft.com/en-us/library/ms162843.aspx). I suppose you could use...

"Missing indexes" for execution plans are pulled from a DMV, sys.dm_db_missing_index_details, which is the culmination of the stored information SQL Server is keeping about the queries the optimizer receives from...

As Grant alluded to, did the size of the backup itself increase? That would be the first indicator of a root cause to me. If that's not the...

I second ChrisTaylor's recommendation of first obtaining an execution plan. That will do wonders in understanding "why" your code is non-performant and where your roadblocks are. If you...

Sorry,

After looking at your post again, the above may not help. You're wanting the actual T-SQL....

Try this:

EXEC distribution.dbo.sp_browsereplcmds '0x00113DA20000F6F60005', '0x00113DA20000F6F60005'

Replacing the xact_seqno "from" and "thru" with your transaction...

cjohn5552 (8/16/2011)

I seem to recall this as being possible. Is there a system table that lists these? Also, any pointers on how to manually skip replication commands? The hexadecimal sequence...

In High-Safety/Protection/Synchronous mode, you're in a two-phase commit situation, so having the mirror offline is not an option. If you don't have a monitor in place for this scenario,...

I know this thread is super old, but in the interest of future individuals Googling and finding this, the below link may be the solution for you....

http://www.replicationanswers.com/TransactionalOptimisation.asp

Good luck...

...

Forgot to add that the SPID on the host server where the problem is occurring is orphaned, meaning, I have physically closed SSMS and the SPID just stays in a...

We get the same problem in our envrinment on occasion and I've found a way to repro it in our environment consistently. It's quite aggravating to be forced to...

Used to be a lot easier to justify. Like others have said already, it's really based on your needs vs your budget.

So I'll just add my personal experience. ...

As metioned above, the exact error you're receving will go a long way in helping us know what the root cause is. Could be any number of things.

Do you...

I used Spotlight for years and up until v7, it was the best tool I'd ever used for historical troubleshooting (24x7 monitoring even when no admins are connected in the...