Viewing 15 posts - 5,941 through 5,955 (of 22,227 total)
Here's an example[/url] of a PowerShell script that will script out the indexes. It's written to only pull the indexes from a single table. You can pretty easily modify it...
"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
June 24, 2015 at 11:39 am
You could just use SSIS. It can connect to Azure SQL Database and you can move the data that way.
"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
June 24, 2015 at 4:14 am
Remember, timeouts are a client-side issue. The problem, most of the time, is likely related to resource contention within SQL Server. But it isn't limited to that. I've seen network...
"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
June 24, 2015 at 4:10 am
Uuummmm, did you go and break the thing? Sure looks like the line snapped.
"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
June 23, 2015 at 10:35 am
rodjkidd (6/23/2015)
Grant Fritchey (6/23/2015)
Wow, you guys were seriously chatty kathy while I was gone.Welcome back oh mighty one!
Did you have fun, by any chance? hehe
Rodders...
Nope. No fun at all. Especially...
"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
June 23, 2015 at 7:57 am
Wow, you guys were seriously chatty kathy while I was gone.
"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
June 23, 2015 at 7:07 am
Matt Miller (#4) (6/19/2015)
Grant Fritchey (5/20/2015)
ForumsFora. Language Nazis need not apply. Your meaning was clear.sorry - just could not help myself 😉
Curse 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
June 23, 2015 at 6:52 am
+1 to what Jeff said. It's always great to get the information of what really happened and what the issue was. Thank 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
June 13, 2015 at 10:05 am
I agree about the filter on the database id... and disagree. As much as possible you should have it interrupt sooner rather than later to take advantage of the great...
"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
June 13, 2015 at 9:58 am
One point. I'm pretty sure duration in extended events is in microseconds. You might want to capture >2000000.
"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
June 11, 2015 at 10:12 am
I haven't set this up, but it shouldn't be at all hard. Documentation on the Task Scheduler is here. You'll want to use SQLCMD.EXE. You can just pass in 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
June 11, 2015 at 9:10 am
There's no automated mechanism I'm aware of. You gather metrics about query behaviors and over time identify those that are causing you pain. Identify the fact that stats are causing...
"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
June 11, 2015 at 8:51 am
Absolutely no silver bullet. That basically looks OK. You may find that statistics updates weekly might be a little light. Depending on the size of your system and the load,...
"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
June 11, 2015 at 7:45 am
Thanks for posting back what you ultimately found. So sorry you're going through this nightmare. It can't be fun. Actual malicious actions against a server is not one I've personally...
"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
June 11, 2015 at 7:36 am
OK. Then, the other option may be true. You had a one or more very large transactions.
"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
June 11, 2015 at 7:29 am
Viewing 15 posts - 5,941 through 5,955 (of 22,227 total)