I was thinking it could be parallel processes. That would show why you couldn't see the statement and plan on all of them.

SELECT queries alone will not cause deadlocks. There has to be data modification queries built in there somewhere.

Do you notice if there are other entrees for the same session_id?

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...

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...

Yeah, same space. At least it should be.

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...

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.

And also, if you drop and recreate the indexes, that also defrags them.

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...

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...

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...

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...

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,...

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...