February 5, 2012 at 11:09 am
I cant find out for definate if data collector collects and displays reports on deadlocks. I know it grabs locking information but cannot find anything to say it collects deadlock information. can anyone confirm if it does or does not?
February 6, 2012 at 6:15 pm
Solution:
Stagger the two collector jobs. E.g. collection_set_2_upload Server Activity and collection_set_3_upload Query Statistics to run a couple of minutes apart. Now, here is a catch! Don’t change the schedule for the SQL Server Agent job, you need to change the schedule using the collector “pick schedule” option in SSMS.
To do this, right click on the collector agent (not the SQL Agent job) select properties and then uploads in the left hand pane. Click on "New" to create a new schedule. If you do it this way you can create two new schedules that are independent of each other.
I did run into another quirky issue when attempting to define a new schedule for the collection sets. i.e I was not able to define a new schedule for this and kept getting this error.
http://thesqldude.wordpress.com/category/data-collector/[/url]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply