Viewing 15 posts - 10,771 through 10,785 (of 22,224 total)
I usually just set the database to restricted_user (assuming I've got proper control of the server and everyone isn't logging in as 'sa') and use WITH ROLLBACK IMMEDIATE set. But...
"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
June 14, 2012 at 7:40 am
That is a weird one. I think I'd open up a Connect item. Since the raw data is coming from Microsoft metrics using Microsoft tools, surely they need to provide...
"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
June 14, 2012 at 7:38 am
Not sure. It's not something I've seen elsewhere. There aren't any huge, general, performance improvements between 2005 & 2008, but there are no huge performance degradations that I've seen either....
"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
June 14, 2012 at 7:34 am
Koen Verbeeck (6/14/2012)
Kiara (6/14/2012)
"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
June 14, 2012 at 7:23 am
Kiara (6/14/2012)
"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
June 14, 2012 at 6:56 am
Don't pull the indexes. That would be bad.
I'm with the others, putting an index on the FKs is a good idea. In fact, you might want to try changing the...
"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
June 14, 2012 at 6:50 am
Just to narrow it down for you a bit, memory management is primarily predicated on the OS, not SQL Server. So a 32-bit OS with a 64-bit SQL server, the...
"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
June 14, 2012 at 6:47 am
No, that's almost the opposite of what I see in most cases. Usually PLE is a constantly increasing value which suddenly drops to near zero once a day or once...
"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
June 14, 2012 at 6:43 am
It's not just the sorts though. You're scanning hundreds of millions of rows. The sorts are making things worse, yes, but the sorts are setting you up for merge joins,...
"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
June 14, 2012 at 6:40 am
Timeouts might be from blocking during the rollback of transactions that were selected as a victim of deadlocks, but I'm with Gail, it's likely just standard blocking. Deadlocks are both...
"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
June 14, 2012 at 6:35 am
Validate the settings are basically the same between both servers. Enable the 'Optimize for Ad Hoc Workloads' option on your server. That frequently helps ORM apps. Possibly look at using...
"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
June 14, 2012 at 6:27 am
GilaMonster (6/14/2012)
Please start a new thread for your problem, don't hijack someone else's. On the main forum page there's a button at the top 'Add Topic'
Actually, if you look up,...
"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
June 14, 2012 at 4:40 am
Daxesh Patel (6/13/2012)
I would create New table ahead of time with partitions...
"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
June 13, 2012 at 8:52 am
DZN61 (6/13/2012)
My table value functions (both inline and multistatements) returns about 500 rows...
For what I have understood from your statement is this is not foreseen 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
June 13, 2012 at 6:33 am
Whoa! That's cool. You have 9.9 billion rows being aggregated down to 12. I think you need to put filters in place, a WHERE clause, to limit the number of...
"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
June 13, 2012 at 6:31 am
Viewing 15 posts - 10,771 through 10,785 (of 22,224 total)