Viewing 15 posts - 1,471 through 1,485 (of 22,219 total)
It's a parallelism deadlock. So, whichever query was involved, it was the only query involved. If you can't see the query from Profiler, you're stuck. Profiler doesn't have a correlation...
"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 12, 2021 at 3:02 pm
"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 12, 2021 at 2:04 pm
I appreciate all the feedback. No arguments from me on any of it. This all really is a balancing act. Getting it to "just right" is hard.
"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, 2021 at 2:23 pm
Each restart, yes, but also failovers, detach/attach, all sorts of variation on that data. It is the one place to try to determine if indexes are in use, but, it's...
"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, 2021 at 12:46 pm
The best way to get detailed information about the behavior of SQL Server is through the use of Extended Events. They are not zero cost, but they are the...
"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, 2021 at 12:43 pm
Yeah, the XML is the easiest way for all involved.
"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 7, 2021 at 4:39 pm
It's two steps. One, gather the info. Two, based on that info, send an alert. So, a rough outline of psuedo-code would be something like:
SELECT COUNT(*)
FROM dbo.mact_data
WHERE dtstamp > (GETDATE()-60);
Then...
"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 7, 2021 at 2:33 pm
Yes. Just grant them read access to the view. Here's the documentation and examples.
"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 7, 2021 at 2:14 pm
I'm not sure what you're looking for in terms of help. Write a query that satisfies the criteria you outlined. Schedule that query to run using SQL Agent. Put an...
"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 7, 2021 at 2:13 pm
Ain't gonna lie, I'm shocked as heck that the optimizer didn't timeout on this query.
The good news, lots of index seeks. The bad news, scattered all over the place, all...
"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 7, 2021 at 1:52 pm
Grant Fritchey wrote:Doggone it. Silly thing took me to an old post on the thread and I responded a second time. Sorry. I'll leave it up.
It's tough getting old.
TRUTH!
"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 6, 2021 at 10:44 pm
Doggone it. Silly thing took me to an old post on the thread and I responded a second time. Sorry. I'll leave it up.
"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 6, 2021 at 7:16 pm
I wonder if the virus was the cause of PASS's demise, or was it the final nail in the coffin?
I hope that it was just the first,...
"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 6, 2021 at 7:14 pm
Looking at the plan, it's calculated columns or constraints. It has to retrieve the data in order to do the validations, so that's why you're seeing a lookup operation.
"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 6, 2021 at 7:01 pm
The execution plan would help a lot.
Also, two different ORDER BY statements going in different directions? Yikes. Maybe... maybe, two indexes ordered in each direction could help performance. That's 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 6, 2021 at 2:57 pm
Viewing 15 posts - 1,471 through 1,485 (of 22,219 total)