Viewing 15 posts - 2,791 through 2,805 (of 22,219 total)
And if there was a very short way through this to make most servers run really fast most of the time, I wouldn't have had to write a 900 page...
"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
January 17, 2019 at 6:44 am
poratips - Tuesday, January 15, 2019 8:42 PMThanks for pointing out GDPR and HIPAA, need to check that too
And the CPPA and...
"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
January 16, 2019 at 6:45 am
Not sure the hospital would approve and he hasn't had alcohol in a...
"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
January 16, 2019 at 6:44 am
I'd need to experiment to be sure, but I suspect that the account that SQL Server is running under can't access the blob storage. Focus on security.
"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
January 16, 2019 at 6:17 am
In addition to moving the databases (backup and restore, unless you want to talk third party tooling) and configuring security (which you've received a lot of good advice around), one...
"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
January 14, 2019 at 7:54 am
Yikes. Just glanced back through and spotted this:isnull(c.DBAction, '') != ''
That's another performance killer. You have a ton of tuning opportunities here without even looking...
"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
January 11, 2019 at 8:01 am
"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
January 11, 2019 at 7:56 am
It doesn't matter that you're not an MVP or whatever. You can teach beginners sessions in tech. Do one on backups. WAY too many people are still getting that wrong....
"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
January 11, 2019 at 6:37 am
"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
January 11, 2019 at 6:34 am
Stuff like this is going to kill performance:
convert(int, sessionUpdate.OBJECT_ID / @idRange) = 6
I didn't read every line or go through it all, but...
"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
January 11, 2019 at 6:32 am
You can look to the Extended Events system_health session for some information. There is an event on long running queries that will be in there and might supply you with...
"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
January 11, 2019 at 6:28 am
Except for materialized views (more on that in a moment), a view is just a query. Yes, it looks and acts like it's a table. It's not. It's just a...
"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
January 11, 2019 at 6:22 am
Let anyone do anything in any way that they want to with backups... right after they prove that they can do a point in time restore as easily and quickly...
"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
January 11, 2019 at 6:15 am
Yeah, and you're in "all" and "auto" for the capture... Maybe change the capture mode. Auto only captures queries that are called more than three times or run longer than......
"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
January 10, 2019 at 11:00 am
If you really want to automate this and run it all the time across multiple environments and multiple databases, I'd strongly suggest getting a copy of Redgate SQL...
"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
January 10, 2019 at 7:16 am
Viewing 15 posts - 2,791 through 2,805 (of 22,219 total)