Viewing 15 posts - 6,856 through 6,870 (of 22,219 total)
If your server is already under stress, don't use Profiler on it. Since you're on 2014 (assuming this since you're in a 2014 forum), use Extended Events. They inherently cause...
"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
January 24, 2015 at 6:47 am
Pulivarthi Sasidhar (1/22/2015)
1. In-place upgrade
Easy to implement
...
"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
January 24, 2015 at 6:43 am
If you already have updated hardware, I'd say the problems are probably code and/or data structure related. You need to understand what exactly is running slow and exactly why 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
January 24, 2015 at 6:30 am
Sean Lange (1/23/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
January 24, 2015 at 3:54 am
Jeff Moden (1/23/2015)
Grant Fritchey (1/23/2015)
sm_iransoftware (1/23/2015)
No :blush:I think I should Know more about these tools and performance Basics.
Thank you
If you really want to get into all that, I'd suggest picking...
"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
January 23, 2015 at 12:58 pm
Steve Jones - SSC Editor (1/23/2015)
Sioban Krzywicki (1/23/2015)
GilaMonster (1/23/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
January 23, 2015 at 11:45 am
sm_iransoftware (1/23/2015)
No :blush:I think I should Know more about these tools and performance Basics.
Thank you
If you really want to get into all that, I'd suggest picking up a copy of...
"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
January 23, 2015 at 11:43 am
Sioban Krzywicki (1/22/2015)
Grant Fritchey (1/22/2015)
Steve Jones - SSC Editor (1/21/2015)
What's the superhero costume of choice here? SQL Bits is a month+ away, with the theme of superheroes for the Friday...
"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
January 22, 2015 at 8:32 am
Steve Jones - SSC Editor (1/21/2015)
What's the superhero costume of choice here? SQL Bits is a month+ away, with the theme of superheroes for the Friday night party.
Need to get...
"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
January 22, 2015 at 7:55 am
Jeff Moden (1/21/2015)
Sioban Krzywicki (1/21/2015)
I hope everyone here is ok with it too...
To be honest, I don't care if someone's eyes are on stems and they leave snail tracks. ...
"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
January 21, 2015 at 2:20 pm
free_mascot (1/20/2015)
search engine work differently in different version to improve the performance. However while doing upgraded one should keep the db in the original compatibility mode unless...
"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
January 20, 2015 at 6:32 am
Doing the rebuilds online can reduce contention, but it will increase the amount of time it takes. It's a tradeoff.
"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
January 20, 2015 at 6:30 am
The execution plan is your bestest buddy in situations like this.
Joining to views is a common code smell in T-SQL. The language just doesn't lend itself to code reuse. While...
"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
January 19, 2015 at 1:16 pm
I am clearly biased, but check out the books below in my signature.
"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
January 19, 2015 at 1:12 pm
It could be any number of things. First thought is the changes to the cardinality estimator. See how many rows the execution plans think it's going to get from the...
"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
January 19, 2015 at 1:09 pm
Viewing 15 posts - 6,856 through 6,870 (of 22,219 total)