Forum Replies Created

Viewing 15 posts - 23,746 through 23,760 (of 49,552 total)

  • RE: Are the posted questions getting worse?

    mtillman-921105 (9/2/2011)

    You live in Africa, and it sounds like you don't enjoy seeing the unique and wonderous wildlife there.

    Not sure where you drew that conclusion from...

    The exotic animals...

    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

    September 2, 2011 at 8:35 am

    #1376469

  • RE: Page Lifeexpectancy Problem ??

    Lesson 1 in perfmon. Most counters don't have hard values of good and bad. What you need to watch for is values that are very different to what's normal for...

    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

    September 2, 2011 at 8:33 am

    #1376468

  • RE: Paging - enabled locked pages...still pages

    Do you have the traceflag enabled?

    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

    September 2, 2011 at 6:25 am

    #1376399

  • RE: Paging - enabled locked pages...still pages

    What edition of SQL?

    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

    September 2, 2011 at 5:54 am

    #1376382

  • RE: Are the posted questions getting worse?

    Tom.Thomson (9/2/2011)

    GilaMonster (9/1/2011)

    mtillman-921105 (9/1/2011)

    GilaMonster (9/1/2011)

    SQLRNNR (9/1/2011)

    Reminds me of a story about my mother-in-law. A duck was in her garden. She went to chase it away and the duck...

    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

    September 2, 2011 at 5:52 am

    #1376379

  • RE: Recovery Models

    h.tobisch (9/2/2011)

    You write: "An operation is said to be minimally-logged if all it logs are the allocation changes."

    In the case of a bulk insert this would mean either that a...

    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

    September 2, 2011 at 5:52 am

    #1376377

  • RE: log shipping from SQL 2000 to SQL 2008 in order to keep the tow databases in sync

    rajughy_ghy (9/2/2011)

    Are you going to use that database (Dev) for any reporting purpose ?

    Hopefully not, as the log shipped database would have to be recovering (standby is not an option...

    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

    September 2, 2011 at 5:47 am

    #1376375

  • RE: read uncomitted doesn't work

    Every single query takes a schema lock to ensure that the schema doesn't change while it's running.

    Other than that, my previous statement holds, not much more can be said without...

    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

    September 2, 2011 at 5:45 am

    #1376373

  • RE: read uncomitted doesn't work

    Read uncommitted doesn't mean No locks at all. It means no shared locks taken by reads. It still takes update and exclusive locks, it still takes schema locks.

    To answer your...

    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

    September 2, 2011 at 3:35 am

    #1376331

  • RE: Please help analyzing MS SQL Database Logfile(s)

    Ignacio A. Salom Rangel (9/2/2011)

    Gail tips should get you there. In case you want to make sure the default trace is on, execute sp_configure and check if the "run_value" of...

    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

    September 2, 2011 at 3:33 am

    #1376330

  • RE: number of database data files should equal the number of cores per CPU socket

    colin.Leversuch-Roberts (9/2/2011)

    It's really one for "It just depends" , the theory behind the multiple files is that each cpu core can support a read/write thread so in theory you...

    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

    September 2, 2011 at 3:30 am

    #1376327

  • RE: number of database data files should equal the number of cores per CPU socket

    Suresh B. (9/1/2011)

    gmamata7 (9/1/2011)

    For Physical servers, we have the best practice for Optimum performance to have data files as

    Note: This best practice is applicable only to tempdb data files....

    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

    September 2, 2011 at 2:40 am

    #1376314

  • RE: Transation Log

    SQLforU (9/2/2011)

    1. Try to run the inserts/deletes on the tables in a batches of 1000/10000 (which ever is applicable in ur case) and make sure that u commit soon after...

    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

    September 2, 2011 at 2:39 am

    #1376313

  • RE: Please help analyzing MS SQL Database Logfile(s)

    Unless there have been frequent SQL restarts since then, the information you're after should be in the default trace (you can use the schema modification report to look through 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

    September 2, 2011 at 2:34 am

    #1376310

  • RE: Please help analyzing MS SQL Database Logfile(s)

    Transaction logs aren't audit logs. They won't show login names, host names or application names

    If you want to read the logs, you need either the log to not have been...

    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

    September 2, 2011 at 2:33 am

    #1376308

Viewing 15 posts - 23,746 through 23,760 (of 49,552 total)