Forum Replies Created

Viewing 15 posts - 12,316 through 12,330 (of 49,552 total)

  • RE: Stored procedure working very slow

    Please read the article I posted as well as the blog post that Sean referenced.

    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

    July 18, 2013 at 1:35 pm

    #1633777

  • RE: Stored procedure working very slow

    Please post table definitions, index definitions and execution plan, as per http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

    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

    July 18, 2013 at 1:28 pm

    #1633770

  • RE: DMV to replicate DBCC OPENTRAN - Log won't truncate

    jallmond (7/18/2013)

    So "logically" I have begun a transaction, but I am not actually burning any log. Clear as mud?

    The transaction has been initiated but no log records reflecting 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

    July 18, 2013 at 1:27 pm

    #1633769

  • RE: SPs inside BEGIN/ROLLBACK TRAN

    Off the top of my head, no. Don't think I ever got around to writing one. Might have been part of Paul Randal's myth a day series.

    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

    July 18, 2013 at 12:56 pm

    #1633761

  • RE: SPs inside BEGIN/ROLLBACK TRAN

    Sean Lange (7/18/2013)

    You can begin as many as you like but after the first all it does is increment @@TRANCOUNT. Then when there is a commit or rollback they are...

    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

    July 18, 2013 at 12:48 pm

    #1633758

  • RE: DMV to replicate DBCC OPENTRAN - Log won't truncate

    Err... there's no such thing as a 'logical' or 'physical' transaction. There are just transactions.

    sys.dm_tran_active_transactions reports at an instance level, so if you're trying it ID transactions within a single...

    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

    July 18, 2013 at 12:27 pm

    #1633755

  • RE: DMV to replicate DBCC OPENTRAN - Log won't truncate

    If DBCC OPENTRAN is showing a session, then that session has an open transaction. If it's AWAITING COMMAND, that just means that the transaction has been started and not committed.

    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

    July 18, 2013 at 12:24 pm

    #1633752

  • RE: sys.dm_db_index_physical_stats - Doubt in the Results

    Well index rebuilds are unlikely to make noticable improvements in performance, so maybe the question should rather be 'what can be done'

    Tune the query to use indexes, modify/add indexes 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

    July 18, 2013 at 9:41 am

    #1633698

  • RE: sys.dm_db_index_physical_stats - Doubt in the Results

    Too small to bother with.

    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

    July 18, 2013 at 9:36 am

    #1633694

  • RE: DMV to replicate DBCC OPENTRAN - Log won't truncate

    The reason you're getting odd results is that BEGIN TRANSACTION alone is not enough to actually start a transaction. The transaction will start when the next command is run.

    So

    BEGIN TRANSACTION

    SELECT...

    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

    July 18, 2013 at 9:34 am

    #1633693

  • RE: sys.dm_db_index_physical_stats - Doubt in the Results

    Ignore the non-leaf levels unless they're absolutely huge.

    Let me guess, those nonclustered indexes are tiny, just a couple of pages?

    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

    July 18, 2013 at 8:14 am

    #1633656

  • RE: SQL Server Backups & Maintenance - Best Practices

    John Mitchell-245523 (7/18/2013)

    (3) The statistics update automatically triggered by ALTER INDEX REBUILD is based on a limited scan of the data, whereas UPDATE STATISTICS is based on a full scan.

    Other...

    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

    July 18, 2013 at 8:12 am

    #1633655

  • RE: sys.dm_db_index_physical_stats - Doubt in the Results

    balasach82 (7/18/2013)

    1. How to reduce this fragmentation in Clustered index at depth 4(in general for all depth rows)

    Don't bother trying. The highest level is the root, which is only 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

    July 18, 2013 at 7:59 am

    #1633651

  • RE: Transaction Log Backup fails Exclusive access could not be obtained because the database is in use

    Welsh Corgi (7/18/2013)

    As far as the option to backup the tail of the transaction log, do you use that for all transaction log backups or for the last transaction 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

    July 18, 2013 at 7:58 am

    #1633650

  • RE: Upgrade from Sql 2003 to Sql 2008

    poratips (7/17/2013)

    Do you have any suggestion which might help to decide how many processor could benefit?

    Benchmark the servers, see what they currently use, plan future growth, that gives you somewhere...

    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

    July 17, 2013 at 4:17 pm

    #1633473

Viewing 15 posts - 12,316 through 12,330 (of 49,552 total)