Viewing 15 posts - 4,981 through 4,995 (of 22,224 total)
Since you're updating the table, and the table is the clustered index, no matter what, the cluster is going to be accessed. However, look at the execution plan. If it's...
"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 21, 2016 at 6:44 am
I suspect you have something else going on there. Those statements are SELECT statements. They're not going to be blocking in this fashion. Instead, there must be something taking out...
"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 21, 2016 at 6:41 am
Normally to set up a reporting system you'd look to something like Availability Groups (where you can set up a read_only secondary), log shipping, mirroring, or even replication. These 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
March 21, 2016 at 6:34 am
helper_10 (3/19/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 21, 2016 at 6:28 am
I've never heard of such a thing, no. Unless you've found some kind of very obscure bug, I can almost 100% guarantee that something is being done on that system....
"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 21, 2016 at 6:18 am
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
Viewing 15 posts - 4,981 through 4,995 (of 22,224 total)