Viewing 15 posts - 11,821 through 11,835 (of 22,214 total)
forsqlserver (9/22/2011)
Nice Grant...But this is giving the error of invalid arguments...means some invalid...how does it related with plan...
Sorry, you have to be more clear what "this" is.
This works fine...
September 22, 2011 at 4:43 am
Waits stats will show you what processes are waiting on, but you won't see what's up with that single request. Instead, I'd suggest using Dynamic Management Objects (DMOs). You can...
September 22, 2011 at 4:30 am
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...
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...
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...
September 22, 2011 at 4:15 am
Sorry for you & your spouses loss Jim.
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.
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...
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...
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...
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...
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...
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....
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...
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...
September 20, 2011 at 9:12 am
Viewing 15 posts - 11,821 through 11,835 (of 22,214 total)