Forum Replies Created

Viewing 15 posts - 10,576 through 10,590 (of 49,552 total)

  • RE: What is a large set of disk managed by a high-performance controller that presents a mount point to various servers across a private network?

    Homework? If so, ask your tutor/lecturer.

    Interview question? If so, the correct answer is "I don't know"

    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

    December 20, 2013 at 12:52 pm

    #1675292

  • RE: What is a large set of disk managed by a high-performance controller that presents a mount point to various servers across a private network?

    Complicated?

    I'm not sure what you're looking for here. What's the context and background for the question?

    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

    December 20, 2013 at 11:59 am

    #1675279

  • RE: Are the posted questions getting worse?

    Jack Corbett (12/20/2013)

    WayneS (12/20/2013)

    I'm curious as to the different ways that you fine folks have seen / dealt with being on-call, and what you perceive the pros/cons 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

    December 20, 2013 at 10:58 am

    #1675253

  • RE: Serious intermittent performance issues

    Jonathan Kehayias (12/20/2013)

    One correction here, RESOURCE_SEMPHORE is execution workspace memory only, associated with hash, sort, bulk copy, or index creation operations. Compile memory is a completely separate resource and...

    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

    December 20, 2013 at 10:21 am

    #1675236

  • RE: Are the posted questions getting worse?

    Grant Fritchey (12/20/2013)

    WayneS (12/20/2013)

    I'm curious as to the different ways that you fine folks have seen / dealt with being on-call, and what you perceive the pros/cons of these are?

    For...

    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

    December 20, 2013 at 10:13 am

    #1675233

  • RE: serious problem with sqlserver service that it can't startup

    Can you post the entire of one of the error logs please

    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

    December 20, 2013 at 10:11 am

    #1675231

  • RE: what this message mean

    It's just asking if you want the changes you made to Management Studio 2008 to be imported into Management Studio 2012.

    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

    December 20, 2013 at 7:53 am

    #1675157

  • RE: Serious intermittent performance issues

    william.rees.howells (12/20/2013)

    Ok so that would indicate that those stored procedures with schema lock waits are trying to modify the schema in some way? This sounds strange because the SPs 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

    December 20, 2013 at 7:49 am

    #1675154

  • RE: serious problem with sqlserver service that it can't startup

    Can you post the entire of one of the error logs that shows the errors?

    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

    December 20, 2013 at 7:06 am

    #1675133

  • RE: Serious intermittent performance issues

    If a process has a Sch-M wait type, then it is waiting to get an Sch-M lock, meaning it is trying to get a schema modification lock and is waiting...

    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

    December 20, 2013 at 6:59 am

    #1675131

  • RE: Database snapshot or read-only copy of the database?

    jasona.work (12/20/2013)

    Will the snapshot therefore have to "grow" to keep track of the changed records so it (the snapshot) stays consistent to the moment it was taken?

    Yes.

    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

    December 20, 2013 at 6:19 am

    #1675116

  • RE: Serious intermittent performance issues

    william.rees.howells (12/20/2013)

    Follow up question what do these wait_resources mean?

    METADATA: database_id = 5 SECURITY_CACHE($hash = 0x2532319d:0x1)

    METADATA: database_id = 9 METADATA_CACHE($hash = 0x3317e3d:0x0)

    Offhand, not sure.

    and also could the compilations cause schema...

    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

    December 20, 2013 at 6:18 am

    #1675115

  • RE: Serious intermittent performance issues

    william.rees.howells (12/20/2013)

    In regards to compilations per second I have just checked and it is currently running at 726 batch requests per second with 32 compilations per second so 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

    December 20, 2013 at 6:16 am

    #1675114

  • RE: What to look for in Execution plans when a query is slow ?

    Lowell (12/20/2013)

    » in an actual execution plan, for any node, if the actual number of rows is orders of magnitude higher than the estimated number of rows, the statistics on...

    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

    December 20, 2013 at 6:08 am

    #1675111

  • RE: What to look for in Execution plans when a query is slow ?

    This may help. http://www.sqlskills.com/blogs/paul/query-plan-analysis-first-steps/

    Also, grab a copy of Grant's Exec plans book, should be lots in there, more than you'll get as forum replies

    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

    December 20, 2013 at 5:52 am

    #1675108

Viewing 15 posts - 10,576 through 10,590 (of 49,552 total)