Viewing 15 posts - 12,826 through 12,840 (of 22,219 total)
Lynn Pettis (4/5/2011)
Grant Fritchey (4/5/2011)
Brandie Tarvin (4/5/2011)
Grant Fritchey (4/5/2011)
"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
April 5, 2011 at 11:28 am
Brandie Tarvin (4/5/2011)
Grant Fritchey (4/5/2011)
"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
April 5, 2011 at 9:05 am
It's not a trace. It's a traceflag. Totally different issue. No. It won't affect performance. You need it to understand deadlocks, otherwise you're just guessing. Here's the BOL entry 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
April 5, 2011 at 6:46 am
Brandie Tarvin (4/5/2011)
GSquared (4/5/2011)
Jack Corbett (4/4/2011)
Roy Ernest (3/31/2011)
Out of Curiosity, isnt 90K US or 80K Euro the normal salary for a Sr. DBA?
Definitely depends on region AND size of 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
April 5, 2011 at 6:42 am
With just that information, you can't. You need to have trace flag 1222 enabled and then a full set of information about the deadlock, including both the victim and 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
April 5, 2011 at 5:29 am
SQLHeap (4/4/2011)
If I were to restore a DB from production to any other server, would the execution plans and statistics come with the prod backup?
Yes, on the statistics, no, 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
April 5, 2011 at 5:25 am
Can you try using restricted user instead of single user? I've seen applications that constantly refresh their connection so they can squeek in before you start the restore.
"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
April 5, 2011 at 5:17 am
forsqlserver (4/5/2011)
Is there any free tool but good also?:hehe:
Yes.
Performance Monitor comes free with every instance of windows. You can combine that with the Dynamic Management Objects within SQL Server and...
"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
April 5, 2011 at 5:15 am
Gianluca Sartori (4/5/2011)
kstjacques (4/4/2011)
"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
April 5, 2011 at 5:13 am
Grubb (4/4/2011)
Craig Farrell (4/4/2011) SELECT * FROM master..sysprocesses.
Thanks, Craig. The problem with that is that the query only runs ~400 ms. Do you know of 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
April 4, 2011 at 6:55 pm
Grubb (4/4/2011)
Grant Fritchey (4/4/2011) since "slow" in this case is 300ms
Tell me about it. Not a good one to really cut my teeth on.
The Tuning Advisor recommended my covered...
"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
April 4, 2011 at 11:20 am
It absolutely could be parameter sniffing, yes, but it also could be contention on resources. Does the table have inserts, updates or deletes that occur? If so, you might be...
"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
April 4, 2011 at 10:16 am
Reinforcing what Gianluca said, Red Gate's SQL Monitor really is an excellent choice for monitoring servers and the price is very reasonable. If you want to, you can actually play...
"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
April 4, 2011 at 10:11 am
Even if you place it in single user mode, if you're connected to that database or another connection is there, it might still be active when you try to run...
"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
April 4, 2011 at 6:33 am
Abrar Ahmad_ (4/4/2011)
Do DMV/Fs provide "Actual Execution Plan" or "Estimated Execution plan" specially Sys.DM_exec_Query_Plan?
Logically it should be "Actual Execution Plan" rather than "Estimated...
"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
April 4, 2011 at 6:09 am
Viewing 15 posts - 12,826 through 12,840 (of 22,219 total)