Viewing 15 posts - 9,091 through 9,105 (of 22,224 total)
Alan.B (1/13/2014)
I took a quick look at this and there does appear to be a lot parameter sniffing but there's a lot of other problems too.
I'm confused. Please let...
"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
January 13, 2014 at 3:10 pm
Not sure why you're getting the error without seeing more about how the code, your servers, the connections between them are all configured. But, you are using distributed transactions because...
"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
January 13, 2014 at 12:47 pm
Sean Lange (1/13/2014)
"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
January 13, 2014 at 10:55 am
If you're seeing one set of behavior from SSMS and a different one from SSRS, the possibility could be bad parameter sniffing, but, the way to address that issue is...
"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
January 13, 2014 at 10:53 am
Deadlocks are a performance issue. It's all about the ability of transactions to clear prior to arriving at a deadlock situation. From the sounds of things, you've probably been borderline...
"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
January 13, 2014 at 7:28 am
Again, I'm with Gail. I couldn't even guess. It could be almost anything from bad parameter sniffing to problematic code to missing/incorrect indexes to one query moving a lot more...
"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
January 13, 2014 at 6:28 am
I've been using a 3rd party tool to do that for the last 15 years. Actually, I liked their tooling so much, I went to work for that company about...
"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
January 13, 2014 at 5:04 am
Yep. That's my understanding too. If you need to have a large number of developers using Microsoft tooling, I'd suggest contacting Microsoft directly and negotiate an MSDN license for your...
"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
January 13, 2014 at 4:58 am
Like Gail says, T-SQL is T-SQL. Dynamic T-SQL will prevent some levels of code reuse which can lead to increased CPU use as more and more queries have to go...
"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
January 13, 2014 at 4:57 am
If it's asking for a serial number, you've gone past the 14 day free trial. You can contact sales and request an extension. Otherwise, you'll need to purchase the software.
"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
January 13, 2014 at 4:53 am
No, nor I. Most of the stuff in the error log is pretty self-explanatory and not usually vague. But, if you are looking for a good getting started book 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
January 12, 2014 at 8:48 am
I don't think there is a single right answer to this. I very much believe that you should NOT use the administrative accounts as owners of the databases or 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
January 12, 2014 at 8:42 am
GilaMonster (1/10/2014)
BWFC (1/10/2014)
There is a philosophical question, often kicked around our office, about what happens when two people who know everything have an argument.
I'm sure I've seen that on gaming...
"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
January 12, 2014 at 3:40 am
You have processes that are doing things that use tempdb such as sorts or index rebuilds or something else. You need to identify these processes, figure out how long it's...
"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
January 10, 2014 at 4:15 am
It's a tough problem to solve. There are two sets of tools that could help you out. Microsoft has a deployment tool called SQL Server Data Tools (SSDT). You can...
"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
January 10, 2014 at 4:07 am
Viewing 15 posts - 9,091 through 9,105 (of 22,224 total)