Forum Replies Created

Viewing 15 posts - 10,021 through 10,035 (of 49,552 total)

  • RE: Log not available error 9001

    SevereIdea (2/13/2014)

    THANKS!!! I had a db that up until today was doing a CHECKDB every few seconds... never reported any errors, but certainly filling up my event log....

    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

    February 13, 2014 at 10:18 am

    #1688850

  • RE: Rebuild Index

    New Born DBA (2/13/2014)

    The Max logical read I see is 3 and I did right click and opened up the execution plan but it says "clustered Index Seek cost 100%...

    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

    February 13, 2014 at 10:15 am

    #1688847

  • RE: Rebuild Index

    New Born DBA (2/13/2014)

    I am sorry I should have been a little more clear on this. Users are having issues with page loading and it is taking them somewhat 30...

    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

    February 13, 2014 at 10:13 am

    #1688846

  • RE: Page life expetancy is low

    30's above what's generally recommended for an instance on a server with that much memory. See the book and cbhapter which I recommended earlier in this thread.

    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

    February 13, 2014 at 5:56 am

    #1688691

  • RE: how to reduce sorting cost?

    ananda.murugesan (2/13/2014)

    Yes. Second one is another blocking query of actual exec.plan due to this blocking statement pervious query got too much duration.

    Make sure you're tuning the query that is causing...

    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

    February 13, 2014 at 5:20 am

    #1688678

  • RE: Page life expetancy is low

    chandan_jha18 (2/13/2014)

    I had read this in one of the articles from Paul Randal's blog and found this mention in other places too where during the backup times, to read the...

    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

    February 13, 2014 at 5:16 am

    #1688676

  • RE: how to reduce sorting cost?

    Grant Fritchey (2/13/2014)

    The fact that you have four clustered index scans and a heap scan should be a bigger concern than sorting cost. And, what the heck, that's a completely...

    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

    February 13, 2014 at 3:59 am

    #1688660

  • RE: how to reduce sorting cost?

    ananda.murugesan (2/13/2014)

    for aviod the blocking will asking dev.team to assign NOLOCK hint in blocking statment.

    It'll avoid blocking. It'll also potentially return incorrect data. Do your users like getting reports that...

    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

    February 13, 2014 at 3:43 am

    #1688656

  • RE: Page life expetancy is low

    chandan_jha18 (2/13/2014)

    See if this goes low during backups because the database pages are read into memory while a backup is running.

    Backups don't run through the buffer pool so they...

    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

    February 13, 2014 at 3:32 am

    #1688652

  • RE: Managing an Extremely Busy OLTP Server

    chandan_jha18 (2/13/2014)

    GilaMonster (2/13/2014)

    chandan_jha18 (2/13/2014)

    I sincerely apologize to have trimmed a few counters by mistake from the list I provided. Following are top 15 results ordered by their counts:

    Over what time...

    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

    February 13, 2014 at 3:30 am

    #1688651

  • RE: Rebuild Index

    Maybe.

    Is it a heap? Is there a shrink operation running at any time? Is Autoshrink on? How are you checking the fragmentation?

    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

    February 13, 2014 at 2:09 am

    #1688634

  • RE: Managing an Extremely Busy OLTP Server

    chandan_jha18 (2/13/2014)

    I sincerely apologize to have trimmed a few counters by mistake from the list I provided. Following are top 15 results ordered by their counts:

    Over what time period?

    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

    February 13, 2014 at 1:56 am

    #1688630

  • RE: Lock escalation

    http://www.amazon.com/Server-2012-Query-Performance-Tuning-ebook/dp/B008E6HOIS/

    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

    February 12, 2014 at 10:34 pm

    #1688597

  • RE: Difference between four part naming and execute at

    I believe that EXECUTE AT forces the execution of the query to occur on the remote server. Hence the query, when it executes on the remote server is only dealing...

    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

    February 12, 2014 at 11:26 am

    #1688524

  • RE: Orphan logins fix

    That's on the primary?

    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

    February 12, 2014 at 11:22 am

    #1688522

Viewing 15 posts - 10,021 through 10,035 (of 49,552 total)