Forum Replies Created

Viewing 15 posts - 1,381 through 1,395 (of 49,552 total)

  • RE: SQL server 2014 is very slow

    Are those the waits over max an hour of busiest time?
    Or is that just an unfiltered query again os_wait_stats?

    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

    May 29, 2017 at 4:00 am

    #1944474

  • RE: Script to Determine SQL Server Version and if the patch level is still in support for large estate

    The thing is, such a script would have to be updated frequently. Probably best if you check the MS sites for what the current  supported patches are, then write 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

    May 29, 2017 at 3:30 am

    #1944470

  • RE: SQL server 2014 is very slow

    I didn't say look at the queries currently executing, and are those the waits over max an hour of busiest time? Can you filter the meaningless waits out and post...

    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

    May 29, 2017 at 1:19 am

    #1944465

  • RE: need help with Invoice summary query

    acmedeepak - Sunday, May 28, 2017 11:59 PM

    Hi Eirikur Eiriksson,
    Can you please help me...

    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

    May 29, 2017 at 12:15 am

    #1944460

  • RE: How to create backup using Mdf and ldf files to another location

    poornima.s_pdi - Sunday, May 28, 2017 8:13 PM

    Yes I am taking Database offfline and detaching from DB then I copy MDF,LDF files...

    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

    May 28, 2017 at 11:14 pm

    #1944458

  • RE: "Logon failure: unknown user name or bad password" - analysis project

    Please note: 10 year old thread.

    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

    May 28, 2017 at 11:06 pm

    #1944457

  • RE: Going all solid state drives - latch timeout - large buffer cache

    Indianrock - Saturday, May 27, 2017 7:55 AM

    Ok that's what I thought.   So with that being near 100% ( except sometimes...

    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

    May 27, 2017 at 8:06 am

    #1944418

  • RE: Going all solid state drives - latch timeout - large buffer cache

    So you're saying buffer cache hit rates near 100% do not indicate sql is able to get most data from memory?

    That's exactly what it indicates.  It's what...

    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

    May 27, 2017 at 7:36 am

    #1944415

  • RE: insert into identity column with out identity insert

    If you want to specify the values for the identity column, you need to set IDENTITY_INSERT on for that table. If you want the identity to automatically assign the values,...

    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

    May 27, 2017 at 7:00 am

    #1944412

  • RE: SQL server 2014 is very slow

    Nope, nothing useful there.
    Most of those counters are only useful if you know what normal is for that server and workload and are looking for the difference from normal.

    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

    May 27, 2017 at 6:43 am

    #1944411

  • RE: Going all solid state drives - latch timeout - large buffer cache

    Indianrock - Saturday, May 27, 2017 6:16 AM

     whether to limit sql to a small amount of memory or empty the buffer cache...

    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

    May 27, 2017 at 6:38 am

    #1944410

  • RE: SQL Licensing Standard vs Enterprise

    bobba - Friday, May 26, 2017 7:54 AM

     (over-provisioning of physical cores to virtual processors) .

    There's easier ways to cripple server performance, 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

    May 26, 2017 at 8:18 am

    #1944325

  • RE: Is it possible to restore to a point in time by starting with current db and rolling back t logs?

    No.

    You need to start with a full backup from before the table was dropped and roll forward.

    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

    May 26, 2017 at 6:04 am

    #1944311

  • RE: Finding the cause of blocking between processes

    julian.fletcher - Thursday, May 25, 2017 12:26 PM

    Presumably there's no easy way of immediately determining what that other statement is - we...

    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

    May 25, 2017 at 2:14 pm

    #1944271

  • RE: Are the posted questions getting worse?

    xsevensinzx - Thursday, May 25, 2017 6:59 AM

    Figured I post this here.

    One of my co-workers went out to PyCon this past week....

    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

    May 25, 2017 at 11:57 am

    #1944242

Viewing 15 posts - 1,381 through 1,395 (of 49,552 total)