Viewing 15 posts - 5,881 through 5,895 (of 22,226 total)
Almighty (7/3/2015)
but we can use profiler remotely or as u said by using TSQL right ? extended events are good but for earlier version profiler was better idea
Nope. 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
July 3, 2015 at 6:02 am
GilaMonster (7/3/2015)
TomThomson (7/3/2015)
But don't make the mistake of thinking that all-nighters are always a sign of problems, or long hours (how can long hours be "heroic"?).
No, I'm not talking...
"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
July 3, 2015 at 5:59 am
Almighty (7/3/2015)
USE PROFILER .. TO FIND OUT WHAT HAPPEN S AT FIRST TIME THEN ANALYIZE THAT
This is actually really bad advice on two levels. First, running the Profiler GUI...
"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
July 3, 2015 at 4:06 am
It could be compile time on the query is very high which can cause some blocking, or that it's loading a lot of data into memory, again, possibly causing blocking....
"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
July 3, 2015 at 4:02 am
If the execution plans are the same then it's likely down to resources. Take a look at the waits statistics before and after the run in order to determine 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
July 3, 2015 at 3:56 am
HanShi (7/2/2015)
Grant Fritchey (7/2/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
July 2, 2015 at 3:51 pm
GilaMonster (7/2/2015)
Do you get the feeling that IT people, especially ones at the top-end of the field, are...
"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
July 2, 2015 at 3:49 pm
The AdventureWorks databases are almost never released before the product. I know this because every time I'm working on a book prior to the release I have to use 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
July 2, 2015 at 11:31 am
Cost threshold for paralellism is a value based on the estimated cost of the execution plan created by the query optimizer. The cost values, once upon a time (we're talking...
"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
July 2, 2015 at 11:28 am
I stopped maintaining the home lab and moved it all to Azure. So much easier to get everything I need fast, no upgrades necessary, nothing to maintain. The only pain...
"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
July 2, 2015 at 11:20 am
There is absolutely no hard and fast rule on this at all. It just depends on your data, how fast it comes in, and how much the data changes are...
"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
July 2, 2015 at 10:23 am
Don't run Profiler on a production server. Profiler is for consuming the data, not doing the monitoring.
To capture the information with the least possible hit on your server, use extended...
"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
July 2, 2015 at 10:19 am
ramana3327 (7/2/2015)
Capturing the transactions 1-2 hrs from production and...
"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
July 2, 2015 at 10:03 am
Since I am usually the harbinger of ill tidings on the thread, you guys should know, Skynet seems to be going live.
"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
July 2, 2015 at 8:25 am
When I taught classes like this where all we were doing was querying, instead of setting up Express (not a bad idea, just not what I needed), I created 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
July 2, 2015 at 7:25 am
Viewing 15 posts - 5,881 through 5,895 (of 22,226 total)