Viewing 15 posts - 6,016 through 6,030 (of 22,226 total)
Also don't forget that you don't just bottleneck on the disks. You also bottleneck on the disk controllers and the connections to the disks. I/O is a giant rats nest...
"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
May 28, 2015 at 4:48 am
That's a big topic and not one that's going to be answered well within a forum post like this. I'd suggest starting out reading this article from the SQL CAT...
"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
May 28, 2015 at 4:46 am
andrew gothard (5/28/2015)
meilenb (5/24/2015)
Everyone knows that CO2, CH4 and N2O are factors in climate change. CH4 (refrigerants) in particular is a 21 multiplier to CO2, R-508B (refrigerant) is 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
May 28, 2015 at 4:36 am
First question, did the execution time change with the removal of DISTINCT with the original indexing scheme?
Next question, did either of those indexes get used? Did you check the execution...
"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
May 28, 2015 at 4:24 am
Kyrilluk (5/28/2015)
Grant Fritchey (5/27/2015)
Since I've seen many a DBA screw up a production environment, I don't see what makes developers special in either regard. However, exposure is an extremely well...
"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
May 28, 2015 at 4:20 am
reynolddejesus100 (5/28/2015)
sir i want to automatic restore the backup files using sql agent, how can i solve this using sql agent automation
SQL Agent can call to T-SQL. You can 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
May 28, 2015 at 4:10 am
The execution time is the same? I'm not surprised the reads are the same. You're still scanning 45,000 rows.
There just isn't anything to tune in the query here.
Wild shot 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
May 27, 2015 at 8:05 pm
Eric M Russell (5/27/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
May 27, 2015 at 11:13 am
Eric M Russell (5/27/2015)
Kyrilluk (5/27/2015)
Eric M Russell (5/26/2015)
Kyrilluk (5/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
May 27, 2015 at 10:43 am
Kyrilluk (5/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
May 27, 2015 at 10:35 am
Since this is two completely different statements, assuming we're putting this into a stored procedure, why not create two stored procedures? You're looking at the need for two different execution...
"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
May 27, 2015 at 7:56 am
If you can't get in with the DAC you may need to restart the service. Do it with the command lines -f and -m to get it to a minimal...
"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
May 27, 2015 at 7:21 am
Views that call to other views and nest and join on views is a notorious code smell that leads to poor performance. My suggestion, write the query you want directly...
"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
May 27, 2015 at 6:25 am
Sounds like there must have been some security changes on your server. The login you're using doesn't have permission to run the RESTORE command.
"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
May 27, 2015 at 6:22 am
There's no way to correlate what's stored in those DMVs to any query. So, instead, you need to query directly against the XML of the execution plans in order 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
May 27, 2015 at 6:22 am
Viewing 15 posts - 6,016 through 6,030 (of 22,226 total)