Viewing 15 posts - 1,126 through 1,140 (of 22,219 total)
My personal challenge workwise is to learn WhereScape and Snowflake to build a warehouse from our two major Health Care systems plus the myriad of one-off systems we have...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 18, 2021 at 12:25 pm
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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....
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
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...
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
October 7, 2021 at 11:39 am
Viewing 15 posts - 1,126 through 1,140 (of 22,219 total)