Viewing 15 posts - 5,641 through 5,655 (of 22,219 total)
diegosiao (8/27/2015)
There is also this free .NET library, which is lightweight and very performatic:
It is a seven year old thread as Gail points out.
But, I have a question, how will...
"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 27, 2015 at 10:45 am
ltibbs (8/27/2015)
What would be the purpose of moving the query capability off of the production server?
Wouldn't that just still require granular permissions that would still apply elsewhere?
Looks like...
"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 27, 2015 at 7:44 am
Monitoring and performance metrics and tuning. Nothing is ever really running fast enough.
"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 27, 2015 at 4:30 am
How are you getting your database objects in and out of TFS? If you're doing it manually, stop.
Microsoft provides a free tool, SQL Server Database Tools. It runs in...
"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 27, 2015 at 4:29 am
I would definitely take a look at that query as a candidate for performance tuning.
"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 27, 2015 at 4:22 am
Why not use the same document? There are changes between 2008 and 2014, but by and large the underlying tool set for monitoring is roughly the same (you should use...
"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 27, 2015 at 4:20 am
SQL Guy 1 (8/26/2015)
Grant Fritchey (8/26/2015)
"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 26, 2015 at 8:53 pm
Also, you say you checked the plan, I mean, did you look at the plan when it's running slow to compare it to when it's running fast. If you're hitting...
"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 26, 2015 at 12:17 pm
I can't know that it'll solve the problem since we're not sure where the contention is coming from. However, I can say with some assurance, it's definitely going to somewhat...
"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 26, 2015 at 12:12 pm
mar.ko (8/26/2015)
Thanks Grant...now I wonder if "someone" sabotaged me.I created a stored proc to reset them to one plus the highest value in the related tables.
Yeah, and no way to...
"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 26, 2015 at 12:10 pm
It suggests an I/O issue. A couple of things could be causing that. First, have you looked at the execution plans when the query is doing more I/O? If they're...
"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 26, 2015 at 11:26 am
I have an explanation from Paul White, so I put a lot of faith in it.
It was my understanding that when a plan was found that was adequate according to...
"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 26, 2015 at 10:27 am
GilaMonster (8/26/2015)
And you've changed snippets. de <space> gets...
"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 26, 2015 at 8:13 am
Ed Wagner (8/26/2015)
Hugo Kornelis (8/26/2015)
GilaMonster (8/26/2015)
Gazareth (8/26/2015)
But probably the most common: DELCARE left left left backspace left C 😛
In that case, mine would be SEELCT left left backspace left L...
"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 26, 2015 at 8:06 am
mar.ko (8/26/2015)
I'm not sure....I didn't do it.
Ah... well, then other stuff may have been run. It's hard to say without knowing more. I ran this test:
USE TestDB;
GO
CREATE SEQUENCE dbo.MySequence
START...
"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 26, 2015 at 8:03 am
Viewing 15 posts - 5,641 through 5,655 (of 22,219 total)