Forum Replies Created

Viewing 15 posts - 10,021 through 10,035 (of 49,571 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....

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

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

    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.

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

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

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

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

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

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

    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?

    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?

    February 13, 2014 at 1:56 am

    #1688630

  • RE: Lock escalation

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

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

    February 12, 2014 at 11:26 am

    #1688524

  • RE: Orphan logins fix

    That's on the primary?

    February 12, 2014 at 11:22 am

    #1688522

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