SQL Server Performance Forum – Threads Archive
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.
Google is your best friend. Check: http://www.neuber.com/taskmanager/process/wmiprvse.exe.html
SQL-Server-Performance.com One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
All postings are provided â€œAS ISâ€ with no warranties for accuracy.
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.
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 ?