Viewing 15 posts - 14,221 through 14,235 (of 22,224 total)
Tim Parker (10/1/2010)
SQL Server by default should be in pessimistic mode, which should give you the behavior you're looking for without table hints.
True but, they've got snapshot isolation going, 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 1, 2010 at 12:04 pm
If they can access row versions through snapshot isolation, you're kind of in trouble. In fact, that's the whole idea of setting up snapshot isolation, allowing access to data while...
"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 1, 2010 at 9:07 am
What do the execution plans look like? Just because you put an index on the tables doesn't mean it's being used.
Also, pulling 35000+ rows out of the db in...
"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 1, 2010 at 9:02 am
Tim Parker (10/1/2010)
We were fortunate that our Senior DBA was monitoring this server during the time frame of that exception. He was not seeing any CPU pressure during...
"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 1, 2010 at 8:48 am
Steve Jones - Editor (10/1/2010)
Grant Fritchey (9/30/2010)
Come on over to my house. I need wood split.
Isn't that your "white oak therapy" time?
Ha! No man, not while swinging a maul or...
"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 1, 2010 at 8:46 am
Ronnie_Doggart (10/1/2010)
CREATE TABLE [dbo].[IMPORTINSTVERSION](
[INSTANCEID] [numeric](18, 0) NOT NULL,
[IMPORTNAME] [varchar](50) NOT NULL,
[IMPORTBUNDLEID] [numeric](18, 0) NOT NULL
)
The procedure does not generate the exceptions on other customer databases, just 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
October 1, 2010 at 8:29 am
You're right. Is IMPORTINSTVERSION a UDF possibly?
It's odd that such a simple, straight-forward proc is getting cache misses. Unless I'm missing something, that should be sitting in cache waiting for...
"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 1, 2010 at 8:21 am
That's basically a hardware issue and means that your processors are maxed out. In terms of waits to monitor for a situation like this? CXPACKET & SOS_SCHEDULER_YIELD are indications of...
"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 1, 2010 at 8:18 am
16954 is related to cursors. Do you have one within the procedure? If so, something is going south with it.
"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 1, 2010 at 8:07 am
The Dixie Flatline (10/1/2010)
Is anyone else having trouble posting this morning?Steve, I have an answer for the OP in this thread and it won't post my reply.
Not that I've noticed,...
"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 1, 2010 at 8:02 am
Yeah, use the shrink file function, not shrink database.
"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 1, 2010 at 7:43 am
The number of rows being returned is different, so the second plan is getting a seek and a key lookup instead of a scan. Personally, I wouldn't be happy 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
October 1, 2010 at 6:04 am
Yeah, it is a setting within SSMS that allows you to display varying amounts of large data fields (text, VARCHAR(MAX), etc.) but only up to a limit. Past, I think,...
"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 1, 2010 at 6:01 am
Well, you might not be able to, but if you use a stored procedure and match the parameters to the columns in terms of data type, you should be able...
"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 1, 2010 at 5:59 am
But, you really don't want to shrink your log over & over. If you had one abnormal set of transactions that caused it to grow, maybe, but if it's because...
"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 1, 2010 at 5:28 am
Viewing 15 posts - 14,221 through 14,235 (of 22,224 total)