Forum Replies Created

Viewing 15 posts - 1 through 15 (of 2,010 total)

  • Reply To: Issues Creating Availability Group

    This issue was resolved.  While the Role was configured to only be owned by certain servers, the FCI inside the Role also needed to have it's resolution is described here:...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • Reply To: Using Availability groups with a named instance

    OK Thanks for the insights.  That was kinda the way I thought this would go, but figured I'd take a chance and bounce it off some other folks.

     

    Thanks again,

    -Luke.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • Reply To: Using Availability groups with a named instance

    Nope, It's no that I don't understand.  I do truly, I've done this a number of times before where I've renamed a traditional FCI.  I understand the computer objects that...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • Reply To: Using Availability groups with a named instance

    Perhaps I wasn't clear.

    @eddie-2 Wuerch, yes what we typically have done in the past with existing FCI's is get everything setup and ready, replicate the data to new instance, then...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • Reply To: Using Availability groups with a named instance

    Thanks for the information.  Yes we'd already taken into account additional disks etc.  It was more a question of how impactful we'd need to be to the connection strings for...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • Reply To: Exec SSIS package from TSQL Agent Job Step

    @dmbaker, thanks for your reply.

    The idea behind making a user an owner of a job follows from the want/need to have users who are not SA's manage their own jobs,...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • Reply To: Using Intel Optane/DAX/PMEM with FCI

    I checked on #sqlhelp and the general feeling was that it either just wouldn't work (no shared resources) and or wouldn't be supported.

    I was thinking about HBP as a use...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • Reply To: Odd Connection / Authentication Errors

    Yes, this was the issue, we just implemented it in the middle of the month and have been monitoring.  There have been no issues since.  We ended up disabling the...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • Reply To: Odd Connection / Authentication Errors

    This in an enterprise class data center, with fully redundant multi core 10Gb Fiber network paths back to the Core switches... The network has been in a rather large state...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • Reply To: Odd Connection / Authentication Errors

    The issue started in earnest the middle of April.  The SPF swap didn't work and our network folks are still seeing packet discards on the switch ports so they are...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • Reply To: Odd Connection / Authentication Errors

    Frederico's suggestion is good, but these are Windows server 2016 servers and or 2012 with up to date patches as of April 2020.

    The large cluster is running on physical machines. ...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • Reply To: Odd Connection / Authentication Errors

    Unfortunately, there was never anything of use in the the Windows Events Logs or even SQL Logs.  The only things we could tie back to the issue were the failed...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • RE: Large Suspect Database

    In the end as we were heading toward the end of the business day, we shut down the instance, deleted the original files, restarted the instance where the database came...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • RE: Adding Old Versioned data to Temporal Table

    Yeah, that's generally what I'm going to try to do. I hadn't really seen much on this on the web and was wondering if I was "just doing it wrong". ...

    To help us help you read this[/url]For better help with performance problems please read this[/url]

  • RE: Importing XML Files into a flat table

    Jeff Moden - Saturday, July 14, 2018 7:16 AM

    Jeff Moden - Friday, July 13, 2018 8:55 PM

    To help us help you read this[/url]For better help with performance problems please read this[/url]

Viewing 15 posts - 1 through 15 (of 2,010 total)