Forum Replies Created

Viewing 15 posts - 19,681 through 19,695 (of 49,552 total)

  • RE: HIGH CPU TIME OF BACKGROUND CHECK POINT

    You'll get an error saying you can't kill system processes. Only user processes can be killed.

    Is that CPU really high? It's a cumulative figure since the checkpoint process started, and...

    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

    March 20, 2012 at 2:23 am

    #1461485

  • RE: ROWLOCK Escalation

    tilew-948340 (3/19/2012)

    - "Rowlock" locks the row being updated and (what I think) releases the lock once the update is done.. It loops for the 7500 rows to be updated, locking...

    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

    March 20, 2012 at 2:20 am

    #1461482

  • RE: Most common types of fix...

    Jake Shelton (3/19/2012)

    I'm surprised at # 4 however, what database-level changes have you found most involved with improving performance?

    AWE on 32 bit instances (instance not database level), max 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

    March 19, 2012 at 2:56 pm

    #1461356

  • RE: Most common types of fix...

    1) SQL code changes

    2) Indexes

    3) Application code changes

    4) Database config changes

    5) Hardware upgrades (IO predominately, very hard to max out a modern CPU with well-written code)

    Restarting SQL 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

    March 19, 2012 at 2:26 pm

    #1461339

  • RE: Query Stalls - Upgrade from 2000 to 2005

    Does updating stats again fix it?

    If so, probably this: http://sqlinthewild.co.za/index.php/2011/03/22/statistics-row-estimations-and-the-ascending-date-column/

    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

    March 19, 2012 at 1:56 pm

    #1461326

  • RE: When does support for SQL Server 2005 end?

    Already has, 11 months ago.

    http://blogs.msdn.com/b/sqlreleaseservices/archive/2011/01/27/end-of-mainstream-support-for-sql-server-2005-and-end-of-service-pack-support-for-sql-server-2008-sp1.aspx

    p.s. A google search with the thread title as search term had that as its first link.

    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

    March 19, 2012 at 10:19 am

    #1461221

  • RE: Is sql server using all cpus?

    forsqlserver (3/19/2012)

    but in my environment sql server has 16 cpu.

    You have a server with 16 physical CPU sockets on the motherboard? That's not a core limitation, it's a processor limitation...

    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

    March 19, 2012 at 10:03 am

    #1461210

  • RE: Are the posted questions getting worse?

    Steve Jones - SSC Editor (3/19/2012)

    Finally read The Hunger Games on Sat since my son desparately wanted me to read it before the movie comes out. It was pretty good,...

    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

    March 19, 2012 at 9:57 am

    #1461205

  • RE: Please Advise - rollback of long running transaction

    The DB did go through the rollback after the restart. It's sometimes faster because there's no one using the DB, the flip side is that unless you're using enterprise edition,...

    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

    March 19, 2012 at 6:29 am

    #1461087

  • RE: Compare two databases

    Link works just fine here: http://msdn.microsoft.com/en-us/library/ms162843.aspx

    tablediff Utility

    SQL Server 2008 R2

    Seriously though, get RedGate's SQLCompare or SQLDataCompare

    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

    March 19, 2012 at 6:20 am

    #1461080

  • RE: help with sql server understanding

    Koen Verbeeck (3/19/2012)

    pacioaga.alisia (3/17/2012)

    (why not stocking that datas on our own pc?)

    Because enterprise data usually takes more then just a few gigabytes.

    And it needs to be available 24/7. If 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

    March 19, 2012 at 1:20 am

    #1460991

  • RE: ROWLOCK Escalation

    The RowLock (or pageLock) hints just say what the locks should start as, nothing more. In this case they'll start as row, but once past the 5000 or so locks...

    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

    March 19, 2012 at 1:18 am

    #1460989

  • RE: How can I tell if Implicit Transactions are turned on in my database?

    Implicit transactions are a connection-level setting. It's set when a connection connects to SQL Server, not at the database or server level. What's set at the server level is 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

    March 19, 2012 at 1:04 am

    #1460984

  • RE: Architecture of Data storing into the disk

    Sure.

    http://technet.microsoft.com/en-us/library/cc966500 (33 pages)

    http://technet.microsoft.com/library/Cc917726 (63 pages)

    A little research on your own would certainly have turned those up, without having to wait for someone to reply.

    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

    March 18, 2012 at 7:11 am

    #1460933

  • RE: How to find out what is actually in use

    drew.georgopulos (3/18/2012)

    1) the limits of my knowledge dictate that profiler and triggers can have an impact in degrading performance...

    They can, but they can also be fine. Depends what you do...

    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

    March 18, 2012 at 7:10 am

    #1460932

Viewing 15 posts - 19,681 through 19,695 (of 49,552 total)