The number of files TempDb has will affect the performance of your SQL server. Often times, and prior to SQL 2016, adding files to TempDb is the proper course of action. In SQL 2016+, the SQL installer correctly adds the number of files to core ratio – at least
I’m working on setting up an upgrade/migration, and one of the tools I have embraced of late is Multiserver jobs for easy(ier) job administration, especially when it comes to Availability Groups. I was growing impatient and frustrated with trying to keep multiple jobs in sync in just one Availability Group
Here’s a quick post to remind myself and others, to check ALL of the permissions when working with replication. For the past couple of days, I’ve been working on getting transactional replication set up between a couple of servers in between other projects I’ve been working on. For the last
This week I got asked to help a developer figure out why a failover wasn’t working on a Postgres cluster. Interesting enough I guess. Especially because I don’t know anything about Postgres. Good time to learn I guess? I don’t know. Anyway, I accepted the directive and started trying to
A while back I was working on setting up a new Availability Group (AG), which required working with tempdb. It was a bit of an advanced setup in the sense that it was a five node cluster. Four of the nodes set up in a standard AG – two active/passive