Viewing 15 posts - 5,836 through 5,850 (of 22,219 total)
Wait types tell you what's causing things to run slow on the system, what it's waiting on. That doesn't tell you what query to look at or what to do...
"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 27, 2015 at 11:16 am
chandan_jha18 (7/27/2015)
The code that I executed kept on running for more than 26 hours and appeared to be doing nothing. After putting in a lot of research and reading...
"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 27, 2015 at 7:46 am
You can issue powershell commands to copy the files down provided you set up a VPN so that your Azure servers are operating within your network. I've done the opposite,...
"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 27, 2015 at 4:43 am
Yeah, compressing a compressed file, I've found, results in a bigger file. So watch commvault.
Nothing special needed with native backup compression other than telling it to do 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
July 27, 2015 at 4:38 am
There's nothing special about how Powershell would issue the command, so I'd have to assume you have blocking or something going on. Look to sys.dm_exec_requests to see what's happening with...
"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 27, 2015 at 4:37 am
If the file transfer speed is slow, that could explain the entire issue. You might want to keep a local copy of the backup for DR situations. Otherwise, figure 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
July 27, 2015 at 4:30 am
TomThomson (7/26/2015)
Grant Fritchey (7/26/2015)
Managed to get a fully-loaded station wagon (four people plus bags) all the way up to 120MPH (195KPH) on the Autobahn.
Don't get caught at that one in...
"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 27, 2015 at 3:17 am
Hey guys!
What'd I miss? I've been busy.
Achievements Unlocked:
Charlemagne's bones (they wouldn't let me sit in the throne)
Flanders Fields (way too many little white crosses)
Ypres (inside a WWI dugout)
Somme (idiot boy-child...
"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 26, 2015 at 4:15 am
Oops. yes. Another query1, query2, not your query1, query2. Sorry about that.
First most likely issue, the two different tables in the query, DIM_MATERIAL vs. DIM2_MATERIAL are showing different statistics right...
"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 10, 2015 at 6:44 am
And the first several chapters of my book on query tuning should help.
"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 10, 2015 at 2:50 am
It doesn't matter a lick.
I'd just strongly argue for consistency to help promote clarity.
"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 10, 2015 at 2:49 am
These are two completely different queries:
SELECT PT.created_dttm Created_Datetime,
PT.proj_task_id Project_Task_Id,
CONVERT(VARCHAR(2000), text, 0) text
FROM...
"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 10, 2015 at 2:46 am
Maybe you mean how frequently can you run log backups?
You can run them as frequently as they complete, but no faster. Considering the management overhead and the work involved in...
"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 10, 2015 at 2:34 am
sindura.pulimamidi1 (7/9/2015)
WHAT ARE BACKUP DEVICES? ANY PERFORMANCE ADVANTAGE WITH USE OF BACKUP DEVICES?
They're just a way to identify where you're storing backups to simplify code. Nothing more. It doesn't hurt...
"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 10, 2015 at 2:32 am
rodjkidd (7/10/2015)
I can get to Redgate for about 4 pm, traffic permitting. Maybe a bit before.
So if you are still up to meet and have a chat let me...
"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 10, 2015 at 2:14 am
Viewing 15 posts - 5,836 through 5,850 (of 22,219 total)