Check MSDE Concurrency Connections

Since MSDE slows dramatically once over the preset limits, it's worthwhile to know how to check for these events.

Run this: 
DBCC CONCURRENCYVIOLATION

See here for a description of what the above all means:

http://www.petefreitag.com/item/194.cfm


Related Scribbles:
  • Free SQL Server / MSDE Admin
    		•
  • Windows Server Links and Notes
    		•

    ID: 614
    Author:
    leonard
    Date Updated:
    2005-03-16 16:31:45
    Date Created:
    2005-03-03 11:12:43

    Edit
    Comments?
     >> Leonard Chan's Homepage  >> Scribble Web  >> Check MSDE Concurrency Connections
    leonard.lotus-land.ca is hosted by Perceptus Solutions Inc.