Viewing 15 posts - 11,341 through 11,355 (of 22,224 total)
Have you taken a look at the Resource Governor?
"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, 2012 at 7:33 am
Start at Microsoft. That's always the best spot.
"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, 2012 at 7:30 am
I wouldn't sweat the Max Degree of parallelism nearly as much as I would the cost threshold for parallelism. The default value there is 5, which is EXTREMELY low, especially...
"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, 2012 at 7:29 am
Take a look at the execution plan for the query. see what it's doing. It could be you're building lots of temporary storage processes (hash tables, sorts, work tables, etc.)....
"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, 2012 at 7:28 am
I agree with everyone else. Resource Governor is going to get you close-ish, to what you're looking for, but it's not going to do specifically what you need. And, 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
February 2, 2012 at 7:24 am
I'm not aware of anything like this in 2012. To my knowledge the best you could do is use the resource governor to try to limit the one you don't...
"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, 2012 at 6:07 am
Also check out SQL Cop. I wrote a review of it here[/url].
"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, 2012 at 5:57 am
And the query stats are aggregate only. If the query was called multiple times and only one of them spiked, you won't be able to tell much about the spike.
"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, 2012 at 5:55 am
4gb of memory is really not enough to run that many VMs.
You have two options. 1) Make the VMs part of your existing network. You can add them to 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
February 2, 2012 at 5:53 am
Data changes can lead to statistics changes which can cause a recompile. If you have a nightly load or something like that you'll see recompiles. Also, plans can simply age...
"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, 2012 at 5:49 am
Or read the book in my signature.
Optimizing stored procedures is a HUGE topic.
"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, 2012 at 5:47 am
A primary key uniquely identifies a row. Let's say you make a primary key on the alphabet. You can insert a value for 'a', and another for 'b', and one...
"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, 2012 at 5:46 am
One phrase sticks out "Made a copy"
Does that mean you ran "BACKUP DATABASE..." or that you copied files?
Assuming it is a backup, check the header. You might find that there...
"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, 2012 at 5:42 am
Not knowing your exact structure, I'm speculating some here...
There are two kinds of indexes, clustered and non-clusterd. You get one clustered index per table. If you're getting a table scan,...
"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, 2012 at 5:22 am
If you have a unique index, it prevents duplicate data. It doesn't matter if you're updating to duplicate the data or inserting to duplicate the data. You can't have duplicate...
"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, 2012 at 5:18 am
Viewing 15 posts - 11,341 through 11,355 (of 22,224 total)