Viewing 15 posts - 5,296 through 5,310 (of 22,219 total)
It's down to disks and controllers. If you're separating storage onto multiple physical locations (and I use that word because if you're on a SAN, using LUNs, and those 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
December 14, 2015 at 11:48 am
Dougieson (12/14/2015)
So, if we can safely assume you are using SQL Server 2014 (cause you...
"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 9:07 am
I do feel for the person. They seem so desperately over their head and quite ill-equipped to deal with that fact, let alone all the other crap that's coming their...
"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:28 am
1) Yeah, possibly. Hard to say without seeing the execution plan and wait statistics. I'd for sure collect those to understand what's happening here.
2) No, the COUNT(*) is a fine...
"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:25 am
Check the error logs on the primary and the secondary to see what the issue is. Look to the wait statistics on both to understand if it's just a simple...
"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:12 am
I'm with Perry. AG is superior in every possible way except the licensing costs.
"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:10 am
shamshad.ali (12/14/2015)
Sorry for asking this, as I wanted to get the idea from those who used...
"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:09 am
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
Viewing 15 posts - 5,296 through 5,310 (of 22,219 total)