Viewing 15 posts - 11,836 through 11,850 (of 22,227 total)
Scripting would be the only way I'd consider it. Even if you just backup & restore msdb to the other server (which won't work), you still need to deal 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
September 22, 2011 at 4:20 am
Assuming you want to minimize downtime, you might want to look into setting up log shipping so that you can get the TB worth of data moved over and only...
"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 22, 2011 at 4:17 am
It really depends on the size of the company and your disaster recovery plan. My former employer was rather large. We had an offsite facility, several hundred miles away 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 22, 2011 at 4:15 am
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
Viewing 15 posts - 11,836 through 11,850 (of 22,227 total)