- #CREATE A UNIQUE INDEX POSTICO INSTALL#
- #CREATE A UNIQUE INDEX POSTICO FULL#
- #CREATE A UNIQUE INDEX POSTICO CODE#
And then I scratched my head and I’m like, what’s the hell a vacuum? So we figured out a really short order. And it happened to be a problem with one of our load tables which wanted a vacuum. Maybe, if I have a good idea of why things happen, you know, but a lot of these, like what happened yesterday, we had 11,000 failures in production, which was just a fun thing to have. Richie Rump: What would we do about job failures? I have no idea…īrent Ozar: So I’m surprised Richie doesn’t Tweet more about – I haven’t looked over to see if he Tweeted, but I’m surprised he doesn’t Tweet more about some of our adventures in production. I mean, you can, but you…Įrik Darling: Yeah, good luck dealing with those.
#CREATE A UNIQUE INDEX POSTICO FULL#
That way, at least when you have those jobs run, you have to be really mindful about detecting if it’s the primary or the secondary because you can’t just have things running full sail everywhere. Just be really careful when you sync them around from one place to another.Įrik Darling: And if you’re really changing jobs that frequently then you probably just want to have a separate server that holds all the jobs and points them at the stuff in your AG or log shipping or mirroring environment.
#CREATE A UNIQUE INDEX POSTICO CODE#
Maybe you have some jobs that only are supposed to run on the primary and you didn’t code in any detection to see whether or not it’s the primary. But you’ve just got to be aware that if you make a change to a job and that job gets synced automatically to every other server – maybe your event paths are different, like the places where you store files. I look at this as one of those things where a third-party vendor should totally step in and do. We all know the quality of those freebie blog posts.īrent Ozar: We’re not saying anything about Jonathan’s we’re saying this about our own as well. Not that I expect him to keep it up to date either because it was a freebie for a blog post, you know. I don’t know that it’s been updated in a while. The only thing is that post is from 2013. I was going to say Kehayias has a syncing job script…Įrik Darling: I just stuck that in chat too. I don’t know if dbatools, PowerShell stuff can help out with this maybe.īrent Ozar: That’s true too.
There’s scripts out there that you can run. Every time I make in the primaries, make it the secondary. So yeah, Robert Davis’s sync login script, jobs, I’ve used doing it manually, making sure that my DR server or whatever server is in sync at all times. I think there have been tools over the years that people have released, but I don’t know that there’s much that people are recommending. Tara Kizer: I mean, we know about Robert Davis’s script for syncing logins, but everything else, there isn’t really one tool to sync everything.
You can register to attend next week’s Office Hours, or subscribe to our podcast to listen on the go.ĭon’t miss an episode, subscribe via iTunes, Stitcher or RSS.īrent Ozar: Jason asks, “When it comes to log shipping, are there any solid solutions out there relating to syncing logins and stuff that’s in the system databases?”
#CREATE A UNIQUE INDEX POSTICO INSTALL#
This week, Brent, Erik, Tara, and Richie discuss syncing logins and database data via log shipping, monitoring page life expectancy, cumulative update issues, when to change MAXDOP, doing SQL Server install on AWS, connecting to SQL Server instance on a virtual box from the desktop where the virtual box is running, and what real DBAs drink.
0 kommentar(er)
