Viewing 15 posts - 4,981 through 4,995 (of 22,219 total)
I'm getting here late, but I'm with Gail and Jeff. It sure sounds like the problem is primarily one of query tuning and possibly the cost threshold for parallelism. Change...
"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
March 17, 2016 at 3:44 am
joshdbguy (3/15/2016)
Grant Fritchey (3/15/2016)
"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
March 15, 2016 at 9:57 am
If you're designing the database, focus first and foremost on the clustered index. Make sure that it is the right choice (and big hint, the primary key is not always...
"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
March 15, 2016 at 8:35 am
Not enough info to go on. Trace, or extended events, is the way to go to capture the queries that are being called. The real question is, is the server...
"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
March 15, 2016 at 6:28 am
What the other people have said...
CXPacket is only a concern if you also see other CPU waits. The one thing I will say, sight unseen, if your Cost Threshold for...
"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
March 15, 2016 at 4:53 am
I doubt there's a document to support that. It's a bad estimate. I've successfully run 200gb databases on servers with 16gb of memory. It really depends on the load on...
"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
March 14, 2016 at 3:22 pm
Andy Warren (3/14/2016)
"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
March 14, 2016 at 9:15 am
Gary Varga (3/14/2016)
Grant Fritchey (3/14/2016)
robert.sterbal 56890 (3/14/2016)
DBAs are somewhat reactionary in technology adaptation.That being said, are there any market share reports on the adaptation you are talking about?
I've seen...
"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
March 14, 2016 at 8:21 am
robert.sterbal 56890 (3/14/2016)
I guess I'd want to know who they are competing with as well.
Everyone. But primarily Amazon. They're the other big player in hosted services.
I can't tell if Microsoft...
"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
March 14, 2016 at 8:19 am
kradi (3/14/2016)
Please, can you share links for trial deployment tutorials
There are free trials available: https://azure.microsoft.com/en-us/pricing/free-trial/
If you have an MSDN license, you have up to $150 of credit, monthly, to experiment...
"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
March 14, 2016 at 8:17 am
robert.sterbal 56890 (3/14/2016)
DBAs are somewhat reactionary in technology adaptation.That being said, are there any market share reports on the adaptation you are talking about?
I've seen some, but none 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
March 14, 2016 at 7:28 am
There are a lot of moving parts here, especially with the introduction of VMs into the mix. You're going to have to go through the settings on the servers, look...
"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
March 14, 2016 at 7:04 am
Agreed. COPY_ONLY is of use with DIFFERENTIAL backups. If you're not using DIFFERENTIAL, then there's no need to use COPY_ONLY. It won't do anything for you.
Instead, the QA process...
"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
March 11, 2016 at 6:15 am
Yeah, I think this could make a good presentation. A DR process with little, or inadequate, documentation is going to fail.
"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
March 11, 2016 at 6:10 am
This is going to be an utter disaster taking this approach.
Generated code is fine, to a point. However, it needs to be generated with actual logic behind it. I'd...
"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
March 11, 2016 at 6:09 am
Viewing 15 posts - 4,981 through 4,995 (of 22,219 total)