Viewing 15 posts - 9,151 through 9,165 (of 22,226 total)
The deadlock is probably being caused by multiple slow points, not just the select statement. I'd suggest getting the execution plans for the two queries involved in the deadlock and...
"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 9:57 am
ramana3327 (1/3/2014)
Thanks for the replies.
I am able to create a user defined data collector from a template or create a custom collection but I am not able define this...
"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 7:39 am
Yeah, same space. At least it should be.
"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 7:37 am
If you feel like your log files are getting too large, you probably should take the backups more frequently. But, that will mean you have to manage more backup files...
"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 7:02 am
If your needs are small, I'd go with CDC. It's easy to set up. Easy to maintain. No worries, especially on a small system as you say you have here.
"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:16 am
And also, if you drop and recreate the indexes, that also defrags them.
"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:14 am
You just want to access SQL Server and look at the data, but you don't want to write any T-SQL code? None of the standard management tools can do this...
"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:04 am
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
Viewing 15 posts - 9,151 through 9,165 (of 22,226 total)