Viewing 15 posts - 13,576 through 13,590 (of 22,219 total)
I'd suggest spending time over at Paul Randal's blog. Here's a link to articles on cache over there.
"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, 2011 at 3:30 pm
Try this. Instead of the COUNT statement, use an EXISTS statement. It will perform much better.
IF EXISTS (SELECT * from dbo.tbl_WhateverItWas WHERE Val1 = @Param1 AND Val2 = @Param2)...
Of course,...
"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, 2011 at 3:27 pm
Roy Ernest (1/17/2011)
Lots of people have talked very Ernestly to me regarding being Ernest all the time in everything I do... 😀
It is important to be Ernest.
"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, 2011 at 1:14 pm
Why do you think it's not related to management studio? The queries are retrieiving the amount of space available. Couldn't someone be running one of the standard reports from SSMS...
"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, 2011 at 12:53 pm
Yes and yes.
When you alter a stored procedure, the plan in cache, if there is one, is marked as invalid, so a new one is created the next time...
"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, 2011 at 12:05 pm
You can't access that DMV for a particular database. Best thing you could do would be to run multiple queries against sys.dm_exec_waiting_tasks as your queries are running to determine what...
"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, 2011 at 12:04 pm
I agree. Execution time is one of the most important. Not on your list is one of my other favorites, frequency of call. Your longest running proc may be called...
"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, 2011 at 11:58 am
Do you have some sort of monitoring software? That looks like some sort of standard maintenance script. Check for scheduled jobs or monitoring software.
"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, 2011 at 11:50 am
GilaMonster (1/17/2011)
Koen (da-zero) (1/17/2011)
GilaMonster (1/17/2011)
Was one of the things that contributed to me leaving the bank. The over-paid consultants from Big Named Consulting Company were considered (by upper management) 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
January 17, 2011 at 10:54 am
GilaMonster (1/17/2011)
pdanes2 (1/17/2011)
"It doesn't work" gets little sympathy in these forums
No, because it's near-impossible to offer useful advice for that. When we have some indication what's not working, 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 17, 2011 at 8:47 am
Koen (da-zero) (1/17/2011)
GilaMonster (1/17/2011)
Was one of the things that contributed to me leaving the bank. The over-paid consultants from Big Named Consulting Company were considered (by upper management) to know...
"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, 2011 at 8:46 am
Ninja's_RGR'us (1/17/2011)
"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, 2011 at 7:09 am
LutzM (1/16/2011)
Lynn Pettis (1/16/2011)
And then you have those individuals that won't even ask their DBAs for help because they don't know them personally and are in a different building.
Strange he...
"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, 2011 at 7:00 am
In the merge operation against MalWare, why are you doing this in the select from the temp table:
group by (FullURL + [MalwareGroup]), FullURL, [MalwareGroup]
If you're going to all the trouble...
"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, 2011 at 6:55 am
I looked back through the thread here, but I'm not sure I saw it. What is the recovery setting on the database? Is it set to Full Recovery? If 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
January 17, 2011 at 6:18 am
Viewing 15 posts - 13,576 through 13,590 (of 22,219 total)