Viewing 15 posts - 6,811 through 6,825 (of 22,219 total)
Brandie Tarvin (2/4/2015)
Anyone know anything about this Grant guy? Does he know what he's talking about?
Nah, I hear he's a giant bag of wind and a bit 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
February 4, 2015 at 7:53 am
One source of suggestions (and please, note that word, suggestions) for columns that might need an index are the Missing Index DMVs. But, the problem with using these is two-fold....
"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
February 4, 2015 at 7:49 am
I too am not a fan of Management Data Warehouse. It works well enough, but misses so much you have to do a ton of extra work to get 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
February 4, 2015 at 7:41 am
Basically, there's a lock in place during execution to prevent updates during execution. That's all.
"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
February 4, 2015 at 7:34 am
Ed Wagner (2/4/2015)
GilaMonster (2/4/2015)
Brandie Tarvin (2/4/2015)
GilaMonster (2/3/2015)
And spending the evening at the office because there are scheduled blackouts in my area. Again.Scheduled blackouts? Is the electrical grid overworked?
Yup, since 2008.
So,...
"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
February 4, 2015 at 7:11 am
Just to toss another point of view in here, admittedly one that is vendor centric.
I work for Red Gate Software. I've used both our products and litespeed in production...
"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
February 4, 2015 at 3:58 am
SQL Guy 1 (2/3/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
February 3, 2015 at 12:22 pm
The best way to monitor in SQL SErver 2008 or better with minimal impact on the server is to use Extended Events. Here's an article[/url] that specifically shows some suggestions...
"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
February 3, 2015 at 12:19 pm
You can use the Dynamic Management Views to get a look at the activity in the system. sys.dm_exec_requests will show you active sessions. You'll have the user_id and any existing...
"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
February 3, 2015 at 12:17 pm
Since you're working in SQL SErver 2014, I strongly recommend you start using Dynamic Management Views to access information about the state of your systems. Using sp_who2 and DBCC commands...
"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
February 3, 2015 at 5:52 am
Have there been changes to the queries being run? New functionality introduced? Additional tables or any other kind of change? A new annual process, something? Did someone accidentally run 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
February 3, 2015 at 5:43 am
I don't have quantifiable measures on this, but yes, I'm pretty sure that having an enforced structure will help to speed the queries. But, they still won't be "fast" 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
February 3, 2015 at 5:39 am
It's really up to the organization. I know a few places that still have SQL Server 2000 in place (I'm aware of two places that have SQL Server 7.0 running)....
"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
February 3, 2015 at 5:37 am
That sounds like some sort of multi-hop problem within active directory. Weird.
"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
February 3, 2015 at 5:14 am
That is the hard part. Let's say there's a reasonably defined set of possible searches, you could have a view do a UNION ALL query across each of the linked...
"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
February 2, 2015 at 1:38 pm
Viewing 15 posts - 6,811 through 6,825 (of 22,219 total)