Forum Replies Created

Viewing 15 posts - 22,711 through 22,725 (of 49,552 total)

  • RE: Odd blocking condition - a SELECT query blocking on tempdb sysschobjs even though session sleeping

    Marios Philippopoulos (10/26/2011)

    GilaMonster (10/26/2011)

    Open transaction, no commit. Tran stays open so locks held even though the session was sleeping.

    Thanks, but why on tempdb? The SELECT was running on a user...

    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

    October 26, 2011 at 8:48 am

    #1399663

  • RE: sys.dm_db_index_usage_stats --- User_Seeks has 0 sometimes NULL?

    GilaMonster (10/25/2011)

    Last user seek can be null, but the user seeks shouldn't be able 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

    October 26, 2011 at 8:45 am

    #1399659

  • RE: Are the posted questions getting worse?

    BrainDonor (10/26/2011)

    No no no no no - if it doesn't make the bookshelf bend then it isn't worth buying. I haven't yet moved to ebooks (unless it's a free pdf...

    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

    October 26, 2011 at 8:42 am

    #1399654

  • RE: Massive IOs!

    Add memory (move to 64 bit if possible, if not make sure AWE is enabled)

    Tune queries. Missing indexes are suggestions, not directives, test on a representative data volume, tuning indexes...

    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

    October 26, 2011 at 8:40 am

    #1399652

  • RE: Odd blocking condition - a SELECT query blocking on tempdb sysschobjs even though session sleeping

    Open transaction, no commit. Tran stays open so locks held even though the session was sleeping.

    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

    October 26, 2011 at 8:38 am

    #1399649

  • RE: DBCC checkdb fials on several databases, but not all

    Check permissions. SQL needs full permissions to files and folder.

    What are the names of the files of those databases?

    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

    October 26, 2011 at 8:26 am

    #1399641

  • RE: Ciclic Redundancy Check error when read xxxxxx_9.ndf file

    Any errors in the windows event log? If so, post them.

    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

    October 26, 2011 at 8:20 am

    #1399639

  • RE: Ciclic Redundancy Check error when read xxxxxx_9.ndf file

    jorge_gomes98 (10/26/2011)

    I need to retrieve the data from the file ... it is possible to know which data are available?

    Is that file it's own filegroup or in a filegroup 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

    October 26, 2011 at 8:18 am

    #1399635

  • RE: High Page life expectancy

    Loner (10/26/2011)

    I thought it supposed to be 300.

    10 years ago if page life expectancy dropped below 300 it was considered bad. Many people still blindly quote 300 as the figure...

    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

    October 26, 2011 at 8:14 am

    #1399632

  • RE: DBCC checkdb fials on several databases, but not all

    Something is causing the snapshot creation to fail.

    If you're on Enterprise Edition, see if you can create a manual database snapshot on the same drive as the data file. If...

    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

    October 26, 2011 at 7:58 am

    #1399619

  • RE: Page restore in SQL Server 2005

    Chapter 8 of SQL Server MVP Deep Dives 2. </shameless plug>

    What you have there is not quite the process.

    Enterprise edition:

    Restore page from full

    Optionally restore diff

    Restore logs in sequence

    Take a 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

    October 26, 2011 at 7:43 am

    #1399607

  • RE: CPU Utilization is 100%

    Lavanyasri (10/26/2011)

    exec sp_cursorunprepare 187379994990 --rpc completed

    FETCH API_CURSOR00000000000000E1 --sp:stmt completed

    sp_cursorclose 180156333 --SQL :stmt completed

    exec sp_cursorfetch 180166335,1,0,138 --rpc : completed

    You can't directly tune those. You need to find...

    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

    October 26, 2011 at 7:30 am

    #1399596

  • RE: index on big table

    dva2007 (10/26/2011)

    Again according to this article here it says following:

    http://www.sql-server-performance.com/2007/clustered-indexes/

    Here are some more good reasons to add a clustered index to every table.

    Keep in mind that a clustered index physically...

    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

    October 26, 2011 at 7:28 am

    #1399595

  • RE: self teaching newbie needs help please...

    Ok, I don't want to be too blunt but.... That's the kind of database 'design' that makes most of us run screaming.

    Columns should hold atomic values, meaning values can't...

    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

    October 25, 2011 at 5:35 pm

    #1399372

  • RE: sys.dm_db_index_usage_stats --- User_Seeks has 0 sometimes NULL?

    You're getting nulls because of the left join. If there's an index in sys.indexes and there's no row in sys.index_usage_stats (which will happen if the index has never been used...

    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

    October 25, 2011 at 3:50 pm

    #1399358

Viewing 15 posts - 22,711 through 22,725 (of 49,552 total)