Results 1 to 4 of 4

i have 2 BES servers. on one server the sql process is at 98MB (with ... Server Admins forum

  1. #1
    uchytilian's Avatar
    uchytilian no está en línea Stack level 1
    Join Date
    Sep 2007
    Posts
    3

    high sql performance

    Advertisement



    i have 2 BES servers. on one server the sql process is at 98MB (with 94 users). on my second server the same process is almost 200MB (with 19 users). is this process too high?
    thanks

  2. #2
    hayden's Avatar
    hayden no está en línea Stack Mod
    Join Date
    Jul 2004
    PIN/ID
    ask
    Posts
    12,440

    Re: high sql performance

    moving to BES forum.

  3. #3
    hayden's Avatar
    hayden no está en línea Stack Mod
    Join Date
    Jul 2004
    PIN/ID
    ask
    Posts
    12,440

    Re: high sql performance

    In the meantime I'd recommend you check out www.zenprise.com BES management.

    Also glance at:
    http://www.itrezzo.com/BES_Software_..._Reporting.htm

  4. #4
    jrockett's Avatar
    jrockett no está en línea BES Pro
    Join Date
    May 2007
    Posts
    962

    Re: high sql performance

    Well SQL is a memory hog and uses as much memory as it needs, gotta love dynamic memory allocation. You can cap it to 25% of the total memory in your server. So if you have 1gb of memory you can set it to 250mb. We have 80 users on one server now and our sqlserver.exe is using 149k of memory. Hope this helps.
    Data Outages
    Reinstall OS
    Desktop/Device Page

    Yes, I'm a BES admin with an iPhone 3G.

    Follow me on Twitter!


Tags for this Thread

Posting Permissions

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