Forum Replies Created

Viewing 15 posts - 376 through 390 (of 5,841 total)

  • RE: Always ON with Transactional Replication Issue.

    Search web for a white paper from Paul Randal entitled SQL Server Replication: Providing High...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • RE: Raid SSD

    msimone - Monday, February 27, 2017 8:24 AM

    Hello, thanks for yours answers.
    SQLGuru, i am not worried, my doubt is between raid5 or 6 and...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • RE: Always ON with Transactional Replication Issue.

    kkanaya - Monday, February 27, 2017 4:12 AM

    Dear All,

    We have setup Always ON (Synchronous) between two nodes Server1 and Server2, which works fine as...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • RE: Raid SSD

    msimone - Monday, February 27, 2017 2:46 AM

    Hello, i have a doubt.
    What is the best configuration for a raid with ssd?
    My doubt...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • RE: PLE and BufferPool Contents

    SteveOC - Sunday, February 26, 2017 9:40 AM

    Hello.

    I have been looking at Memory utilisation for some time now, and am looking for a...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • RE: Performance improves after reboot

    RVO - Saturday, February 25, 2017 8:49 PM

    I noticed 
    SQL Full-text Filter Daemon Launcher (MSSQLSERVER) service is running on that machine.
    Do we need...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • RE: Performance improves after reboot

    RVO - Saturday, February 25, 2017 7:20 PM

    TheSQLGuru - Saturday, February 25, 2017 8:56 AM

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • RE: Performance improves after reboot

    RVO - Friday, February 24, 2017 10:06 PM

    Kevin,
    May I please ask you to clarify some of your your comments.

    1) Any time...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • RE: Performance improves after reboot

    sgmunson - Friday, February 24, 2017 3:30 PM

    Hey Kevin,

    Just wondering where I can get my hands on the hardware you used...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • RE: Performance improves after reboot

    1) Any time I see nvarchar(4000) parameters I think ORM, mismatched data types, and a butt-ton of CONVERT_IMPLICITs with their correspondingly horrible performance and concurrency issues.

    2) You clearly...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • RE: Performance improves after reboot

    Your eye is on the wrong ball here. Not sure how long this server has been up, but queries have waited almost ONE FULL DAY PER TEMPDB DATA FILE!!!! You...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • RE: Queries Hung on Memory Request

    I see that someone else has gotten to this before I was able to. Glad you have some improvements.

    BTW, the code and especially data structures are, I'll be...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • RE: Queries Hung on Memory Request

    Stamey - Thursday, February 23, 2017 11:32 AM

    Adding the estimated query plans for two options, 1. Current design, with a join on...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • RE: Performance improves after reboot

    Jeff Moden - Thursday, February 23, 2017 12:56 PM

    adb2303 - Thursday, February 23, 2017 12:46 PM

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

  • RE: Queries Hung on Memory Request

    Can you post the estimated query plan up? We may be able to do something that can force a particular type of query plan that doesn't require a massive memory...

    Best,
    Kevin G. Boles
    SQL Server Consultant
    SQL MVP 2007-2012
    TheSQLGuru on googles mail service

Viewing 15 posts - 376 through 390 (of 5,841 total)