Bugs. Natural and inevitable. And probably perpetual.

I didn't trust virtual machines when we first started using them. And, we had problems. Then, over time, they just became a standard. I...

What? My opinion can't possibly be wrong. HA! Totally kidding.

Yeah, hey, honest people can certainly disagree. Without a doubt our experiences and the lessons we get from the vary. It's...

I'm not...

Never mind. AI lied to me. I'm going with my original answer until I find something otherwise.

Hang on. Might have something else. Give me a sec to do an experiment.

Oooh, great question.

I assumed that the best way to do this would be to schedule the start and stop of the session. However, upon investigation, yeah, that is the best...

On  high level, assuming its a new project? what questions you will be asking to the business ? and lets say. I have collected the database size per file...

The only sure way to do forecasting is to measure today, measure next week (or have measured last week), and do some calculations. Redgate Monitor (yes, full disclosure,...

The only sure way to do forecasting is to measure today, measure next week (or have measured last week), and do some calculations. Redgate Monitor (yes, full disclosure, my employer)...

I know, we always want a short cut. I sure do. Let me solve the problem with zero to minimum effort so it's done right now. Easy peasy. I get...

Another 3 followup questions

1 . When do we see index size is greater than actual data size of the table?  is that because of creation of too many non-clustered...

Thank you Grant sir. All I can sense is, this has to be carefully dealt with a proper index performance tuner or consultant.

Just want to ask, is there any...

Still sounds like a monitoring solution looking at stuff, especially since it's against every database.

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.

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...