Forum Replies Created

Viewing 15 posts - 15,526 through 15,540 (of 49,552 total)

  • RE: Memory Clerks - MEMORYCLERK_SQLBUFFERPOOL

    First hit on google for "MEMORYCLERK_SQLBUFFERPOOL single page allocator"

    http://social.msdn.microsoft.com/Forums/en-US/sqldatabaseengine/thread/2c14df9a-0f82-45a5-ac53-13062eb3a2df/

    And the BoL page for the DMV you're using

    http://msdn.microsoft.com/en-us/library/ms175019%28v=sql.105%29.aspx

    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

    November 26, 2012 at 12:16 am

    #1562078

  • RE: Amount of data

    You can look at the execution plan, you're looking for the last arrow, the one pointing at the select operator. It is an estimate, not an actual, assuming stats are...

    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

    November 25, 2012 at 12:12 pm

    #1562056

  • RE: Transactio log growth

    Move that table to a different database, set that DB to simple recovery. Logging cannot be disabled for an object.

    Get more drive space (optimal)

    Don't restrict your log file. When it...

    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

    November 25, 2012 at 9:48 am

    #1562051

  • RE: question on index

    It can go straight to the data. The RID is a 8-byte combination of file ID, page number and slot array. The first 2 allow SQL to go straight to...

    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

    November 24, 2012 at 10:48 am

    #1561985

  • RE: Simple Database

    A large log file does not in and of itself cause perforance problems. If a log file fills and has to grow, it will slow down any data modifications occuring...

    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

    November 24, 2012 at 10:27 am

    #1561982

  • RE: need one doubt clarification application team trying to execute a simple query

    naga.rohitkumar (11/22/2012)

    or after rebuilding the table wheter we have to rearrrange the colums of the table which previous ly having

    Order of columns in a table has no meaning.

    can we rebuild...

    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

    November 24, 2012 at 2:09 am

    #1561963

  • RE: Simple Database

    I assume you mean the log file...

    It does get truncated, every time a checkpoint runs. Truncate means make log space reusable, not make log file smaller. The only thing 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

    November 24, 2012 at 2:07 am

    #1561962

  • RE: Failed Simple Maintenance Plan only when Full Backups do not run

    http://ola.hallengren.com/Versions.html

    http://sqlfool.com/2011/06/index-defrag-script-v4-1/

    Just 2 of the options available.

    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

    November 23, 2012 at 1:48 pm

    #1561931

  • RE: SNAPSHOT Isolation with (NOLOCK) being used all over

    You also might mention that getting the wrong result fast is usually not acceptable to users. Most users would rather have the correct results, even if it does take slightly...

    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

    November 23, 2012 at 12:39 pm

    #1561922

  • RE: SNAPSHOT Isolation with (NOLOCK) being used all over

    SET STATISTICS TIME ON.

    And send them this http://blogs.msdn.com/b/davidlean/archive/2009/04/06/sql-server-nolock-hint-other-poor-ideas.aspx

    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

    November 23, 2012 at 12:15 pm

    #1561915

  • RE: SNAPSHOT Isolation with (NOLOCK) being used all over

    SQL_ME_RICH (11/23/2012)

    Is there a query that I could run against some of the system objects that would retrieve a time/date stamp for me of when the Isolation Level was...

    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

    November 23, 2012 at 12:03 pm

    #1561911

  • RE: Does READ_COMMITTED_SNAPSHOT ignore ROWLOCK hints?

    Do feel free to test it out though

    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

    November 23, 2012 at 9:08 am

    #1561887

  • RE: Multiple Index Rebuild

    Can you have some patience? It's only been an hour, on a holiday weekend for the US.

    If the largest index is 80 GB, then the peak usage of TempDB won't...

    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

    November 23, 2012 at 8:30 am

    #1561880

  • RE: Shrunk data file in sqlserver2008

    Go rebuild all your indexes.

    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

    November 23, 2012 at 5:05 am

    #1561832

  • RE: Check this correct - my DBCC script

    sysdatabases is deprecated, included only for backward compatibility with SQL 2000 and should not be used in new development.

    Replacement is sys.databases

    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

    November 23, 2012 at 5:02 am

    #1561831

Viewing 15 posts - 15,526 through 15,540 (of 49,552 total)