Forum Replies Created

Viewing 15 posts - 196 through 210 (of 49,552 total)

  • RE: High CPU usage % on master database

    Jeff Moden - Thursday, April 12, 2018 7:17 AM

    Recovery model being set to SIMPLE for the master database would indicate a problem. ...

    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
  • RE: High CPU usage % on master database

    PiMané - Thursday, April 12, 2018 12:09 AM

    Evgeny Garaev - Wednesday, April 11, 2018 7:12 PM

    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
  • RE: Are the posted questions getting worse?

    No music here. Does 3d graphics work as an alternative?

    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
  • RE: Auto shrink Log file.

    -- ignore

    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
  • RE: Are the posted questions getting worse?

    Michael L John - Saturday, April 7, 2018 5:46 PM

    A few weeks back, we were all sharing our "can you top this"...

    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
  • RE: Automatically Create indexes as needed

    steve 96379 - Wednesday, April 4, 2018 7:59 AM

    It actually checks all custom indexes and compares the columns and include columns 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
  • RE: Automatically Create indexes as needed

    This is not a good idea.

    The missing index feature is a great place to start index tuning, but it will result in a lot of near-duplicate indexes (eg...

    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
  • RE: Database corrupt - Msg 8966, Level 16, State 2, Line 1

    Did you try what Eirikur asked?

    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
  • RE: Application Name from Profiler

    Note, it's going to return the same application names, because that's not profiler hashing or anything like that. It's the application passing that guid as the application name in 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
  • RE: Moving Database Objects

    VastSQL - Wednesday, April 4, 2018 2:42 AM

    GilaMonster - Wednesday, April 4, 2018 1:53 AM

    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
  • RE: Database corrupt - Msg 8966, Level 16, State 2, Line 1

    Don't bother with repair, it'll do nothing.

    Got a clean backup?

    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
  • RE: Application Name from Profiler

    VastSQL - Wednesday, April 4, 2018 3:08 AM

    GilaMonster - Wednesday, April 4, 2018 2:33 AM

    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
  • RE: Database too big than .bak

    tmmutsetse - Wednesday, April 4, 2018 3:17 AM

    @Gila the server is ticked to compress backup on server properties.

    There you go then. 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
  • RE: Application Name from Profiler

    Ok, why are you using Profiler on SQL 2014?

    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
  • RE: Application Name from Profiler

    Those are the application names, at least it's what the app is putting into the connection string when connecting. Trace doesn't obsfucate or hash application name.
    Add in the username...

    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

Viewing 15 posts - 196 through 210 (of 49,552 total)