Viewing 15 posts - 4,756 through 4,770 (of 22,221 total)
harikumar.mindi (4/30/2016)
EXEC sp_MSForEachTable 'UPDATE STATISTICS ? WITH FULLSCAN;'However i will rebuild / reorganize indexes and test it again and will update here.
Just so you know, rebuilding/reorganizing indexes will not...
"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 1, 2016 at 12:18 pm
You're kind of all over the map here, but I'll be happy to make some suggestions.
First off, get the SQL Toolbelt from Redgate[/url]. It has a number of tools that...
"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
April 30, 2016 at 7:29 am
There are a few clues around this. If you look at the properties of the SELECT operator, there are differences in the apparent setup of the servers. One has 12...
"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
April 30, 2016 at 7:22 am
Luis Cazares (4/29/2016)
Brandie Tarvin (4/29/2016)
Grant Fritchey (4/29/2016)
Brandie Tarvin (4/29/2016)
"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
April 29, 2016 at 3:43 pm
Brandie Tarvin (4/29/2016)
"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
April 29, 2016 at 11:50 am
fred.newcomer (4/29/2016)
"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
April 29, 2016 at 11:48 am
jasona.work (4/29/2016)
Grant Fritchey (4/29/2016)
"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
April 29, 2016 at 11:19 am
Sioban Krzywicki (4/29/2016)
John Mitchell-245523 (4/29/2016)
Sergiy (4/28/2016)
The names don't affect performance or quality of the code anyway.
It's not 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
April 29, 2016 at 10:46 am
N_Muller (4/29/2016)
Grant Fritchey (4/29/2016)
N_Muller (4/28/2016)
Or is it a hit and miss in terms of queries that perform poorly.
I'll just pile on and agree.
The main issues I've seen are with multi-statement,...
"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
April 29, 2016 at 10:44 am
Just a follow up on my other post (and apologies for bring tech & real work into the Thread, but you guys have the answers so I may as 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
April 29, 2016 at 8:06 am
2gb index for a 1mb table... yeah, that might be a problem. 2gb index for a 200gb table. Who cares.
There's nothing bad or good saying an index is X size....
"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
April 29, 2016 at 8:00 am
Your limits are the same as they would be if it was a client application calling the database. INSERT/UPDATE/DELETE will cause blocking. SELECT with poor or improper code can lead...
"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
April 29, 2016 at 7:58 am
I would look at the wait stats and top running queries over the same period of time for the spike.
It looks like you're using SQL Monitor. 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
April 29, 2016 at 7:54 am
You say you're going to a single record, but are you actually putting everything into one column? If so, why. That's not what a relational database management system is designed...
"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
April 29, 2016 at 7:51 am
Identify the query or queries that are taking a long time.
Observe their locking, blocking and wait statistics behaviors. That might tell you what's wrong.
Look at their execution plans. That might...
"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
April 29, 2016 at 7:48 am
Viewing 15 posts - 4,756 through 4,770 (of 22,221 total)