Viewing 15 posts - 12,826 through 12,840 (of 22,224 total)
It sounds like you're experiencing what is known as bad parameter sniffing. There are several ways to fix this before you get to plan forcing. That should be the last...
"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:47 am
Lots can go wrong. Upgrading away from 2000 can be quite dangerous. It really depends on what kind of code was written against the 2000 server and how it was...
"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:44 am
Rich-403221 (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:42 am
I don't know that there is a single best practice, but in general I would advocate for having a service account for SQL Server and have the jobs owned by...
"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:37 am
Stefan Krzywicki (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:33 am
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
Viewing 15 posts - 12,826 through 12,840 (of 22,224 total)