Viewing 15 posts - 14,311 through 14,325 (of 22,224 total)
Instead of SSMS or Trace, try using the DMV's.
sys.dm_exec_requests will show open, active requests, not just open connections. If you have an uncommitted transaction, it'll be there.
"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
September 24, 2010 at 9:24 am
Are you getting an error or is there missing/incorrect data?
"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
September 24, 2010 at 9:22 am
So you're saying that the 2008 instance moves more data locally and then processes faster than the 2005 instance...
Are there other differences? More memory, better/more cpu's? Are the connection settings...
"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
September 24, 2010 at 9:21 am
You mean that the exact same amount of data is moved regardless of which side you run the query from? Are you sure that one side or the other isn't...
"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
September 24, 2010 at 9:04 am
GilaMonster (9/24/2010)
Grant Fritchey (9/24/2010)
Based on the info in the spread sheet, it looks like you have out of date statistics. You've got missing stats warnings.Or maybe auto_create_stats turned off?
Yep, absolute...
"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
September 24, 2010 at 9:00 am
You might be able to find a free software that could help you here: http://www.supershareware.com/sql-server-comparison-free/
I'd go for something like that rather than try to write it myself.
Do you have Visual...
"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
September 24, 2010 at 8:06 am
Yep. A linked server query will move all the data across the wire and then perform filtering. You're better off using OPENQUERY to pass the processing to the remote machine...
"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
September 24, 2010 at 8:02 am
First off, nesting views frequently leads to performance problems. I recommend against it.
Based on the info in the spread sheet, it looks like you have out of date statistics. You've...
"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
September 24, 2010 at 8:01 am
Yep 10gb
"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
September 24, 2010 at 7:53 am
You can't segregate the data within a table. If your client has to be completely isolated, then you have to move them to another table. The only other option 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
September 24, 2010 at 7:51 am
You can run it for 24 hours, you just have to be prepared for the fact that you're going to get a whole lot of data. Plan accordingly, run a...
"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
September 22, 2010 at 9:42 am
Bhuvnesh (9/22/2010)
"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
September 22, 2010 at 6:48 am
Brandie Tarvin (9/22/2010)
Grant Fritchey (9/22/2010)
...I think people thought I was a little weirder than usual.
I'm so glad you put those last two words on that sentence. Otherwise, I would feel...
"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
September 22, 2010 at 6:44 am
From Books Online:
Security
In Windows Authentication mode, the user account that runs SQL Server Profiler must have permission to connect to an instance of SQL Server.
To perform tracing with SQL 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
September 22, 2010 at 6:23 am
Bhuvnesh (9/22/2010)
Tara-1044200 (9/21/2010)
the execution plans are choosen differently.
No , view has same exec plan as it has for inner incorporated query.sql optmizer treats both view and query same while analyzing...
"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
September 22, 2010 at 6:20 am
Viewing 15 posts - 14,311 through 14,325 (of 22,224 total)