Results 1 to 7 of 7
  1. #1
    Join Date
    Dec 2003
    Posts
    5

    Unanswered: be notified when connections = 5

    I would like to be notified of when my database connection hit 5. That way I know when I ned to upgrade from msde to standard edition. I have the server email ready but not sure how to moniter the connections.

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    Create an alert in performance monitor.

  3. #3
    Join Date
    Dec 2003
    Posts
    5
    sounds streight forward thanks.

  4. #4
    Join Date
    Jan 2003
    Location
    Massachusetts
    Posts
    5,800
    Provided Answers: 11
    The limitation on MSDE is on 5 concurrently running processes. You can periodically check DBCC CONCURRENCYVIOLATION (sp?) to see if you have hit that limit. So long as you keep the queries short, you could concievably keep 20 or 30 people happy enough with the application.

  5. #5
    Join Date
    Dec 2003
    Posts
    5
    it is one of those situations where I really do not know how many users I will get at a time. That is why I want to have a way to moniter it. If I have to by the full version fine, if I can hold of awhile great.

  6. #6
    Join Date
    Feb 2002
    Posts
    2,232
    The concurrent workload governor looks at concurrent batches - not connections. Knowing that, I would enable the logging using the DBCC CONCURRENCYVIOLATION(STARTLOG) command and/or use active transactions in the performance monitor.

  7. #7
    Join Date
    Dec 2003
    Posts
    5
    ok, great. thanks for the info.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •