Viewing 15 posts - 11,611 through 11,625 (of 22,224 total)
Dev (11/28/2011)
1204 & 1222.Trace Flags (Transact-SQL)
I wouldn't use both. I'd just use 1222 (which won't work in this case). Too messy in the error log otherwise.
"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
November 28, 2011 at 12:06 pm
So these are queries and not stored procedures? If they're stored procs you can use the dependency DMOs, sys.dm_sql_referenced_entities and sys.dm_sql_referencing_entities.
"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
November 28, 2011 at 12:03 pm
Not enough information to suggest a good solution. Execution plans would sure 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
November 28, 2011 at 11:59 am
Interesting issue. Do you have monitoring on the server? Does CPU, Disk, Memory use go up in different ways during the multi-file backup than during the single file backup? 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
November 28, 2011 at 11:57 am
waseem.shahzad 45937 (11/28/2011)
The most likely reason for Multi-Script to skip a server is because it can't connect to that servernot server... A DB on Same server.
Sorry, misunderstood. It could still...
"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
November 28, 2011 at 8:01 am
I'd need to see the TSQL script and any error messages.
The most likely reason for Multi-Script to skip a server is because it can't connect to that server.
"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
November 28, 2011 at 7:16 am
Oksana March (11/26/2011)
"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
November 27, 2011 at 5:29 am
SqlNewJack (11/25/2011)
"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
November 26, 2011 at 5:16 am
Lexa (11/23/2011)
Grant Fritchey (11/23/2011)
Lexa (11/22/2011)
Grant Fritchey (11/22/2011)
Lexa (11/22/2011)
Grant Fritchey (11/22/2011)
Lexa (11/22/2011)
"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
November 23, 2011 at 7:00 am
SqlNewJack (11/23/2011)
... and my wife and I just welcomed our baby boy into the world ...
WHOOP!
Best of luck.
While you're up at 3AM, after changing the diaper, just sit and read...
"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
November 23, 2011 at 6:56 am
Lexa (11/22/2011)
Grant Fritchey (11/22/2011)
Lexa (11/22/2011)
Grant Fritchey (11/22/2011)
Lexa (11/22/2011)
"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
November 23, 2011 at 4:35 am
Jim Murphy (11/22/2011)
"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
November 23, 2011 at 4:30 am
Jack Corbett (11/22/2011)
"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
November 22, 2011 at 2:52 pm
Lexa (11/22/2011)
Grant Fritchey (11/22/2011)
Lexa (11/22/2011)
"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
November 22, 2011 at 2:27 pm
I'll either open two windows & bounce between them, or I'll open two instances of SSMS.
SQL Sentry's Plan Explorer is worth checking 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
November 22, 2011 at 2:26 pm
Viewing 15 posts - 11,611 through 11,625 (of 22,224 total)