SQL Server Performance

wmiprvse#1, smsapm32

Discussion in 'Performance Tuning for Hardware Configurations' started by ramasubbup, Dec 12, 2005.

  1. ramasubbup New Member

    I see two processes wmiprvse#1 ( with avg 1590793 pages/sec ) and smsapm32 (with avg. 265125 pages/sec) in my Performance counters.

    What are these Services? Can I stop these services ?

    They are affecting my SQL server performance.

  2. Luis Martin Moderator

    Google is your best friend.



    Luis Martin

    One of the symptoms of an approaching nervous breakdown is the belief that one's work is terribly important
    Bertrand Russell

    All postings are provided “AS IS” with no warranties for accuracy.

  3. satya Moderator

    Are you running SMS services on teh SQL Server?
    Then you tend to see these counters and it is advised to keep the SQL on a dedicated server and avoid any sharing of resources if the performance is degraded drastically.

    Satya SKJ
    Contributing Editor & Forums Moderator
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
  4. ramasubbup New Member

    Yes, SMS service is running. The server is a dedicated one.
    I think that sms is a part of Windows component and should be running

    The server is in cluster env. Stopping this service will impact anything ?

Share This Page