Results 1 to 12 of 12

Thread: What is PKM?

Hybrid View

  1. #1
    Join Date
    Nov 2002
    Location
    Chesapeake, VA
    Posts
    104

    What is PKM?

    I've noticed that when I do an sp_who2 during times when my server is running slow, I see multiple entries for...

    Program Name: PKM
    Login: NT AUTHORITY\SYSTEM
    DBName: master

    We don't have an application called PKM and I suspect it's generated by SQLServer or the operating system. I've not been able to find any information about it.

    Anybody have a clue?

    Sidney Ives
    Database Administrator
    Sentara Healthcare

  2. #2
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    Looks like a 3rd party tool to me.

    http://www.destinationkm.com/article...?ArticleID=615

    See whether any services is running on that server like PKM

    if you do a select * from sysprocesses you can find the host machine.

  3. #3
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254

  4. #4
    Join Date
    Nov 2002
    Location
    Chesapeake, VA
    Posts
    104
    I'm still reviewing the articles you referenced. The host server is the database server. SDCNTS08 is the host server. It is also the database server. I've looked at the services that are running and don't see anything like that at all.

  5. #5
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    See what kind of queries it is sending to sql server. May be this will give you a clue.

    I suspect it must be some windows tool like performance monitor. Do you have HP Open view on the server?

  6. #6
    Join Date
    Sep 2002
    Location
    Fantasy
    Posts
    4,254
    choices:

    If you really dont want PKM to be hitting your sql box

    1. go to the server - task manager - see any process related to PKM and try to kill it.

    2. go to the server - start - run - regedit and press F3 search for PKM. find the path and delete the files and path. (Warning: updating registry is very dangerous). Ask Network admin for assitance.

    3. go to server - start - search -files or folders - search for PKM. see whether any uninstall executables are there.

  7. #7
    Join Date
    Sep 2002
    Posts
    5,938
    What's spid for this process? If spid is > 50, it's user process and you can find host name it runs on with sp_who2.

  8. #8
    Join Date
    Nov 2002
    Location
    Chesapeake, VA
    Posts
    104
    SPIDS are greater than 50. I know the host_name. The host is the database server itself.

  9. #9
    Join Date
    Nov 2002
    Location
    Chesapeake, VA
    Posts
    104
    I reviewed the Registry, and there are no references for PKM. I looked for files and folders containing PKM and there are no files/folders with PKM.
    There were no TaskManager Processes that looked like likely suspect.

    Im running profiler to see if I can capture more info. when they appear.

  10. #10
    Join Date
    Sep 2002
    Posts
    5,938
    Or run 'dbcc inputbuffer (spid)' to see the command used.

  11. #11
    Join Date
    Sep 2002
    Posts
    5,938
    Did you install SharePoint Portal Service on the server?

  12. #12
    Join Date
    Nov 2002
    Location
    Chesapeake, VA
    Posts
    104
    SharePoint is not installed.

Posting Permissions

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