Viewing 15 posts - 8,746 through 8,760 (of 22,219 total)
Jack Corbett (3/7/2014)
"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
March 8, 2014 at 4:00 am
Well, it's not really simple. The issue is, you shouldn't be seeing locks held like that. It means the system is improperly put together. Not helpful I realize, but, 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
March 7, 2014 at 12:47 pm
suneel kamavaram (3/7/2014)
This may help
So, correct me where I'm wrong, but doesn't that just address deadlocks? The situation we're in here is not deadlocks, but blocks. Totally different. Unless I'm...
"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
March 7, 2014 at 12:28 pm
The only way you can do that is to somehow filter that out of your UPDATE query using the WHERE clause. There's nothing in the system that lets you update...
"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
March 7, 2014 at 12:16 pm
The only reason, other than outright compatibility issues, is price.
The licensing costs for SQL Server 2012 are different than 2008R2 and less. For most situations I've seen, they're more. 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
March 7, 2014 at 11:56 am
When SQL Server takes an exclusive lock, which it must have in order to maintain data integrity when modifying data, there is no way for any other process to get...
"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
March 7, 2014 at 11:53 am
SQLRNNR (3/7/2014)
SQL Guy 1 (3/7/2014)
Question: if my database files sit all on one drive, will my query benefit from parallelism (even if query cost > threshold)?
Yes you could benefit...
"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
March 7, 2014 at 10:41 am
When you add a row to a table that has an index, the index has to be updated to reflect the new value added. When you modify a value that...
"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
March 7, 2014 at 6:59 am
CXPACKET waits in and of themselves are no big deal. They're just indications of parallelism occurring within your system. Now, you may be seeing parallelism for some queries that are...
"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
March 7, 2014 at 6:53 am
You might want to take a look at this article I wrote in SimpleTalk. It goes through how to retrieve versioned data[/url] from the table. Assuming you can identify 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
March 7, 2014 at 3:41 am
Right there with Gail. This is something I'd test the heck out of this before I got anywhere near production. It's far too big a change to do it any...
"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
March 7, 2014 at 3:36 am
Sqlsavy (3/7/2014)
How to reduce fragmentation <30?
IndexTypeavg_fragmentation_in_percent
CLUSTERED INDEX 97.67442
CLUSTERED INDEX...
"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
March 7, 2014 at 3:27 am
sqlbuddy123 (3/6/2014)
Rebuild index doesn't update all the statistics. It updates only index statistics. Column statistics that are not part of index are not updated.
True, but we know they 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
March 6, 2014 at 6:00 pm
It's hard to know for sure, but on a guess, statistics. I'll bet they're not being well maintained on either machine. Minimum, start with sp_updatestats. After that, you may find...
"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
March 6, 2014 at 4:28 pm
For a quick hit, I agree with Lowell, pull information out of the cache. You can see what's going on there. For longer term though, you need to look into...
"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
March 6, 2014 at 4:23 pm
Viewing 15 posts - 8,746 through 8,760 (of 22,219 total)