Viewing 15 posts - 5,176 through 5,190 (of 22,219 total)
I agree with Hugo, although I'd be a bit more concerned about production access because of what he notes at the end.
However, in dev, heck yes. Get them access. 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 26, 2016 at 12:48 pm
I love this software. I haven't hit this issue, but I've alerted Jenn & Sean. I suspect one or both will swing by shortly to help you out.
"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 26, 2016 at 6:32 am
If I wanted to get service status, you're going to be much better off going through the windows OS rather than attempting this through T-SQL. T-SQL doesn't even control SSAS,...
"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 26, 2016 at 6:30 am
Therefore, a point-in-time recovery could potentially lead to a transactionally inconsistent database
I'd push back on this statement and try to get a better understanding of exactly what they mean. Let'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 26, 2016 at 6:28 am
Hugo Kornelis (1/25/2016)
Grant Fritchey (1/25/2016)
What blockers are you seeing for...
"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 25, 2016 at 5:55 pm
Greg Edwards-268690 (1/25/2016)
Grant Fritchey (1/25/2016)
What blockers are you seeing for...
"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 25, 2016 at 12:01 pm
GilaMonster (1/25/2016)
Bandwidth, latency and data out of the country (for 1 and 3)
Makes sense.
"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 25, 2016 at 10:02 am
A few questions for the threadizens. Interested in this from everyone, but especially interested in what you guys who consult think.
What blockers are you seeing for Azure?
What blockers are you...
"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 25, 2016 at 8:58 am
Yeah, what can you see from the SQL Server side? Is the process blocked or waiting on a resource or what? That's what I'd want to know.
"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 25, 2016 at 6:07 am
It's possible that you're experiencing CPU pressure. Those queries are horrific. However, changing your max degree of parallelism is only going to make those queries run in a serial mode....
"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, 2016 at 8:46 am
High CXPACKET waits are an indication of parallel query execution, but not an indication that parallel execution is causing problems on your server. You need to look to other wait...
"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, 2016 at 8:26 am
That wait type is not very descriptive and is usually nothing to worry about. However, it can be an indication of issues with the query itself. Rather than focus on...
"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, 2016 at 2:44 am
ramana3327 (1/21/2016)
So triggers are the only option if you don't want have any 3rd party tools!
Well, extended events are not a third party tool. You would have to write some...
"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, 2016 at 3:17 pm
The most effective way you can have this done from within SQL Server itself is through triggers. You can set up extended events to capture the changes... it's going 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
January 21, 2016 at 11:15 am
Hugo Kornelis (1/21/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
January 21, 2016 at 6:05 am
Viewing 15 posts - 5,176 through 5,190 (of 22,219 total)