Viewing 15 posts - 16,636 through 16,650 (of 22,219 total)
That's almost 180 degrees away from what people usually complain about, how NVARCHAR slows things down because it's bigger than VARCHAR. Bob probably hit the answer with parameter sniffing. What'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
August 31, 2009 at 1:04 pm
I agree with Steve. When you go in to have the conversation, one of the easiest ways to inform them of activity lulls is to capture user connections 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
August 31, 2009 at 6:51 am
Maybe not the greatest approach to the solution, but you could just add WITH MAXRECURSION = 365 query hint. Recursion is limited to ~32,000 calls.
"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
August 31, 2009 at 6:48 am
We've got different thresholds for different servers. Personally, I'd say yours are too high if it's for an OLTP system. 60 seconds is a really long time (or should 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
August 31, 2009 at 6:31 am
There are further error messages available. With only this, it's impossible to tell you what the problem is. It could be almost anything.
"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
August 31, 2009 at 6:28 am
I'd suggest picking up a book like Itzik Ben-Gan's "Inside SQL Server T-SQL Querying" or Joe Sack's "Transact -SQL Recipes." You'll get a lot more concentrated information than from 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
August 31, 2009 at 6:24 am
Just to pile on a bit, a well designed system may have 30 or 40 people calling a single stored procedure at the same time with very few issues. Relax...
"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
August 31, 2009 at 6:20 am
Assuming correct data in the parameters you're passing, this should update the data in the table. So, the problem has to exist elsewhere. What kind of trigger do you have...
"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
August 31, 2009 at 6:18 am
It depends on your system, the business requirements, the types of transactions... There's no one right answer. I manage systems that if I saw blocks going past 10 seconds I'd...
"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
August 31, 2009 at 6:14 am
That's a huge topic and one that you're unlikely to get a complete answer in a post like this. First question, slow as compared to what? From what you're saying,...
"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
August 31, 2009 at 6:12 am
I'm not logged in from home, putting in extra time, working on extra projects and especially I'm not cruising the boards at SSC... CRAP!
"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
August 29, 2009 at 2:46 pm
You guys are all getting about 20 people per meeting. We're getting ready to start our fourth year and still only have about 10 per. It's tough.
"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
August 29, 2009 at 2:31 pm
Roy Ernest (8/28/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
August 28, 2009 at 3:45 pm
Lynn Pettis (8/28/2009)
Anybody else get an email via SSC from pboyall969@xxxxxxxxxx requesting help to purge all the tables in a database?
Not yet. They must know who the nice people are.
"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
August 28, 2009 at 8:32 am
Steve S (8/28/2009)
I was thinking about an 'Active\Active' clustering...
"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
August 28, 2009 at 7:57 am
Viewing 15 posts - 16,636 through 16,650 (of 22,219 total)