Viewing 15 posts - 5,311 through 5,325 (of 22,227 total)
Welsh Corgi (12/14/2015)
Does anyone have a guide as to what steps should be taken to debug a Log Reader failure?
Start with the logs. Why is the Log Reader failing? Without...
"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
December 14, 2015 at 7:06 am
The backup process runs under the system process on the server where the backup is occurring. This means even when you call it remotely, it's running locally. So, the local...
"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
December 13, 2015 at 7:58 pm
rodjkidd (12/13/2015)
I have a ticket for Marillion in Boston Friday Nov 4th. 🙂
It's a early show - doors at 6.
I then have one for New York the week after....
"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
December 13, 2015 at 7:47 pm
I probably should have followed up. I wrote up the article from this data. It's here at Simple-Talk.[/url]
"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
December 13, 2015 at 9:34 am
After removing lots of data, yeah, I'd probably do index rebuilds. That will also rebuild the statistics, so you don't need to worry about them. Just remember that fragmented 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
December 12, 2015 at 9:18 am
You could avoid DB configurations if you use one of the disk level replication features available from some of the larger disk vendors like EMC. But it's not going to...
"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
December 12, 2015 at 9:17 am
There are a couple of links in my signature below this that I think are useful for performance tuning.
"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
December 12, 2015 at 4:11 am
Oh, I didn't understand that it has to be writeable...
This really doesn't make a lot of sense... at all...
What the heck are they writing to this database that they're willing...
"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
December 11, 2015 at 7:38 am
jevitts (12/10/2015)
I figured that was the case. Thanks for confirming!I've definitely got my work cut out for me... the table in question has 55 indexes. :crazy:
Ow.
The place to start 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
December 11, 2015 at 7:10 am
There's nothing uniquely special about an ODS. It's a SQL Server database that will primarily be used for reporting. I can't think of any special configurations that I've had to...
"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
December 11, 2015 at 7:08 am
Yikes.
Why not simply keep the database unrecovered and continue to apply log files to it every day? Basically build your own log shipping process. It's still subject to utterly breaking...
"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
December 11, 2015 at 7:04 am
I agree with everything Gail says (shocker).
However, if you don't already have a clustered index, then maybe using the same key structure she suggests will make for a good cluster....
"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
December 11, 2015 at 6:59 am
rustman (12/11/2015)
"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
December 11, 2015 at 6:56 am
rodjkidd (12/11/2015)
ThomasRushton (12/11/2015)
rodjkidd (12/11/2015)
ThomasRushton (12/10/2015)
Pity they can't seem to stabilise...
"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
December 11, 2015 at 6:53 am
Eirikur Eiriksson (12/11/2015)
ThomasRushton (12/11/2015)
Grant Fritchey (12/10/2015)
Grant Fritchey (12/10/2015)
BrainDonor (12/10/2015)
Bought this one in Portland - designed to upset as many sci-fi fans as possible - http://fashionablygeek.com/t-shirts/trolling-shirt/
That is beautiful. The sad thing...
"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
December 11, 2015 at 4:57 am
Viewing 15 posts - 5,311 through 5,325 (of 22,227 total)