Viewing 15 posts - 17,221 through 17,235 (of 22,219 total)
RBarryYoung (6/12/2009)
Does anyone know of any...
"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 12, 2009 at 5:26 am
Jeffrey Williams (6/11/2009)
Grant Fritchey (6/11/2009)
I'd suggest getting the DBCC run first. If there are problems with the database, you want to know prior...
"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 11, 2009 at 1:45 pm
Nope.
This is a side-by-side test between Profiler & server-side traces by Linchi Shea. The difference is not to be sneezed at.
When the Profiler GUI runs, it attaches a memory latch...
"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 11, 2009 at 11:18 am
You will see contention between these two processes.
I'd suggest getting the DBCC run first. If there are problems with the database, you want to know prior to running backups.
"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 11, 2009 at 11:12 am
vaxn8r (6/11/2009)
"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 11, 2009 at 9:32 am
No, I'm sorry. I didn't mean upgrade to SQL Server 2008. I meant upgrade to the GDR. I don't think there's any cost associated there. The functionality improvements in 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 11, 2009 at 9:15 am
The GDR is for 2008, but it changes the tool pretty radically in terms of deployment. It works great with 2005. I'd go for it if I were you.
I just...
"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 11, 2009 at 9:04 am
Yeah, I'd make sure you've got the SP for VS installed, but also, I'd strongly recommend getting the GDR version, which I think also has a service pack. It eliminates...
"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 11, 2009 at 8:42 am
Without knowing what your query is doing and what your structure looks like, it's just not possible to answer this question.
If you can, please post the query, the actual execution...
"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 11, 2009 at 8:26 am
Well, you can also see if a lock has an outstanding convert request inside sys.dm_tran_locks. That's an indication of lock escalation. Once the lock is escelated though, you won't see...
"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 11, 2009 at 8:23 am
I'd use a server-side trace. If you're unsure how to put them together, you can use Profiler to build the scripts for you after you use the GUI to define...
"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 11, 2009 at 6:52 am
I have to agree with Hans here. You may need to maintain logic in more than one location simply because you can't have a single solution for all problems. As...
"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 11, 2009 at 6:32 am
You're going to have to implement a code solution, not try to control locking. Here's a rough outline of an approach. You add two columns, call them InUse and UserID...
"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 11, 2009 at 6:28 am
WayneS (6/10/2009)
A reader of my article today asked a very good question that I'm not sure what the answer would be. I'm hoping that someone along the likes 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 11, 2009 at 6:20 am
t_king (6/11/2009)
"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 11, 2009 at 6:15 am
Viewing 15 posts - 17,221 through 17,235 (of 22,219 total)