Forum Replies Created

Viewing 15 posts - 17,671 through 17,685 (of 49,552 total)

  • RE: SQL Server Performance Troubleshooting - Wait Stats

    SQLSACT (7/12/2012)

    So this is saying that a process wanted to acquire a Shared Lock on an object but something else already had an exclusive lock on the same object?

    Not necessarily...

    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 12, 2012 at 8:32 am

    #1512104

  • RE: Last Full and Log backup

    What follows the THEN is just an expression, any combination of parameters, literals, columns, variables, just as a normal column in the 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 12, 2012 at 7:46 am

    #1512061

  • RE: Adding data & index file best pratices?

    ananda.murugesan (7/12/2012)

    1. If more then 200GB primary data file reached, I assumed need to create one more datafile for improve database perfromance?

    No.

    There's no xGB 'limit' on the size 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

    July 12, 2012 at 6:51 am

    #1512022

  • RE: Switching from full recovery model to simple on logshipping DB

    GilaMonster (7/12/2012)

    Your log shipping will break and you will need to take a full or differential backup on the primary, copy that to the secondary and restore it before 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

    July 12, 2012 at 4:39 am

    #1511970

  • RE: sql server 2008 backups of transaction logs taking longer and longer

    What's the script you use to take log backups.

    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 12, 2012 at 3:16 am

    #1511930

  • RE: Adding data & index file best pratices?

    First question, why are you splitting the files apart?

    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 12, 2012 at 3:13 am

    #1511929

  • RE: Switching from full recovery model to simple on logshipping DB

    Your log shipping will break and you will need to take a full or differential backup on the primary, copy that to the secondary and restore it before you will...

    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 12, 2012 at 3:12 am

    #1511928

  • RE: Database mirroring is disabled by default; need trace 1400

    You're running SQL 2005 RTM. Patch to SP4.

    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 12, 2012 at 2:57 am

    #1511921

  • RE: Are the posted questions getting worse?

    SQLRNNR (7/11/2012)

    GilaMonster (7/11/2012)

    Some students clearly don't have enough work...

    Speaking of which, do you want some of my work and deadlines?

    I said some students, not referring to self.

    Lots of deadlines have...

    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 11, 2012 at 2:14 pm

    #1511793

  • RE: Are the posted questions getting worse?

    Some students clearly don't have enough work...

    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 11, 2012 at 2:08 pm

    #1511785

  • RE: SQL Server Performance Troubleshooting - Wait Stats

    It's the type of the wait in all cases.

    When a process has to wait for a resource, it gets a matching wait type (waiting for locks gets a lock wait,...

    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 11, 2012 at 11:51 am

    #1511714

  • RE: DBCC CheckDB Errors 8992, 8954, 8989

    wampiah (7/11/2012)

    Here is what I did to resolve mine. I've used these steps several times for "check catalog msg 3853".

    Before you start deleting anything please bear in mind that no...

    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 11, 2012 at 9:53 am

    #1511660

  • RE: Default trace to capture what is causing TEMPDB to expand??

    rarara (7/11/2012)

    i guess that it will take some sort of active monitoring, maybe along the lines of the above script but also returning the SP or select statement assosiated 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 11, 2012 at 9:42 am

    #1511645

  • RE: Why have a heap?

    Jim_K (7/11/2012)

    Out of curiosity, are inserts "cheaper" in terms of time for a heap versus a clustered index?

    Maybe a little, but I doubt it. SQL is optimised for tables 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 11, 2012 at 9:41 am

    #1511641

  • RE: Default trace to capture what is causing TEMPDB to expand??

    Probably your best bet is not profiler, but something like this:

    SELECT

    session_id,

    user_objects_alloc_page_count,

    user_objects_dealloc_page_count,

    internal_objects_alloc_page_count,

    ...

    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 11, 2012 at 8:28 am

    #1511583

Viewing 15 posts - 17,671 through 17,685 (of 49,552 total)