Forum Replies Created

Viewing 15 posts - 14,566 through 14,580 (of 49,552 total)

  • RE: very high CX packet waits

    sqldba_newbie (1/29/2013)

    GilaMonster (1/29/2013)

    If you want all queries to only use one processor, why not pull the other 23 out? That's essentially what you've done by setting maxdop to 1. 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

    January 29, 2013 at 12:51 pm

    #1582323

  • RE: Are the posted questions getting worse?

    jcrawf02 (1/29/2013)

    I've been farming for post count, and I gotta say, it's really confusing because I can't tell where you're supposed to go cash in all these points for better...

    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

    January 29, 2013 at 10:55 am

    #1582264

  • RE: Backup Problem

    Not enough information to draw any conclusions. What does the backup app log say? Anything useful in the SQL error log?

    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

    January 29, 2013 at 10:26 am

    #1582253

  • RE: Are the posted questions getting worse?

    wolfkillj (1/29/2013)

    GilaMonster (1/29/2013)

    I went through all of the ones I saw yesterday, his post is not relevant, the over-sized plan cache problem on SQL 2005 RTM and SP1 is not...

    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

    January 29, 2013 at 9:57 am

    #1582239

  • RE: Behaviour in partitioned database.

    https://www.simple-talk.com/sql/database-administration/gail-shaws-sql-server-howlers/

    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

    January 29, 2013 at 9:53 am

    #1582236

  • RE: Turning Scan into Seek...

    ChrisM@Work (1/29/2013)

    How many rows in the table? How many rows are you returning? If you are returning more than say 25%* of the rows in the table, SQL Server may...

    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

    January 29, 2013 at 9:53 am

    #1582235

  • RE: Foreign Keys,Deadlocks, Partioning,OLTP ......what is the best setup?

    DominantDBA (1/29/2013)

    We are using AlwaysOn to a DR site so we do have High Availability

    The 2 hour restore is if we lose both it has to be available within 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

    January 29, 2013 at 9:51 am

    #1582233

  • RE: Can I purge data on the principal without the purging it on the mirror?

    MyDoggieJessie (1/29/2013)

    I would recommend transactional replication slightly customised so that the deletes don't replicate. This additionally gives you the ability to have different indexes on the reporting replica.

    Sorry 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

    January 29, 2013 at 9:48 am

    #1582230

  • RE: Are the posted questions getting worse?

    I went through all of the ones I saw yesterday, his post is not relevant, the over-sized plan cache problem on SQL 2005 RTM and SP1 is not going 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

    January 29, 2013 at 9:48 am

    #1582229

  • RE: Can I purge data on the principal without the purging it on the mirror?

    Mirroring is a high-availability feature that can additionally be leveraged for reporting. It is not primarily a reporting solution. As a HA feature, the mirror is an exact, identical copy...

    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

    January 29, 2013 at 7:33 am

    #1582136

  • RE: Foreign Keys,Deadlocks, Partioning,OLTP ......what is the best setup?

    DominantDBA (1/29/2013)

    There is a business requirement that the database needs to be opreational within 2 hours if it is lost

    Log shipping, database mirroring?

    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

    January 29, 2013 at 5:40 am

    #1582057

  • RE: Stored procedure very slow execution

    sqlnaive (1/29/2013)

    there is no way we can updates the statistics in middle of the whole process.

    Why not?

    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

    January 29, 2013 at 5:39 am

    #1582056

  • RE: Stored procedure very slow execution

    sp_updatestats does sampled updates. That may not be good enough.

    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

    January 29, 2013 at 4:34 am

    #1582014

  • RE: Foreign Keys,Deadlocks, Partioning,OLTP ......what is the best setup?

    Why are you partitioning? What's the goal there?

    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

    January 29, 2013 at 4:01 am

    #1581992

  • RE: checkdb error

    Ratheesh.K.Nair (1/29/2013)

    DBCC CHECKDB WITH TABLOCK GAVE BELOW ERROR

    ---------------------------------------------------------------

    Msg 5030, Level 16, State 12, Line 1

    The database could not be exclusively locked to perform the operation.

    Msg 7926, Level 16, State 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

    January 29, 2013 at 2:34 am

    #1581954

Viewing 15 posts - 14,566 through 14,580 (of 49,552 total)