Viewing 15 posts - 9,151 through 9,165 (of 22,219 total)
It's a connectivity error from distributed replay. You approach it the same way you do any connectivity error. What login is it attempting to use? Does that login have access...
"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 3, 2014 at 5:00 am
There are lots of examples right here on the site. Just do a search for xp_cmdshell and zip.
Here's one example here. And another. And one more[/url]. There are still others...
"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 3, 2014 at 4:57 am
I'm with Jeffrey. You could use detach to unlink the databases from your server, then load them to the FTP server, then the other party can download and attach 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
January 2, 2014 at 4:13 pm
I'm assuming we're talking Performance Monitor. The best way to collect the data is not to use the GUI that lets you look through the data. Instead, in the 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
January 2, 2014 at 9:35 am
In general, CDC is a good way to track data changes over time. It does add overhead to the system, but it has fairly reliable performance. Whereas, you have 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 2, 2014 at 7:37 am
GilaMonster (1/2/2014)
Grant Fritchey (1/2/2014)
Badly written apps provide nothing, or, as in this case, something misleading. But it can be anything.
Implying that Management Studio is badly written (but we already knew...
"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 2, 2014 at 6:28 am
david.alcock (1/2/2014)
Grant Fritchey (1/2/2014)
"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 2, 2014 at 5:56 am
Perry Whittle (1/2/2014)
Grant Fritchey (1/2/2014)
If you want faster performance for the system databases, you might consider local storage.
Unless its an FCI then you are required to use shared storage not...
"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 2, 2014 at 5:53 am
The only way to determine "normal" for any system is to measure it over time.
"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 2, 2014 at 5:29 am
The application name is a connection string bit of information that you can put anything in. You could say "Bob" for the application and SQL Server wouldn't know what you're...
"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 2, 2014 at 5:27 am
If you want the redundant storage that a SAN gives you, yes. If you want faster performance for the system databases, you might consider local storage. Everything is a tradeoff.
"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 2, 2014 at 5:25 am
In the free arena you might want to check out Kendal Van Dyke's Powershell scripts.
"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 2, 2014 at 5:24 am
Unless there's a specific reason for it, 4 logins/sec isn't freaking me out. It's just an indication of load, not a problem.
"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 2, 2014 at 5:19 am
Jeff Moden (12/30/2013)
Grant Fritchey (12/30/2013)
Jeff Moden (12/29/2013)
Grant Fritchey (12/18/2013)
"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
December 30, 2013 at 12:38 pm
Jeff Moden (12/29/2013)
Grant Fritchey (12/18/2013)
"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
December 30, 2013 at 6:12 am
Viewing 15 posts - 9,151 through 9,165 (of 22,219 total)