Viewing 15 posts - 1,096 through 1,110 (of 22,189 total)
I'm having the same problem time-wise. As the old saying goes, "So say we all". 😀
I also have to admit there's great incentive in learning something new if you...
October 18, 2021 at 12:23 pm
Thanks Jeff.
Yeah, I'm still at "barely functional" when it comes to PostgreSQL. I made a few fast leaps and then I just haven't been able to carve out time to...
October 16, 2021 at 7:05 am
There really is no easy way to about defining table access. The tools you have can show you the queries that have been run and/or the procedures that have been...
October 13, 2021 at 1:12 pm
Sorry. I was away. Looks like everyone took good care of you. Glad you tracked down the issue.
October 13, 2021 at 4:38 am
You can look at sys.dm_db_wait_stats, note, NOT sys.dm_os_wait_stats, to see network waits from the Azure SQL Database side of things. However, otherwise, you have to measure that from the client.
October 11, 2021 at 11:12 am
Whatever you choose, please, please, OH PLEASE, focus first on clarity and communication. Any other kind of rigid enforcement of some particular little persnickety rule must come second. The purpose...
October 11, 2021 at 4:53 am
Are you initializing the backup file each time, or is the backup file stacking? Try running RESTORE HEADERONLY to see if you're putting multiple backups into a single file....
October 11, 2021 at 4:49 am
Both have a future. Further, "cloud computing" is an insanely vague term, like, "I work with computers". Cloud computing encompasses stuff like cloud-hosted virtual machines, services, up to and including...
October 11, 2021 at 4:45 am
I tried it for a time to see if there was more or better engagement versus Youtube. Kind of sucked actually.
In other news "Oh no, my moribund Twitch account (which...
October 8, 2021 at 1:49 pm
That's a measure you have to do from the client. Azure SQL Database isn't going to see latency on it's end. It's going to get a connection request (however long...
October 8, 2021 at 1:45 pm
Another vote for Extended Events. Safe, as light weight as you can get while still monitoring behaviors on the system.
However, yes, you'll have to set something up in order to...
October 7, 2021 at 11:45 am
Without an error message of any kind, it could be sunspots, extra solar radiation or the vast conspiracy of the Bohemian Grove. We simply don't have enough information to say...
October 7, 2021 at 11:43 am
It's hard to say without a lot more data. Capture query metrics using extended events. Capture wait statistics (you can combine these with the query metrics using extended events so...
October 7, 2021 at 11:42 am
ALWAYS, go to Microsoft for accurate licensing information. They're just going to know better than some knucklehead on the internet, like me.
However, this one I think I can answer accurately...
October 7, 2021 at 11:39 am
I'd argue you'll some some general performance enhancements, but it won't be night & day.
October 5, 2021 at 4:29 pm
Viewing 15 posts - 1,096 through 1,110 (of 22,189 total)