shohelr2003 (12/22/2012)

---

Please suggest me what can I do to prevent tlog from growing. In addition to, I need your support to develop an effective backup plan. What...

Principal, Synchronized or Principal, Synchronizing, depending whether the mirror is behind or up to date.

Asynchronised is not a word, the negation to synchronised would be unsynchronised.

Please read through these: Managing Transaction Logs[/url] and http://www.sqlservercentral.com/articles/Transaction+Log/72488/

That's not enough.

Please read through this - Managing Transaction Logs[/url]

If you know there's no replication inentionally configured and running, then just take the steps listed to remove the replication effects.

How about

SELECT '[' + NDC + ']' FROM TableA

?

If you have a replication log wait then you have either CDC or replication somewhere, either running or improperly removed. Please see the article I referenced.

You have two very different queries there (different in meaning), so it shouldn't be much of a surprise that they return different results.

See http://sqlinthewild.co.za/index.php/2010/01/12/in-vs-inner-join/ (IN and EXISTS use the same...

CDC perhaps? It uses the replication log reader hence shows as replication.

Please have a look at the article I referenced.

You have (or had) snapshot replication?

See this article, specifically the section on replication, and the blog post that it references

http://www.sqlservercentral.com/articles/Transaction+Log/72488/

p.s. The truncateonly option is not valid for log files. It's...

MyDoggieJessie (12/21/2012)

---

Taking this with a grain of salt and the "it depends" answer, another way to see if you have disk contention is to track the average disk queue length...

Well excessive PageIOLatch indicates that the IO subsystem is been driven harder than it can handle. Whether that's...

CREATE TABLE [FROM]([SELECT * FROM] INT, [WHERE =...

MyDoggieJessie (12/21/2012)

---

For instance, high PAGEIOLATCH_EX "may" indicate issues with the disk subsystem (hardware) because it's waiting to look up the page from the disk, CXPACKETS may indicate poorly written queries...

When in doubt, assume bad queries and poor indexing.