SQL Server Performance

Data collection

Discussion in 'SQL Server 2008 General DBA Questions' started by klehonia, May 18, 2011.

  1. klehonia New Member

    Hi,
    i have enabled Data Collection and the Data Collection set Server Activity stops after attempts with the Message
    "A deadlock was detected while trying to lock variable "User::CollectionPackageName" for read access. A lock could not be acquired after 16 attempts and timed out. "
    My mdw database is in different sql server. The other two sets Disk Usage and Query Statistics work fine.
    Thanks in advance.
  2. Luis Martin Moderator

    Is someone writing at the same time?
  3. klehonia New Member

    If you ask if database is in use, yes it is in use (inserts, select, updates etc). The counter 'Number of Deadlocks/sec' doesn't change, i don't know what deadlock is detected. Another point is that only one of the two collection items failed, "Server Activity - DMV Snapshots". I separated them in two custom data collections i created and work fine, but i don't have reports for them and i don't know how to create rdl files. How can i find the reports (rdl files) for the default Server Activity? Any ideas?

Share This Page