Viewing 15 posts - 11,836 through 11,850 (of 22,224 total)
Sorry for you & your spouses loss Jim.
"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
September 21, 2011 at 11:29 am
Yeah, absolutely. That's the same technology at work in Virtual Restore. It reads the backup like it was a 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
September 21, 2011 at 5:42 am
Nah, no points, don't sweat it.
Basically, you're hitting a situation that's not far removed from parameter sniffing. Your query is better off with an average, sampled, set of values, rather...
"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
September 20, 2011 at 8:34 pm
The thing is, both plans show as having done FULL optimization, so these aren't terribly complex plans. But the costs are very high, and the table scans and RID lookups...
"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
September 20, 2011 at 11:14 am
You've got a GIANT disparity in statistics between the two data sets. One estimates 3.7 million, the other estimates 174. Right there is the main point of difference that I...
"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
September 20, 2011 at 11:01 am
In addition to what the ninja says, you need to check all the fundamentals, server settings, is the memory identically configured, are the cpu's identically configured, do you have 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
September 20, 2011 at 10:57 am
What it does is it gets down into the guts of the backup file and captures the calls between the two, for data & nothing else.The rest of the 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
September 20, 2011 at 10:25 am
Yeah, if it's grinding along, you should be looking as sys.dm_exec_requests for blocked & blocking processes or for processes that are using lots of resources or are waiting on resources....
"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
September 20, 2011 at 9:21 am
It's always hard to know if the estimated values are going to be the same as the actual, but taking it as it exists, 87% of the cost of 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
September 20, 2011 at 9:19 am
Network backups are notorious for poor performance, although this precise behavior is not one I've seen. Generally, you're better off backing up to attached storage and then copying to 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
September 20, 2011 at 9:12 am
Brandie Tarvin (9/16/2011)
Gianluca Sartori (9/16/2011)
WayneS (9/16/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
September 16, 2011 at 12:22 pm
Do a search on the web site here. This question comes up all the time, There are a lot of discussions about it.
I'll suggest two books. First, Itzik Ben-Gan's Introduction...
"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
September 15, 2011 at 6:01 am
I would assume performance for querying is going to start degrading, but honestly, I've never seen a system with 150,000 tables before, so I couldn't tell you when.
I suspect, really...
"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
September 15, 2011 at 5:59 am
Erik Hansson (9/15/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
September 15, 2011 at 5:53 am
I'm at a bit of a loss here. Common and best practices are to split up tables, apply unique constraints, primary key constraints, foreign key constraints and build clustered indexes....
"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
September 15, 2011 at 5:50 am
Viewing 15 posts - 11,836 through 11,850 (of 22,224 total)