Forum Replies Created

Viewing 15 posts - 15,091 through 15,105 (of 49,552 total)

  • RE: TLOG GROWING VERY LARGE

    shohelr2003 (12/22/2012)

    That's not enough.

    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...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 23, 2012 at 2:43 am

    #1571173

  • RE: Asynchronize Mirroring Operation mode

    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.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 22, 2012 at 10:14 am

    #1571146

  • RE: Log File Size Issue

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

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 22, 2012 at 8:18 am

    #1571137

  • RE: TLOG GROWING VERY LARGE

    shohelr2003 (12/22/2012)

    I take full backup everyday once.

    That's not enough.

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

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 22, 2012 at 5:36 am

    #1571132

  • RE: Unable to shrink a 50GB log db file

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

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 21, 2012 at 3:50 pm

    #1571095

  • RE: Len did not display right size

    How about

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

    ?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 21, 2012 at 3:28 pm

    #1571089

  • RE: Unable to shrink a 50GB log db file

    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.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 21, 2012 at 3:19 pm

    #1571085

  • RE: Correlated Subquery - Stream Aggregate

    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...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 21, 2012 at 3:14 pm

    #1571081

  • RE: Unable to shrink a 50GB log db file

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

    Please have a look at the article I referenced.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 21, 2012 at 3:11 pm

    #1571078

  • RE: Unable to shrink a 50GB log db file

    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...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 21, 2012 at 1:54 pm

    #1571064

  • RE: Hardware or Bad Queries = Performance issues?

    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...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 21, 2012 at 1:14 pm

    #1571053

  • RE: Hardware or Bad Queries = Performance issues?

    scogeb (12/21/2012)

    LOL, so those waits really don't tell a person much!

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

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 21, 2012 at 12:23 pm

    #1571032

  • RE: Table and SP cannot have same name

    Lowell (12/21/2012)

    reminds me of horrors like this:

    CREATE TABLE [SELECT]([SELECT] INT IDENTITY(1,1) NOT NULL PRIMARY KEY )

    SELECT [SELECT].[SELECT] FROM [SELECT] WHERE [SELECT] = 1

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

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 21, 2012 at 10:31 am

    #1571009

  • RE: Hardware or Bad Queries = Performance issues?

    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...

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 21, 2012 at 9:26 am

    #1570978

  • RE: Hardware or Bad Queries = Performance issues?

    When in doubt, assume bad queries and poor indexing.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

    December 21, 2012 at 9:19 am

    #1570974

Viewing 15 posts - 15,091 through 15,105 (of 49,552 total)