Viewing 15 posts - 211 through 225 (of 22,202 total)
Still sounds like a monitoring solution looking at stuff, especially since it's against every database.
June 19, 2024 at 5:24 pm
Turn on query monitoring (Extended Events first, Query Store second, DMVs third, ignore everything else) and see what queries are being run on the system. Done.
June 19, 2024 at 11:53 am
Nope. That information isn't provided from AWS. You get what they give you, and that's it. Sorry to be the bearer of sad tidings. However, the information they do give...
June 19, 2024 at 11:50 am
If you're not already doing security patches/fixes on a regular basis, you need to change your ways.
TRUTH!
June 19, 2024 at 11:49 am
I'd start with the login. Which one is running the query? That'll give you a lot of information. It looks like a monitoring query. It might be SentryOne itself. If...
June 19, 2024 at 11:48 am
This is a tough process. First up, testing is your buddy. Plan to test your queries, a lot, before you just disable indexes willy nilly. Next, small changes. Only take...
June 19, 2024 at 11:44 am
This is a tough process. First up, testing is your buddy. Plan to test your queries, a lot, before you just disable indexes willy nilly. Next, small changes. Only take...
June 19, 2024 at 11:44 am
Are you getting more and more data? If so, that's the challenge (note, not a problem or an issue, just something you have to deal with). And yeah, it may...
June 19, 2024 at 11:39 am
Perry Whittle wrote:anyone finding the posts in last couple months are real Facepalmers
You should start a thread about that 😉
Oooh, that's a good idea.
June 19, 2024 at 11:33 am
I truly hate hearing the term applied to me. I simply don't believe it. Can't. It's just not true. However, it does happen. And oh boy, you can see the...
June 1, 2024 at 12:08 pm
The new kids prefer the term data engineer over DBA. Work & responsibilities are the same, but they really don't like the DBA moniker for some reason.
June 1, 2024 at 11:21 am
Well, I'll be there. Causing trouble. Saying stupid stuff. You know, the usual.
May 29, 2024 at 11:01 am
I see a day coming, and soon, where the work that today is done by a junior, or even a mid-level, DBA, will be readily replaced by AI. My concern...
May 19, 2024 at 8:47 am
Following on to what Steve said, when I'm doing sales & support work at Redgate, talking to clients, they'll say something like "You should do this with Product X". My...
May 14, 2024 at 4:50 pm
Nope.
"The name of the secondary database must be the same as the name of the primary database."
May 10, 2024 at 1:15 pm
Viewing 15 posts - 211 through 225 (of 22,202 total)