Forum Replies Created

Viewing 15 posts - 8,056 through 8,070 (of 49,552 total)

  • RE: Is partitioning good option for OLTP?

    curious_sqldba (8/19/2014)

    Reason I say that is if I have multiple file groups I can just backup that one file group and restore on Dev server for troubleshooting purposes.

    No, 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

    August 19, 2014 at 7:44 am

    #1739215

  • RE: Log Backup With Truncate_Only

    Ok..... I'll mark that one down as another tool to avoid.

    p.s. If you don't keep the log backups, then you can't restore to point in time. In that case, assuming...

    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

    August 19, 2014 at 3:48 am

    #1739134

  • RE: Same database on multiple cluster nodes for performance?

    protix (8/18/2014)

    Well, I'm interested in the performance mainly.

    How many transactions/sec are you talking here? What hardware? What are your current bottlenecks?

    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

    August 19, 2014 at 3:47 am

    #1739133

  • RE: General practice for MAXDOP setting

    TheSQLGuru (8/18/2014)

    As far as I am concerned there is a hard limit for most every server out there and that is the number of physical cores in each NUMA node....

    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

    August 19, 2014 at 2:33 am

    #1739119

  • RE: I need a Query for this (Bit Urgent)

    If you want it urgently, then make it as easy as possible for someone to answer.

    Please provide the CREATE TABLE for all involved tables and the sample data as insert...

    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

    August 19, 2014 at 2:30 am

    #1739117

  • RE: General practice for MAXDOP setting

    RPSql (8/18/2014)

    I was looking for a general practice you follow in order to set MAXDOP setting on a SQL instance.

    0 unless I have a good reason to change 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

    August 19, 2014 at 2:29 am

    #1739116

  • RE: General practice for MAXDOP setting

    MyDoggieJessie (8/18/2014)

    TheSQLGuru (8/18/2014)Don't forget the other part of the equation - Cost Threshold for Parallelism. The default of 5 is universally too low.

    What's a good way 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

    August 19, 2014 at 2:28 am

    #1739115

  • RE: Log Backup With Truncate_Only

    codykonior (8/18/2014)

    I thought, this would not clear out log records where a log reader replication agent has not yet marked them as read.

    He thinks, this will clear out log records,...

    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

    August 19, 2014 at 2:24 am

    #1739112

  • RE: High value of work files and Work table

    Firstly, is that value a problem? Is it higher than usual? Is it causing problems?

    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

    August 19, 2014 at 2:23 am

    #1739111

  • RE: Are the posted questions getting worse?

    Luis Cazares (8/18/2014)

    Help! I was asked by my DBA to optimize the following query because it has a high cost.

    DELETE MySchema.Facttable

    WHERE datecol = @Date;

    It's part 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

    August 19, 2014 at 2:18 am

    #1739107

  • RE: Filtered indexes in sql server 2012

    Do it the other way around. Look at the queries, look at how they filter, whether there's a common predicate (like WHERE Archived = 0), which is not parameterised. 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

    August 18, 2014 at 11:35 am

    #1738984

  • RE: Full and Differential Backups failing but Transaction Log backups working

    No where near enough info. That error message is useless

    Try taking a backup from a query window (backup database ... to disk = '<backup location>') and post any and 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

    August 18, 2014 at 7:24 am

    #1738852

  • RE: Filtered indexes in sql server 2012

    Sindhu Ravi (8/18/2014)

    If the number of rows in histogram is less than 10 for a particular index and the percentage of equality rows is greater than 30 , then 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

    August 18, 2014 at 6:24 am

    #1738823

  • RE: ROW_NUMBER in a WHILE loop

    I can't see your screen, I haven't read your requirements, I can't read your mind 🙂

    If you had no knowledge of this problem and someone told you just what 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

    August 18, 2014 at 6:22 am

    #1738818

  • RE: Memory page fault/sec - too high value?

    SQL Galaxy (8/18/2014)

    1. What's normal for this server for those counters?

    I am not sure those counter normal values, It might be < 500 seconds for better (soft/hard...

    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

    August 18, 2014 at 6:19 am

    #1738816

Viewing 15 posts - 8,056 through 8,070 (of 49,552 total)