Forum Replies Created

Viewing 15 posts - 19,876 through 19,890 (of 49,552 total)

  • RE: SQL Server memory performance

    Chapter 4: http://www.simple-talk.com/books/sql-books/troubleshooting-sql-server-a-guide-for-the-accidental-dba/

    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

    March 7, 2012 at 6:37 am

    #1455947

  • RE: Log record ID corruption

    Check for any IO-related errors in the windows event log, SAN logs, etc.

    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

    March 7, 2012 at 6:32 am

    #1455945

  • RE: What causes parameter sniffing to start?

    paul.goldstraw (3/7/2012)

    What I would want is for the compiler to see somehow (don't ask me how) that the compiled value and the runtime value aren't the same and had we...

    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

    March 7, 2012 at 6:32 am

    #1455944

  • RE: Page level locking is disabled????

    OLDCHAPPY (3/7/2012)

    thanks for the help.

    i thought it was proper forum etiquette to use a thread regarding the same subject. no?

    No, just about the opposite. New threads for new questions please...

    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

    March 7, 2012 at 6:09 am

    #1455928

  • RE: What causes parameter sniffing to start?

    HowardW (3/7/2012)

    You should bear in mind that recompiling each time isn't that expensive, so it's a valid option.

    Depends on how often 'each time' is. If I have a complex query...

    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

    March 7, 2012 at 6:08 am

    #1455926

  • RE: What causes parameter sniffing to start?

    paul.goldstraw (3/7/2012)

    However, I don't consider this, or any of the other solutions online to be true solutions. A real solution would be code that just works. Whether this is...

    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

    March 7, 2012 at 4:02 am

    #1455858

  • RE: Log record ID corruption

    Query sys.databases, not the old sysdatabases view. I can't recall offhand if it's state_desc or status_desc, query it and see, post the value.

    The old sysdatabases view is for backward compatibility...

    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

    March 7, 2012 at 3:55 am

    #1455852

  • RE: Are the posted questions getting worse?

    Koen Verbeeck (3/7/2012)

    Is it me, or is this publishing copyrighted material:

    http://www.sqlservercentral.com/Forums/Topic1262092-148-1.aspx

    Yes, and it's not the first pdf he's posted, though I didn't check the others.

    p.s. I downloaded it, it is...

    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

    March 7, 2012 at 1:09 am

    #1455780

  • RE: Learning about SSAS

    anthony.green (3/6/2012)

    this might be a good place to start, granted its for 2008, but the principles are the same

    Sorry, you're posting an illegal pdf of a copyrighted book? That book'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

    March 7, 2012 at 1:05 am

    #1455778

  • RE: Constant Deadlocks on Production

    For a reader-writer deadlock the snapshot isolations are completely effective in preventing them, and any other form of locking problem. You do need to test them first, some behaviour can...

    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

    March 7, 2012 at 12:17 am

    #1455764

  • RE: Freeproccache

    If a database has general poor performance, then maybe have a read through the following and see if you can use that technique to identify the problematic queries

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-1/

    http://www.simple-talk.com/sql/performance/finding-the-causes-of-poor-performance-in-sql-server,-part-2/

    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

    March 6, 2012 at 3:53 pm

    #1455652

  • RE: Buffer size

    What's the exact error message?

    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

    March 6, 2012 at 3:49 pm

    #1455648

  • RE: What causes parameter sniffing to start?

    paul.goldstraw (3/6/2012)

    We already use Option (recompile) as our solution

    If you use Option(Recompile) then you cannot have a parameter sniffing problem. Parameter sniffing problems occur when a plan is compiled...

    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

    March 6, 2012 at 3:39 pm

    #1455644

  • RE: Log record ID corruption

    Status_desc

    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

    March 6, 2012 at 3:31 pm

    #1455641

  • RE: Time outs due to huge transactions?

    Correct, but that message says that it was growing, and while the log is growing data modifications must wait.

    10% is a poor autogrow setting. Set a fixed size in MB,...

    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

    March 6, 2012 at 9:31 am

    #1455428

Viewing 15 posts - 19,876 through 19,890 (of 49,552 total)