Forum Replies Created

Viewing 15 posts - 23,326 through 23,340 (of 49,552 total)

  • RE: avg disk queue length

    Yes, avg sec/read and avg sec/write and the threshold for these is typically 20ms = good, 50ms = bad, above that = terrible.

    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 23, 2011 at 9:49 am

    #1385871

  • RE: what's the best column for clustered indexes

    okbangas (9/23/2011)

    Funny you mention it. Datetime can be ever inceeasing, bit rarely unique, causing sql server to add a four byte identifier to each row. Om such a scenario, 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

    September 23, 2011 at 9:41 am

    #1385863

  • RE: avg disk queue length

    Reads and writes/sec aren't much better. What you really need to look at is the latency. sec/read and sec/write

    I've seen Disc read/sec at 500 or so frequently. I have also...

    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 23, 2011 at 9:36 am

    #1385860

  • RE: what's the best column for clustered indexes

    mpalaparthi (9/23/2011)

    Kindly advice. I am seeing frequest fragmentation of indexes on the XYZ tables and because of this deadlocks are occuring in the application.

    Fragmentation is not going to be 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

    September 23, 2011 at 9:35 am

    #1385856

  • RE: finding Structure of the table

    shivendrakumaryadav60 (9/23/2011)

    BUT NOT SURE ABOUT STRUCTURE HISTORY ... I WILL SEARCH ABOUT IT

    SQL doesn't keep history unless you set something up to do so.

    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 23, 2011 at 8:53 am

    #1385812

  • RE: Device activation error. The physical file name

    The error means that SQL cannot open the file. It doesn't mean anything else.

    Double-check there's not a spelling mistake somewhere. Double check that SQL has access to the files (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 23, 2011 at 8:40 am

    #1385800

  • RE: what's the best column for clustered indexes

    Gianluca Sartori (9/23/2011)

    Also a uniqueidentifier can be a good clustering key.

    Can be, maybe, if the person designing the table understands the complexities. Usually however it's about the worst clustered...

    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 23, 2011 at 8:35 am

    #1385796

  • RE: Point in time recovery for new database.

    Joy Smith San (9/23/2011)

    Had I taken atleast a full backup, I could have taken the tail log backup and do a PIT recovery, right ?

    If the database was in full...

    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 23, 2011 at 8:03 am

    #1385763

  • RE: Point in time recovery for new database.

    Nop. You have no backup, therefore you have no recovery options at all.

    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 23, 2011 at 7:51 am

    #1385743

  • RE: Device activation error. The physical file name

    Either the files G:\data_prod\rd_prod1.mdf, G:\index\rd_prod1_1.ndf' and G:\logs\rd_prod1_log.ldf don't exist or SQL doesn't have access to them (or, if this is a cluster, the G drive is not properly configured in...

    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 23, 2011 at 7:49 am

    #1385739

  • RE: finding Structure of the table

    If you've got source control then surely you can just get previous versions out of the source control system (that's kinda one of the reasons for having source control...)

    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 23, 2011 at 7:47 am

    #1385737

  • RE: how to find Ram memory occupied by sql server

    Performance monitor with the total server memory counter.

    Working set is wrong for the same reasons that Task Manager is wrong. Easy to see it's wrong...

    Task manager (and Process(sqlservr.exe\Working Set) say...

    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 23, 2011 at 7:46 am

    #1385734

  • RE: how to find Ram memory occupied by sql server

    Task manager is a terrible way to check SQL's memory. It's incorrect in many cases (yes, there is a reason, it's not a bug)

    Performance monitor with the total server memory...

    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 23, 2011 at 6:05 am

    #1385642

  • RE: i want to display alternative records..

    In this case, as simple as

    SELECT id, name FROM SomeTable WHERE id % 2 = 1

    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 23, 2011 at 3:36 am

    #1385593

  • RE: Query maxing out 24 CPUs

    Probably not. It's not a case where the plan was compile optimally for one scenario and is performing badly for another (which is when recompile helps). It's that the optimiser...

    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 23, 2011 at 3:00 am

    #1385584

Viewing 15 posts - 23,326 through 23,340 (of 49,552 total)